Some server wide settings can have major negative impact if they are changed in your SQL … Logging changes to sys.configurationsRead more
Deny updates on a table but allow inserts
Sometimes it is nessesary to deny updates on a table, but allow inserts. This is the … Deny updates on a table but allow insertsRead more
Adding a Workflow step in Automate BPA Server
When designing workflows in Automate BPA Server, I like to “draw the big picture” first. That … Adding a Workflow step in Automate BPA ServerRead more
List SQL server roles by users
SQL Server roles can be used to give users server wide privileges. The server roles are … List SQL server roles by usersRead more
A replacement for syslogins
The system table sys.syslogins was marked as deprecated in SQL Server 2005, and is included up … A replacement for sysloginsRead more
Copy logins between SQL Server instances
If you are using SQL Server log shipping (or mirroring), you probably want to copy the … Copy logins between SQL Server instancesRead more
Tables larger than tempdb
If your database contains very large tables, querying or managing those tables may fill tempdb. When … Tables larger than tempdbRead more
Tempdb max size
There is always a limit on how large tempdb can get. Even if there are no … Tempdb max sizeRead more
sp_MSforeachdb
sp_MSforeachdb is an undocumented system stored procedure that lets you iterate through all databases on an … sp_MSforeachdbRead more
An alternative to xp_fixeddrives
Want to know the disk space available on your database server from T-SQL? This can be … An alternative to xp_fixeddrivesRead more