View Recording: Building Perfect SQL Servers, Every Time
Slides and Scripts: Link to Joey's Blog
In this in introductory session, we will walk through some of the defaults that are configured when installing SQL Server, and their potential impacts to overall performance in stability. We will walk through best practices for configuring SQL memory, optional settings and physical configuration. Lastly we will discuss how to automate the install and configuration within your environment.
Presented by Joseph D'Antoni
View Recording: Microsoft SQL Server 2014 Countdown: SQL Server 2014 In-Memory OLTP Overview
Slides and Scripts:
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this overview, we discuss the user scenarios and the hardware trends, such as decreasing memory cost, many-core processors, and stalling CPU clock rate that prompted the key architectural pillars of memory optimization, no lock/latch concurrency control, and native compilation. We also cover how in-memory OLTP is integrated with the rest of SQL Server.
View Recording: Manage Your Shop with CMS and Policy Based Management
Slides and Scripts: 2014_03_04 Slides
In this session I will talk about Central Management Server and how it can help you manage a disperse environment. I will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. I will demonstrate PBM from creating and evaluating policies to receiving alerts on policy violations
View Recording: SQL Server 2014 - Features Drilldown
Slides and Scripts: 2014_02_04_Final_scripts.zip
SQL 2014 Features Drilldown with Tara S. Jana at "Microsoft Pty. Ltd. Australia"
View Recording: Statistics Starters
Slides and Scripts: Link to SQLSkills Archive
What is important about Statistics? Learn everything you need to know to get started with Statistics -- Erin Stellato MVP at SQLskills
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.
View Recording: The Minimalist Guide to Database Administration
The best DBA is a lazy DBA...or at least a Minimalist DBA - Presented by
@SQLRockstar - Thomas Larock MVP and @DataChick - Karen Lopez MVP
View Recording: Building an effective Data Warehouse Architecture
You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach?
View Recording: SQL 2012: Whats New Breakthrough
Server 2012 Engine has seen a paradigm shift in the number of features offered compared to previous verisons, and its considered one of the best Enterprise Ready SQL versions Microsoft has ever produced. Therefore, it is extremely important to learn about these new features, in order to build the most effective business logic, robust architecture and optimal performance solutions to support Enterprise.
Tara S. Jana at "Microsoft Pty. Ltd. Australia"
View Recording: Indexing Fundamentals
Wednesday, July 10th, 2013 11:00 AM
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"><o:lock v:ext="edit" aspectratio="t">
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.
Ayman is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. From there, he moved up to computer programming in high school and went on to get B.S. and M.S. degrees in Information Systems from Drexel University in Philadelphia. He has worked with the SQL Server product since 2006 and has experience with SQL 2000 through SQL 2012. He holds MCSE Data Platform, MCSA SQL 2012, and MCITP SQL 2008 DBA certifications and is also a Microsoft Certified Trainer (MCT). He has been active with the virtual chapters of PASS, participating in online training and also giving presentations. He is fluent in Arabic, a huge football(soccer) fan, and is always looking forward to learn more about SQL Server, SQL Server BI, and technology in general.
View Recording: Introduction to SQL Server 2012 AlwaysOn Availability Groups
Tuesday, May 7th, 2013 11:00 AM
One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications & databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.
View Recording: Backup and Recovery Fundamentals
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"><o:lock v:ext="edit" aspectratio="t">Backup and Recovery are essential parts of and DBA's job. After all, if you lose your data you lose your job so you need a great backup strategy. In this session we will cover Recovery Models, Backup Types, Backup Strategy, Restores, RTO, RPO, and understanding how your Transaction Log is maintained through backups.
Ayman El-Ghazali is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. He has worked with SQL Server product since 2006, holds a MCITP SQL 2008 DBA certification and is also a Microsoft Certified Trainer (MCT). He holds a BS and MS degree in Information Systems from Drexel University and has been active with the virtual chapters of PASS; participating in online training and giving presentations.
View Recording: What Counts For a DBA
Tuesday, January 8th, 2013 11:00 AM
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"><o:lock v:ext="edit" aspectratio="t">The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA.
Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. For more information please visit drsql.org
2012-12-04 View: The ABCs of SSIS! Glenda Gable firstname.lastname@example.org
2012-11-13 View: Profiler? What is this Tool you Speak of? Jason Spangler
2012-09-04 View: Introduction to SQL Server Service Broker Adam Belebczuk
2012-10-02 View: Make Your Voice Heard! Jes Schultz Borland