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,694 reads
2021-10-08
2,188 reads
2017-04-25
248 reads
2017-04-12
6,821 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,218 reads
2017-02-28
11,292 reads
2014-06-12
642 reads
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Hi as we replace on prem machines , sometimes not with vm's, what should...
Hi folks I have two tables, both with a NAME, START and END fields...
I am in the process of migrating from MySQL to SQL Server. I have...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers