SQL Server General DBA

Differential Database Backups in SQL Server

In this fast moving world, data is the heart & soul of any enterprise. As the business is expanding many organizations around the world have adopted a 24×7 business model to support and run their businesses. In a 24×7 business model data changes happen around the clock, thereby increasing the demand for database backups. Taking […]

Backup System Databases Using Maintenance Plans

System databases are an integral part of SQL Server, as SQL Server is dependant on the System Databases for functionality. Database Administrators should make sure that all the system databases are part of their day to day backups. Most importantly, database administrators should take full backup of all the system databases immediately after they have applied any Hotfixes […]

Overview of Maintenance Plans in SQL Server 2008

The Maintenance of a SQL Server databases is one of the primary responsibilities of a Database Administrator. To make database maintenance easier, DBA’s can leverage the Maintenance Plan Wizard or Maintenance Plans which are available in SQL Server 2005 and higher versions. A DBA can create a database maintenance plan either by using the Maintenance Plan Wizard […]

Dedicated Administrator Connection in SQL Server

As a Database Administrators you may come across a scenario where you are unable to access a SQL Server instance, especially when the CPU or Memory utilization on the server is very high. To allow database administrators to troubleshoot such scenarios, Microsoft introduced the Dedicated Administrator Connection (DAC) in SQL Server 2005; this is a special diagnostic connection for […]

How to Use the Microsoft SQL Server 2008 Upgrade Advisor Tool

Upgrading from the previous version of SQL Server to a newer version is always a challenging task for a Database Administrator. In order to improve the SQL Server 2008 upgrade experience, Microsoft introduced a free tool called SQL Server 2008 Upgrade Advisor (SSUA). This tool basically does the analysis of installed components of the earlier […]

Grouping Sets in SQL Server 2008

SQL Server 2008 introduces a new feature called GROUPING SETS for SQL Server Database Developers. When a GROUP BY clause is used with the GROUPING SETS feature in SQL Server 2008 it will help you generate a result set which will be equivalent to that generated by a UNION ALL of multiple simple transact SQL Group […]

Restore Transaction Logs for Point in Time Recovery

In this fast moving world, data is the heart and soul of any enterprise. It has become an essential task for organizations around the world to protect their data. Database Administrators have a tough job to implement database backup and disaster recovery plans. Backing up your databases can protect an organization against the accidental loss […]

Configure Windows Firewall for SQL Server Integration Services

The Firewall is an important component of Microsoft Windows which prevents the unauthorized access to computer resources. If windows firewall is turned on and if it is not configured correctly, then attempts made to connect to SQL Server Integration Services by the users will be blocked. To access SQL Server Integration Services through a firewall, […]

Super Sizing Columns in SQL Server

Fast Food is no longer the only thing that comes with a Super Size option.  Since SQL Server 2005, columns can also be Super Sized due to the introduction of the MAX Specifier.  In previous versions of SQL Server, if an application allowed for the storage of string data that would exceed 8000 bytes, the […]

Fixing Orphaned Users in SQL Server Database

SQL Server Database Administrators have always come across scenarios where they need to restore a copy of the latest production database to a test or development environment. Some of the challenges that could be faced by the Database Administrators are to Obtain Exclusive Access to Restore a SQL Server Database; otherwise the restore process is […]