Changing Your Habits to Improve the Performance of Your T-SQL
**** New Date ->July 13 2016 CDT Noon <-*** New Date
By Mickey Stuewe
Azure and SQL Server
August 3, 2016 Noon CDT
By Jes Borland
Jes Borland is a Senior SQL Engineer at Concurrency and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, founder of FoxPASS in northeast Wisconsin, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturday, and other community events.
Understanding SQL Server Backup and Restore
Wed, Aug 17, 2016 Noon CDT
By Tim Radney
Understanding SQL Server Backup and Restore Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn!
Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.
Full Bio: http://www.sqlskills.com/about/tim-radney/
Statement Execution and the Plan Cache
Sept 7, 2106, Noon CST
By Kimberly L. Tripp
Statement Execution and the Plan Cache
Kimberly will discuss the impact on caching / performance of different methods of statement execution. Briefly, she will also compare / contrast this with stored procedures. In the end, you’ll know the best way to request data so that stable requests are cached and unstable requests are not (giving you the most optimal performance).
KIMBERLY L. TRIPP
Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.
Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/
SQL Server MVP since 2002
Silent Killers Lurking in Your Schema
October 11th 2016 CST Noon
By Mickey Stuewe
December 7th 2016 CST Noon
Table Partitioning: Secret Weapon for Big Data Problems
Is big data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks.
Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.
PASS Summit Discount Code
$1,795 until Midnight, July 17
Save $150 on your registration by using the code VC15FFM6
If you are interested in presenting on Data Architecture topic, please submit your bio and abstract to email@example.com
Zero-Downtime Upgrades: Rockstar DBA
By Argenis Fernandez
SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL
You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.
In this session you will:
* Understand how rolling upgrades are better than in place upgrades
* Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
* Explore how you might use Log Shipping to perform a simpler type of rolling upgrade
This is a demo-intensive session, so you can see rolling upgrades live and up close.
If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!
Argenis Fernandez is a SQL Server MVP and SQL Server Solutions Architect for Pure Storage. He has worked with SQL Server for over 17 years and enjoys high-end OLTP databases, virtualization, performance troubleshooting, high availability, disaster recovery, best practices, and dealing with hard problems. Previously a Senior Consultant for Microsoft, he is also a Microsoft Certified Master, founder of the PASS Security Virtual Chapter, and an active member of the SQL Server community.
underpins just about everything we do in IT. Without a clear understanding of
how data is structured, there is no reliable way to derive meaning from it.
Data Architecture drives the design and governance of data systems, and thus
should be of interest to any data professional. Data Architecture provides the
blue-prints that we all share, whether we be DBAs, data integration developers,
database developers, data warehousing professionals, data presentation
developers or client-side application developers persisting data for later
The PASS Data Architecture Virtual Chapter will focus on data
architecture concerns as they impact users, developers and DBAs on the
Microsoft SQL Server platform. We want to make data architecture accessible to
all data practitioners, and drive the point home that Data Architecture is a
set of practices and a body of knowledge that overlaps almost all database
professionals to some degree.
Email us at firstname.lastname@example.org or twitter is @DArchVC