Monthly Archives: December 2009

SQL Server DBCC Commands

SQL Server DBCC Commands    Microsoft provides a set of SQL Server DBCC Commands originally that stood for Database Consistency Check commands. The DBCC commands are divided into four main categories: Status, validation, maintenance, and miscellaneous commands. Let’s take a … Continue reading

Posted in SQL Server DBA | Tagged , , , | 2 Comments

ESSENTIAL STEPS AFTER INSTALLING SQL SERVER

Essential Steps after Installing SQL Server   Rolling out SQL Servers is a key task for DBAs.  While for some DBAs this can be a frequent exercise, others will have to face it one time or other throughout their career … Continue reading

Posted in SQL Server DBA | Tagged , , | Leave a comment

SQL SERVER 2005 ARCHITECTURE

–> SQL SERVER 2005 ARCHITECTURE    Please have a look here to get the full and latest article to know sql server 2005 architecture SQL Server Architecture  SQL Server is a client/server relational database management system. Figure 1.3 shows the … Continue reading

Posted in Database Design, Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , | Leave a comment