Locking down your database environment can be a difficult task, but it doesn’t have to be. Learn how to protect your databases by using service accounts and encryption to secure your database files and network.
In situations where elevated permissions are needed to execute particular SQL Server jobs, or more importantly, steps within given jobs, a more secure way to tackle elevated permissions is to use credentials and proxies....More
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More