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

SQLSaturday Orlando Marketing Plan-Part 37

I’m continuing to experiment with the messaging. Without A/B testing (and maybe even with, given the small list size) it’s...

Still a Need for a SQL Server Specific Organization

If you haven’t already, please read Denise McInerney’s post about why PASS no longer stands for the Professional Association for...

The End of The Professional Association Of SQL Server? It Should Be More Than Just An Acronym

I read with a bit of despair this post by Denise McInerney this morning. Going forward, it’s just “PASS”. Somehow...

The Red Gate Way…

As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind...

Two years!

Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...