The Performance Impact to Prefix Stored Procedures with sp_
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,463 reads
Blog Posts
T-SQL Tuesday #39 – Wrapup
Last week, I hosted the T-SQL Tuesday blogging party event, and the topic was on how do you use PowerShell...
2013-02-19
986 reads
Using Team Foundation Service
Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012. Up to 5 users are free, plus for a...
2013-02-19
1,276 reads
A Month of PowerShell – Day 18 (Databases: Stored Procedures)
Welcome to Day 18 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-18
797 reads
Building My Next Workstation–Part 1
It’s been four years – maybe more – since I last bought a workstation to use for development and lab work. It’s...
2013-02-18
746 reads
Configuring PerformancePoint Data Source for Time Intelligence
PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’. Data sources that...
2013-02-18
1,848 reads
Get Data Warehouse Training and Help a Neat School
If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on...
2013-02-18
1,107 reads
Last Weeks Top 20 “Reading” Links #20
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-18
598 reads
Multiple instances, single query window
Anyone who has been reading my blog for a while should realize that several divisions in my company have been...
2013-02-18
1,023 reads
Off to Redmond
Actually I’m off to Bellevue this week for the annual MVP Summit that Microsoft puts on each year. This is...
2013-02-18
786 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