SQL Server Security Basics: Why Would I Use SQL Server Authentication?
The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL...
2009-04-24
3,828 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Simple Maintenance Tasks for Non-Production Databases
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,353 reads
Catalog View: sys.sql_logins
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,943 reads
SQL Server Security Basics: Logins vs. Users
When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...
2009-04-21
22,769 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have...
2009-04-20
9,117 reads
Getting Started with Technical Presentations
I was talking with a gentleman last night after the Greater Charleston .NET User Group about career development. He's not...
2009-04-17
794 reads
It's a .NET World!
Next week I'll be giving presentations in Charleston and in Florence here in South Carolina.
Tuesday, April 14, 2009 - Pee Dee...
2009-04-07
644 reads
Midlands PASS Meeting Tonight!
Next Meeting - April 2, 2009
SPEAKER:Paul S. Waters
During Paul’s 16 years of working in IT, he has held a variety of...
2009-04-02
694 reads
SQL Server Authentication Modes and Surface Area Test
One of the videos I did for JumpStart TV is up on the front page:
SQL Server Authentication Modes
It is an...
2009-03-16
1,148 reads
CONTROL SERVER vs. sysadmin membership
In a previous blog post on Detecting When a Login Has Implicit Access to a Database, I mentioned that having CONTROL SERVER rights means having implicit rights into the databases. Robert Davis posted a comment asking if there was a difference with respect to explicit permissions between being a member of the sysadmin fixed server role and having CONTROL SERVER rights.
2009-03-16
3,550 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers