Index Fragmentation : Quick Tip

Fragmentation can cause issues for performance to the point of having queries not resolve at all. Your normally scheduled maintenance...

Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !

I got motivated to write this post as there was a question on twitter which was like  -

The user was...

How SQL Server Full Backups Work

I’m writing this in support of a few talks I give that talk about backups. This is how I see...

Last Weeks Top “Reading” Links #57

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...

For the Aspiring DBA

Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...

PowerShell – Service Comparison GUI Tool

Service Comparison GUI Tool  does comparison of all the services of any given two servers. The output is a grid view...

Testing network throughput with iperf

Have you ever wondered if that black box in your datacenter called the network is performing as well as it...

Notes From SQLSaturday #248

For once the drive from Orlando to Tampa went smoothly, no delays due to accidents or construction or UFO’s, a...

Automated Permissions Auditing With Powershell and T-SQL: Part 1

A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly...

PASS Data Architecture VC presents Steve Simon–Challenges to Designing Financial Warehouses

Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look...