Sessions & Content

Search
Content Type
Conference
Tags
Advanced SQL Server 2008 Troubleshooting Klaus Aschenbrenner
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 David Morrison
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
The video is not available to view online.
Gather SQL Server Performance Data with PowerShell Allen White
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.
Hey PowerShell Eventing, can you notify me ? Laerte Junior
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?
Inside Ola Hallengrens Maintenance Solution Ola Hallengren
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 Allen White
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.
LogParser-quicker than SSIS, easier than BCP Jonathan Allen
LogParser is a free data application that anyone working with SQL Server should know about, come along and see how you could use it.
Many-to-Many Relationships in DAX Alberto Ferrari
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
The forgotten DBA daily essential checklist Francesco Quaratino
Well, I'm a DBA and one of my duties is to check that all SQL Server stuff are in the right place. It's a routine job, but, probably, the most important duty as DBA because it can help me to predict many important problems.
T-SQL : Bad Habits to Kick Aaron Bertrand
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 Milos Radivojevic
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.
Understanding SQL Server Execution Plans Klaus Aschenbrenner
Do you know SQL Server Execution Plans? Yes! - and can you read/analyze them? No... For the beginner it is not very easy to understand and explain execution plans generated by SQL Server for your queries.
Whats New in Denali-DB engine and client tools Aaron Bertrand
An overview of the engine and tools changes coming in SQL Server "Denali" - including some of the features that will stop working.
The video is not available to view online.
Whats new in Denali-TSQL Dave Ballantyne
A look at the new TSQL functionality within denali
Working with Server Side Traces Christina E. Leo
Learn to create and customise TSQL scripts for capturing SQL Profiler data in a server side trace. Examine methods for stopping, starting and storing these traces, and finally look at free tools available for analysing the captured data.
<<1>>