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,...

Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during...

ISPACs – Got To Love Em

Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...