Speaking at SQLSaturday #30 in Richmond
I'll be presenting two sessions this Saturday (January 30, 2010) in Richmond - Automate SQL Server Administration with PowerShell and Gather...
2010-01-25
369 reads
SQL Saturday 30 – Richmond VA
This weekend, I’ll be headed for the east coast to speak at the SQL Saturday in Richmond, VA on Saturday. ...
2010-01-25
717 reads
Microsoft – Follow best practices – Part 2
In addition to my previous post, another best practice is to not use NOLOCK and READ UNCOMMITTED transaction isolation level.
Here’s...
2010-01-25
554 reads
Should You Achieve All Your Goals?
So many people wrote posts at the end of 2009 analyzing their goals and what they achieved. I did the...
2010-01-25
1,045 reads
Web Site Tuning
I just spent a couple days doing some minor tuning on SQLShare and here are some notes from that effort.
I...
2010-01-25
605 reads
Working with ADO.Net variables in SSIS scripts
I am always looking to improve the performance of my SSIS packages. I try to do as much work within...
2010-01-25
5,302 reads
Living with TED 5000
Since I installed my TED 5000 home energy monitor about a week ago, I have learned quite a bit about...
2010-01-25
941 reads
XML Index - ALTER INDEX with REBUILD Issue
I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...
2010-01-24
667 reads
Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-24
1,905 reads
SQLSaturday 32 – Tampa Recap
I had the privilege to attend and speak at SQLSaturday 32 – Tampa this past weekend. As I said in my...
2010-01-24
563 reads
Blogs
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...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
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