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
9,753 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
5,215 reads
Here is a short How To article on querying for permissions in a SQL Server database
2014-07-01
10,411 reads
Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012
2014-06-12
3,420 reads
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Hi Guys, I'm not sure if this is possible or not, but let me...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers