Join us Monday, November 4, for in-depth, full-day training workshops delivered by some of the leading SQL Server and Microsoft Business Intelligence experts in the world. Choose from four PASS SQLRally Nordic Pre-Conference Seminars:
Performance Tuning with Indexes: Internals and Best Practice
By Kalen Delaney
Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. And knowing how indexes are useful lets us generalize some best-practice recommendations. In this seminar, we’ll look at the following topics:
- Basic index structures, including clustered vs. nonclustered, unique vs. non-unique, and Included columns
- Tools for exploring index structures
- Index maintenance, including page splits, fragmentation, and defragmentation
- Index design considerations, including ANDs/ORs, JOINs, and Composite indexes
- Best-practice guidelines
- Columnstore index storage
- Columnstore index guidelines
No More Guessing! An Enlightened Approach to Performance Troubleshooting
by Adam Machanic
Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution―or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when.
In this full-day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues. All of this will be illustrated through demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper―pinpointing the exact problem and helping you quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.
This Year's SQL Server Setup Best Practices
by Brent Ozar
You don’t build a lot of SQL Servers, but this year, you need to build one for your company – and it’d better work. You need it to be reliable and fast the very first time. Unfortunately, everything keeps changing, and yesterday’s best practices don’t cover solid state drives, FusionIO, AlwaysOn Availability Groups, and clusters without shared storage. In this all-day session, Microsoft Certified Master Brent Ozar will bring you up to speed. He’ll teach you how to pick storage, when it’s okay to use virtual servers, how to turn business requirements into clustering/mirroring/AlwaysOn/log-shipping, and where to put your data files, log files, and TempDB. This session is for developers and DBAs who need to pick SQL Server hardware and aren’t sure about the options today.
Data Warehouse Modeling – Making the Right Choices
by Thomas Kejser and Davide Mauri
Data warehouses play a central role in any BI solution. It's the back end upon which everything in years to come will be created. For this reason, it must be rock solid and yet flexible at the same time. To develop such a data warehouse, you must have a clear idea of its architecture, a thorough understanding of the concepts of Measures and Dimensions, and a proven engineered way to build it so that quality and stability can go hand-in-hand with cost reduction and scalability. In this workshop, Thomas Kejser and Davide Mauri will share all the information they learned since they started working with data warehouses, giving you the guidance and tips you need to start your BI project in the best way possible―avoiding errors, making implementation effective and efficient, paving the way for a winning Agile approach, and helping you define how your team should work so that your BI solution will stand the test of time.
- Data warehouse architecture and justification
- Agile methodology
- Dimensional modeling, including Kimball vs. Inmon, SCD1/SCD2/SCD3, Junk and Degenerate Dimensions, and Huge Dimensions
- Best practices, naming conventions, and lessons learned
- Loading the data warehous, including loading Dimensions, loading Facts (Full Load, Incremental Load, Partitioned Load)
- Data warehouses and Big Data (Hadoop)
- Unit testing
- Tracking historical changes and managing large sizes