SQL Server Powershell Extensions PowerGUI PowerPack
If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is...
2009-07-24
1,169 reads
Chad Miller
Orlando PASS User Group Presentation
I presented a one-hour session for Orlando PASS User Group on Powershell and SQL Server. I had previously given this talk...
2009-07-12
624 reads
Powershell Charting with MS Chart Controls
Richard MacDonald's demonstrates using Microsoft Chart Controls with Powershell in his post, Charting with Powershell. The chart controls are free and work with...
2009-07-09
3,476 reads
Powershell SQL Server Backup/Restore
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,150 reads
SQLPSX Release 1.6
I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions,...
2009-06-28
1,613 reads
Powershell + SMO Error Handling Tips
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,676 reads
Adventures in Powershell SSIS Administration Programming
In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with...
2009-06-19
1,550 reads
Creating Red Gate SQL Compare Snapshots with Powershell
Co-worker and fellow DBA,, John O'Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out...
2009-06-17
1,065 reads
Give Me a Coconut and Six Months
Tim Benninghof tagged me with the question. "So You’re On A Deserted Island With WiFi and you’re still on the...
2009-06-13
462 reads
Backup Monitoring and Reporting
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
2009-06-04
16,244 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
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
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
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