[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB

Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners...

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:
The concert hall at the Sydney...

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come up with a set of rules or start...

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...

Powershell – Copy the Latest Backup

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess...

Brand Level Zero

It’s that time of year when people look back on the past year(s) and think about what they have and...

Finding a common AD group for a set of users.

I work for a large organization that over the last few years has been doing a LOT of reorgs. And...

Do you want to build an Audit?

So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql...

SQL Server 2014 Best Practice: Set built-in Sysadmin(sa) account as an default owner of all databases on SQL Server instance

As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the...