Category Archives: SQL Server DBA

SQL Server files and File Groups

SQL Server files and File Groups This is to understand SQL Server files and File Groups. It’s ironic that the Relational Database Management System (RDBMS) was invented to implement data structures in something other than files. The irony is that … Continue reading

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

SQL Server Isolation Levels and Locks

SQL Server Isolation Levels and Locks We will learn about SQL Server Isolation Levels and Locks. Isolation levels come into play when you need to isolate a resource for a transaction and protect that resource from other transactions. The protection … Continue reading

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

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