At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...

At Microsoft Build 2025, we announced the public preview of SQL Server 2025. Built on a foundation of best-in-class security, performance, and availability, SQL Server 2025 empowers customers to ...

Existing index tuners typically rely on the “what if” API provided by the query optimizer to estimate the execution cost of a query on top of an index configuration. Such cost estimates can be ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

Abstract: Data explosion with knowledge shortage is becoming increasingly prominent. By utilizing business intelligence technology, supply chain analytics turns data into business insights and ...

Part of the problem is that there is no magic bullet, and for almost every best practice, I can show you at least one exception. Typically, a developer finds his or her own favorite methods — though ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...