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 … Read More →
Tag Archives: How Do I … ?
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 … Read More →
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 … Read More →
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 … Read More →
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 … Read More →
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS
Facebook