Sessions & Content

Tags
Content Type
Search
Conference
Advanced SQL Server 2008 Troubleshooting
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
Around the world (of query plan operators) in 50 minutes
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
Gather SQL Server Performance Data with PowerShell
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
Inside Ola Hallengrens Maintenance Solution
How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.
Let Service Broker Help You Scale Your Application
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
T-SQL : Bad Habits to Kick
This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.
TSQL Performance Recommendations
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
<<1>>