SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2009

Stored Procedures to Store and Get Database Users with All Permissions

Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the Generate Scripts wizard to script all logins and permissions. This approach can take several minutes and as I recently learned does not script database level permissions.

Bothered by… Read more

0 comments, 1,410 reads

Posted in Adventures in SQL on 31 December 2009

Script Individual User Rights in a Database with PowerShell


Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a specific user. I wrote a script once that I was pretty sure did that so I jumped in to help. It turns out that I lost that particular script… Read more

0 comments, 1,213 reads

Posted in Adventures in SQL on 31 December 2009

A Busy/Accidental DBA’s Guide to Managing VLFs


Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there on the proper management of VLFs, but nothing I have found that tries to boil it down to the most important parts. So here it is, my attempt at… Read more

1 comments, 771 reads

Posted in Adventures in SQL on 21 December 2009

How to Shrink TempDB in SQL 2005


From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never my first choice but sometimes it is the best I have. Many people think that you cannot shrink TempDB in SQL 2005, but I am going to show you… Read more

2 comments, 2,317 reads

Posted in Adventures in SQL on 17 December 2009