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)
22,434 reads
2021-10-08
2,140 reads
2017-04-25
246 reads
2017-04-12
6,702 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,109 reads
2017-03-21 (first published: 2017-03-15)
459 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,314 reads
2017-03-07 (first published: 2017-03-01)
1,205 reads
2017-02-28
11,159 reads
2014-06-12
640 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...