Checking Up on Vendors
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
2021-05-10
162 reads
Auditing
Constant Integration
Apple buys a company every few weeks. The data integration for this must be a large effort.
2021-03-31
91 reads
2021-03-04
368 reads
2019-11-11
918 reads
Generic trigger for maintaining the Audit Log
This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.
Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.
2019-10-15 (first published: 2019-10-10)
2,995 reads
2019-08-22
791 reads
Audit Users logging in using "sa" or service accounts
Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]
2019-07-04 (first published: 2019-06-26)
2,107 reads
2016-04-11
1,337 reads
Failed and Successful Login Auditing Using xp_readerrorlog
Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login
2015-12-30 (first published: 2015-12-15)
1,843 reads
Users , Roles and Logins
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
2,949 reads
Blogs
Cool AI sites
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
A Quick Test Data Manager Eval with My Database Backup
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
How-To Convert Excel Date & Time to SQL
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Getting below error
An error occurred during recovery, preventing the database 'XXXXX' (28:0) from restarting. Diagnose the...
Why is "SELECT *" about 10 times faster than "SELECT (ALL Columns)"
Dear all, I have noticed that a "SELECT * ..." is about 10 time...
Question of the Day
Dates and Languages
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers