Trigger Based Change Data capture
This script capture INSERTs / UPDATEs / DELETEs on SQL Server table and logs to single table in JSON Format.
2017-12-22 (first published: 2017-12-01)
2,763 reads
Ankush Parab
usp_tableReference
Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.
2013-08-12 (first published: 2013-08-02)
1,115 reads
Blogs
Choosing to not drive the Tesla
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Advice I Like: Transactions and Relationships
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
Free PostgreSQL Performance Monitoring with pgNow
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Forums
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Mixed Backups
Comments posted to this topic are about the item Mixed Backups
Or condition in where clause works differently in MS SQL comparing with Sybase
Hello, I ran below statements in MS SQL, and got error, but fine in...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers