A View On Views

In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....

Over-Indexing can hurt your SQL Server performance

Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...

PASS Summit 2017 Day 2

It’s day 2 of the PASS Summit. Yesterday was a whirlwind of a day, after my early-morning post-Halloween trip to...

An overview of Python vs PowerShell for SQL Server Database Administration

Today, Microsoft claims that Linux runs like a First-Class citizen on Azure, .NET Core has been open-sourced, and has been...

SQL PASS Summit 2017 Day 2 – Keynote Notes and Ideas

This morning, Dr Rimma Nehme tells us the story of the birth of Azure Cosmos DB, a global, scale-out database system. At the beginning of the talk, I can already...

Microsoft MVP!?

What? Is probably the most common reply out there and if it is then that is how I felt when...

SQL Query Experiment - "WHERE" & "ON"

Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.

This happened recently...

Contained Databases

Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or used that it deserves even when it helps solving...

Contained Databases

Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...

Capture the most expensive queries across your SQL Server using Query Store

I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...