Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,957 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
The Three A’s: Auditing
Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...
2017-07-13 (first published: 2017-06-28)
1,631 reads
The Three A’s: Authorization
Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know...
2017-07-10 (first published: 2017-06-27)
1,673 reads
The Three A’s: Authentication
When I start talking with folks about security, one of the areas of confusion I often find has to do...
2017-07-05 (first published: 2017-06-26)
1,832 reads
Recording of PASS Security VC Webinar
If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...
2017-06-29
570 reads
#SQLChat on Performance Issues
Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource...
2017-06-23
380 reads
PASS Security VC Presentation – The Dirty Business of Auditing
On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...
2017-06-19
375 reads
Speaking at Charleston PASS on May 18, 2017
During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening...
2017-05-12
326 reads
Slides from 24 Hours of PASS – Data Security
As promised, here are my slides from the 24 Hours of PASS on Data Security:
S1 – Brian Kelley_WhatYouAbsolutelyMustKnowAboutSQLServerSecurity (.pptx – 733 KB)
S7 – Brian...
2017-05-09
392 reads
Slides from SSWUG 2017 Spring Virtual Conference
As promised, here are the slides for my two presentations from SSWUG’s 2017 Spring Virtual Conference:
SSWUG_Spring_Building an Auditing Framework for...
2017-05-08
329 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers