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,922 reads
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,922 reads
When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...
2009-04-21
22,709 reads
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
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
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
628 reads
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
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
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
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
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,195 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers