On-Demand Webinar: SQL Server Performance Architecture for Beginners
Databases store data the same way we would store groceries in our refrigerator. We organize them so that they are easy to find; the architecture for SQL performance operates in a similar way. If you’re familiar with SQL basic and want to get a jump start on undemanding the performance nuts and bolts then this on-demand webinar is perfect for you.
Watch Rick Morelan and Scott Walz as they cover the basic performance concepts and tips, including which ones always work and which ones always fail. These concepts apply to all of today’s enterprise databases. You will gain insight on basic performance tuning tips and tricks, common index types and when to use them and habit-based mistakes and how to avoid them.
Watch the on-demand webinar to learn about:
Clustered and non-clustered indexes
Basic storage concepts and terms of the database
How to read execution plans
About the presenters:
Rick Morelan has been working with Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008).
Rick has provided training for Northwest University, Volt Technical Education, and Microsoft. He currently works as a Software Design Engineer in Test for the Windows Mobile group, Bellevue College, and Moretechnology.com. As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.
Scott Walz has more than 20 years of experience in the area of database development and currently serves as the Director of Software Consultants for Embarcadero Technologies. Prior to joining Embarcadero 12 years ago, Scott served as a development lead for Louisville Gas & Electric. He holds a bachelor's degree in computer information systems from Western Kentucky University.