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)
63,937 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)
20,966 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,458 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)
56,749 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,399 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers