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 […]
2021-10-15
5,034 reads
2021-10-08
1,318 reads
2017-04-25
226 reads
2017-04-12
5,111 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
2,952 reads
2017-03-21 (first published: 2017-03-15)
417 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
1,826 reads
2017-03-07 (first published: 2017-03-01)
1,058 reads
2017-02-28
7,422 reads
2014-06-12
631 reads
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, all! I have an existing always on availability group on-prem and last week...
Hi Result is determined by the calculated Usage, With the below query, the result...
Hi all, I'm still pretty new to SQL and could use some help getting...
Ask SSC