If you are experiencing deadlocks in SQL Server, you want to know more about them. What queries are causing them? What tables and indexes are at the root of the problem? You can find this information by using tools such as trace flags, Profiler, and Extended Events.
As a DBA, you constantly seek ways to optimize SQL Server database performance. One option is TempDB, a widely misunderstood system database that has a critical impact on how your SQL Server performs. Learn in this video what TempDB is for, how SQL Server uses it, how best to set it up, and how to …
Windows Azure SQL Database is a fully managed relational database service based on SQL Server technologies. This video provides a brief tour of Windows Azure SQL Database and shows how SQL Server Data Tools in Visual Studio 2013 interfaces with it, enabling rapid development of sophisticated relational databases in the Windows Azure cloud.