SQL Server

SQL Performance Issues: Query Compilation

Learn how to improve the performance of your SQL Server database and understand when the recompilation of queries is necessary and when it is not. Understanding query compilation issues from an operational perspective requires intimate familiarity with two indispensable tools: Performance Monitor and SQL Profiler.

SQL Server Installation Best Practices

You get only one chance to install your SQL Server correctly. Before you run setup.exe, there are some basic configuration steps that will make all the difference in performance and troubleshooting.

The SQL Server Magic

Think SQL Server is magical? You’re right! However, there’s some sense to the magic, and that’s what I’ll show you in this extremely deep dive session. Through my work in creating OrcaMDF, an open source parser for SQL Server databases, I’ve learned a lot of internal details for the SQL Server database file format.

What’s New in Manageability for Microsoft SQL Server 2012

Microsoft SQL Server 2012 has many new features and enhancements. With a focus on manageability,this session video tours new features including Contained Databases,Distributed Replay Utility,User Defined Roles,SQL Management Studio enhancements,and PowerShell. The session is demo-intensive and provides you clear guidance and strategy in the upcoming release of SQL Server.

SQL Server Backup Basics

This presentation explores the backup options available in SQL Server and how you can take advantage of SQL Server’s built in functionality to ensure that your data is safe, secure, and easily restored. Backups are something that we take for granted. As long as the backup jobs are working, there’s nothing to worry about, right?

Cloud-Ready Data Services

Windows Azure includes a complete set of enterprise-ready data services, including Windows Azure Storage and SQL Databases. In this demo-filled session developers will see how to can effectively use these services to develop and migrate data-centric applications to Windows Azure, while using familiar tools.