Windows 2012 for the DBA Setting Your Server to High Performance
Hello Dear Reader! I’ve been doing a lot of work with Windows Server 2012 lately. The interface is wildly different...
2013-02-27 (first published: 2013-02-20)
3,536 reads
Blog Posts
A Month of PowerShell – Day 20 (Databases: Table-Valued Functions)
Welcome to Day 20 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26 (first published: 2013-02-20)
2,762 reads
A Month of PowerShell – Day 26 (Changing Login Passwords)
Welcome to Day 26 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26
1,305 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 9: Time Series
by Steve Bolton
The data mining method known as Time Series is aptly named, because it seems to take a...
2013-02-26
3,124 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
12 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
13 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4...
2013-02-26
1,310 reads
Cost Threshold for Parallelism
Parallelism, where to start? Well let’s start right at the beginning shall we with the question, what is parallelism? Simply...
2013-02-26
3,523 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual...
2013-02-26
948 reads
Get Database information in mail using PowerShell !
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would...
2013-02-26
1,938 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