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.
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.
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.
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
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.
If you want to learn how to make your business systems available then attend this session
Explore the new features of SQL Server 2008 R2 Reporting Services
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
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.
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.