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
7,262 reads
2021-10-08
1,809 reads
2017-04-25
235 reads
2017-04-12
5,617 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
3,315 reads
2017-03-21 (first published: 2017-03-15)
445 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
2,229 reads
2017-03-07 (first published: 2017-03-01)
1,109 reads
2017-02-28
8,688 reads
2014-06-12
634 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
I have a query that is supposed to return one patient id but even...
i have a cursor that runs on all my views and then exec...
Hi All, I am looking for some inputs on how to avoid or prevent...
Ask SSC