Dealing with Database Corruption
Help, my database is corrupt. Now what? Views – 677
Shrinking TempDB and what to do when it doesn’t
This post is based on Tara’s recent blog post over on Brent Ozar’s site: and another: Basically, a query is killing your tempDB.…
Copy Logins to another server with SIDs and passwords
I often need to replicate logins to another SQL Server where the SID and password (for SQL login types, not Windows based) need…
Viewing the remaining restore time for rebuilding log-shipping
I sometimes need to rebuild the log-shipping for a database and if it is a large database the windows dialogs only display the…
Recycling SQL Server Error Logs without restarting the SQL service
You can recycle the SQL Error Logs without restarting the SQL service by using either of these 2 commands:
|
1 2 3 4 5 6 7 8 9 10 |
USE master; GO -- system sproc EXEC SP_CYCLE_ERRORLOG; -- or -- DBCC command DBCC ERRORLOG; |
Views – 679
Exploring WMI Resources and Tools
Here are some resources and tools for exploring WMI for PowerShell development: WMI Explorer – SorceForge Views – 855
Switching from SIMPLE to FULL Recovery Model
Important to note: if you switch from SIMPLE recovery model to FULL, you will need to take a full backup, otherwise you are…
Getting the groups an AD Principal is a member of
This query will return, filter and sort the groups an AD account is a member of:
|
1 |
Get-ADPrincipalGroupMembership lboveeadm | select name | sort name |
This query will return the AD…
Devart Studio for SQL Server Issues
I am documenting known issues I have run into with Devarts’ Studio for SQL Server here. I want to state up front that…
Why using GUIDs as Primary Keys on a Clustered Index (Table) is not a good idea and some alternative approaches
Here is a great blog post by Kimberly Tripp on why using GUIDs as a PRIMARY KEY on a CLUSTERED index is a…