With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
2016-07-18
2,589 reads
Not thrilled with that one, but it's ok. Haven't read this one, but it's rated highly: http://www.amazon.com/exec/obidos/tg/detail/-/1576108724/qid=1098804679/sr=1-1/ref=sr_1_1/102-4683263-6980948?v=glance&s=books
2004-10-26
Eagles may soar in the clouds, but weasels never get sucked into jet engines.And Steve,It is difficult to soar like an Eagle when you work with Turkeys
2004-10-26
The SUBSTRING command implicitely converted Description into a varchar(8000). I'm guessing that the characters at positions 7953-8000 are spaces and so were implicitely RTRIMed.The Query Analyzer setting only limits the amount of text it prints to the output window for a SELECT statement's output and does not impact the SQL executed at all (even for the […]
2004-10-21
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers