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,864 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,242 reads
Here is a short How To article on querying for permissions in a SQL Server database
2014-07-01
11,312 reads
Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012
2014-06-12
3,540 reads
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
Hi everyone, We are selling cars and have a range of options at our...
hi for the 2 years i've been here I believe we've had "encryption" turned...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers