In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.
2014-11-06
8,884 reads
An SSIS package that can generate an XML file for each record in an XML column in a SQL Server Database using the Source Script Component in a Data Flow Task.
2014-08-25
4,962 reads
Here is a short How To article on querying for permissions in a SQL Server database
2014-07-01
8,649 reads
Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012
2014-06-12
3,201 reads
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...
Comments posted to this topic are about the item Validating Password Expiration
Hello, I have a situation. I am trying to show each distinct...
Ask SSC