Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't.

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of ...

Development hiring managers and potential interviewees may find these open-ended SQL Server proficiency interview Q&As useful.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.

Hyperscale is an Azure SQL Database built upon a new set of Hyperscale storage technologies that enable high throughput and performance, databases of up to 100Tb in size, and offers very elastic and ...