Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.
2019-09-18 (first published: 2003-12-12)
64,211 reads
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,018 reads
SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.
2013-11-08 (first published: 2009-03-09)
37,793 reads
Longtime author Brian Kelley brings us a new article on security and Kerberos authentication in SQL Server.
2011-03-28 (first published: 2008-12-11)
61,026 reads
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-11
2,330 reads
Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...
2011-02-08
1,933 reads
Cross-posted from a Goal Keeping DBA blog:
Just recently, my oldest son entered the ranks of the teenagers. I shouldn’t actually...
2010-12-10
2,038 reads
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
2010-12-07
2,805 reads
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
2010-11-01
2,380 reads
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
2010-09-02
6,438 reads
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I am a bit stuck on how to write this query. Below...
Comments posted to this topic are about the item Powershell script to generate SQL...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers