SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: C.J. Garcia

SQLServerCentral.com profile

   Items 1 to 4 of 4   

Is Database Mirroring Causing The Transaction Log To Fill Up

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.  Read more...
By C.J. Garcia 2014/11/06 | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 3,736 reads

Auto Generating Multiple XML Files Using SSIS

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.   Read more...
By C.J. Garcia 2014/08/25 | Source: SQLServerCentral.com | Category: integers
Rating: |  Discuss |   Briefcase | 3,417 reads

Database Permissions

Here is a short How To article on querying for permissions in a SQL Server database  Read more...
By C.J. Garcia 2014/07/01 | Source: SQLServerCentral.com | Category: database permissions
Rating: |  Discuss |   Briefcase | 6,157 reads

Logging in Maintenance Plans

Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012  Read more...
By C.J. Garcia 2014/06/12 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 2,374 reads
   Items 1 to 4 of 4