Tag Archives: Mcm Prep

MCM level material that can be reviewed for preparation for the MCM exams.

Auditing Users in a Failover Partner Database

September 19, 2011 8:16 pm / Leave a Comment / SQLSoldier

Auditing Users in a Failover Partner Database I read a question on a discussion list today asking if it is possible to audit SELECT queries on a log shipping secondary in stand-by mode. His attempts to set it up had obviously failed because the database is read-only and you cannot create a database audit in … Read More →

Posted in: SQL Server / Tagged: Database Mirroring, High Availability, How do I ... ?, Log Shipping, MCM Prep, Security, Tips & Tricks


Remote DBA Services - serious SQL Server expertise for less than a full-time DBA
My Articles		My Book
Check out my interview on
Extreme Data Recovery (with Argenis Fernandez) 10 Things all BI System Administrators Should Know

Download my Powershell Scripts

The following scripts can be downloaded as text files. You will need to change the file extension to .ps1 in order to execute them.

Backup a database
Restore a database
Scan a server to find a free port
Query DNS to get the FQDN of a server

To see some examples of my other forms of writing, please visit my page on WritersCafe.org. It is almost exclusively horror fiction, but I sometimes throw other things in there too from time to time. There's one science fiction story, a couple of poems, and quite a few humor pieces as well.

Look for me in the SQL Q&A section of the August, 2007 issue of TechNet Magazine.
August issue of TechNet Magazine's SQL Q&A column

Tag Archives: Mcm Prep

Auditing Users in a Failover Partner Database

My SQL Server Magazine Articles

News

Download my Powershell Scripts

Protect our Heroes

Tag Archives: Mcm Prep

Auditing Users in a Failover Partner Database

My SQL Server Magazine Articles

Tags

News

Download my Powershell Scripts

Protect our Heroes