SQL Server – How to Rename Table/Column in SQL Server
To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via...
2013-03-04
2,024 reads
Blog Posts
SQL Server 2012 Diagnostic Information Queries (March 2013)
Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-03-04
1,070 reads
The end of the Internet, data and the PC
The Big Data revolution will be more important than the PC or the Internet. While there were many...
2013-03-04
11 reads
The end of the Internet, data and the PC
The Big Data revolution will be more important than the PC or the Internet. While there were many interesting conversations last week at Strata, two new publications captured my...
2013-03-04
16 reads
Trust in Access
One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you...
2013-03-04
683 reads
Using Object Typed Variables in SSIS
Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration...
2013-03-04
1,671 reads
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
675 reads
What is mssqlsystemresource?
If you are lucky you’ve never seen an error along the lines of:
The SELECT permission was denied on the object...
2013-03-04
1,007 reads
Baton Rouge SQL Server User Group
Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge,...
2013-03-03
712 reads
List all Objects and Indexes per Filegroup / Partition
Today, I received a call from friend asking how he can find out which database object belongs to which filegroup.
Well...
2013-03-03
1,668 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