Contents tagged with sql server 2008
-
Checklist for testing and reviewing ssis packages
At UruIT we work a lot with SQL Server Integration Services and compiled several best practices found on the web that we already adopted. Many of them related to performance tips and conventions. At the end of this post I am sharing some usfeul links.
-
Access denied when attempting to restore database backup
I have run a cuple of times in the past with an access denied error when attempting to restore an SQL Server 2005 / 2008 database backup. As I always forget the solution, I figured out it is time to post it here in case it happens again.
-
Validating Stored Procedures using SQL Server 2008 policies and C#
Microsoft SQL Server 2008 incorporates a new feature named Policy Based Management, allowing the administration of SQL 2008-based policies. DBAs can control many different aspects of SQL Server and automate several time-consuming tasks.