Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
2015-06-12 (first published: 2013-02-18)
21,039 reads
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-30 (first published: 2015-04-17)
5,137 reads
I’m a big fan of automation. I’ve been in IT for 27 years now. One unchanging rule during that time...
2015-04-20 (first published: 2015-04-09)
5,071 reads
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-17
302 reads
At the Charlotte BI Group meeting last night, one of the questions I was asked after I gave my talk...
2015-04-16 (first published: 2015-04-08)
5,456 reads
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
675 reads
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
416 reads
I’m a big fan of automation. I’ve been in IT for 27 years now. One unchanging rule during that time...
2015-04-09
304 reads
At the Charlotte BI Group meeting last night, one of the questions I was asked after I gave my talk...
2015-04-08
285 reads
Tomorrow, Tuesday, April 7, 2015, I’ll be speaking at the Charlotte BI user group. The meeting starts at 5:30 PM.
Here’s...
2015-04-06
216 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
Comments posted to this topic are about the item BIT_COUNT in SQL Server
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