LinkedIn Endorsements
Last year LinkedIn rolled out a new feature called endorsements, not to be confused with recommendations. Recommendations are free form...
2013-02-11
774 reads
Blog Posts
Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.
But Sometimes...
2013-02-11
1,826 reads
Right sizing your virtual machine for maximum database performance
I have a new blog post up at HouseOfBrick.com on why you should understand your workload performance characteristics. When you...
2013-02-11
940 reads
Something to watch out for when using sp_rename on Stored Procedures, Functions and Views
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically...
2013-02-11
2,346 reads
SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established
Today, I received an email from the development team complaining why they have not received any of the SQL Agent...
2013-02-11
4,497 reads
SQL Saturday #183 Albuquerque – Wrap Up
This past weekend was the first SQL Saturday in New Mexico. I had written about our trip down last week,...
2013-02-11
1,072 reads
SSIS Webinar Satisfaction Score
Our first free SSIS Webinar is over and the overall satisfaction score we got was 9.2 out of 10 so...
2013-02-11
1,006 reads
XML Support and SQL Server (Part 3)
Checkout the third part of my XML support and SQL Server article series here.
In this part, I talked about the...
2013-02-11
691 reads
Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores
My series 31 Days of Disaster recovery has been on hiatus due mostly to illness. I’ve been battling a chest...
2013-02-10
1,297 reads
Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup
Welcome back for day 26 of my series 31 Days of Disaster Recovery. Today I want to share a tale...
2013-02-10
1,123 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