Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2009

Stored Procedures to Store and Get Database Users with All Permissions

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

Solution
Bothered by… Read more

0 comments, 753 reads

Posted in Adventures in SQL on 31 December 2009

Script Individual User Rights in a Database with PowerShell

Introduction

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, 570 reads

Posted in Adventures in SQL on 31 December 2009

A Busy/Accidental DBA’s Guide to Managing VLFs

Introduction

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, 373 reads

Posted in Adventures in SQL on 21 December 2009

How to Shrink TempDB in SQL 2005

Introduction

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, 791 reads

Posted in Adventures in SQL on 17 December 2009