Month: August 2013

Providence – SQL Saturday #213

admin

I want to thank the SNESSUG SQL Saturday committee for their hard work in organizing the SQL Saturday #213 event. I know it will be a hit like last year. I will be the master of ceremonies for this event. There is an awesome line up of speakers this day. It should be a good time to network with other professionals in the field and learn some new things about the product. I hope you have time to attend cool event on September 21st, 2013. Below are the details of…

Page Anatomy – Part 2

admin

I am going continue my series of articles describing how information is stored and organized in a Microsoft SQL Server database. Today, I am going to talk about the Database Boot Page. All of the information is a gleamed from SQL Server 2008 Internals book by Kalen Delaney. If it is not on your bookshelf, I suggest you go out and by a copy. The online MCM training videos from Paul Randal are also an excellent resource. A single page (8K) is the smallest unit in which SQL Server allocates…