Sessions & Content

Search
Content Type
Conference
Tags
10 things you should never do with SQL Server Simon Sabin
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.
25 Years of OLAP Andrew Baker
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.
Alice's Adventures in Reporting Services Jennifer Stirrup
The target audience is anyone who feels, where reporting is concerned, that they are running on the spot in the Red Queen's Race! Please join me to learn more about the processes involved in designing, displaying and producing reports effectively, using SSRS.
Analysis Services Best Practices Ashwani Roy
Some tips and tricks which I have picked in my last few projects which can help you optimize cube design , optimize query and processing performance .
Attunity Change Data Capture for SSIS Attunity
Attunity will be presenting their award winning change data capture (CDC) products for SSIS. This session will discuss whatchange data capture is, why it's used, and will demonstrate how CDC processingcan be seamlessly integrated into SSIS.
Automating Admin Tasks with Powershell James Boother
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.
Automating SSIS Andre Kamman
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 :-)
Common Analysis Services design mistakes and how to avoid them Chris Webb
Learn about the most frequently made Analysis Services design mistakes, the problems they cause, and how to fix them or not make them in the first place
Consolidating data collection with SQLDIAG and analysing it all with SQLNexus Christian Bolton
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.
Creating a business Continuity Plan Buck Woody
If you want to learn how to make your business systems available then attend this session
Creating Compelling reports with Microsoft SQL Server 2008 R2 Chris Testa-O'Neill
Explore the new features of SQL Server 2008 R2 Reporting Services
DAC (Data Tier Applications) - Build and deploy your first Dacpac Neil Hambly
DAC(Data Tier Applications) a new feature introduced in SQL Server 2008 R2, learn how this new feature can fit into your database deployment lifecycle strategies, monitor the health & performance of your DAC applications using Utility Explorer
Designing and deploying a database using visual studio 2010 Anthony Brown
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.
Designing and Tuning high speed data loading Thomas Kejser
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server so come here my talk on the options you have.
Designing High Scale OLTP systems Thomas Kejser
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server. This talk focuses on lessons learned when using high end hardware and stressing it.
End to End Master Data Management with SQL Server Master Data Services Jeremy Kashel
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.
End-to-end database development has arrived Red Gate
TBA
Expert Query Analysis with SQL Sentry SentryOne
TBA
Expose the power of Recency Frequency analytics to your data using SQL Tony Rogerson
The technique of Recency Frequency Intensity/Monetary is a powerful analytical technique for identifying data patterns as well as 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!
Extreme scaling with SQL Azure Martin Schmidt
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.
<<123>>