Nr: 233
SQLSaturday #233 - Washington DC 2013
SessionID: 10079
SQL Server Backup and Recovery Fundamentals
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 1
Speaker: Ayman El-Ghazali
Title: SQL Server Backup and Recovery Fundamentals
Abstract:
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.
SessionID: 10828
SQL 2012 Extended Events
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 2
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 11180
Judge, Jury, and Executioner--A First Look At Execution Plans
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Dev
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: 12552
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 2
Speaker: David Klee
Abstract:
SessionID: 12962
Dealing With Errors in SSIS 2012
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: David Dye
Title: Dealing With Errors in SSIS 2012
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
SessionID: 14745
Tune Queries By Fixing Bad Parameter Sniffing
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Grant Fritchey
Title: Tune Queries By Fixing Bad Parameter Sniffing
Abstract:
SessionID: 16209
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 1
Speaker: Joseph D'Antoni
Abstract:
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
SessionID: 16667
Data Warehouse ETL Rollback with SSIS 2012
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 2
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: 18015
Being the Swiss Army Knife of DB Pros
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Prof. Dev
Speaker: Brian Kelley
Title: Being the Swiss Army Knife of DB Pros
Abstract:
Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, "Jack of all trades, master of none." The full saying is, "Jack of all trades, master of none, though often times better than master of one."
SessionID: 18284
SQL Server 2012 Columnstore index
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 1
Speaker: Kevin Goff
Title: SQL Server 2012 Columnstore index
Abstract:
It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well. Time permitting, I'll also talk about the new enhancements in SQL 2014.
SessionID: 18540
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 1
Speaker: Konstantin Melamud
Abstract:
This topic will cover best practices when optimizing index performance in your DBMS. This presentation is targeted for mid to senior level DBA’s. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.
SessionID: 20202
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 1
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: 20440
Never Have to Say "Mayday!!!" Again
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Prof. Dev
Speaker: Mike Walsh
Title: Never Have to Say "Mayday!!!" Again
Abstract:
December 1978: 10 people die in a commercial airliner. Why? Bad troubleshooting skills and poor maintenance – disaster-causing attitudes. As you'll learn in this session, the doomed airliner ran out of fuel while the crew of three wasted time troubleshooting a false alarm. We can draw some parallels in the database world. Poor troubleshooting, disaster-causing attitudes, and a lack of disaster preparedness lead to needless downtime and serious user impact across our environments.
In this session, we'll look at case studies of real-life aviation disasters and production database downtime incidents. We'll see similarities in attitudes that cause disasters. Come learn about the importance of preparation, troubleshooting, and teamwork. This will be an interactive session where we’ll pick apart disasters, engage in discussion around case studies, and leave prepared to change attitudes in ourselves and our colleagues and avoid disasters at work.
SessionID: 21801
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 23547
HealthySQL
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 2
Speaker: Robert Pearl
Title: HealthySQL
Abstract:
Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? Let's make sure your servers are up to its latest optimizations!
What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)
SessionID: 23895
Merge Dimensions Ahead
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 1
Speaker: Samuel Vanga
Title: Merge Dimensions Ahead
Abstract:
Using SSIS to load data warehouse dimensions is a common task. There are several methods available, but the best method is the one that performs well and is easy to maintain. More importantly, you should be able to automate the development of this common package.
In this session, Sam will provide:
An overview of slowly changing dimensions, Comparison between different patterns that can be used including T-SQL merge, Solutions for the common errors with merge statement, and Scripts and framework to automatically generate merge statements and SSIS packages you can readily use for loading dimensions
SessionID: 24483
Branding Yourself for a Dream Job
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Prof. Dev
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 24697
(Way Too Much) Fun with Reporting Services
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 1
Speaker: Stacia Varga
Title: (Way Too Much) Fun with Reporting Services
Abstract:
SessionID: 26151
Indexing Deep Dive
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Kevin Boles
Title: Indexing Deep Dive
Abstract:
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
SessionID: 26724
It is TEMPDB, Why Should You Care?
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 1
Speaker: Tim Radney
Title: It is TEMPDB, Why Should You Care?
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 26825
A Walk Around the SQL Server 2014 Audit Feature
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 1
Speaker: Timothy McAliley
Title: A Walk Around the SQL Server 2014 Audit Feature
Abstract:
In this demo-heavy session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2014. The session will largely focus on the specifics of using the SQL Server 2014 Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Serve 2014r Audit for server and database events. The demo environment will be run on a Windows Azure Virtual Machine running Windows Server 2012 R2 and SQL Server 2014 (CTP 1 or higher).
SessionID: 27511
Best SQL Server Programming practices
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Slava Murygin
Title: Best SQL Server Programming practices
Abstract:
This session is mostly for junior SQL Server developers, Project Managers and Team Leads.
We will talk about how to write good SQL code, how to collaborate in a team and produce perfect documentation.
SessionID: 27688
Crazy Things That Developers Do, Part I
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Wayne Sheffield
Title: Crazy Things That Developers Do, Part I
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 2 part session to learn what we do, why it's bad to the database server... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
SessionID: 28235
Change Data Capture Change Tracking Deep Dive
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Kevin Hazzard
Title: Change Data Capture Change Tracking Deep Dive
Abstract:
Change Data Capture (CDC) and Change Tracking (CT) have been standard features in SQL Server for a few years now but there's not really that much useful information out in the blogosphere about how they work under the hood. Kevin Hazzard will dig deep into the implementations of CDC and CT in SQL Server 2012, showing you all of the parameters you can use to make these great features serve your organization well. This will be a highly-interactive, highly-entertaining session with lots of questions answered and mysteries revealed.
SessionID: 35784
Data Career Paths and Decision Making Strategies
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: Prof. Dev
Speaker: Melissa Demsak
Title: Data Career Paths and Decision Making Strategies
Abstract:
SessionID: 8965
Introduction to SQL Server 2012 AlwaysOn Availability Groups
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 2
Speaker: Adam Belebczuk
Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups
Abstract:
SessionID: 9153
Policy-Based Management and Central Management Server
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 2
Speaker: Andrew Kelly
Title: Policy-Based Management and Central Management Server
Abstract:
Two of the most highly underutilized features of SQL Server are Policy-Based Management (PBM) and Central Management Server (CMS). PBM allows you to administer and control your SQL Server environment in a way that was very difficult or even impossible beforehand. Simply put PBM lets you define rules or policies to govern your SQL Server enterprise. CMS among other things allows you to organize and manage your instances in groups that you define from a single point. Come see how these two features can add a whole new level of manageability and reduce the time you spend achieving your management goals.
SessionID: 9245
SQL Server Dos and Don'ts: Keys to DBA Nirvana
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: DBA 1
Speaker: Allan Hirt
Title: SQL Server Dos and Don'ts: Keys to DBA Nirvana
Abstract:
SessionID: 9497
Using BIML as an SSIS Design Patterns Engine
Event Date: 07-12-2013 - Session time: 00:00:00 - Track: BI 2
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.