May 21
I will be teaching a half day course on SQL Server security and auditing for the Midlands Chapter of...

2009-04-30

1,524 reads

Midlands PASS May Meeting

by Brian Kelley

Databases – Infrastructure – Security

The Midlands PASS Chapter will be meeting next Thursday night, May 7, at Training Concepts. We have the privilege of welcoming...

2009-04-30

1,413 reads

The #1 Secret to Building Your Skill Set is...

by Brian Kelley

Databases – Infrastructure – Security

Self-Discipline
Yes, I've said it: self-discipline.
I'm reading a book called Disciplines of a Godly Man by R. Kent Hughes. Now...

2009-04-29

1,983 reads

Security Basics: Defense-in-Depth

by Brian Kelley

Databases – Infrastructure – Security

In my security presentations, another basic I talk about is defense-in-depth. The idea here is to produce multiple layers of...

2009-04-28

4,238 reads

SQL Quiz 4: Leadership

by Brian Kelley

Databases – Infrastructure – Security

I'm finally getting around to answering this one originated by Chris Shaw (@SQLShaw), as I was tagged by Jack Corbett...

2009-04-27

738 reads

Patterns & Practices SIG starting up in Columbia, SC

by Brian Kelley

Databases – Infrastructure – Security

C# MVP Chris Eargle (@kodefuguru on Twitter), who is also an INETA community champion and president of the Columbia Enterprise...

2009-04-24

1,008 reads

SQL Server Security Basics: Why Would I Use SQL Server Authentication?

by Brian Kelley

Databases – Infrastructure – Security

The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL...

2009-04-24

3,819 reads

Simple Maintenance Tasks for Non-Production Databases

by Brian Kelley

Databases – Infrastructure – Security

Log File Sizes:
It's not unusual to see cases where database backups are taken from production and restored to a development or QA environment....

2009-04-23

1,345 reads

Catalog View: sys.sql_logins

by Brian Kelley

Databases – Infrastructure – Security

When it comes to logins to SQL Server, there are basically 3 types:
SQL Server-based loginsWindows user accountsWindows security groupsThe latter...

2009-04-22

6,933 reads

SQL Server Security Basics: Logins vs. Users

by Brian Kelley

Databases – Infrastructure – Security

When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...

2009-04-21

22,742 reads

Speaking / Teaching Engagements in May

Midlands PASS May Meeting

The #1 Secret to Building Your Skill Set is...

Security Basics: Defense-in-Depth

SQL Quiz 4: Leadership

Patterns & Practices SIG starting up in Columbia, SC

SQL Server Security Basics: Why Would I Use SQL Server Authentication?

Simple Maintenance Tasks for Non-Production Databases

Catalog View: sys.sql_logins

SQL Server Security Basics: Logins vs. Users

Blogs

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

SQL 2025 SSMS Nonsense

PowerBI Question - Data Sources

SQL Server Certificates

Question of the Day

Limiting Checkpoints