SQL Server MasterClass
This Thursday gone, (June 18th) I went to a hotel near Heathrow airport in London for what was titled a...
2010-06-21
808 reads
Feature Packs for SQL Server (and SSIS)
Some of the best extensions for Integration Services (and SQL Server itself) are found in what Microsoft has released as...
2010-06-21
2,069 reads
T-SQL - Finding Changes
Someone posted a note recently asking about how to detect the changes in a sequence. Say you have a table...
2010-06-21
4,138 reads
Live Meeting Presentation – ETL with PowerShell
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,026 reads
SQL Server MasterClass Event Review
I often begrudge a 5am start to travel anywhere, let alone to SQL events but this was a trip definitely...
2010-06-19
525 reads
3.15Kw Grid-Tied Solar PV System Online
I took a day off work so I could be here when Namaste Solar and IREA came out to my...
2010-06-18
870 reads
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,952 reads
Finding Duplicates
This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a...
2010-06-18
1,123 reads
Learn SQL Server 2008 R2 with 24-HOP
Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for...
2010-06-18
411 reads
PASS Update #34 (The “Spring Event”!)
The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed...
2010-06-18
670 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