PowerShell Help Notes
A neat feature I just discovered was the -ShowWindow toggle when using Get-Help. This toggle allows you to redirect your output when using…
Read More
Manually removing log-shipping
I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…
Read More
Resolving the “Backup detected log corruption in database”
I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…
Read More
MSDB is in “Recovery Pending” state
I had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…
Read More
Moving the TempDB database to a new drive
Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…
Read More
Moving system databases to a new drive
A common task for any DBA building new SQL servers is to relocate where SQL Server stores user and system databases. This post…
Read More
Resolving “Cannot resolve collation conflict for equal to operation”
I recently had to run a query for one of our developers where the script was inserting a number of rows. All went…
Read More
“Why can’t I truncate my log file?!?”
I found a VERY useful query from Brent Ozar’s daily emails that go out on how you can check for the reason SQL…
Read More
Unblocking files downloaded from the Internet with IE
You can unblock a file downloaded from the Internet using IE as follows:
|
1 |
Unblock-File -Path ./myfile.zip |
Views – 1400
Read More
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.…
Read More