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
10,536 reads
2021-10-08
1,891 reads
2017-04-25
239 reads
2017-04-12
5,986 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
3,576 reads
2017-03-21 (first published: 2017-03-15)
452 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
2,681 reads
2017-03-07 (first published: 2017-03-01)
1,141 reads
2017-02-28
9,837 reads
2014-06-12
636 reads
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...
Comments posted to this topic are about the item Validating Password Expiration
Hello, I have a situation. I am trying to show each distinct...
Ask SSC