Grant Execute Permission on All Stored Procedures

Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...

Gain exclusive control of a database

Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...

SQL Server:Understanding The Page Free Space (PFS) Page

In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...

X-XMLA: vii. Partition Management with XMLA

In the 7th article of this series, I will discuss how to manage your partitions with XMLA.   We will be...

Lose #5 Before #sqlpass

Win Valuable Prizes!

Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...

PASS 2012 Countdown – 4 Weeks To Go

One week down and we are now 4-weeks from this years PASS Summit.  Hopefully, you have already registered for the...

Update with UPDLOCK

Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...

Auditing changes in Merge Replication

One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...

Generate Uniqueidentifier with SSIS

If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...

Slides and Scripts from Idera Auditing SQL Server presentation

I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...