sqlsathistory

Nr: 297

Back to Main list

SQLSaturday #297 - Colorado Springs 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Ben Miller	Track 1	SMO Internals for High Performance PowerShell
00:00:00	Bill Fellows	Track 3	Type More, Click Less: Programmatically build SSIS packages
00:00:00	Brent Greenwood	Track 3	Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular
00:00:00	Carlos Bossy	Track 1	SQL Server Replication in Practice
00:00:00	Doug Lane	Track 3	SQL Server Murder Mystery Hour: Dead Reports Don't Talk
00:00:00	Rick Lowe	Track 4	I Don't Know Which Queries Are Slow, Just Make All of Them Faster
00:00:00	Glenn Berry	Track 1	Dr. DMV's Troubleshooting Toolkit
00:00:00	Jason Horner	Track 3	Advanced Spatial Analysis: Beyond Bubble Charts
00:00:00	Jason Strate	Track 1	Managing SQL Server Performance with Extended Events
00:00:00	Jason Kassay	Track 4	Getting Started with Execution Plans
00:00:00	John Morehouse	Track 1	SQL Server Databaseology 201: A Study of Database Internals
00:00:00	Kat Long	Track 4	SQL Server performance management
00:00:00	Keith Tate	Track 1	The Curious Case of Isolation Levels
00:00:00	Leonard Lobel	Track 2	Native File Streaming with SQL Server 2012
00:00:00	Meagan Longoria	Track 3	The Accidental Report Designer: Data Visualization Best Practices in SSRS
00:00:00	Michael Sexton	Track 3	SSIS Logging Reconsidered
00:00:00	Reeves Smith	Track 3	Master Data Services – 101
00:00:00	Jeff Renz	Track 2	Tabular Models
00:00:00	Rob Mandeville	Track 2	Virtualizing our Environment
00:00:00	Russ Thomas	Track 4	XPath - XQuery; I guess if I HAVE to
00:00:00	Rob Schafer	Track 4	Tabular Data Modeling and Visualizations
00:00:00	Steve Jones	Track 2	The Encryption Primer
00:00:00	Thomas LaRock	Track 4	Database Design: Size DOES Matter
00:00:00	Steve Wake	Track 4	Capture Change and Apply it With Change Data Capture SSIS
00:00:00	Seth Washeck	Track 2	Back the Truck Up
00:00:00	TJay Belt	Track 2	Documentation – you know you love it
00:00:00	Michael Fal	Track 2	Managing Log File Obesity
00:00:00	AJ Mendo	Track 1	DBA Survival Guide: Daily Checklist and Server Monitoring

SessionID: 10224

SMO Internals for High Performance PowerShell

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Ben Miller

Title: SMO Internals for High Performance PowerShell

Abstract:

Ever wanted to know what happens behind the scenes in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You'll be glad you did.

SessionID: 10452

Type More, Click Less: Programmatically build SSIS packages

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Bill Fellows

Title: Type More, Click Less: Programmatically build SSIS packages

Abstract:

Developing repetitive strain injury (RSI) from all those mouse clicks in Business Intelligence Development Studio/SQL Server Data Tools? Longing to automate the tedium in SQL Server Integration Services package creation? In this session, we’ll explore the Integration Services object model and learn how to create rich packages without ever clicking our mouse. You’ll learn about the basic object model, the EzAPI wrapper for it, as well as using BIMLScript to build moderately complex packages.

SessionID: 10712

Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Brent Greenwood

Title: Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular

Abstract:

You may not see this in the marketing materials, but the reality is PowerPivot and AS Tabular together provide some powerful options for Data Warehousing professionals. This session is for DW dimensional modeling pros interested in streamlining optimizing the design delivery process for enterprise-quality data marts dimensional semantic models.

We'll touch on Agile Lean disciplines, how they can be applied to DW solution delivery. Then we’ll walk through demos of practical applications in the form of PowerPivot POCs prototypes that can be promoted to AS Tabular models and refitted to the finished DW structures once delivered. We’ll focus on key DW challenges and how these technologies and techniques can be used to speed and improve effectiveness of requirements gathering and user testing, optimize sequencing of deliverables, minimize risk of rework and ultimately deliver quality DW solutions successfully.

SessionID: 11341

SQL Server Replication in Practice

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Carlos Bossy

Title: SQL Server Replication in Practice

Abstract:

SQL Server Replication is an important tool that I’ve implemented many times for reliable data movement to support Business Intelligence architectures. This includes using replication to create databases that are used as sources for data warehouses, reporting systems, operational data stores, and historical audit trails. The key concepts to consider when setting up replication will be covered, including replication type, table selection, filters, indexing, and more. Live demonstrations will show how to implement transactional replication for high performance in a real-time environment.

SessionID: 13393

SQL Server Murder Mystery Hour: Dead Reports Don't Talk

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Doug Lane

Title: SQL Server Murder Mystery Hour: Dead Reports Don't Talk

Abstract:

SABOTAGE? MURDER?

Before a pivotal meeting to secure venture capital, a key report vanishes from the server without a trace, leaving Cromulent Technologies' future in jeopardy. Our group must solve the crime. Time is critical as the CEO has promised to explain the matter to investors just sixty minutes from now. Only with your investigative skills, SQL Server knowledge, and teamwork can we find the missing report, bring the perpetrator to justice, and save Cromulent Technologies!

SQL Server Murder Mystery Hour is part technical presentation, part networking event. We'll focus on Reporting Services administration in areas that are vital to business continuity: security roles, encryption keys, and backups. All attendees have a part to play.

SessionID: 14292

I Don't Know Which Queries Are Slow, Just Make All of Them Faster

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Rick Lowe

Title: I Don't Know Which Queries Are Slow, Just Make All of Them Faster

Abstract:

Shortly after learning how to troubleshoot a poorly performing queries it's not unusual for a DBA to discover a nasty surprise - some (or perhaps most) of your users will not be able to actually tell you what query is performing poorly. The good news is that SQL Server does know! This session covers some of the basics of looking through the plan cache for slow queries, including some tips on spotting potential parameter sniffing issues when you don't have the luxury of actual execution plans.

SessionID: 14694

Dr. DMV's Troubleshooting Toolkit

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Glenn Berry

Title: Dr. DMV's Troubleshooting Toolkit

Abstract:

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains numerous DMV queries that you can quickly and easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.

SessionID: 15812

Advanced Spatial Analysis: Beyond Bubble Charts

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Jason Horner

Title: Advanced Spatial Analysis: Beyond Bubble Charts

Abstract:

Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!

SessionID: 15983

Managing SQL Server Performance with Extended Events

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Jason Strate

Title: Managing SQL Server Performance with Extended Events

Abstract:

One of a DBA's primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it's one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.

SessionID: 16875

Getting Started with Execution Plans

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Jason Kassay

Title: Getting Started with Execution Plans

Abstract:

There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.

SessionID: 17244

SQL Server Databaseology 201: A Study of Database Internals

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: John Morehouse

Title: SQL Server Databaseology 201: A Study of Database Internals

Abstract:

Did you take apart your Mom's toaster or your Dad's alarm clock just to see how it worked? Ever wonder how that database you built or support works behind the scenes at the record level? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures down to the very records themselves. This session will explore some of those deep inner workings of a SQL Server databases. The attendee will walk away with a better understanding of how SQL Server databases work which would allow them to build better and faster databases.

SessionID: 17990

SQL Server performance management

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Kat Long

Title: SQL Server performance management

Abstract:

discuss approaches to SQL Server performance management from both Resource and Wait State perspectives, and ways to use these approaches using both native utilities and Dell Software tools

SessionID: 18854

The Curious Case of Isolation Levels

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Keith Tate

Title: The Curious Case of Isolation Levels

Abstract:

Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.

SessionID: 19056

Native File Streaming with SQL Server 2012

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Leonard Lobel

Title: Native File Streaming with SQL Server 2012

Abstract:

In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.

SessionID: 19191

The Accidental Report Designer: Data Visualization Best Practices in SSRS

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Meagan Longoria

Title: The Accidental Report Designer: Data Visualization Best Practices in SSRS

Abstract:

Whether you are a DBA, a developer, or an analyst, there is a good chance that you will have to create reports for coworkers, company executives, or clients. As with any UI design, careful consideration should be given to your data visualization design to ensure you are effectively communicating the intended message and providing a good user experience. While the principles are applicable across reporting platforms and tools, this session will contain demos and examples implemented in Reporting Services using SQL Server Data Tools. Learn how to make information (not just data) the focus of your report and provide your audience with something better than just shiny!

SessionID: 20595

SSIS Logging Reconsidered

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Michael Sexton

Title: SSIS Logging Reconsidered

Abstract:

The advent of SQL Server 2012, SQL Server Data Tools and Integration Services Catalogs have significantly improved out of the box logging. Unfortunately, logging best practices have not evolved with the new logging tools. This talk will outline the logging available “out of the box” with SSIS and discuss the implications for “traditional” ETL logging. Logging best practices will vary by business, industry and regulatory environments. We will review examples from the most basic operational logging to the most sophisticated logging required for auditing and regulatory compliance.

SessionID: 22762

Master Data Services – 101

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Reeves Smith

Title: Master Data Services – 101

Abstract:

Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in and some Integration Services packages.

SessionID: 22920

Tabular Models

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Jeff Renz

Title: Tabular Models

Abstract:

Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.

SessionID: 23361

Virtualizing our Environment

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Rob Mandeville

Title: Virtualizing our Environment

Abstract:

This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I'll discuss the differences between virtual and physical host metrics and issues surrounding them. We'll discuss some virtualization shortcomings and then show a little about Confio's Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.

SessionID: 23591

XPath - XQuery; I guess if I HAVE to

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Russ Thomas

Title: XPath - XQuery; I guess if I HAVE to

Abstract:

I don't know anyone who likes it. But the reality is sooner or later you'll have to use XML in your database career. It appears in extended events, ring buffer queries, and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and semi-structured data in administering databases.

SessionID: 24038

Tabular Data Modeling and Visualizations

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Rob Schafer

Title: Tabular Data Modeling and Visualizations

Abstract:

In this session, we will look at Tabular Data modeling, the life cycle of Tabular Models, and visualization tools available in the Microsoft Business Intelligence Stack. We will build a tabular solution from scratch and discuss use cases and differences between Tabular and Multidimensional Data Models. Finally, we will take a look at the data visualization tools in the Microsoft BI Stack including: SharePoint Integration, Excel Services, and Power View. This demo heavy presentation will cover a wide variety of topics and tools equipping attendees with the knowledge to start developing Tabular Data models and understanding how to use Data Visualization tools to effectively empower users with self-service BI and drive efficiency across the organization.

SessionID: 24526

The Encryption Primer

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Steve Jones

Title: The Encryption Primer

Abstract:

Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.

SessionID: 25150

Database Design: Size DOES Matter

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Thomas LaRock

Title: Database Design: Size DOES Matter

Abstract:

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

SessionID: 25699

Capture Change and Apply it With Change Data Capture SSIS

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Steve Wake

Title: Capture Change and Apply it With Change Data Capture SSIS

Abstract:

Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.

SessionID: 25935

Back the Truck Up

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Seth Washeck

Title: Back the Truck Up

Abstract:

Performance tuning backups? Yes. Performance tuning backups. As your data grows, so does your DR profile. In this session we'll take a look at how different backup configuration options affect both the performance of your backups as well as the performance of your server during the backups. Of course, this is also sneaky way to introduce a real-world use of Extended Events during the process.

SessionID: 26896

Documentation – you know you love it

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: TJay Belt

Title: Documentation – you know you love it

Abstract:

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.

SessionID: 34789

Managing Log File Obesity

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Michael Fal

Title: Managing Log File Obesity

Abstract:

Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything? Log file obesity is a problem that can challenge DBAs of any level. This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.

SessionID: 9108

DBA Survival Guide: Daily Checklist and Server Monitoring

Back to calendar

Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: AJ Mendo

Title: DBA Survival Guide: Daily Checklist and Server Monitoring

Abstract:

You are responsible for the health and welfare of the servers, and the databases under your command. What should you check daily? How about weekly? Should you automate? We will discuss all these things, and how having a Daily Checklist, and monitoring your server will help you maintain balance in the galaxy.

This site is open source. Improve this page.