Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild
Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...
2010-09-29
5,048 reads
Blog Posts
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
2010-09-29
2,207 reads
Upcoming Florida Events
Lots of events in Florida, easy to lose track! The Tallahassee Code Camp is October 23, 2010, details at http://www.tallycodecamp.org/...
2010-09-29
1,684 reads
Do You Have Influence? Part 3
I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you...
2010-09-28
712 reads
Find the largest tables in a database
From time to time, I need to find the largest tables in terms of rows / used space / total space etc....
2010-09-28
33,277 reads
Knight's Microsoft Business Intelligence 24-Hour Trainer released
Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release. In this book you will learn about...
2010-09-28
965 reads
Lessons from a Great Mentor
On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He...
2010-09-28
927 reads
Open-Source Databases are Not Free, MySQL has a High Cost, According to MySQL.com Itself
After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those...
2010-09-28
1,194 reads
Performance Tuning Analysis Services (SSAS) Webinar Today
Thanks for coming to today's webinar. We had a great turnout and hope to see you again soon. I have...
2010-09-28
448 reads
Performing a Cross Join (Cartesian Product) in SSIS
There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS. One of...
2010-09-28
4,382 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