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,920 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
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,705 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,069 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
784 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
627 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
685 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,133 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
[Off-Topic] Eleven Year-Old Making a Difference
Those who know me personally know that I grow my hair out to donate for kids. I have donated a couple of times to Locks of Love . This past Saturday I participated in a hair collection drive led by 11 year-old Sarah Brotman: Midlands girl gets a haircut...
2009-03-13
1,452 reads
Microsoft March Security Bulletin Release
This month there were 3 security bulletins released and 1 re-released:
Microsoft Security Bulletin Summary for March 2009
First, let's tackle the...
2009-03-10
1,193 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers