sqlsathistory

Nr: 318

Back to Main list

SQLSaturday #318 - Orlando 2014

Start Time (24h) Speaker Track Title
00:00:00 Allen White Cloud/Security Get Near Realtime ETL with Service Broker
00:00:00 Allen White Cloud/Security Manage Both On-Prem and Azure Databases with PowerShell
00:00:00 Allen White DBA Bonus Track Maintain SQL Server Performance Baseline with Powe
00:00:00 Bradley Ball SSIS/Virtualization Track Indexing Internals for Developers
00:00:00 Brett Tomson SSIS/Virtualization Track ETL in a Nutshell with SSIS
00:00:00 Carl Berglund DBA Admin 2 Track Get Your Nights Weekends Back from SQL Server Planned Downtime
00:00:00 Jack Corbett BI/Big Data/Misc Tired of the CRUD? Automate it!
00:00:00 David Klee DBA Admin 2 Track Easy SQL Server Benchmarking
00:00:00 Diana Betancourt DBA Admin 2 Track A DiBA guide to Database Standards
00:00:00 Dmitri Korotkevitch DBA Admin 2 Track How To Kill SQL Server in 60 Minutes
00:00:00 Louis Davidson T-SQL/SQL 2014 Track How In-Memory Database Objects Affect Database Design
00:00:00 Ed Watson DBA Performance Track Performance Tuning for Mere Mortals Part I
00:00:00 Jorge Novo SSIS/Virtualization Track Dynamic File Loading Using SSIS Programming
00:00:00 Eric Wisdahl T-SQL/SQL 2014 Track SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures
00:00:00 Gene Webb BI Track Learn How To Build A Golden Record for Any Subject Over Lunch!
00:00:00 Gene Webb BI Track Building an MDM Center of Excellence with MDS and Maestro
00:00:00 Geoff Hiten Cloud/Security Cloudy with a Chance of Data
00:00:00 Greg Larsen T-SQL/SQL 2014 Track T-SQL Best Practices
00:00:00 Guillermo Caicedo Santiago Cloud/Security SQL Server 2014 Hybrid Cloud Features
00:00:00 Janis Griffin DBA Performance Track Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
00:00:00 Jason Carter Prof Dev/Security Encryption 101: A look at SQL Encryption Options
00:00:00 Jason Horner DBA Performance Track Tricks from the DBA Inbox: Real World Performance Tuning
00:00:00 Jason Thomas BI Track DataViz You Thought You Couldn't Do with SSRS
00:00:00 Jeffrey Garbus Prof Dev/Security How to be a GREAT DBA
00:00:00 Jonathon Moorman DBA Admin Track Database Projects
00:00:00 Jason Hall DBA Admin Track TempDB Parasites!
00:00:00 James McAuliffe BI Track Report With Power: New Data Tools, New Insights
00:00:00 Richie Rump DBA Performance Track Database Design Disasters: Common Mistakes Found in the Wild
00:00:00 Jose L. Rivera T-SQL/SQL 2014 Track Mastering T-SQL Window Functions
00:00:00 Josh Luedeman BI/Big Data/Misc Show me whatcha workin' with: Big Data Edition
00:00:00 John Pertell DBA Admin Track An Introduction to FileTables
00:00:00 Karla Landrum T-SQL/SQL 2014 Track Flash 101- An Introduction to Flash Storage for MS SQL Server and Data Centers
00:00:00 Kendal Van Dyke DBA Bonus Track Discover, Document, Diagnose Your Servers on Your Lunch Break
00:00:00 Devin Knight BI Track Getting Started with Power Query
00:00:00 Leigh Freijo Prof Dev/Security Why I won't hire you and what you can do about it!
00:00:00 Mark Kromer BI/Big Data/Misc Big Data Analytics with SQL Server, Hadoop and MongoDB
00:00:00 Matthew Brimer Prof Dev/Security SQL Security Best Practices Shrinking Your Attack Surface
00:00:00 Maximo Trinidad Cloud/Security Powershell Working with Windows Azure SQL Database Server
00:00:00 Gareth Swanepoel DBA Admin Track A practical guide to Windows Azure SQL Database for the DBA
00:00:00 Michael Corey SSIS/Virtualization Track Virtualizing SQL Server: Doing IT Right - The SeQueL
00:00:00 miguel Cebollero DBA Admin 2 Track Database Development Comes out of the Dark Ages
00:00:00 Mike Lawell DBA Performance Track Performance Tuning for Mere Mortals Part II
00:00:00 Mikey Nelson DBA Admin Track Test Automation - Where to Start
00:00:00 Sebastian Meine Cloud/Security Permission Management: 12 Pitfalls Misconceptions
00:00:00 Prakash Heda DBA Admin 2 Track Re-Indexing - The quest of ultimate automation
00:00:00 Pam Shaw BI/Big Data/Misc Tips Tricks for dynamic SSRS Reports
00:00:00 Randy Knight DBA Admin Track Understanding the SQL Server Transaction Log
00:00:00 Brian Davis T-SQL/SQL 2014 Track Getting Started with Hekaton (In-Memory OLTP)
00:00:00 Robert Biddle SSIS/Virtualization Track Loading a Data Warehouse with SSIS
00:00:00 Rob Volk T-SQL/SQL 2014 Track Revenge: The SQL! - Director's Cut
00:00:00 Rodney Landrum Beginner First Day DBA - Installation to Fascination withou
00:00:00 Ronald Dameron Prof Dev/Security SQL Server Security Easy Button
00:00:00 Rowland Gosling BI/Big Data/Misc Hadoop + SQL Server: The Emerging Patterns in Big Data
00:00:00 Wes Springob BI Track Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
00:00:00 Todd Phillippe BI/Big Data/Misc Object Level Recovery Made Easy
00:00:00 Elijah Baker DBA Admin 2 Track How to Partition Anything!
00:00:00 Andy Warren Beginner From Student to IT Professional - Part 1
00:00:00 Andy Warren Beginner From Student to IT Professional - Part 3
00:00:00 Andy Warren Prof Dev/Security Turbocharge Your Career With a Learning Plan
00:00:00 Argenis Fernandez DBA Bonus Track Rolling Upgrades, The Easy Way!
00:00:00 Argenis Fernandez DBA Performance Track Making DBCC CHECKDB Go Faster
00:00:00 Arvin Meyer BI/Big Data/Misc Access As A Front-end to SQL-Server

SessionID: 10053

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security

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

Manage Both On-Prem and Azure Databases with PowerShell

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security

Speaker: Allen White

Title: Manage Both On-Prem and Azure Databases with PowerShell

Abstract:

In today's world you're more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014 it actually becomes easier. In this session we'll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.

SessionID: 10062

Maintain SQL Server Performance Baseline with Powe

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Bonus Track

Speaker: Allen White

Title: Maintain SQL Server Performance Baseline with Powe

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 10174

Indexing Internals for Developers

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track

Speaker: Bradley Ball

Title: Indexing Internals for Developers

Abstract:

What are the secrets to making your queries run faster? Why does SQL Server use an index for some queries and not for others? What makes a good index? How many indexes should I have? Have you ever asked these questions? When you want to understand an application you look at its core architecture. Underneath the covers SQL Server is just a C++ application. Together we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.

SessionID: 11095

ETL in a Nutshell with SSIS

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track

Speaker: Brett Tomson

Title: ETL in a Nutshell with SSIS

Abstract:

New to BI? Loading data warehouses got you down? Do Connection Managers, Control Flows, and Data Flows make your head swirl? Well, don't fret. In this session, we will peel back the onion that is SQL Server Integration Services and identify the elements necessary to develop efficient, high performance ETL packages that will shock and amaze your friends and coworkers. Expect to cover several real-world scenarios including implementing best practices around disparate data sources, package design and development, logging, troubleshooting, and deployment. This will be an interactive session based on your input; come with questions!

SessionID: 11167

Get Your Nights Weekends Back from SQL Server Planned Downtime

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: Carl Berglund

Title: Get Your Nights Weekends Back from SQL Server Planned Downtime

Abstract:

Major disaster events resulting in unplanned downtime get all the press—but planned downtime constitutes almost 80% of the outages in any IT environment. This downtime is typically for tech refresh, migration projects, and OS/SQL Server patching. And when do you have to schedule the large downtime windows required to accomplish these upkeep tasks? Nights and weekends. Like you don't have better things to do then! In this session, learn how you can get in-place upgrades for OS and/or SQL Server as fast as SQL Server can stop restart, no data migrations for tech refresh, low-impact break/fix, and planned downtime windows of less than 2 minutes.

SessionID: 11860

Tired of the CRUD? Automate it!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Jack Corbett

Title: Tired of the CRUD? Automate it!

Abstract:

T4 templating support was added in the March 2014 release of SSDT. This means we can now create a T4 template to automatically create CRUD procedures for all the tables in our database project. Sure ORM tools like EF and nHibernate can handle CRUD operations in code, but if you want to provide an API to your database and avoid the tedious work of hand creating simple CRUD procedures this is the session for you!

After this session you will:

  1. Understand the basics of T4 templating
  2. Have a basic understanding of the Dac object model
  3. Be able to create a script that will create 100's or even 1000's of CRUD procedures in seconds.

SessionID: 12614

Easy SQL Server Benchmarking

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: David Klee

Title: Easy SQL Server Benchmarking

Abstract:

Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and want to see how they compare against each other? Multiple free and easy ways to stress test your SQL Servers exist by simulating an OLTP workload against a real SQL Server and the infrastructure underneath. In this session we will demonstrate how to test your storage and SQL Server instances to get raw performance numbers that you can use to compare performance of machines across your enterprise. The utilities DVDStore, HammerDB, and SQLIO will be demonstrated in depth.

SessionID: 12877

A DiBA guide to Database Standards

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: Diana Betancourt

Title: A DiBA guide to Database Standards

Abstract:

If you work with SQL Server, either as a developer, Dev/DBA, or accidental DBA, we are all DiBA's! but in order to keep that status and not run into "fire drill" mode, you need to make sure you set the ground to keep on looking good. This session will focus on how to set your Database Server environment in a way that will switch you from reactive to proactive mode. And I will demo its implementation via Policy Based Management.

SessionID: 13297

How To Kill SQL Server in 60 Minutes

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: Dmitri Korotkevitch

Title: How To Kill SQL Server in 60 Minutes

Abstract:

It is easy to design a system that uses SQL Server as a database backend. However, designing a system that efficiently works under heavy load is a much more complicated task. You can encounter the same set of database design and code mistakes in almost every system implemented by a team of application developers.

This Power Point-free session is targeted to developer DBAs and developers. It shows the commonly encountered obvious and not-so-obvious database design and T-SQL code mistakes and demonstrates how to bring a perfectly healthy SQL Server to its knees in just 60 minutes.

SessionID: 13483

How In-Memory Database Objects Affect Database Design

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Louis Davidson

Title: How In-Memory Database Objects Affect Database Design

Abstract:

With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.

SessionID: 13711

Performance Tuning for Mere Mortals Part I

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track

Speaker: Ed Watson

Title: Performance Tuning for Mere Mortals Part I

Abstract:

In this first part of a two part series, we look at performance tuning from the very beginning. You're a new DBA, you want to be a DBA, or you've been declared an "Accidental DBA" and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? The application is running slowly. Can you help them? Do you even know where to begin to help them? In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow."

SessionID: 13987

Dynamic File Loading Using SSIS Programming

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track

Speaker: Jorge Novo

Title: Dynamic File Loading Using SSIS Programming

Abstract:

Every organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization.

SessionID: 14034

SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Eric Wisdahl

Title: SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures

Abstract:

With the release of SQL Server 2014 one of the most talked about new features is the In Memory OLTP (project "Hekaton") and natively compiled stored procedures which promise to deliver dramatic performance increases. But, is this new feature ready for prime time or another version one that should be avoided until the next release? In this session we will look at how you implement memory optimized tables and compiled procedures, do some quick demos and comparisons to see what the hype is about, and examine some of the considerations and requirements.

SessionID: 14417

Learn How To Build A Golden Record for Any Subject Over Lunch!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Gene Webb

Title: Learn How To Build A Golden Record for Any Subject Over Lunch!

Abstract:

Attend the lunch demo and see how you can use Master Data Services and Maestro to:• Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise

SessionID: 14419

Building an MDM Center of Excellence with MDS and Maestro

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Gene Webb

Title: Building an MDM Center of Excellence with MDS and Maestro

Abstract:

Learn how to build an MDM Center of Excellence with Best Practices using extensive demo. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.

SessionID: 14501

Cloudy with a Chance of Data

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security

Speaker: Geoff Hiten

Title: Cloudy with a Chance of Data

Abstract:

Cloud, Cloud, Cloud. Microsoft is "all in". CxOs love the idea of renting compute resources. You know this is where our profession is headed, but when and how fast. When should you jump on board? The good news is cloud will not eliminate or even reduce the need for IT and Data professionals. The bad news is our world and our profession is changing. Adapt or be left behind. Come see what Microsoft Azure has to offer Data Professionals.

SessionID: 14836

T-SQL Best Practices

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Greg Larsen

Title: T-SQL Best Practices

Abstract:

This presentation covers a number of different SQL Server T-SQL coding best practices. There will be a discussion around each best practice so attendees will better understand the rationale behind each. Some of the best practices will have a demo to showing how different coding styles arrive at the same answer while using different amounts of SQL Server resources (CPU, and I/O). These demos will help attendees better understand how poor coding practices produce sub-optimal execution plans.

SessionID: 14857

SQL Server 2014 Hybrid Cloud Features

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security

Speaker: Guillermo Caicedo Santiago

Title: SQL Server 2014 Hybrid Cloud Features

Abstract:

These days, it seems like everything is moving to the cloud. Are you ready to begin your transition and take advantage of what the cloud offers you? Join us for an overview of the SQL Server 2014 hybrid cloud features and learn how to start your transition to the cloud.

SessionID: 15728

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track

Speaker: Janis Griffin

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract:

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

SessionID: 15810

Encryption 101: A look at SQL Encryption Options

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security

Speaker: Jason Carter

Title: Encryption 101: A look at SQL Encryption Options

Abstract:

Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.

SessionID: 15852

Tricks from the DBA Inbox: Real World Performance Tuning

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track

Speaker: Jason Horner

Title: Tricks from the DBA Inbox: Real World Performance Tuning

Abstract:

n this heavily demo based session, we show some techniques for performance tuning common problems faced by DBA's Including: how to identify the problem, resolve the issue, and test the solution. Along the way we will also discuss some of theory behind the solutions. We all know there is no such thing as DBCC GO_FASTER but this session is the next best thing.

SessionID: 15912

DataViz You Thought You Couldn't Do with SSRS

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Jason Thomas

Title: DataViz You Thought You Couldn't Do with SSRS

Abstract:

SessionID: 16353

How to be a GREAT DBA

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security

Speaker: Jeffrey Garbus

Title: How to be a GREAT DBA

Abstract:

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

SessionID: 16389

Database Projects

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track

Speaker: Jonathon Moorman

Title: Database Projects

Abstract:

SessionID: 16779

TempDB Parasites!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track

Speaker: Jason Hall

Title: TempDB Parasites!

Abstract:

Unless you happen to be Chuck Norris, your SQL Server instances only have one tempDB. That makes tempDB a single point of contention for an instance. What’s worse is that there are a lot of things going on in tempDB that you may not be aware of. Let’s look at some things that can use tempDB while we’re not looking.

SessionID: 16995

Report With Power: New Data Tools, New Insights

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: James McAuliffe

Title: Report With Power: New Data Tools, New Insights

Abstract:

By now, we have heard a lot about the new Power* tools. PowerPivot, PowerView, PowerQuery and the tabular data model. But what does it all mean? How can you put these tools to work for you, where you live and work every day? This session provides examples of powerfully combining data from lots of different sources in creative ways that were simply not possible in the past. This session will walk you through real life scenarios, using these tools to fill in missing and move from “if only” to “what if”, and valuable insight...

SessionID: 17462

Database Design Disasters: Common Mistakes Found in the Wild

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track

Speaker: Richie Rump

Title: Database Design Disasters: Common Mistakes Found in the Wild

Abstract:

Not every system has a database architect available to design it. But what happens when a database is created and the proper care wasn't taken into designing it? This session will take a real-world look into my experiences with some database design choices. We'll take a deep look into these design choices including a detailed discussion on why they didn't work and what could have been done better. We may even take a peek into SQL Server internals. This session is primarily for data professionals that are new to database design.

SessionID: 17473

Mastering T-SQL Window Functions

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Jose L. Rivera

Title: Mastering T-SQL Window Functions

Abstract:

TSQL window functions, originally introduced in SQL Server 2005, have proven to be quite useful to solve complex ranking and aggregation scenarios. The new additions in SQL Server 2012 make them irresistible. In this session, we will discuss how to use them and highlight the new order, offset and distributions functionalities in real-world examples.

SessionID: 17531

Show me whatcha workin' with: Big Data Edition

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Josh Luedeman

Title: Show me whatcha workin' with: Big Data Edition

Abstract:

Congratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

SessionID: 17549

An Introduction to FileTables

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track

Speaker: John Pertell

Title: An Introduction to FileTables

Abstract:

With the release of SQL Server 2012 Microsoft introduced FileTables, a better way to store large objects inside a database. With FileTables you get the advantage of the security and transactional consistency of a database AND improved file streaming from the OS. In this session I'll show you how easy it is to set up and use FileTables, as well as improved methods of searching document keywords with FullText and Semantic searches.

SessionID: 17963

Flash 101- An Introduction to Flash Storage for MS SQL Server and Data Centers

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Karla Landrum

Title: Flash 101- An Introduction to Flash Storage for MS SQL Server and Data Centers

Abstract:

More CPU/more Memory/More Spindles’ has been the mantra for increasing performance for SQL Server environments that are resource bound. This often leads to complicated file placements, complicated lun/disk striping, complex partitioning schemes and creative resource handling. Storage has been the last area of hardware technology that has improved performance for enterprise systems, but now the next generation of storage is here… Flash, and its available and practical for database systems.

SessionID: 18088

Discover, Document, Diagnose Your Servers on Your Lunch Break

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Bonus Track

Speaker: Kendal Van Dyke

Title: Discover, Document, Diagnose Your Servers on Your Lunch Break

Abstract:

Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?

You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're out at lunch. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.

Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office

SessionID: 18657

Getting Started with Power Query

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Devin Knight

Title: Getting Started with Power Query

Abstract:

Power Query is a free add-in for Excel 2010 and up that provide users an easy way to discover, combine and refine data all within the familiar Excel interface. With Power Query you can now combine and transform data from a variety of unusual data sources all within Excel, which would have previously required a complex ETL job. Join Devin and learn how you can use Power Query to take your Self-Service BI solutions to the next level.

SessionID: 19009

Why I won't hire you and what you can do about it!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security

Speaker: Leigh Freijo

Title: Why I won't hire you and what you can do about it!

Abstract:

As a hiring manager, I see the same mistakes over and over again. In this session we'll talk about common mistakes in resumes, interviews, social media and how you can avoid them. We'll also discuss lost opportunities and how not to miss them. This information applies to both internal and external candidates.

SessionID: 19673

Big Data Analytics with SQL Server, Hadoop and MongoDB

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Mark Kromer

Title: Big Data Analytics with SQL Server, Hadoop and MongoDB

Abstract:

If you would like to see how real businesses build real-world Big Data Analytics solutions, then come to this session. I will dive right into a number of reference architectures and demos of Big Data Analytics using SQL Server, Hadoop and MongoDB.

SessionID: 19870

SQL Security Best Practices Shrinking Your Attack Surface

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security

Speaker: Matthew Brimer

Title: SQL Security Best Practices Shrinking Your Attack Surface

Abstract:

Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA's tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data.

In addition, attending this talk is worth 1.5 Continuing Education credits.

SessionID: 19919

Powershell Working with Windows Azure SQL Database Server

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security

Speaker: Maximo Trinidad

Title: Powershell Working with Windows Azure SQL Database Server

Abstract:

In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)

SessionID: 20035

A practical guide to Windows Azure SQL Database for the DBA

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track

Speaker: Gareth Swanepoel

Title: A practical guide to Windows Azure SQL Database for the DBA

Abstract:

What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ?

If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.

SessionID: 20241

Virtualizing SQL Server: Doing IT Right - The SeQueL

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track

Speaker: Michael Corey

Title: Virtualizing SQL Server: Doing IT Right - The SeQueL

Abstract:

SessionID: 20424

Database Development Comes out of the Dark Ages

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: miguel Cebollero

Title: Database Development Comes out of the Dark Ages

Abstract:

Database development has traditionally been done using SQL Server Management Studio query window as the primary tool, when far more powerful tools are available in your toolset. This is the equivalent of writing a document using Notepad, when MS Word is available on your desktop. This session will take you through some of the basics of using SSDT, show you how to use VS2012 database projects effectively, how to utilize TFS build, test and deploy your code. I've had my share of bumps on the road to deploying these toolsets. At the end of this session you will have a good introduction into how to use the tools and how to avoid some common issues with legacy code you are already have in your environments.

SessionID: 20610

Performance Tuning for Mere Mortals Part II

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track

Speaker: Mike Lawell

Title: Performance Tuning for Mere Mortals Part II

Abstract:

This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events.

This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.

There will be homework!

SessionID: 20635

Test Automation - Where to Start

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track

Speaker: Mikey Nelson

Title: Test Automation - Where to Start

Abstract:

This session is designed to help DBAs, Developers, Testers, and Operations folks gain an understanding of why and more importantly HOW to approach Test Automation. Learn all the tools (mostly free) that are available to get you started. Learn from a guy that has been successfully been automating test for years saving companies valuable time and serious money. Learn what you can start doing immediately with Windows PowerShell.

SessionID: 21727

Permission Management: 12 Pitfalls Misconceptions

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Cloud/Security

Speaker: Sebastian Meine

Title: Permission Management: 12 Pitfalls Misconceptions

Abstract:

SQL Server comes with a powerful built-in permission management system. However, as most powerful tools, this one too can be difficult to use and get right.

This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience selects topics that we will cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: If you are not aware of them, you might GRANT or DENY more permissions than you intended.

SessionID: 22284

Re-Indexing - The quest of ultimate automation

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: Prakash Heda

Title: Re-Indexing - The quest of ultimate automation

Abstract:

How many times you have been called on weekends to handle a nightmare caused by Re-Indexing job? One of the most common aspect of performance tuning is a well-design dynamic index optimization process. If you ever wonder what it takes to design an efficient re-indexing process, which do selective re-indexing, handles blocking efficiently, avoid system downtime due to log disk full, automatically stop itself beyond a threshold, can be implemented across all sql servers regardless of application type or data size, in other words, fewer headaches. This session is for you!!

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

SessionID: 22368

Tips Tricks for dynamic SSRS Reports

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Pam Shaw

Title: Tips Tricks for dynamic SSRS Reports

Abstract:

In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

SessionID: 22580

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin Track

Speaker: Randy Knight

Title: Understanding the SQL Server Transaction Log

Abstract:

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

SessionID: 22677

Getting Started with Hekaton (In-Memory OLTP)

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Brian Davis

Title: Getting Started with Hekaton (In-Memory OLTP)

Abstract:

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.

SessionID: 23151

Loading a Data Warehouse with SSIS

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: SSIS/Virtualization Track

Speaker: Robert Biddle

Title: Loading a Data Warehouse with SSIS

Abstract:

You've just been assigned a data warehouse project. Maybe you've figured out what tables you want to work with, but outside of that you don't really know how to get started. In this session we'll cover some of the basics of data warehousing, and then we'll show how to use SSIS as an ETL tool to load a Kimball data warehouse.

SessionID: 23345

Revenge: The SQL! - Director's Cut

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: T-SQL/SQL 2014 Track

Speaker: Rob Volk

Title: Revenge: The SQL! - Director's Cut

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 23395

First Day DBA - Installation to Fascination withou

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Beginner

Speaker: Rodney Landrum

Title: First Day DBA - Installation to Fascination withou

Abstract:

In this session we will step through the very basics of SQL Server for the new DBA. Since we can not delve into the SQL Server without a SQL Server, we will install one from scratch. Next we will add a database, write a couple of simple queries and export and import some data. All of this will be in preparation for our final look at running a report using data that we just loaded. At the end you will be familiar with many of the tools and techniques that DBAs use every day.

SessionID: 23443

SQL Server Security Easy Button

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security

Speaker: Ronald Dameron

Title: SQL Server Security Easy Button

Abstract:

Attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.

DBAs will leave this session with an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data. In addition, I’ll talk about our DBA’s real world experience with reduced permissions

SessionID: 23480

Hadoop + SQL Server: The Emerging Patterns in Big Data

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Rowland Gosling

Title: Hadoop + SQL Server: The Emerging Patterns in Big Data

Abstract:

Ever wonder how to take Big Data technology such as Hadoop and use it to extend SQL Server? Archives, Data Lakes, ETL solutions. I'll show you how to create solutions with little or no MapReduce code! These will center around Linux-based Cloudera Enterprise, Impala, Hive, Pig, and Sqoop coupled with SQL Server 2014.

SessionID: 24808

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Wes Springob

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract:

As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

SessionID: 26964

Object Level Recovery Made Easy

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Todd Phillippe

Title: Object Level Recovery Made Easy

Abstract:

Have you ever found yourself in a situation where data mysteriously disappears from your database? Or a stored procedure or function was altered without your knowledge.How do I recover and get back to the original state?Recovering data and/or database code can be a frustrating and time-consuming effort without the proper tools.In this session, I will show how to recover data and/or database code using native SQL Server tools.Do I have space to restore a copy of the database, do SLAs allow me to do this now or after hours, etc.Then I will show how LiteSpeed for SQL Server's Object Level Recovery (OLR) functionality can simplify the process and get back to the original database state in a fraction of the time.The result is you are the hero and everyone is happy.

SessionID: 27156

How to Partition Anything!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Admin 2 Track

Speaker: Elijah Baker

Title: How to Partition Anything!

Abstract:

Are you struggling with lots of data and really large tables? Have you heard of SQL Server Partitioning? Have you tried to figure out how you could add it to your database only to get lost in choosing the all-important Partition Key? Have you been told you can’t do that or had problems trying to figure out how you could use Partitioning on an OLTP database because the search criteria doesn't fit the Partition Key mold of a date Partition Key in the data warehouse examples that you may have seen. In this session I will describe a way that you can use partitioning on just about any table in any type of database. This system of Partitioning can not only bring query times down but it can also speed up the insert times on very large tables. Please come and let me provide you some useful information that you can immediately implement on your very large problem tables in your database and see immediate results.

SessionID: 9590

From Student to IT Professional - Part 1

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Beginner

Speaker: Andy Warren

Title: From Student to IT Professional - Part 1

Abstract:

SessionID: 9592

From Student to IT Professional - Part 3

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Beginner

Speaker: Andy Warren

Title: From Student to IT Professional - Part 3

Abstract:

In the final hour of our half day seminar for students we'll discuss the SQL Server Community including key web sites, events, and the idea of SQLFamily, followed by tips on how to build your professional network, and wrapping up with a presentation on how to use IT staffing companies effectively.

SessionID: 9593

Turbocharge Your Career With a Learning Plan

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: Prof Dev/Security

Speaker: Andy Warren

Title: Turbocharge Your Career With a Learning Plan

Abstract:

What will you learn next quarter and why? How will you learn it? How much time and money will it cost? What is the ROI on learning those skills? Those are the questions that you answer by building a learning plan and, if you do it well, you’ll find yourself steadily pulling away from your peers.

It starts with a learning list, a place to capture skills you think you need to learn. That’s where you score each topic by estimating the effort to learn it in time and money and the value it adds to your career now and later. It’s absolutely an analog process, but it gives you the framework for answering one question: what do I learn next and why?

Once you’ve picked a topic, how do you learn more about it? Do you read blogs, buy books, or attend a class? Or all of the above? How much time makes sense? Join this session and learn how to dig into the topic to answer the questions that lead to a learning plan. After that, it’s just a matter of executing the plan!

SessionID: 9790

Rolling Upgrades, The Easy Way!

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Bonus Track

Speaker: Argenis Fernandez

Title: Rolling Upgrades, The Easy Way!

Abstract:

In this session we will discuss how to perform upgrades while maintaining high availability of your SQL server infrastructure by leveraging rolling upgrades. We will review how to use database mirroring or AlwaysOn Availability Groups for this, along with a simpler version using Log Shipping. This is a demo-intensive session that you won't want to miss.

SessionID: 9791

Making DBCC CHECKDB Go Faster

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: DBA Performance Track

Speaker: Argenis Fernandez

Title: Making DBCC CHECKDB Go Faster

Abstract:

Along with backups, consistency checks are the two most important tasks that DBAs need to perform regularly. Our databases are getting bigger every day, and CHECKDB run times, along with its performance impact to Production systems, keep increasing. In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like DOP, tempdb configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey's consistency checks were taken from 7 days down to 6 hours.

SessionID: 9882

Access As A Front-end to SQL-Server

Back to calendar

Event Date: 27-09-2014 - Session time: 00:00:00 - Track: BI/Big Data/Misc

Speaker: Arvin Meyer

Title: Access As A Front-end to SQL-Server

Abstract:

Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.