2016-03-17
1,052 reads
Security
2016-02-11
1,300 reads
Orphaned login report for all databases
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,164 reads
2016-02-03
1,369 reads
2016-01-26
1,427 reads
2015-12-28
1,141 reads
2015-12-24
1,646 reads
Liberating the DBA from SQL Authentication with AD Groups
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
2018-02-02 (first published: 2015-12-21)
9,612 reads
SMKs, DMKs, Certificates for TDE and Encrypted Backups
This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.
2015-12-09
4,783 reads
2015-08-18
1,390 reads
Blogs
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Forums
dont see a file system task approach to copying excel
Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-and-move-to-a-new-location-using-ssis where content rather than file level...
need community help on 1 final cdata odbc driver product eval question
Hi, for whatever reasons, CDATA is conflicted about answering 1 remaining disclosure type question...
Problem installing SQL Server 2022
Hello, I currently have an instance of SQL Server 2019 Developer installed on my...
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers