Copying DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2008

I’ve seen this approach from the CSS SQL Server Engineers blog post and wondered if I can give it a shot. We’re migrating a SQL Server 2000 database to a SQL Server 2005 instance (finally!) and that included a lot of DTS packages. While I would highly recommend upgrading the DTS packages to SSIS packages […]

Backup on shared folders running on a local system account?

I still see a lot of SQL Servers running using the LocalSystem account, particularly, MSDE 2000, which is very popular among third-party applications that requires storing data in a database. Others run a stand-alone SQL Server system and use LocalSystem account for the service accounts. While this may be a security risk, a lot of […]

The Customer is King vs Doing the Right Thing

Most of the service-oriented businesses these days know that the customer is always the king. This means doing everything they can at their disposal to make sure that their customers would be more than satisfied with their goods and services even to the extent of simply yielding to the customers’ irrational requests. Having worked for […]