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)
21,957 reads
2021-10-08
2,127 reads
2017-04-25
246 reads
2017-04-12
6,664 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,075 reads
2017-03-21 (first published: 2017-03-15)
458 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,292 reads
2017-03-07 (first published: 2017-03-01)
1,200 reads
2017-02-28
11,121 reads
2014-06-12
640 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers