Log is Filling Up
Today I ran across Paul Randal’s latest post showing how to find open transactions and such. This is a nice...
2010-02-05
532 reads
Another free tool for SQL Server...
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,130 reads
Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008
I had a little bit of excitement with one of my production servers couple of days ago, that I thought...
2010-02-04
3,164 reads
SQL Server Default Trace
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...
2010-02-04
3,883 reads
oPASS Meeting Reminder – February 9, 2010
Our next meeting is February 9, 2010, We’ve got Ronald Dameron coming to speak this month on Database Hardening using...
2010-02-04
325 reads
SQLSaturday #42 Announced!
Dave Schutz will be leading the first ever SQLSaturday in Columbus, OH on June 5, 2010 at the Fawcett Center...
2010-02-04
333 reads
I think it’s a hole
The other day I was trying to help someone that had removed the BUILTIN/Administrators logins from their instance without first...
2010-02-04
817 reads
Three Things That Got Me Here
Tim Mitchell (Blog | Twitter) and Jack Corbett (Blog | Twitter) both tagged me in the latest meme circulating through the SQL...
2010-02-04
559 reads
Troubleshooting and Optimising SQL 2008 Reporting Services Configuration for Microsoft Dynamics CRM 4.0
Recently we have been struggling with configuration and installation of SQL Server Reporting Services 2008 when there was a co-existing...
2010-02-04
4,169 reads
February Question: What is one of your best practices for making full backups and transactions log backups of your production databases?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-02-04
576 reads
Blogs
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers