sqlsathistory

Nr: 300

Back to Main list

SQLSaturday #300 - Kansas City 2014

Start Time (24h) Speaker Track Title
00:00:00 Bill Fellows SSIS Project Deployment Model: Deployment and maintenance
00:00:00 Bill Graziano Concurrency and Asynchronous Processing in SQL Server
00:00:00 Chris Shaw Outages; Dispatchers, Cops and Detectives
00:00:00 David Klee SQL Server Virtualization 101
00:00:00 WIlliam Barnes Fill Factor: Performance or Nuisance?
00:00:00 David Maxwell DBA 911 - Database Corruption
00:00:00 Ed Leighton-Dick SQL Server Features That Will Blow Your Mind!
00:00:00 Glenn Berry Analyzing I/O Subsystem Performance
00:00:00 Nathan Heaivilin Introduction to Execution Plans
00:00:00 Janis Griffin Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
00:00:00 Jason Horner Advanced Spatial Analysis: Beyond Bubble Charts
00:00:00 Jennifer McCown Introduction to Powershell cmdlets for DBAs
00:00:00 Jason Hall TempDB Parasites!
00:00:00 Jason Kassay Visual Studio Database Projects and Database Deployment
00:00:00 John Morehouse Social Networking Is Alive!!!
00:00:00 Kathi Kellenberger Writing Better T-SQL Queries with Window Functions
00:00:00 Lance Kolie Tabular vs Multidimensional. Lets build it together!
00:00:00 Larry Toothman Yesterday I Couldn’t Even Spell ‘DBA’.
00:00:00 Leslie Weed Data Modeling 101
00:00:00 Matt Wigdahl The Fundamentals of Great SQL Query Performance
00:00:00 Matthew Brimer SQL Security Best Practices Shrinking Your Attack Surface
00:00:00 Michael Bourgon Master of All I Survey - track code changes and more across your environment
00:00:00 Randy Knight Understanding the SQL Server Transaction Log
00:00:00 Chase Aucoin Scaling the relational model
00:00:00 Reeves Smith Increase your SSIS productivity with Biml
00:00:00 Jeff Renz Data Vault Data Warehouse Architecture
00:00:00 Robert Smith Table Partitioning 101
00:00:00 Russ Thomas XPath - XQuery; I guess if I HAVE to
00:00:00 Sean McCown REGEX for DBAs
00:00:00 Steve Jones Continuous Integration for Databases
00:00:00 MIKE DONNELLY Twice in a Lifetime: T-SQL Refactoring 101
00:00:00 Bob Ward The Top Customer Problems: How to avoid calling Bob
00:00:00 Bob Ward Troubleshooting the Memory of SQL Server
00:00:00 JK Wood NULL: A Love Story
00:00:00 Tristan Wilson Can you check on the database?
00:00:00 Steve Wake Capture Change and Apply it With Change Data Capture SSIS
00:00:00 Christopher Wolff Fun with Availability Groups
00:00:00 Tim Radney Know Backups and Know Recovery
00:00:00 Tracy McKibben 10 Ways To Abuse T-SQL
00:00:00 Wendy Pastrick Read Dirty to Me - Isolation Levels/User Impact
00:00:00 Zane Brunette Build ETL in 30 minutes or less with SSIS
00:00:00 Amy Herold Making the Leap from Developer to DBA
00:00:00 Thomas Norman Policy Based Management, Trolls and Watchmakers
00:00:00 Allen Smith BI Basics - Finding Return on Data

SessionID: 10453

SSIS Project Deployment Model: Deployment and maintenance

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Bill Fellows

Title: SSIS Project Deployment Model: Deployment and maintenance

Abstract:

In this session, you'll learn everything you need to know to successfully deliver a modern SSIS solution. We'll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution troubleshooting.

SessionID: 10467

Concurrency and Asynchronous Processing in SQL Server

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Bill Graziano

Title: Concurrency and Asynchronous Processing in SQL Server

Abstract:

The fastest way to process large amounts of data in SQL Server is using set-based operations. That is if you can stand the blocking. This session walks through different ways to think about applications when transaction blocking becomes your biggest problem. It covers specific T-SQL suggestions to minimize the rows locked, application architectures to maximize concurrency and reporting solutions to reduce impact on the production database. And always lots of demos and spirited discussion.

SessionID: 11484

Outages; Dispatchers, Cops and Detectives

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Chris Shaw

Title: Outages; Dispatchers, Cops and Detectives

Abstract:

Recently I watched the news as a crisis situation was played out. There were police officers were running around, moving behind large solid objects like cars, putting on their protective gear.  At first it looked like mass chaos but after watching it closely the officers moved like a well-oiled machine.

  The more I watched the more I realized that as database professionals we have crisis situations as well. As the situations are compared there are a number of things that we can learn by watching how other professionals handle crisis.  This session is dedicated to looking at how others handle crisis so that we can learn from what they do.

SessionID: 12512

SQL Server Virtualization 101

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: David Klee

Title: SQL Server Virtualization 101

Abstract:

What is virtualization? What impact does it have on DBAs and their systems? What aspects of their job stays the same, and what changes? What is really going on inside that black box? The fundamentals of private cloud computing and how it impacts data professionals will be discussed in this interactive session. Tips on how to use the best of virtualization to improve their daily tasks and efficiencies will be demonstrated, and common questions and concerns will be addressed.

SessionID: 12864

Fill Factor: Performance or Nuisance?

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: WIlliam Barnes

Title: Fill Factor: Performance or Nuisance?

Abstract:

We expand on a little known but widely modified feature of SQL Server. Fill Factor is something to address in performance tuning after all the low hanging fruit has been addressed. This is not a deep dive into the underlying mechanics of how SQL Server works, but a softer more useful approach to this subject. We will be looking into why changing this could be either good or bad for your environments. This presentation is useful for DBA’s as well as developers trying to get a little more out of their servers.

SessionID: 13303

DBA 911 - Database Corruption

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: David Maxwell

Title: DBA 911 - Database Corruption

Abstract:

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.

SessionID: 13673

SQL Server Features That Will Blow Your Mind!

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Ed Leighton-Dick

Title: SQL Server Features That Will Blow Your Mind!

Abstract:

How many lines of code does it take to generate a running total? How would you find a value in the next row of data - without using a cursor or loop? How can you efficiently store rows of data with a lot of optional fields, and how can you quickly find which of those rows have values? And how can you eliminate locking without resorting to dirty reads? SQL Server has answers for all of these questions, and none requires more than a few lines of code. Give me an hour, and I will blow your mind!

SessionID: 14691

Analyzing I/O Subsystem Performance

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Glenn Berry

Title: Analyzing I/O Subsystem Performance

Abstract:

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

SessionID: 14952

Introduction to Execution Plans

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Nathan Heaivilin

Title: Introduction to Execution Plans

Abstract:

Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.

SessionID: 15721

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

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - 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: 15816

Advanced Spatial Analysis: Beyond Bubble Charts

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

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

Introduction to Powershell cmdlets for DBAs

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Jennifer McCown

Title: Introduction to Powershell cmdlets for DBAs

Abstract:

You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!

SessionID: 16770

TempDB Parasites!

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - 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: 16873

Visual Studio Database Projects and Database Deployment

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Jason Kassay

Title: Visual Studio Database Projects and Database Deployment

Abstract:

How does your shop keep track of changes to your database schema? What are the database deployment procedures? Do you just make changes directly in production? In this beginner level session you will learn how to easily manage your database schema by leveraging SSDT in Visual Studio with Database Projects, create deployment scripts, and generate re-runnable deployment packages called DACPAC's. We will review how source control interacts with database projects as well as discuss how you can use PowerShell to automate your database deployments.

SessionID: 17250

Social Networking Is Alive!!!

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: John Morehouse

Title: Social Networking Is Alive!!!

Abstract:

Social Networking/Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don't have any fear as this session is for you! Social networking can be a very confusing place and when you don't know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking/Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We'll be covering Facebook, LinkedIn and Twitter.

SessionID: 18439

Writing Better T-SQL Queries with Window Functions

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Kathi Kellenberger

Title: Writing Better T-SQL Queries with Window Functions

Abstract:

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

SessionID: 18945

Tabular vs Multidimensional. Lets build it together!

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Lance Kolie

Title: Tabular vs Multidimensional. Lets build it together!

Abstract:

This session will be one big demo where we will build both a Tabular and Multidimensional model side by side to contrast and compare the uses of both methods. By the end of this session you should have a good understanding of both modeling methods and how to make use of them in the future.

SessionID: 18963

Yesterday I Couldn’t Even Spell ‘DBA’.

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Larry Toothman

Title: Yesterday I Couldn’t Even Spell ‘DBA’.

Abstract:

Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator. Once the initial shock passes they realize that they need help. This is a great place to start finding resources! The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help.

SessionID: 19142

Data Modeling 101

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Leslie Weed

Title: Data Modeling 101

Abstract:

Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West. We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task. We will go over some different modeling techniques around Normalized, Dimensional and Data Vault options. And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast. Yee-Haw!

SessionID: 19853

The Fundamentals of Great SQL Query Performance

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Matt Wigdahl

Title: The Fundamentals of Great SQL Query Performance

Abstract:

Whether you're a SQL developer or a DBA, a sound understanding of the factors that make a query perform either well or poorly is vital. In this session, you'll learn (through many examples) how to find performance pitfalls in your code and the best ways to mitigate those issues.

SessionID: 19867

SQL Security Best Practices Shrinking Your Attack Surface

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

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

Master of All I Survey - track code changes and more across your environment

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Michael Bourgon

Title: Master of All I Survey - track code changes and more across your environment

Abstract:

Almost everyone's seen it happen - problems due changes made on servers, be it SPs, index rebuilds, or even configuration changes. But what if you could look historically across servers and track down what changes were made when, by who, and from where? It exists, it's already built into SQL Server standard edition from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment. We'll start at the basics and end by checking new production code changes into TFS.

SessionID: 22546

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - 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: 22752

Scaling the relational model

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Chase Aucoin

Title: Scaling the relational model

Abstract:

More data being captured than ever and more business decisions are needing to be made real-time with high volumes of transactions. A well designed relational model is imperative to most business/products success. But, how do we scale it? This talk will cover methodologies for tackling this challenge and will cover techniques using SQL Azure, SQL 2014, and some other cutting edge technologies.

SessionID: 22759

Increase your SSIS productivity with Biml

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Reeves Smith

Title: Increase your SSIS productivity with Biml

Abstract:

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

SessionID: 22923

Data Vault Data Warehouse Architecture

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Jeff Renz

Title: Data Vault Data Warehouse Architecture

Abstract:

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2014. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2014 help make your data warehouse solution provide maximum value to your users.

SessionID: 23358

Table Partitioning 101

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Robert Smith

Title: Table Partitioning 101

Abstract:

Do you have large tables you can’t delete old data from or perform maintenance on? Then this may be for you! Table Partitioning 101 will make an introduction to table partitioning through the GUI and a code based approach. The session will be a discussion about how to make it work and will include: creating partitioned tables, partition schemes, left vs. right facing partition functions and how to do a basic switch operation. A small deep dive about how to find out which partition your data is in and what exactly does it mean for an index to be “aligned” will also be discussed.

SessionID: 23587

XPath - XQuery; I guess if I HAVE to

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

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. XML appears in extended events, ring buffer queries, the plan cache, 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: 24248

REGEX for DBAs

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Sean McCown

Title: REGEX for DBAs

Abstract:

As DBAs there are many tasks we’re asked to do every day that we just accept as taking a long time because of some manual component we can’t get around. Many of these tasks can be brought into line with regex. You can use it to format your own T-SQL and create code that writes code with relative ease. I’m going to teach you the basics of regex and show you how to perform many tasks that’ll make your life much easier like deploying code, formatting T-SQL, and much more.

SessionID: 24517

Continuous Integration for Databases

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Steve Jones

Title: Continuous Integration for Databases

Abstract:

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

SessionID: 24961

Twice in a Lifetime: T-SQL Refactoring 101

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: MIKE DONNELLY

Title: Twice in a Lifetime: T-SQL Refactoring 101

Abstract:

Whether it's because you inherited the code from the "last guy," or your stored procedures haven't been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn't just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn't know about five years ago.

This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can't be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.

SessionID: 25162

The Top Customer Problems: How to avoid calling Bob

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Bob Ward

Title: The Top Customer Problems: How to avoid calling Bob

Abstract:

Come learn about the top problems customers call Microsoft for the SQL Server Database Engine. We will cover a range of topics including performance, errors, memory, and others. Learn more about the details of what customers bring to Microsoft support and learn the specific steps Microsoft uses to help customers resolve these problems. This session will include demonstrations of the tools built into the SQL Server product that you can use every day while deploying, managing, or troubleshooting your SQL Server environment As a bonus, we will talk about new troubleshooting tools coming for SQL Server 2014.

SessionID: 25163

Troubleshooting the Memory of SQL Server

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Bob Ward

Title: Troubleshooting the Memory of SQL Server

Abstract:

SessionID: 25166

NULL: A Love Story

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: JK Wood

Title: NULL: A Love Story

Abstract:

NULL - an unknown value. At least, that's what it's SUPPOSED to be. The problem is, NULL is often treated differently based on what you're doing - even equality is suspect. Join JK as he works on demystifying NULLs in the database, looking at how they interact with various queries and how to work around and with the idiosyncrasies of this sometimes misunderstood concept.

SessionID: 25174

Can you check on the database?

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Tristan Wilson

Title: Can you check on the database?

Abstract:

How many times have you heard the phrase, "Can you check on the database?". There's a problem, and they want YOU to validate it's not a problem with Sql Server. How do you quickly validate the health of Sql Server? Is there a problem you're not seeing? At what point is Sql Server not the problem? This session covers a step by step guide to validate that Sql Server is healthy and running its best. This also provides a framework to keep Sql Server healthy over time and prevent future problems. If you're not sure how to "check on the database", this session is for you!

SessionID: 25693

Capture Change and Apply it With Change Data Capture SSIS

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

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

Fun with Availability Groups

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Christopher Wolff

Title: Fun with Availability Groups

Abstract:

Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.

SessionID: 26662

Know Backups and Know Recovery

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Tim Radney

Title: Know Backups and Know Recovery

Abstract:

It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.

SessionID: 27053

10 Ways To Abuse T-SQL

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Tracy McKibben

Title: 10 Ways To Abuse T-SQL

Abstract:

Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover.

SessionID: 27821

Read Dirty to Me - Isolation Levels/User Impact

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Wendy Pastrick

Title: Read Dirty to Me - Isolation Levels/User Impact

Abstract:

Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.

SessionID: 28297

Build ETL in 30 minutes or less with SSIS

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Zane Brunette

Title: Build ETL in 30 minutes or less with SSIS

Abstract:

Learn how to use integration services to create a fast reliable ETL structure that's designed to insert or update your destination from nearly any source.

SessionID: 9403

Making the Leap from Developer to DBA

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 9843

Policy Based Management, Trolls and Watchmakers

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Thomas Norman

Title: Policy Based Management, Trolls and Watchmakers

Abstract:

Peanut Butter and Jelly holds two slices of bread together what can hold my Sql Servers together, PBM? Do you like to be constant, have a pattern and be reliable? I have way too much to do, I can’t review every line of code. Help me, please! PBM is your friend, your ally and the gateway to your system. Policy Based Management can be your bridge to your Sql Server. Let PBM be your troll, letting the best pass. But wait, PBM can also be your watchmaker. Policy Based Management, Trolls and Watchmakers, come watch PBM control our systems.

SessionID: 9934

BI Basics - Finding Return on Data

Back to calendar

Event Date: 13-09-2014 - Session time: 00:00:00 - Track:

Speaker: Allen Smith

Title: BI Basics - Finding Return on Data

Abstract:

This session will you chart the waters through the sea of Business Intelligence (BI) options. IT departments need tools to turn data into useful information for users. Instead of ROI, this session talks about Return on Data' for IT Managers.

In this session we look at the roles of data warehousing, big data and business intelligence systems. The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint. This session is non-technical.

This site is open source. Improve this page.