SQL Server General DBA

One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool. SQL Server Utility provides a unified view of the managed instances of SQL Server providing details such as CPU [...]

The key new features of SQL Server 2008 R2 relate to the management of organizations’ master data (Master Data Services – MDS ), administration of multiple servers (SQL Server Utility), and processing large amounts of data (PowerPivot for Excel, formerly known as Project Gemini). One of the main concerns of any organization is the management [...]

There are couple of enhancements in SSIS 2008 from its predecessor SSIS 2005. For example, Lookup transformation has been enhanced, development environment for Script Task and Script Component has been changed from VSA to VSTA, name of certain connection providers have changed etc. If you intend to upgrade your SSIS 2005 packages to SSIS 2008, [...]

There are several enhancements in SSIS 2008 such as enhanced lookup transformation, the development environment for Script Task and Script Component changing from VSA to VSTA, etc. If you intend to upgrade your SSIS 2005 packages to SSIS 2008 it may be a challenging task especially if it uses the Script Task or Script Component [...]

Introduction In most organizations backup plans are implemented using full differential and transactional log backups. The normal scenario would be take a full backup on Sunday (off peak hours), differential backup daily at mid-night and transactional log backups on hourly basis. What if there is a requirement to refresh on the test/development environment with production [...]

Sonasoft, Directors – Andy Khanna ,  Dr Romesh K. Japra ,  W. Patrick Kelley Sr I haven’t written a notice like this before but I thought it was my duty to let you all know the situation regarding a former advertiser on SQL Server Performance.com . After ove 18 months of requesting payment of amounts [...]

 SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using the Transfer Jobs Task in SQL Server Integration Services I discussed how to use the Transfer Job Task which is available in SQL [...]

As a SQL Server Recruitment Consultant for Rullion Computer Personnel, I specialise in SQL Server and Database Professionals for a multitude of different clients throughout the UK. I am writing this article to give an honest reflection and hopefully cast a more positive light on the current economic situation, and reassure those candidates who are [...]

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS I discussed how to use the Transfer Error Messages Task [...]

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers and administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS I discussed how to use the Transfer SQL Server Objects [...]