The default filegroup, and why you should care.

You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index...

Synonyms, how and why.

Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even...

Hobbies, stress relief, and meeting management: T-SQL Tuesday #99

It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that...

Backups of backups or How long is my backup really available?

I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important,...

SQL Homework – February 2018 – Work with security

This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts

Create a SQL login and a Windows authenticated login....

The difference between blogging about something you know, and something you are learning (Love blogging! Live!)

Close but you need to blog about learning while blogging about the difference of blogging when you are learning something...

How To: Install SQL Server on an Azure VM

Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is...

Help it takes forever to open the SQL Server Log!

Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the...

What’s dbo?

Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...

How to read a technical blog

There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If...