PowerShell for Batch Operations
I’m right in the middle of moving one of our databases from Oracle to SQL Server (and I just love...
2010-03-01
1,688 reads
March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-03-01
1,008 reads
Speaker Evaluations for SQLSaturday #32 – Tampa
I recently received my Speaker Evaluations for my session, Why I Use Stored Procedures, from Pam Shaw (@pamshaw) and as...
2010-03-01
440 reads
How Do You Drive Your DBA Mad?
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
2010-03-01
1,585 reads
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-01
3,209 reads
Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-01
3,482 reads
Rocky Mountain Tech Trifecta Impressions
I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack...
2010-02-28
1,491 reads
Rocky Mountain Tech Trifecta – Beginning SQL Server
At the Rocky Mountain Tech Trifecta this past weekend in Denver, I presented a talk on “Beginning SQL Server”, a...
2010-02-28
1,572 reads
Weekly Electrical Usage from Google PowerMeter
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,572 reads
SQL Agent – Giving non-SA users permissions on jobs
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more...
2010-02-28
15,122 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
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...
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