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
12,948 reads
2021-10-08
1,956 reads
2017-04-25
240 reads
2017-04-12
6,218 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
3,730 reads
2017-03-21 (first published: 2017-03-15)
453 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,000 reads
2017-03-07 (first published: 2017-03-01)
1,161 reads
2017-02-28
10,461 reads
2014-06-12
637 reads
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
Hey! Kev is here to invite you to an exciting experience. Our team, full...
NOTE: The Topic Title probably isn't very good but I wasn't sure how to...
Hey Folks, So I have SQL Transactional Replication set up on a database that's...
Ask SSC