RSS

Monthly Archives: July 2013

New Logo and Media Partnership with SQL Server Live! 360

New Logo and Media Partnership with SQL Server Live! 360

Just recently I signed up to be a Media Partner and help spread the word about this great conference SQL Server Live! 360. It is simple, I help spread the word on their conference, and they spread the word about my website I don’t work for them they don’t pay me 🙂 Later this month I will be posting a code to give prospective conference goers a $500 discount. In September, I will hold a small competition and one randomly selected winner will get a free pass to the conference!

So check out my logos and check out the conference and let me know what you think.  Special thanks to my work colleague and long time iPhone Enemy Michael Myrick for creating the logos.

Read the rest of this entry »

 
Leave a comment

Posted by on July 26, 2013 in Other

 

Indexing Fundamentals Presentation – Pending Questions Answered

Indexing Fundamentals Presentation – Pending Questions Answered

On July 10th 2013, I gave a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. The topic was Indexing Fundamentals and there were some questions that we did not have time to answer. I have combined similar questions and given one answer to cover the specific topic.

If you missed the presentation, you can click HERE to see the recording.

Abstract:
Indexing is an integral part of SQL Performance and Architecture. In this presentation we will cover the basics of Clustered and Non-Clustered Index structure and function. Additionally, we will discuss the B-Tree structure, index density (fill factor), page splits, and performance considerations. Finally, there will be a brief discussion of index maintenance.

Read the rest of this entry »

 

Tags: , , , , , ,

Indexing Fundamentals Presentation

Indexing Fundamentals Presentation

**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)**

On July 10th 2013 @ Noon EST (16:00 UTC) I will be giving a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. Entrance is free as always and details can be found at http://fundamentals.sqlpass.org.

Code, Slides, and other information about the presentation will be under the Presentations section of this site afterward. Hope to see you there!

Abstract: Indexing is an integral part of SQL Performance and Architecture. In this presentation we will cover the basics of Clustered and Non-Clustered Index structure and function. Additionally, we will discuss the B-Tree structure, index density (fill factor), page splits, and performance considerations. Finally, there will be a brief discussion of index maintenance.

 

Tags: , , , , , ,

 
%d bloggers like this: