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…
| News From the Frontlines |  |
Tag Archive: Security
Hardening SQL Server
Hardening SQL Server My new article for SQL Server Magazine on Hardening SQL Server has been posted online and will appear in an upcoming print issue. This article is a brief explanation of how to secure SQL Server against malicious attack or invasion. This article can serve as a guide for preventing your SQL Servers…
(No Ratings Yet)
Loading ...When Does Trustworthy Get Reset on a Mirror?
When Does Trustworthy Get Reset on a Mirror? When I’ve done sessions on automating database mirroring processes and in my book, I talk about incorporating steps to set properties that get reset during the restore process in the mirroring setup such as database owner and the Trustworthy property. When you perform the initial restores of…
(2 votes, average: 5.00 out of 5) Loading ...Product Review: Security Explorer by ScriptLogic
Product Review: Security Explorer by ScriptLogic Recently, I started writing for SQL Server Magazine. A couple of days ago, my first piece for the magazine was posted online. It is a product review of Security Explorer by ScriptLogic. I have just completed the first draft of future article and am beginning work on another. Excerpt…
(1 votes, average: 5.00 out of 5) Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS