SQL Server General DBA

Fast Database File Creation for Large Databases in SQL Server 2005

The time needed for creating large and very large database can often take many minutes.  SQL Server 2005 has a new feature called Instant File Initialization (IFI) that can speed up the data file initialization of a database. Database File initialization The pages in the Data and Log files are initially filled with zeros when one […]

Transparent Data Encryption in SQL Server 2008

As a Database Administrator, security is one of the most important areas to consider when it comes to protecting the databases that you support. We use various mechanisms and technologies to secure our data and databases such as firewalls, certificates, and data encryption. Having said that although we have secured our environment, questions will always […]

Usage of SQL Server Database Snapshots

Introduction If you needed to analyse a database at a given time, what would you do? For example, say you wanted to analyse a database at 12:00PM, how would you do this? Most probably, you would create a schedule to create a backup at 12:00 PM and then restore the database into a database server giving it another name. Then […]

Creating Custom Reports for SSMS

With the release of SQL Server 2005 SP2, Microsoft added a new feature to SQL Server called “Custom Reports”. ). These RDL files are rendered as tabbed documents within SSMS. Reporting Services reports are rendered without even having Reporting Services installed. This new feature allows DBAs to extend the reporting capabilities within SSMS. In this […]

Importing Poorly Formatted Text Files using SSIS

Introduction Handling text files from SQL Server Integration Service (SSIS) is not new and I am not going to discuss about importing well formatted text files. There are many occasions when database developers must import text files which are not properly formatted. I will discuss three methods of doing this. For these situations we are […]

Data Cleansing with SSIS

What is Data Cleansing ? Data cleansing (or ‘data scrubbing’) is detecting and then correcting or removing corrupt or inaccurate records from a record set. After cleansing, a data set will be consistent with other similar data sets in the system. The inconsistencies detected or removed may have been caused by different data dictionary definitions […]

Isolation Levels in SQL Server

Isolation Levels Isolation levels come into play when you need to isolate a resource for a transaction and protect that resource from other transactions. The protection is done by obtaining locks. What locks need to be set and how it has to be established for the transaction is determined by SQL Server referring to the […]

SSIS Package Configuration in SQL Server 2005

Introduction If you are working on SQL Server Integration Service (SSIS) packages, it is highly unlikely that you are working in the production environment directly. Alternatively, you might be working in the development environment and later deploying to the production environment. Apart from these environments, you normally have testing and staging environments as well. For […]

A Look at Microsoft SQL Server Upgrade Advisor

Microsoft SQL Server Upgrade Advisor tool helps the user with the process of upgrading SQL Server 2000 (or 7.0) instances to SQL Server 2005. It analyzes the configuration of installed SQL Server 2000 (or 7.0) components and generates reports. The reports give an idea of the issues that will hinder the upgrade process. The user […]

Server System Architecture, 2007 (Preliminary)

The original article in this series was published in 2002 and covered Pentium III and Pentium III Xeon systems. I had prepared an update in 2005 to cover the NetBurst (Pentium 4) based Xeon and Xeon MP systems. For some reason I never got around to publishing this article, but I did briefly mention some […]
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 |