Do you need to find out where the location of your SQL Server's database is? Use this quick tip from Arthur Fuller to show you how. Sometimes your application needs to know the specific directory ...

There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

Historically, database auditing and database performance have been like oil and water; they don’t mix. So auditing is often eliminated, because performance drag on critical systems is unacceptable. In ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...