Including Missing Values in Data Ranges Without a Lookup Table

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 be active on various internal SQL discussion lists at work, and an interesting question came in today. My gut reaction was to go with the
read more

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 the database (nor anything else). Wanting to modify the secondary database is actually a pretty common question with a simple solution though I had never
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 theme is all about the new hotness (i.e., the hot new features of SQL Server 2008 R2). For my part in this month’s TSQL2sday, I’m
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 how to determine the best backup strategy for your system. The best advice for how to develop the optimum backup strategy is to not try
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 use the msdb database of a named instance, you have to manually edit the SSIS configuration file. Here are the steps for that: Shut down
read more