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,964 reads
2021-10-08
1,957 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,734 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,463 reads
2014-06-12
637 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...
Comments posted to this topic are about the item Backing Up Master
Ask SSC