2023-03-27
197 reads
2023-03-27
197 reads
I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation. The UK Financial Services Authority (FSA) was seen to be a toothless tiger. The UK government replaced the FSA with two separate bodies, each with its own more […]
2021-10-25
1,361 reads
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
2021-05-10
152 reads
Apple buys a company every few weeks. The data integration for this must be a large effort.
2021-03-31
78 reads
2021-03-04
353 reads
2019-11-11
906 reads
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)
1,926 reads
2019-08-22
762 reads
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)
1,692 reads
2016-04-11
1,318 reads
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
I have a stored procedure that was created to run dynamically. Other than me...
I have the following historical wait report for my SQL server. I have noticed...