As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables. This is especially true with logging tables. Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
2024-08-30 (first published: 2021-10-15)
23,709 reads
2021-10-08
2,189 reads
2017-04-25
248 reads
2017-04-12
6,824 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,222 reads
2017-03-21 (first published: 2017-03-15)
462 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,360 reads
2017-03-07 (first published: 2017-03-01)
1,219 reads
2017-02-28
11,293 reads
2014-06-12
642 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Hi If value is 21000030 it should return 4 not 5 . In first...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers