200
DBA
Are your SQL Servers running optimally and providing the high availability your organization expects of them? If you don’t know, or if you have inherited some SQL Server instances that you are not familiar with, then you need to perform a SQL Server Health Check in order to find out.
In this session, you will learn about a comprehensive checklist (a spreadsheet you can download) that allows you to examine every important aspect of a SQL Server instance’s health, which you can use to help you determine if the instance is running optimally and providing the high availability you expect. It covers hardware, the operating system, SQL Server configuration, database configuration, maintenance, performance, and high availability.
Because of time considerations, and the amount of content to be covered, the focus will be on explaining how to perform the health check, not on the step-by-step procedures needed to perform the health check. After attending this session, and downloading the health check spreadsheet, DBAs will be able to go back to their organizations and begin to immediately perform their own SQL Server health checks.
|
400
DBA
These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.
|
300
DBA
With the combination of Windows Server 2008 R2 and SQL Server 2008 R2 it has now become possible to run SQL Server on up to 256 Cores. Recently, the SQL CAT team had a customer in the lab to test a banking application at high scale-up. Previously, we had test runs for the same application on 32-cores – but now the time had come to stress the app to 128 Cores. In this session, I will talk about the lessons we learned from stress testing an OLTP workload at this scale. You will see some interesting bottlenecks and get an idea of what sort of numbers are achievable on a big SQL Server box. Of course, I will also provide you with the guidance on how to get those numbers.
|
200
Kat
This presentation will give you give you a complete overview with real life examples of Idera’s Award Winning SQL virtual database. SQL virtual database is a powerful, new one-of-a-kind solution that lets you attach SQL Server backup files and query them just like they were real databases! Its revolutionary, patent-pending technology allows DBAs to gain instant-access to critical data in a backup file without wasting the time or storage necessary to restore thedatabase. Just attach the backup file, and use any native SQL Server or third party tools to query and extract the data you need in minutes. David Terry is a Systems Engineer with Idera and has over 10 years experience in systems integration, consulting, specialized monitoring tools, and systems administration including SQL Server and Sharepoint. David has a wide variety of experiences including consulting, training, presales, and complete implementations common back office tools like, Microsoft Systems Center andSharepoint. In the past 3 years with Idera, David has been working with SQL Server and Sharepoint implementations worldwide optimizing backups, recovery, performance, compliance, security, and administration.
|
300
DBA
Come hear Buck Woody, Microsoft’s “Real World DBA” as he explains how to create a plan for your database servers to provide business continuity in your organization. You’ll learn the options you have for making your system highly available, and you’ll learn how to apply those choices based on your company’s needs.
|
300
BI
The Microsoft SQL Server provides a complete library of programmatically accessed objects for all Business Intelligence relevant services. With this set of functions almost any customer challenge can be solved without the need to purchase additional products. This possibility is often underestimated in projects.
We will explore the ways how to create powerful solutions with Integration Services, Reporting Services and, of course, Analysis Services. This session provides many samples and .net sourcecode to demonstrate the possibilities of creating your own tools with Windows Forms and Silverlight for your daily work. Many manual clicks and tasks can be automated, really!
Finally we build a complete Business Intelligence Middleware as a blueprint for your own projects.
|
300
DBA
In almost all data warehouses there is a requirement to quickly get data into SQL Server. In this talk, I will present the different options you have: SSIS vs. T-SQL. We will look at some common design patterns for scalability and take a deeper look at how the Bulk API for SQL Server works.
|
400
DBA
PANIC IN THE DATACENTER! Your databases are approaching - or surpassed - the Terrible Terabyte mark. You're pouring money into the SAN, but your data isn't pouring back out as fast as you want. You're terrified to DBCCs or index maintenance because everything takes forever, and you don't have big maintenance windows.
Take a deep breath. In this session, you'll learn the things your SAN admin doesn't even know, like how to configure your databases for iSCSI, how to make multipathing work for you, and how to leverage solid state drives without paying crazy prices.
|
200
Dev
In this session we will look at the toolset you have available to you to find performance problems in your system. Once you've found the problem you need to solve it. We will show you how you can go about resolving your problems.
We will look at SQL Server profiler, Dynamic Management Views and Perfmon amongst other things to help us identify the problem.
To resolve the problem we will look at Query Plans and SET options to help us identify the source of the problem and look at some resolutions to common problems. This will include changes to queries, table design changes and index changes.
After this session you will have a understanding of the tools available to you to resolve performance problems and how to use them.
|
200
Kat
This presentation will give you give you a complete overview with real life examples of Idera’s Award Winning SQL virtual database. SQL virtual database is a powerful, new one-of-a-kind solution that lets you attach SQL Server backup files and query them just like they were real databases! Its revolutionary, patent-pending technology allows DBAs to gain instant-access to critical data in a backup file without wasting the time or storage necessary to restore thedatabase. Just attach the backup file, and use any native SQL Server or third party tools to query and extract the data you need in minutes. David Terry is a Systems Engineer with Idera and has over 10 years experience in systems integration, consulting, specialized monitoring tools, and systems administration including SQL Server and Sharepoint. David has a wide variety of experiences including consulting, training, presales, and complete implementations common back office tools like, Microsoft Systems Center andSharepoint. In the past 3 years with Idera, David has been working with SQL Server and Sharepoint implementations worldwide optimizing backups, recovery, performance, compliance, security, and administration.
|
300
BI
Ok, so this wasn’t the best advert for Australian tourism, but it is a question often asked by data applications. We understood spatial data in SQL Server 2008, and we love the map functionality in SQL Server 2008 Reporting Services. But if you have a pile of addresses, how can you convert that into data that you can map? And how do you make a map that lets you zoom in and out? In this talk, Rob Farley looks at how to handle shape files in Report Builder 3.0, the Bing Maps functionality for searching for addresses and displaying a map, and how this can tie into the spatial types we’ve been seeing for the last couple of years. It may also include a venture into the world of Live Labs Pivot, investigating new and interesting ways to display your data.
|
200
Dev
SQL Injection attacks are one of the most common hacker tricks used on the web. Learn what a SQL injection attack is and why you should be concerned about them. Through demonstrations, witness different types of SQL injection attacks, how to find them, and how to block them.
|
300
DBA
Do you want to know why the Query Optimizer chooses one execution plan
|
300
DBA
Extended Events offer a refreshing new way of troubleshooting problems with SQL Server 2008. This session will focus on how to create custom sessions using the available events, targets and actions available in the Extended Events metadata. It will cover how to use the default system_health session to perform initial troubleshooting, as well as how to use the Extended Events Manager to simplify creating Extended Event Sessions and accessing the information captured in the session targets.
|
400
DBA
Scaling up SQL Server performance is easier than it used to be in the days of SQL Server 2000. This is due across board, from the server system, the Windows operating system and the SQL Server engine.
A number of techniques, such as port affinities, hyper-threading, trace flag T2301, etc have been discussed, as these are elements of the published performance benchmarking reports.
However there is very little available guidance on the impact of each for specific application characteristics.
Some techniques are absolutely critical essential and others contribute a few percent. Certain tuning methods are essential in high call-volume (chatty) applications. Data warehouses are highly dependent on effective use of parallelism, not to mention a powerful storage system. In certain circumstances, parallelism may have negative impact. In others, it may be difficult to get a parallel execution plan.
Finally, why is Big-Iron better than Oracle RAC-style scaling?
|
200
Kat
This session will show how development practices, such assource control, unit testing and continuous integration, have long since beenexclusive to application developers. This talk will describe how databasedevelopment has narrowed the gap.
|
200
Dev
This session will provide an overview of the future of the tools, language constructs, the SQL Modelling Services Metadata core, discussion on end to end modelling in an enterprise environment and how SQL Server Modelling services delivers these models into the business. Demonstrations of the M language , M -> SQL and the Data driven Quadrant User Interface will be given.
|
300
Dev
There’s so much more to SARGability than people think, and people can often miss out on significant performance benefits by not appreciating this. SARGable means Search ARGument Able and relates to the ability to search through an index for a value. Unfortunately many database professionals don’t really understand it – especially in regard to joins – leading to queries which don’t run as well as they should. This is a talk involving lots of demos, showing plenty of queries and execution plans.
|
200
BI
The Presentation will take the simplest export to excel report then combine the Ordnance survey open data with RS 2008 R2 to create an interactive visual map report.
“http://www.ordnancesurvey.co.uk/oswebsite/opendata/”
What types of data is available
UK Open data provides the back bone to the Geo – Coding to provide a post code to latitude and longitude translation.
An introduction to spatial data types and why the UK open data does not plot natively to Bing maps.
Demo data types
An introduction to the new Mapping features
Demo new mapping features
Linking mapping data to corporate data
Demo linking data
Creating your report
Demo combining mapping and open data
All of that done on SQL 2008 R2 express
Creating your own UK report templates
|
300
Dev
The technique of Recency Frequency Intensity/Monetary is a powerful analytical technique for identifying data patterns and business performance. An introduction to the technique will be given, however the main focus of the session will be on demonstrating on how RFI/M can be performed using a number of SQL features such as Data Windowing, the OVER clause and PARTITION BY, CROSS APPLY and Common Table Expressions and how you can nest the table expressions. The session should be of benefit to both inexperienced and experienced SQL coders and analysts, each construct will be explained as well as the query plans produced. Demo's will be done on AdventureWorks which we actually discover is going out of business!
|
400
DBA
In this session with examples we will continue to cover how to identify and tune inefficiencies in parallel query execution.
Part I was presented during SQLBits VI in London, if you missed it, view the Webcasts @ http://webcast.sqlworkshops.com.
|
200
Kat
In this session, Brad McGehee, Red Gate’s Director of DBAEducation, will explain what items should be on your monitoring checklist andhow to manually monitor your SQL Servers. You will also be able to sneak a peekat SQL Response 2, Red Gate’s SQL Server monitoring and alerting tool that iscurrently under development. New features that will be demonstrated by ProductManager Ben Rees include SQL Response’s intuitive overviews, intelligent alertsand how to go back in time to identify the source of a problem fast.
|
300
DBA
In this session I will introduce the NoSQL philosophy before going on to compare and contrast the strengths and weaknesses of the relational model versus the NoSQL model, showing scenarios where you would choose one over the other and explaining why. I will complete this session with a demonstration of an application written with a NoSQL storage layer and explain the advantages that accrue from that decision. By the end of this session you will have the answer to the question posed in the title.
|
200
DBA
In an ideal world our systems would scale out infinitely across geographies, maintaining consistency, availability, response-times, and durability as they did. This is not the world we live in however. In the face of faults only some of these desirable traits can be maintained. This talk will introduce the literature around building highly scalable, fault-tolerant, distributed systems and discuss where relational databases can sit within this space.
The aim of this talk will be to introduce this topic to the attendees in the context of SQL Server, highlighting the limitations of different approaches, and leaving the audience bootstrapped to understand the implications of adopting different approaches to scaling out.
|
200
BI
For many organisations Access Databases have offered a rich user experience yet posed a thorn in their side when it comes to controlling and managing what is produced. With Access 2010 organisations now have the opportunity to both move the data into a more secure repository built on SQL Server through a SharePoint 2010 Enterprise Server Interface, yet also maintain the client applications. The new Access Web Databases are hybrid in that they both support a native client Access application and a pure browser based interface to the SharePoint host.
Access 2010 Web Databases offer the opportunity to exploit the fantastic RAD capabilities of the product and yet allow business level users for the first time to develop a solution which can be delivered through a browser interface.
Detailed topics
Relational database structure vs. SharePoint Lookups and Relationships.
How to migrate existing applications.
RAD fast with Access 2010 deploying a web browser interface, setting new standard.
Macro Programming and more advanced topics.
|
300
BI
Buiding highly performant data flows takes more than just dragging a few boxes onto the design surface and wiring them up. In this session I'll talk about SSIS's buffer architecture, synchronous and asynchronous transformations, performance tuning knobs and, most important of all, designing for performance.
|
300
BI
DAX is Microsoft's new multidimensional calculation language. At the moment it's only used in PowerPivot, but in the future it's likely to have an important role in other corporate BI products from Microsoft, so it's something that all BI consultants need to learn now. In this session we'll learn about the basic concepts of the language and see how it can be used to implement a number of common business calculations.
|
|
|
200
Kat
Consolidation of SQL Server infrastructure has become increasingly popular.
This is true from both a technological and financial perspective, may it be through virtualization, instance concentration or in building SQL Server hotel environments.
This is an in-depth presentation on one of the biggest consolidation projects so far in the Nordic countries based on SQL Server 2008.
This presentation will cover both the business aspects as well as the technical reasons behind this project by two of its top resources.
In one year the customer went from nearly 200 physical machines hosting over 1100 databases to only 20 servers without using any form of virtualization!
Topics that will be covered in this session include:
- Why did we go for SQL Server 2008?
- How to handle 3rd party hosting partners.
- How we gotthe project sold, generating a solid proof POC.
- How did we identify potential servers and databases spread across multiple countries?
- How did we identify easy wins from the high-end systems using resource consumption monitoring?
- How did we allocate the right resources for the project?
- How did we create the right rules and setup going from a shared noting, to a share all environment?
- What was the biggest success and what could have been done better.
- How we created a private cloud using an internal invoicing system based on resource consumption.
- What we did to meet the different deadlines and how to finish a project in time.
|
200
DBA
This session provides an overview of a recent customer engagement to investigate storage performance problems and evaluate potential solutions. The session include details on measuring performance of the existing storage solution, profiling SQL Server disk IO activity and tools to simulate load and evaluate performance.
The session will discuss the benefits and drawbacks of traditional high performance SAN based solutions and compare these with SSD and ioMemory solutions.
The session includes a case information from a customer deployment where performance of existing shared SAN storage was evaluated and a high performance storage solution implemented.
|
300
DBA
Transaction Replication is a widely used feature in SQL Server though its internals are sparsely understood.
In this session we will look under the hood and gain indepth understanding about Transactional Replication architecture and its corresponding components like logreader and distribution agents, Reader/Writer threads, etc. We will learn methods of identifying and monitoring replication latency and methods of troubleshooting and eliminating bottlenecks to improve Replication Performance.
|
300
BI
This session contains tips and tricks for modelling a high performance cube both in terms of processing and querying. I will demonstrate how attribute relationships play a crucial role in a cube design , why are hierachies important , how to make sure aggregations are used efficiently and many more tips around dimensional modelling , AS server configuration etc .
Expect loads of demos and real life examples.
|
100
BI
The origins, use and evolution of OLAP software over the last 25 years. This is a personal view (not a history lesson) from an experienced BI practitioner who has used a variety of OLAP software, such as, SQL Server Analysis Services since graduating in 1985.
|
|
|
300
Dev
SQL Azure is Microsoft’s new strategy for storing your data in the cloud, but what to do when you exceed the 10/50GB limit. This is where sharding or partitioning comes into play – this session shows you how it can be done in an OLTP system and show you some of the common pitfalls of SQL azure as we have discoverd in analyzing SQL Azure as an alternative to onsite SQL Server instances at different clients.
|
300
BI
After years of careful observation and recording of the Species SSIS, Genus ETL, in both natural and artificial environments, I’ve gathered a large collection of fieldnotes. Find out the little decisions that get made that can have big impacts on your project later on. What option to choose for better performance, or better management, and what are the trade-offs? This session won’t just focus on the holy grail of performance, it will review the way you build packages and use SSIS taking into account the on going maintenance and management aspects as well.
|
400
Dev
In this session we will get deep under the covers of what happens when you build a StreamInsight Application. We will cover
LINQ Queries Debugging Batching SQL Inserts (Procs and Bulk Insert) and lots lots more.
This is an exciting new technology for real time processing of data and analytics. Don't miss this session
|
300
Dev
SQL Server implements three different physical operators to perform joins. In this session, we will examine how each of these operators works, including its advantages and challenges. Using real life examples, we will better understand the logic behind the optimizer’s decisions on which operator to use for various joins. Finally, we will learn how to avoid some common join related pitfalls and how to get better performance from our queries.
|
300
DBA
SQLDIAG is a great tool that was introduced in SQL Server 2005 to help co-ordinate the collection of perfmon logs and SQLTraces as well as gathering other system data. In this session you’ll learn how to configure, customize and run SQLDIAG as well as the perfstats script from Microsoft which adds locking, blocking and wait stats to the list of collectors that SQLDIAG co-ordinates. This tool is one of the secrets of the trade for efficient data collection and this session is a must for anyone not using it extensively already. Using the output from sqldiag we'll then look at SQLNexus to analyze the results. I'll show you how to configure, run and draw conclusions from the reports created by this tool which is by far the most useful piece of software in the troubleshooting kit bag of people that have taken the time to learn it. This session is based on 2 chapters from Professional SQL Server 2008 Internals and Troubleshooting.
|
200
Kat
In this session Greg Gonzalez, SQL Sentry founder,will show you how to take your query tuning to a new level with SQL Sentry’sinnovative new query analysis features. See how these features greatly expandupon the capabilities of the graphical plan designer in SSMS, providingmultiple ways to quickly analyze query plans that have never before been available.
|
200
BI
When you're starting out on your first Analysis Services project it's very easy to make design mistakes that can cause problems for you later on. In this session you'll learn about the mostly frequently make Analysis Services design mistakes, what the consequences of making them are, and how to fix them.
|
400
Dev
Service Broker provides several new key features for building SOA applications directly with SQL Server 2008. This "No slides – just code" session shows you, in just 75 minutes, how to build an SOA-based, secure, reliable, and distributed messaging application with SQL Server 2008 Service Broker from scratch. In this session you will see:
*) The core architectural concepts behind Service Broker
*) How you can do SOA with Service Broker – a practical approach
*) Routing between several SQL Server instances
*) Implementing reliable messaging
*) Securing a Service Broker conversation between you and your trading partners
*) Using managed code in Service Broker applications
|
100
Dev
Database projects allow offline development and easy deployment of a database. Previously they were only available in team system versions of visual studio, but with the release of visual 2010 they will also be available in the professional version. This presentation will introduce the key concepts of database projects. It will also show you how to create a database project, import an existing database, modify objects and then deploy it to any sql server.
|
300
DBA
Being a specialist in SQL Server is not enough. SQL Server, the platform it runs on, the interfaces that it consumes and the technologies that effect it are becoming ever more complex. Being aware of, and learning about these technologies can make you a better DBA.
In this session, discover what skills you need to learn, why you need to learn them and how you can use them and these tools to your advantage.
The presentation will include :-
- SQL Instance Enterprise name resolution strategies.
- Failing cluster groups BETWEEN independent clusters.
- Using the CLR to expose and manage the OS from the SQL Instance.
- Being aware of your environment.
- Its always the DBA's fault.
- Keeping your instances standardised.
This session will present real world solutions and practices to real world problems.
|
200
Kat
Powershell is a powerful scripting engine that can be used to automate admin tasks making more efficient use of your time. This session will introduce Powershell and how it can be used within a SQL Server environment.
|
200
Kat
In this session Greg Gonzalez, SQL Sentry founder,will show you how to take your query tuning to a new level with SQL Sentry’sinnovative new query analysis features. See how these features greatly expandupon the capabilities of the graphical plan designer in SSMS, providingmultiple ways to quickly analyze query plans that have never before been available.
|
100
BI
Reporting is an essential and highly-visible part of running a business. Reports can be distorted and misinterpreted, ultimately leading to poor business decisions. Thus, the enterprise can end up like Alice in 'Through the Looking Glass' - madly running on the spot in the Red Queen's Race, but staying in the same place, without moving forward.
Using SSRS, this presentation aims to present some guidance around report design in order to maximise the interpretation of the data presented, in addition to providing some tips and tricks on Reporting Services.
The target audience is anyone who feels that they are running on the spot in the Red Queen's Race, and needs some pointers around SSRS!
|
200
BI
Master Data Services (MDS) is a new component in the R2 release of Microsoft SQL Server 2008 that allows organisations to centrally manage data from multiple sources in order to produce a single view of cleaned and trustworthy master data.
The heart of this session will be an end-to-end technical demo that will show the role of MDS in extracting master data from source systems, before demonstrating how data is fed via MDS to subscribing downstream systems. Whilst the focus of the session will be on MDS, other parts of the Microsoft BI stack will be shown, in order to demonstrate how a Microsoft MDM solution complements existing parts of SQL Server.
|
300
BI
I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward.
The samples that you can find online are not allways functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into.
After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc.
This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages.This session should also be usefull if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)
|
200
BI
With Reporting Services 2008 R2, Microsoft takes a step forward in presenting SQL Server as an enterprise data platform. Innovations in data regions, vast improvements in visualisation, and a new Report Builder 3 application,
This session will focus on the new features and walk through the authoring, management and delivery of reports, focusing on the new features of Reporting Services 2008 R2,
This session will focus on...
- Report Designer Controls
- Data Visualisation
- Report Builder 3
- Extended Expression Support
-
Report Management
|
300
Dev
So, you’ve got good design, got correct indexes, hell, you’ve even got good sargability. But your system is still slow. What’s the problem? The chances are your SQL Code is asking too much of your hardware.
In this session, I will demonstrate why a set-based mindset is so critical to performance and some simple techniques to lower resource usage through better use of TSQL code.
|
200
Kat
Attunity will be presentingtheir award winning change data capture (CDC) products for SSIS. Now supportingOracle, DB2 zOS, DB2 iSeries, HP NonStop SQL/MP, HP OpenVMS RMS and SQL Server2000/2005/2008/R2 the CDC Suite for SSIS enables operational replication acrossheterogeneous systems and can dramatically reduce ETL load times. This session will discuss whatchange data capture is, why it's used, and will demonstrate how CDC processingcan be seamlessly integrated into SSIS.
|
300
Dev
In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more.
After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.
|
200
BI
SSRS 2008 and in particular R2 introduces some great features for visualising data. This session will look at some of the principles of data visualisation as advocated by Stephen Few, Edward Tufte etc and how you can put them into practice when building great looking dasboards and reports using Reporting Services. Warning - you may never used a 3d pie chart again after this session :)
|
300
DBA
DBAs need to be pro-active, that means the data should be recovered or available quickly or be prepared for worst.
How can you be assured that your RECOVERY strategies are best?
How many times you have tested the backups?
So the action should be quickly, when you encounter a problem that could lead to a loss of data in a customer location which terms as "Data Recovery" problem.
SQL Server 2008 brings flavour of new and enhancements to existing features to correct various problems like DBCC CHECKDB failing or database being marked as suspect or log file fails to restore etc. This session covers how to take corrective actions and what process need to be in place in yoru database platforms.
(Prior DBA knowledge is essential)
|
200
Dev
An introductory session on CLR integration within SQL Server, looking at what is required for implementation of CLR types, aggregates, triggers, stored procedures and functions. A few practical examples will also be covered, including some performance-based CLR implementations, as well as maintenance based ones.
- Overview of CLR in SQL Server
- Explore all types of CLR object
- The differences in CLR permission sets
- Worked examples of problem-solving with the CLR
|
200
Kat
DAC (Data Tier Applications) introduced in SQL Server® 2008 R2 release, in collaboration with Microsoft Visual Studio® 2010 it allows Developers & DBAs to develop and deploy Data Tier Applications in self-contained units (dacpacs)
Using DACs, developers and database administrators can now automate common operations and design practices during their database lifecycles in controlled environments
We will discuss the key features and perform some demonstrations of the development & then deployments of a dacpac, as with any new feature it presently has several limitations, we will discuss those and where/when this feature can be used to good effect.
|
200
Kat
Attunity will be presentingtheir award winning change data capture (CDC) products for SSIS. Now supportingOracle, DB2 zOS, DB2 iSeries, HP NonStop SQL/MP, HP OpenVMS RMS and SQL Server2000/2005/2008/R2 the CDC Suite for SSIS enables operational replication acrossheterogeneous systems and can dramatically reduce ETL load times. This session will discuss whatchange data capture is, why it's used, and will demonstrate how CDC processingcan be seamlessly integrated into SSIS.
|
100
DBA
This session introduces some key concepts and product features of the Oracle database world in an attempt to give nervous SQL Server DBAs the courage to at least have a go and store “Hello world” when they get back home. The presentation will cover the following areas: Why use Oracle, Installation, Platform support, Database and schema namespaces, DBA tools, Storage methods, Backup and recovery, Programmability features, High availability including clustering.
|
200
DBA
The increase in the amount of spatial data created and consumed has created a demand for storage of spatial data within the database. While SQL makes it seem easy to work with spatial data, the odd shape of the earth, alternative projection systems and various spatial indexing algorithms mean that working with spatial data requires a bit of background knowledge and some understanding of the domain. This session introduces database professionals to spatial data concepts so that they can be better prepared to implement geospatial solutions.
|