sqlsathistory

Nr: 347

Back to Main list

SQLSaturday #347 - Washington DC 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Allen White	BI2 - Intermediate / Advanced	Get Near Realtime ETL with Service Broker
00:00:00	Ayman El-Ghazali	DBA 2 - Intermediate / Advanced	Performance Tuning Pit Stop for DBAs
00:00:00	Jason Brimhall	DBA 1 - Intro / Intermediate	Murder They Wrote
00:00:00	Carlos L Chacon	DBA 1 - Intro / Intermediate	"I Know What You Did Last Query" --SQL Server
00:00:00	David Dye	BI 1 - Intro / Intermediate	Dealing With Errors in SSIS 2012
00:00:00	Doug Purnell	Prof. Dev.	Congrats on your promotion to DBA, now what?
00:00:00	Gigi Bell	Prof. Dev.	Dealing With Difficult People
00:00:00	Grant Fritchey	DBA 2 - Intermediate / Advanced	Getting Started Reading Execution Plans
00:00:00	Joseph D'Antoni	BI 1 - Intro / Intermediate	Power BI in the Fast Lane--Visualizing Formula 1
00:00:00	Jessica Moss	BI2 - Intermediate / Advanced	Analysis Services: Multidimensional vs Tabular
00:00:00	Jimmy May	BI2 - Intermediate / Advanced	Columnstore Indexes in SQL Server 2014: Flipping the DW /Faster Bit
00:00:00	Konstantin Melamud	DBA 2 - Intermediate / Advanced	Performance Tuning - Analyzing Execution Plans
00:00:00	Konstantin Melamud	DEV	Turbo Boost Performance: In Memory Tables index optimizations
00:00:00	Ravi Kumar	BI 1 - Intro / Intermediate	Think like SSIS and Build a package
00:00:00	Michael Bourgon	DBA 1 - Intro / Intermediate	SQL Watchdog - find out instantly when SQL changes occur in production
00:00:00	Paresh Motiwala	Prof. Dev.	DBA to Project Manager in 75 minutes flat
00:00:00	Sebastian Meine	DEV	Securing a Multi-Database Application
00:00:00	William Wolf	DEV	Common Coding Mistakes and how to Mitigate them
00:00:00	Randy Knight	DBA 2 - Intermediate / Advanced	Locks, Blocks, and Deadlocks Oh My!
00:00:00	Reeves Smith	BI 1 - Intro / Intermediate	Data Discovery with Power Query for Excel
00:00:00	Reeves Smith	BI2 - Intermediate / Advanced	Get Into Evaluation Context with DAX, the Language of PowerPivot
00:00:00	Samuel Vanga	BI2 - Intermediate / Advanced	SSIS Data Flow Engine: Under the Hood
00:00:00	Steve Jones	Prof. Dev.	Branding Yourself for a Dream Job
00:00:00	Timothy McAliley	DBA 1 - Intro / Intermediate	Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure
00:00:00	Theresa Iserman	DBA 1 - Intro / Intermediate	Not So Basic Backup and Restore
00:00:00	Slava Murygin	DBA 2 - Intermediate / Advanced	Charlie and the SQL Server Re-Fill Factory
00:00:00	Wayne Sheffield	DEV	SSMS Tips Tricks
00:00:00	Alan Faulkner	BI 1 - Intro / Intermediate	SSAS Best Practices
00:00:00	Amy Herold	DEV	Beginning Automation with Powershell

SessionID: 10068

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI2 - Intermediate / Advanced

Speaker: Allen White

Title: Get Near Realtime ETL with Service Broker

Abstract:

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

SessionID: 10089

Performance Tuning Pit Stop for DBAs

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 2 - Intermediate / Advanced

Speaker: Ayman El-Ghazali

Title: Performance Tuning Pit Stop for DBAs

Abstract:

Our users are in constant demand of faster running servers that spill out data before they can blink. Performance can be hard to measure and improve. Before we get in the race we will cover how to get a Performance baseline using the PAL Tools. The first Pit Stop will be to review TempDB setup to improve performance. Before getting into high gear we'll pull over to refuel on some Log File best practices and performance implications of VLFs. Finally before passing the checkered flag we'll make one more stop to talk about Data Files and improving your mileage from there. After this session you'll have a good idea of how to make changes transparent to any application to get your server crossing that finish line in style!

SessionID: 10867

Murder They Wrote

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 1 - Intro / Intermediate

Speaker: Jason Brimhall

Title: Murder They Wrote

Abstract:

Join Microsoft Certified Master and SQL Server MVP, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy.

This is the Solo version of the Joint version normally done as an all-day precon

SessionID: 11205

"I Know What You Did Last Query" --SQL Server

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 1 - Intro / Intermediate

Speaker: Carlos L Chacon

Title: "I Know What You Did Last Query" --SQL Server

Abstract:

Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings. This information is available via Dynamic Management View and functions and officially they "return internal, implementation-specific state data." This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment. We also open up the floor for ideas of how you are using these views/functions.

SessionID: 13197

Dealing With Errors in SSIS 2012

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI 1 - Intro / Intermediate

Speaker: David Dye

Title: Dealing With Errors in SSIS 2012

Abstract:

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.

You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details

SessionID: 13416

Congrats on your promotion to DBA, now what?

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Prof. Dev.

Speaker: Doug Purnell

Title: Congrats on your promotion to DBA, now what?

Abstract:

For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.

SessionID: 14412

Dealing With Difficult People

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Prof. Dev.

Speaker: Gigi Bell

Title: Dealing With Difficult People

Abstract:

John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.

SessionID: 14793

Getting Started Reading Execution Plans

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 2 - Intermediate / Advanced

Speaker: Grant Fritchey

Title: Getting Started Reading Execution Plans

Abstract:

The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.

SessionID: 16240

Power BI in the Fast Lane--Visualizing Formula 1

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI 1 - Intro / Intermediate

Speaker: Joseph D'Antoni

Title: Power BI in the Fast Lane--Visualizing Formula 1

Abstract:

Power BI provides a great toolkit for building data models and doing rapid analysis of data. When you combine the broad capabilities of Power Query to gather external data through a wide variety of data sources and Open APIs. In this session, you will learn about the entire Power BI toolset using data from the current Formula 1 season. You will learn how to use graphics (track maps) as icons for filtering in Power View. You will learn how to relate data in a Power Pivot data model to build complex visualizations. You will learn about Power BI QA and how it can provide answers from your data.

SessionID: 16673

Analysis Services: Multidimensional vs Tabular

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI2 - Intermediate / Advanced

Speaker: Jessica Moss

Title: Analysis Services: Multidimensional vs Tabular

Abstract:

The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.

SessionID: 16850

Columnstore Indexes in SQL Server 2014: Flipping the DW /Faster Bit

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI2 - Intermediate / Advanced

Speaker: Jimmy May

Title: Columnstore Indexes in SQL Server 2014: Flipping the DW /Faster Bit

Abstract:

Columnstore indexes were introduced in SQL Server 2012 have been wholly re-architected optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads are a hybrid technology leveraging the best of off-disk in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, big wins at customer sites inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit why columnstore manifests my motto, “Change the world or go home!”

SessionID: 18566

Performance Tuning - Analyzing Execution Plans

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 2 - Intermediate / Advanced

Speaker: Konstantin Melamud

Title: Performance Tuning - Analyzing Execution Plans

Abstract:

Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations.

In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation

SessionID: 18568

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DEV

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 18871

Think like SSIS and Build a package

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI 1 - Intro / Intermediate

Speaker: Ravi Kumar

Title: Think like SSIS and Build a package

Abstract:

You wouldn't drive to a new place without directions? Then why build a SSIS package without having a road map on how to build it. Learn how to think like SSIS, make your ETL life easy, and convert a Process into an SSIS Package. If time allows, we will also cover SSIS Package Configurations, security and deployment. Expect to participate actively in the class.

SessionID: 19934

SQL Watchdog - find out instantly when SQL changes occur in production

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 1 - Intro / Intermediate

Speaker: Michael Bourgon

Title: SQL Watchdog - find out instantly when SQL changes occur in production

Abstract:

Almost everyone's seen it happen - problems due to changes, be it SPs, index rebuilds, or even configuration changes. What if you could look historically and track down what changes were made when, by who, and from where? What if you could see in realtime when changes occur? It exists, it's built into all SQL Servers from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment. This is not theory, all code provided and in production on hundreds of servers in multiple environments.

SessionID: 21674

DBA to Project Manager in 75 minutes flat

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: Prof. Dev.

Speaker: Paresh Motiwala

Title: DBA to Project Manager in 75 minutes flat

Abstract:

As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.

In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.

SessionID: 21731

Securing a Multi-Database Application

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DEV

Speaker: Sebastian Meine

Title: Securing a Multi-Database Application

Abstract:

It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable.

In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.

SessionID: 22077

Common Coding Mistakes and how to Mitigate them

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DEV

Speaker: William Wolf

Title: Common Coding Mistakes and how to Mitigate them

Abstract:

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

SessionID: 22571

Locks, Blocks, and Deadlocks Oh My!

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 2 - Intermediate / Advanced

Speaker: Randy Knight

Title: Locks, Blocks, and Deadlocks Oh My!

Abstract:

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.

SessionID: 22779

Data Discovery with Power Query for Excel

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI 1 - Intro / Intermediate

Speaker: Reeves Smith

Title: Data Discovery with Power Query for Excel

Abstract:

Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing.

This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.

SessionID: 22780

Get Into Evaluation Context with DAX, the Language of PowerPivot

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI2 - Intermediate / Advanced

Speaker: Reeves Smith

Title: Get Into Evaluation Context with DAX, the Language of PowerPivot

Abstract:

Data Analysis Expressions (DAX) is the language of PowerPivot and the Analysis Services Tabular engine. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demonstrate row and filter context.

SessionID: 23904

SSIS Data Flow Engine: Under the Hood

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI2 - Intermediate / Advanced

Speaker: Samuel Vanga

Title: SSIS Data Flow Engine: Under the Hood

Abstract:

A data flow task moves data from point A to point B, but how does it work behind the scenes? Understanding the internals of data flow engine can help you make correct package design choices in the first place and identify issues when your data loads run forever.

Using simple analogies, you'll see how data flow engine moves data through each component, uses buffers, builds execution trees, and transforms data in the pipeline. Along the way, you'll learn corresponding options and tips that make your packages run as fast as possible. This demo-filled session is for SSIS developers who're comfortable with creating packages but not so comfortable figuring out why data flow is slow and when or how to parallelize the data flows. Open the hood, you need to know how data flow engine works to make it work for you in an efficient and optimal way.

SessionID: 24558

Branding Yourself for a Dream Job

Back to calendar

Event Date: 06-12-2014 - 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: 26834

Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 1 - Intro / Intermediate

Speaker: Timothy McAliley

Title: Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure

Abstract:

In this session, we will discuss and demonstrate backup and recovery of your on-premises SQL Server databases to and from Windows Azure, a key Hybrid Cloud capability of SQL Server 2014. We will discuss key feature concepts such as the enhanced Backup UI, Restore UI, encrypted backups, SQL Server backup to URL, and the SQL Server Backup to Windows Azure Tool. We will also discuss the scenarios for integration of this technology.

SessionID: 26888

Not So Basic Backup and Restore

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 1 - Intro / Intermediate

Speaker: Theresa Iserman

Title: Not So Basic Backup and Restore

Abstract:

You’re taking basic backups and you know how to restore them. Things have been running smoothly in your environment but you want to be confident that you’re equipped with the backup and restore tools, techniques, and options that you’ll need to adapt your strategies as business needs change. You’ve heard about piecemeal restores, filegroup backups, and backing up to multiple files, and now you’re ready to dig into learning more about these topics. In this demo-rich presentation, we’ll review scenarios using these options and you'll gain an understanding of some intermediate and advanced options related to backup performance, corruption detection, and the new SQL Server 2014 hybrid backup scenarios. You'll return to the office inspired to validate your backups and test your restore processes regularly, and you'll have references to great tools the SQL community has shared to help you get started.

SessionID: 27532

Charlie and the SQL Server Re-Fill Factory

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DBA 2 - Intermediate / Advanced

Speaker: Slava Murygin

Title: Charlie and the SQL Server Re-Fill Factory

Abstract:

Will show you the chocolate of Fill Factor and how to win the Golden Ticket by easy Re-FillFactoring

SessionID: 27758

SSMS Tips Tricks

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DEV

Speaker: Wayne Sheffield

Title: SSMS Tips Tricks

Abstract:

Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Come to this session, consisting mostly of demos, to see features built-in to SSMS that will improve your experience and productivity. Time permitting, we'll also go into some 3rd party products that also increase your productivity in SSMS.

SessionID: 9069

SSAS Best Practices

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: BI 1 - Intro / Intermediate

Speaker: Alan Faulkner

Title: SSAS Best Practices

Abstract:

A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

SessionID: 9414

Beginning Automation with Powershell

Back to calendar

Event Date: 06-12-2014 - Session time: 00:00:00 - Track: DEV

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you wil learn how you can leverage Powershell to not only efficiently meet the needs of your busines, but also free up your time for other things.

This site is open source. Improve this page.