SQL Server General DBA

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 […]

Table Valued Parameters in SQL Server 2008

SQL Server 2008 introduces a new feature called Table Valued Parameters. In the earlier versions of SQL Server it was not possible to pass a table variable as a parameter to a stored procedure or a function. However, in SQL Server 2008 it is now possible to pass multiple rows to SQL Server in one […]

System Databases in SQL Server

Being a SQL Server Database Administrator one needs to have a sound knowledge of System Databases in SQL Server. System databases are an integral part of the SQL Server product as it depends on the System Databases to function. Having a good knowledge of System Databases will help the Database Administrator to perform day-to-day tasks […]

Database Recovery Models in SQL Server

One of the primary responsibilities of Database Administrators is to make sure that the databases are backed up at regular intervals so that in the case of a disaster the DBA can bring the SQL Server database back online for the business to continue without much downtime. We have already discussed in detail the Importance of […]

Filtered Indexes in SQL Server 2008

SQL Server 2008 introduces a new feature called Filtered Index. A Filtered Index is an optimized form of non clustered index. It is basically useful to cover those queries which return a small percentage of data from a well defined subset of data within a table.  In the earlier versions of SQL Server, Developers and […]

Importance of Database Backups and Recovery Plan

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 Administrator’s have a tough job to implement database backup and disaster recovery plans. Backing up your databases can protect an organization against the accidental loss […]

Data Compression in SQL Server 2008

SQL Server 2008 provides two types of compression namely, Database Backup Compression and Data Compression. We have already discussed the Database Backup Compression feature in my article titled How to configure and Use Database Backup Compression in SQL Server 2008. Data Compression was first introduced in SQL Server 2005 with Service Pack 2 where Microsoft […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |