sqlsathistory

Nr: 421

Back to Main list

SQLSaturday #421 - Columbus 2015

Start Time (24h) Speaker Track Title
08:30:00 David Eichner Track 3 SRS Report Builder for Business Intelligence
08:30:00 John Deardurff Track 3 How to get Microsoft Certified
08:30:00 Allen White Track 1 Get Near Realtime ETL with Service Broker
08:30:00 Colleen Morrow Track 1 What changed? Auditing options in SQL Server 2014
08:30:00 Erin Stellato Track 3 Updating Statistics Affects Query Performance More Than You Think
09:40:00 Dave Mattingly Track 3 Database: The Motion Picture
09:40:00 Ravi Kumar Track 3 SSRS 101 to 301: Learn how to build Simple and Intermediate level
09:40:00 Sam Nasr Track 3 Full-Text Search with Custom Proximity
09:40:00 Mark Tabladillo Track 2 Primer on Power BI
09:40:00 Brian Davis Track 3 DQ What? DQ Who? DQ How?
10:50:00 Eddie Wuerch Track 1 A Day in the Life of a Row: Internals Deep Dive
10:50:00 David Klee Track 1 Right-Sizing Your SQL Server Virtual Machine
10:50:00 Chris Bell Track 1 The Spy Who Loathed Me - An Overview of SQL's Security Features
10:50:00 Konstantin Melamud Track 3 Turbo Boost Performance: In Memory Tables index optimizations
10:50:00 Adam Belebczuk Track 1 SSIS Grab Bag of Best Practices
13:00:00 Kevin Feasel Track 3 Much Ado About Hadoop
13:00:00 Phillip Labry Track 3 Getting Started with Analysis Services Tabular mode
13:00:00 Eugene Meidinger Track 3 Execution Plans 101
13:00:00 Ryan Adams Track 1 Backup and Restore Tips and Tricks
13:00:00 Brian Davis Track 3 Goodbye Next Next Next, Hello Automated Installs
14:10:00 Gill Rowley Track 3 Partition Switching - Moving a Lot of Data Very Quickly
14:10:00 George Walkey Track 1 Scripting out SQL Server for Documentation and Disaster Recovery
14:10:00 Chris Bell Track 1 Hacking Expos#233; - Using SSL to Secure SQL Server Connections
14:10:00 Warren Sifre Track 3 Introduction to Azure Machine Learning
14:10:00 Eddie Wuerch Track 3 Join Us! Getting Started as a Technical Speaker
15:20:00 Paul Popovich Jr Track 3 Clusters! From the ground up, don't double your storage, let's build one together.
15:20:00 Warren Sifre Track 3 Introduction to APS
15:20:00 David Klee Track 1 My Brain Has Blue Screened - Let's Laugh
15:20:00 Jay Robinson Track 1 Playing in Traffic: Lessons from High-Speed, High-Volume Applications
15:20:00 Adam Belebczuk Track 3 XML Without Xanax: How to Handle XML in SQL Server

SessionID: 12802

SRS Report Builder for Business Intelligence

Back to calendar

Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 3

Speaker: David Eichner

Title: SRS Report Builder for Business Intelligence

Abstract:

Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!

SessionID: 17230

How to get Microsoft Certified

Back to calendar

Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 3

Speaker: John Deardurff

Title: How to get Microsoft Certified

Abstract:

This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification..

SessionID: 36038

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 1

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? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. 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: 36890

What changed? Auditing options in SQL Server 2014

Back to calendar

Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 1

Speaker: Colleen Morrow

Title: What changed? Auditing options in SQL Server 2014

Abstract:

When and how was this view changed? Where did that index go? Who's accessing my sensitive data? As a DBA, you'll face these and similar questions throughout your career. And if you don't have an audit in place, providing answers can be difficult.

In this demo-rich session we'll examine auditing options in SQL Server 2014, including SQL Trace, event notifications, DDL and logon triggers, and SQL Server Audit. We'll begin by defining real-world requirements for an auditing solution, such as events to capture, data to collect, output destinations, and performance considerations. As we implement each tool, we'll discuss its unique benefits and limitations, and see how it stacks up against our specifications.

By the end of this session, you'll have the knowledge you need to select and implement the auditing tool that's right for you.

SessionID: 37239

Updating Statistics Affects Query Performance More Than You Think

Back to calendar

Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 3

Speaker: Erin Stellato

Title: Updating Statistics Affects Query Performance More Than You Think

Abstract:

Stop me if you've heard this one, "This query is slow, let's update statistics." But what does updating statistics really do to your query performance? And is it the right solution? While updating statistics may provide a short-term solution, it can bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you do update statistics, and you’ll see why that might not always be the right long-term solution.

SessionID: 12264

Database: The Motion Picture

Back to calendar

Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3

Speaker: Dave Mattingly

Title: Database: The Motion Picture

Abstract:

Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"

SessionID: 36404

SSRS 101 to 301: Learn how to build Simple and Intermediate level

Back to calendar

Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3

Speaker: Ravi Kumar

Title: SSRS 101 to 301: Learn how to build Simple and Intermediate level

Abstract:

We will start with basic reporting services report and work up to intermediate level. If time allows, we will cover some advance feature. We will also cover some "Gotchas" as we move along. The session will be heavily demo based.

SessionID: 36943

Full-Text Search with Custom Proximity

Back to calendar

Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3

Speaker: Sam Nasr

Title: Full-Text Search with Custom Proximity

Abstract:

Custom proximity search is a new feature introduced in SQL Server 2012 Full-Text Search. It's facilitated using the NEAR operator, allowing it to be used in the CONTAINS predicate or CONTAINSTABLE function. The NEAR operator allows for searching words near each other. It also allows the user to specify the maximum number of non-search terms separating the first and last search terms in a match. In addition, an optional parameter can be used to specify an exact order match.

SessionID: 37279

Primer on Power BI

Back to calendar

Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 2

Speaker: Mark Tabladillo

Title: Primer on Power BI

Abstract:

Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies. We will answer the following questions:

◾What makes Power BI different from the Microsoft Office I have known for years?

◾What are the major Power BI features in Excel 2013 and 2010?

◾What are the major features for Power BI for Office 365?

◾How can our team license Power BI?

SessionID: 37306

DQ What? DQ Who? DQ How?

Back to calendar

Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3

Speaker: Brian Davis

Title: DQ What? DQ Who? DQ How?

Abstract:

Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.

SessionID: 36048

A Day in the Life of a Row: Internals Deep Dive

Back to calendar

Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1

Speaker: Eddie Wuerch

Title: A Day in the Life of a Row: Internals Deep Dive

Abstract:

The SQL Server Query Processor does a great job of hiding all the dirty work necessary to display, store, and delete data. But when it's time to tune performance, the more you know, the better decisions you will make. In this T-SQL demo-heavy deep-dive session, we'll follow the Query Processor as it rips through a database and discover the steps it takes responding to our queries.

Attend this advanced session and you will be able to: * View and interpret raw data and metadata with DMVs, XEvents, and DBCC commands, including some undocumented ones (all demo scripts included in session download) * View and describe, with precise details, exactly what data and metadata actions any given query took, and, * Attack and destroy query performance problems with some neat new weapons.

SessionID: 36532

Right-Sizing Your SQL Server Virtual Machine

Back to calendar

Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1

Speaker: David Klee

Title: Right-Sizing Your SQL Server Virtual Machine

Abstract:

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

SessionID: 36578

The Spy Who Loathed Me - An Overview of SQL's Security Features

Back to calendar

Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1

Speaker: Chris Bell

Title: The Spy Who Loathed Me - An Overview of SQL's Security Features

Abstract:

You have lots of data painstakingly collected over the years.

How do you ensure that all your hard work is protected from hackers, spies and other ne’er-do-wells? Having knowledge of the vast array of security features available in SQL Server is the first step in helping determine what actions you need to take to protect your data. This session will quickly go through a majority of the security features in SQL Server, to help you learn what each does, and let you determine which features work best for your situation.

*Note – This session is demo-free.

SessionID: 37214

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 3

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: 37312

SSIS Grab Bag of Best Practices

Back to calendar

Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1

Speaker: Adam Belebczuk

Title: SSIS Grab Bag of Best Practices

Abstract:

Interested in SQL Server Integration Services, but aren't sure where to start? Do you already use SSIS, but aren't sure if you're getting the most out of it? Are you looking for ways to increase the performance of your SSIS packages? Then join Adam Belebczuk and Brian Davis as they pull best practices and performance tuning tips and tricks from their SSIS Grab Bag.

SessionID: 14232

Much Ado About Hadoop

Back to calendar

Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

SessionID: 22128

Getting Started with Analysis Services Tabular mode

Back to calendar

Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3

Speaker: Phillip Labry

Title: Getting Started with Analysis Services Tabular mode

Abstract:

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data.

SessionID: 35976

Execution Plans 101

Back to calendar

Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3

Speaker: Eugene Meidinger

Title: Execution Plans 101

Abstract:

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, 5 common troublemakers, and where to learn more. If an execution plan looks like hieroglyphics, this course is for you!

SessionID: 36678

Backup and Restore Tips and Tricks

Back to calendar

Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 1

Speaker: Ryan Adams

Title: Backup and Restore Tips and Tricks

Abstract:

Do you need to devise a backup and restore plan to meet the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) of your business? I'll show you how to pick the right backup type, method, and recovery model to meet your business needs. You'll learn how the network and drive format can have an effect on your backups and avoid the pitfalls that slow down your backup and restore plan. You'll also learn how to keep your transaction log from growing uncontrollably while speeding up your backups and restores using the native tools without any added cost!

SessionID: 37305

Goodbye Next Next Next, Hello Automated Installs

Back to calendar

Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3

Speaker: Brian Davis

Title: Goodbye Next Next Next, Hello Automated Installs

Abstract:

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). Automating your installs doesn't just save you time, it improves standardization and adherence to best practices. There are multiple ways to automate your installs, but FineBuild goes above and beyond by allowing you to automate every part of the install from file locations to clusters, service accounts to custom databases, Reporting Services, Integration Services, Master Data Services, configurations and settings as well as many common 3rd party tools and more. We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.

SessionID: 14638

Partition Switching - Moving a Lot of Data Very Quickly

Back to calendar

Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 3

Speaker: Gill Rowley

Title: Partition Switching - Moving a Lot of Data Very Quickly

Abstract:

You have a million rows you need to move into a table. Because of constraints, this import process is very slow. In this session I will show you how you can speed up this process greatly by partitioning the table and moving partitions from one table to another.

SessionID: 36322

Scripting out SQL Server for Documentation and Disaster Recovery

Back to calendar

Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 1

Speaker: George Walkey

Title: Scripting out SQL Server for Documentation and Disaster Recovery

Abstract:

Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects.

Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers

SessionID: 36579

Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Back to calendar

Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 1

Speaker: Chris Bell

Title: Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Abstract:

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data?

We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! We will then secure our database connections with a simple self-signed SSL certificate. Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. *Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.

SessionID: 36905

Introduction to Azure Machine Learning

Back to calendar

Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 3

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 37313

Join Us! Getting Started as a Technical Speaker

Back to calendar

Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 3

Speaker: Eddie Wuerch

Title: Join Us! Getting Started as a Technical Speaker

Abstract:

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session

SessionID: 21880

Clusters! From the ground up, don't double your storage, let's build one together.

Back to calendar

Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 3

Speaker: Paul Popovich Jr

Title: Clusters! From the ground up, don't double your storage, let's build one together.

Abstract:

You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!

SessionID: 27608

Introduction to APS

Back to calendar

Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 3

Speaker: Warren Sifre

Title: Introduction to APS

Abstract:

We will have a conversation of what is APS and specifically how it differs from the normal SQL Server instances we work with daily. By the end of this talk, you will have a very good understanding of the differences between the APS' MPP architecture compared to SMP SQL Server. We will cover the topic of Polybase and what Hadoop Components are supported by Polybase.

SessionID: 36534

My Brain Has Blue Screened - Let's Laugh

Back to calendar

Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 1

Speaker: David Klee

Title: My Brain Has Blue Screened - Let's Laugh

Abstract:

Is it the end of the day, your brain is mush, but you want to stay for the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.

SessionID: 36653

Playing in Traffic: Lessons from High-Speed, High-Volume Applications

Back to calendar

Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 1

Speaker: Jay Robinson

Title: Playing in Traffic: Lessons from High-Speed, High-Volume Applications

Abstract:

How do you as a developer take database activity into account when designing and writing your code? What works well on a small scale can often fall down as traffic picks up. In this session, attendees will learn methods for making their SQL scripts run faster, avoid blocking, and remain stable in a busy environment.

SessionID: 8992

XML Without Xanax: How to Handle XML in SQL Server

Back to calendar

Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 3

Speaker: Adam Belebczuk

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract:

Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.