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.
Have you ever been curious about how SQL Server returns the results of your queries to you? Have you ever opened an execution plan but been bewildered by the results? Have you dabbled in query tuning, but weren’t sure where to focus your efforts?
You have heard the term ‘parameter sniffing’, but you’re always a little bit fuzzy on the details. Is this a bug in SQL Server? Could it be happening to you? This video explains the truth about this complex and often confusing feature in SQL Server.
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 …
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 …
You think locking and blocking in SQL Server may be slowing down your application, but you’re not sure how much of a problem it’s causing. In this video, you learn how to find lock waits and decode what they mean.
