Automated Source Control: A Librarian For Your Database Objects, Part 1

One of the biggest headaches in most development groups that do any sort of SQL Server work is that of...

Monitor the Number of Deleted Rows in a Clustered Columnstore Index

In some of my previous posts, I have talked about how to create Columnstore indexes. Now I’d like to discuss...

Notes on the August 19, 2014 Pinellas SQL Group Meeting

Busy week, should have blogged about it before the eventDid a remote presentation on securing credit card dataFirst time using...

Parameterization Part 1: Plan Caching

Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way...

Reviewing the PASS 2015 Budget

I just spent a few minutes reviewing the 2015 PASS budget, things that I noticed:
Anticipating a change in revenue of...

Silliness for an Important Cause

I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease...

SQLSat Birmingham: SQL Server Admin Best Practices with DMVs

Thanks for attending my session today SQL Server Admin Best Practices with DMVs at 8AM!

Here's the link to a .zip file...

SQLSat Birmingham: SQL Server Permissions and Security Principals

Thanks for attending my session today, SQL Server Permissions and Security Principals at 9:15AM!

Here's the link to a .zip file to...

Being a Volunteer Leader Is Hard

I’ve been thinking about this topic for a few weeks, maybe longer. It’s based on the three years I served...

Database Creation using Create Database command

In SQL Server, database can be created by 2 ways:-
 Using Create Database command Using SQL Sever Management Studio (SSMS).
In this article,...