Monthly Archives: December 2009

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

DAC in SQL Server

DAC in SQL Server

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment