Including Missing Values in Data Ranges Without a Lookup Table One of the ways that I learn new things is by helping others with their issues or questions. In my career, this has served me well by exposing me to a vast array of experiences that I may not have otherwise seen. I try to…
| News From the Frontlines |  |
Tag Archive: How do I … ?
Including Missing Values in Data Ranges Without a Lookup Table
(5 votes, average: 2.40 out of 5)
Loading ...Auditing Users in a Failover Partner Database
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…
(No Ratings Yet) Loading ...T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2 This blog entry is participating in T-SQL Tuesday #007, hosted this month by Jorge “@SQLChicken” Segarra (Blog|Twitter). You are invited to visit his blog to join the party and read more blogs participating in this month’s theme: Summertime in the SQL. This month’s…
(3 votes, average: 4.67 out of 5) Loading ...How do I … Write a Backup Strategy?
How do I … Write a Backup Strategy? How do I Write a Backup Strategy? DBA’s harp about the need to have backups. The first thing many DBA’s do when they inherit a new SQL Server is to check to see that the databases have backups. I’m not backing off of that assertion now. I’m offering advice on…
(2 votes, average: 4.50 out of 5) Loading ...How Do I Configure SSIS to Work With a Named Instance
How Do I Configure SSIS to Work With a Named Instance By default, SSIS (SQL Server Integration Services) uses the msdb database of the default instance on the server for storing packages. SSIS can still manage packages stored as files in the file system without any changes to the current setup. To be able to…
(No Ratings Yet) 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