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)
26,574 reads
2021-10-08
2,292 reads
2017-04-25
257 reads
2017-04-12
7,065 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,388 reads
2017-03-21 (first published: 2017-03-15)
481 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,485 reads
2017-03-07 (first published: 2017-03-01)
1,242 reads
2017-02-28
11,417 reads
2014-06-12
656 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers