Nr: 277
SQLSaturday #277 - Richmond 2014
SessionID: 10085
SQL Server Internals Party: Storage, Memory and the Query Life-cycle
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #5 (Dev)
Speaker: Ayman El-Ghazali
Title: SQL Server Internals Party: Storage, Memory and the Query Life-cycle
Abstract:
Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB BI Developers and System Administrators. Party hats not included, rated G for Geeks.
SessionID: 10689
Treating Tables Like Legos, Partitioning Basics
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #5 (Dev)
Speaker: Brandon Leach
Title: Treating Tables Like Legos, Partitioning Basics
Abstract:
SessionID: 10690
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #6 (Misc)
Speaker: Brandon Leach
Abstract:
In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation.
SessionID: 10841
SQL 2012 Extended Events
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #7 (Misc)
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 10842
SQL 2012 Table Compression
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #7 (Misc)
Speaker: Jason Brimhall
Title: SQL 2012 Table Compression
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
SessionID: 11185
Judge, Jury, and Executioner--A First Look At Execution Plans
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #4 (DBA)
Speaker: Carlos L Chacon
Title: Judge, Jury, and Executioner--A First Look At Execution Plans
Abstract:
When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the 'Hairy' Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/
SessionID: 11187
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #4 (DBA)
Speaker: Carlos L Chacon
Abstract:
SessionID: 11265
The Spy Who Loathed Me - An Intro to SQL Security
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #5 (Dev)
Speaker: Chris Bell
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract:
You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
SessionID: 11541
Check Engine Lights
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #7 (Misc)
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
Together we'll explore SQL Server "check engine lights", those little indications that SQL Server needs your attention. Ignore these and you could be stuck alongside the road with a broken engine.
SessionID: 11542
Your Best Interview Ever
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #3 (Pro Dev)
Speaker: Chris Skorlinski
Title: Your Best Interview Ever
Abstract:
Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. I'll cover key strategies you can use to make your face-2-face interview the best ever increasing chances for a new job and new adventure.
SessionID: 12423
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #7 (Misc)
Speaker: David Orlandi
Abstract:
Set up comprehensive data collections within seconds
Create a series of threshold-based alerts automatically and tie them to email notifications
View the historical state of the instance when an issue occurred
Monitor the entire application stack to identify bottlenecks
Diagnose the source of CPU or I/O problems immediately
Integrate Spotlight on SQL Server data with SSRS
Monitor additional connections, such as SSAS, VMware, SQL Azure, and any Windows OS
SessionID: 13412
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #3 (Pro Dev)
Speaker: Doug Purnell
Abstract:
SessionID: 13478
How to Write a DML Trigger
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #6 (Misc)
Speaker: Louis Davidson
Title: How to Write a DML Trigger
Abstract:
Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..
SessionID: 14194
T-SQL Anti-Patterns
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #7 (Misc)
Speaker: Kevin Feasel
Title: T-SQL Anti-Patterns
Abstract:
SessionID: 14477
Using Expressions to Avoid Three SSRS Annoyances
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #1 (BI)
Speaker: Geoff Johnson
Title: Using Expressions to Avoid Three SSRS Annoyances
Abstract:
As powerful as it is, SQL Server Reporting Services still has frustrating annoyances. Three in particular are: 1) non-queried parameter values must be entered one value at a time, with lots of clicking along with way; 2) the page header and page footer sections cannot contain data regions and therefore cannot display sets of data-driven values; and 3) matrix reports promise the analytical ability of Excel PivotTables but fall short because they are fixed and lack the ability to dynamically slice-and-dice data by values selected by the user. With the expression techniques taught in this session, these annoyances will annoy no longer because you will be able to work around all three.
SessionID: 14955
Basic Monitoring with Perfmon
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #7 (Misc)
Speaker: Rick Heiges
Title: Basic Monitoring with Perfmon
Abstract:
SessionID: 14956
Community and Cool Stuff
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #4 (DBA)
Speaker: Rick Heiges
Title: Community and Cool Stuff
Abstract:
Learn how to navigate the SQL Server Community. There are a lot of great resources out there - Most of them Free. Learn what is available and how you can get the most of the community. We will them explore THREE cool features in SQL Server 2014 - Clustered Column-Store Index, Buffer Pool Extension, and In-Memory OLTP Database Technology (aka Hekaton).
SessionID: 15907
DataViz You Thought You Couldn't Do with SSRS
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #1 (BI)
Speaker: Jason Thomas
Title: DataViz You Thought You Couldn't Do with SSRS
Abstract:
SessionID: 16668
Data Warehouse ETL Rollback with SSIS 2012
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #1 (BI)
Speaker: Jessica Moss
Title: Data Warehouse ETL Rollback with SSIS 2012
Abstract:
Loading a data warehouse can be fraught with data quality issues, data type mismatches, and failed loads. To combat these issues and load your data quickly can be a challenge. This session will explain step-by-step how to implement an ETL rollback framework to remove any data that was loaded incorrectly. Based on a real-world implementation, this framework can either automatically or manually load the corrected data, making your life easier.
SessionID: 17680
12 Steps to Workload Tuning
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #6 (Misc)
Speaker: John Sterrett
Title: 12 Steps to Workload Tuning
Abstract:
SessionID: 17681
Automate your daily checklist with PBM and CMS
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #5 (Dev)
Speaker: John Sterrett
Title: Automate your daily checklist with PBM and CMS
Abstract:
This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.
SessionID: 20210
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #2 (BI)
Speaker: Mark Hudson
Abstract:
Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
SessionID: 20728
Practical SQL: High Availability and Disaster Recovery for SQL Server
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #5 (Dev)
Speaker: Mike Sullivan
Title: Practical SQL: High Availability and Disaster Recovery for SQL Server
Abstract:
From log shipping to Always On Availability Groups, SQL Server has a lot of options for keeping your systems up and your data safe. In this session we will look at the various HA/DR options available in SQL Server and discuss the pros, cons, tips and tricks to each of them. Be sure to bring your questions because we won’t leave until the last question is answered.
SessionID: 22648
SSIS Templates Can Make Your Life Easier
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #2 (BI)
Speaker: Brian Davis
Title: SSIS Templates Can Make Your Life Easier
Abstract:
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
SessionID: 22946
ETL Architecture Chekup: Avoiding Costly Mistakes
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #2 (BI)
Speaker: Rafael Salas
Title: ETL Architecture Chekup: Avoiding Costly Mistakes
Abstract:
In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.
SessionID: 24938
Administering Managing the Power BI Environment
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #2 (BI)
Speaker: Melissa Coates
Title: Administering Managing the Power BI Environment
Abstract:
Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.
SessionID: 26670
Know Backups and Know Recovery
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #4 (DBA)
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
SessionID: 26819
Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #2 (BI)
Speaker: Timothy McAliley
Title: Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure
Abstract:
SessionID: 27513
Inside of Indexes
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #4 (DBA)
Speaker: Slava Murygin
Title: Inside of Indexes
Abstract:
We will navigate through the internal differences between Clustered and non-Clustered indexes. Will take a look how indexes are built, what page splits are and how SQL Server uses indexes to retrieve a data. In that session we will use DBCC IND and DBCC PAGE and dig into pages' binary code. That is Intermediate session for everybody who already knows about indexes, but doesn't really know how they work.
SessionID: 27734
Crazy Things That Developers Do
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #6 (Misc)
Speaker: Wayne Sheffield
Title: Crazy Things That Developers Do
Abstract:
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
SessionID: 9159
Squeezing the Most out of Row Page Compression
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #4 (DBA)
Speaker: Andrew Kelly
Title: Squeezing the Most out of Row Page Compression
Abstract:
SQL Server 2008 brought us the ability to do Row and Page level compression in our databases but even today many people are not taking full advantage of these wonderful features. The most common bottle neck today is physical I/O and SQL Server compression can help with that in most cases. If you are not sure how these features work or how to apply them in your environment this session is for you. We will discuss in detail how the compression schemes work at both the row and page levels along with which data types may or may not be able to participate. We will see from various demos what else affects the compression ratio and just how extensive it can be under the right conditions. Nothing comes for free though so we will also cover the pros and cons along with why, when and most importantly how to use it effectively.
SessionID: 9534
Using BIML as an SSIS Design Patterns Engine
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #1 (BI)
Speaker: Andy Leonard
Title: Using BIML as an SSIS Design Patterns Engine
Abstract:
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
SessionID: 9535
Hacking the SSIS 2012 Catalog
Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track #1 (BI)
Speaker: Andy Leonard
Title: Hacking the SSIS 2012 Catalog
Abstract:
Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!