sqlsathistory

Nr: 307

Back to Main list

SQLSaturday #307 - Iowa City 2014

Start Time (24h) Speaker Track Title
00:00:00 Chaitanya Khaladkar Track 4 Data Visualization with SQL Server 2012
00:00:00 David Klee Track 1 How to Argue with Your Infrastructure Admins – and Win
00:00:00 David Klee Track 4 SQL Server Virtualization 101
00:00:00 Dennis Graham Track 4 Reporting for SQL Health
00:00:00 Dave Tigges Track 5 That's Not in My Job Description: The Accidental Developer
00:00:00 Ed Leighton-Dick Track 1 SQL Server Features That Will Blow Your Mind!
00:00:00 Jim Dorame Track 4 PowerShell and SQLPSX the Dynamic Duo for the DBA
00:00:00 Jason Strate Track 1 Managing SQL Server Performance with Extended Events
00:00:00 James Borland Track 2 Add SSIS to the developer tool belt without adding to the DBA’s work load Part 1 (for the DBA)
00:00:00 James Borland Track 3 Add SSIS to the developer tool belt without adding to the DBA’s work load Part 2 (for the developer)
00:00:00 John Morehouse Track 3 10 Things Every DBA Should Know!
00:00:00 Kirby Richter Track 4 Implement a Dynamic Table Partitioning Solution
00:00:00 Keith Tate Track 3 The Curious Case of Isolation Levels
00:00:00 Larry Toothman Track 2 Yesterday I Couldn’t Even Spell ‘DBA’.
00:00:00 Mike Hays Track 2 Recovery that May or May Not have a Wizard
00:00:00 Mark Skiles Track 5 Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups
00:00:00 Paul Timmerman Track 5 Scary Things A Database Owner Can Do
00:00:00 Frank Gill Track 3 Designing a Restore Strategy
00:00:00 MIKE DONNELLY Track 5 Microsoft Azure SQL Database for the DBA
00:00:00 Kevin Boles Track 2 Indexing Deep Dive
00:00:00 Kevin Boles Track 1 SQL Server 2014 New Features
00:00:00 William E Pearson III Track 2 Getting Started with MDX
00:00:00 Andy Galbraith Track 5 Are You Maintaining Your SQL Servers?

SessionID: 11140

Data Visualization with SQL Server 2012

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Chaitanya Khaladkar

Title: Data Visualization with SQL Server 2012

Abstract:

This session will cover the end user experience of Data Visualization. We will look at how data helps businesses gain insights into processes and make informed decisions.

SessionID: 12508

How to Argue with Your Infrastructure Admins – and Win

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: David Klee

Title: How to Argue with Your Infrastructure Admins – and Win

Abstract:

Do you feel like you spend hours going round-and-round with your system, storage, and virtualization administrators over SQL Server best practices? Are their application-agnostic requirements hurting your SQL Server’s performance, or worse, their reliability? David Klee (@kleegeek) will discuss valuable insight into how to start and work through the common conversations with them on the SQL Server infrastructure practices that matter to you the most, and how to succeed in getting what you need while keeping everyone happy.

SessionID: 12509

SQL Server Virtualization 101

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 4

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

Reporting for SQL Health

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Dennis Graham

Title: Reporting for SQL Health

Abstract:

Many of us make our living writing reports for other people; it is time SQL server Professionals take advantage of reporting. You will walk away from this session with 40 or more reports designed to review an SQL Server system for its health and to predict potential problems.

SessionID: 13590

That's Not in My Job Description: The Accidental Developer

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Dave Tigges

Title: That's Not in My Job Description: The Accidental Developer

Abstract:

By now most everyone is familiar with the term "Accidental DBA". They are the people who for one reason or another, and usually by no choice of their own, wind up being their company's DBA by default. But what about the reverse of that situation? You could be happily installing, configuring and maintaining SQL Server, taking care of backups, restorations, setting up HA and DR and then all of a sudden your boss asks you to write some code. It could be a complex report using SSRS, it could be an SSIS package, a small data entry intranet web app or a dashboard. DON'T PANIC. In this session we will show you how use the skills that you have developed as a SQL Server DBA, along with other free tools that are available to you, and show you how to make coding easier than you thought!

SessionID: 13675

SQL Server Features That Will Blow Your Mind!

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 1

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

PowerShell and SQLPSX the Dynamic Duo for the DBA

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Jim Dorame

Title: PowerShell and SQLPSX the Dynamic Duo for the DBA

Abstract:

With PowerShell and SQLPSX your DBA life can be a lot simpler.SMO is powerful, but can be difficult to use. Enter SQLPSX.Chad Miller put together a set of PowerShell functions thatstreamline the use of SMO, easing management of a multi-server environment. Come learn when and how the addition of PowerShell and SQLPSX can benefit you.

SessionID: 15978

Managing SQL Server Performance with Extended Events

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Jason Strate

Title: Managing SQL Server Performance with Extended Events

Abstract:

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

SessionID: 16830

Add SSIS to the developer tool belt without adding to the DBA’s work load Part 1 (for the DBA)

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: James Borland

Title: Add SSIS to the developer tool belt without adding to the DBA’s work load Part 1 (for the DBA)

Abstract:

SSIS is a powerful tool for this but up until SQL 2012 it has been cumbersome in deployment and for security issues for both the developers and DBAs alike. How is SSIS 2012 different than past versions? This session will discuss the various SSIS deployment modes focusing on the new project deployment model. We will walk through several examples. Using a Hosted SSIS server and the project deployment model empowers the developer to view SSIS as self-service SQL feature and not chore to have to coordinate with the DBA.

SessionID: 16831

Add SSIS to the developer tool belt without adding to the DBA’s work load Part 2 (for the developer)

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: James Borland

Title: Add SSIS to the developer tool belt without adding to the DBA’s work load Part 2 (for the developer)

Abstract:

This is the second part looking at a hosted model for SSIS 2012 packages. As developer, how is SSIS 2012 different than past versions? This session will discuss the various SSIS deployment modes focusing on the project deployment model. We will walk through several examples. The examples also demonstrate the use of variables, parameters, and environments to make you SSIS more dynamic and reusable.

SessionID: 17252

10 Things Every DBA Should Know!

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: John Morehouse

Title: 10 Things Every DBA Should Know!

Abstract:

Are you just starting out in the DB world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things from both an administration side a well as developmental that he's seen in the wild that every DBA should know and understand. We'll look at things like Auo Shrink, SELECT *, Indexe Basics and 7 others!

SessionID: 18388

Implement a Dynamic Table Partitioning Solution

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Kirby Richter

Title: Implement a Dynamic Table Partitioning Solution

Abstract:

Have a large or potentially large database that you would like to partition? Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We set it up to keep a FIXED number of file groups. The partition maintenance will recycle the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest. Assumes you have a basic understanding of SQL Server table partitioning.

SessionID: 18855

The Curious Case of Isolation Levels

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Keith Tate

Title: The Curious Case of Isolation Levels

Abstract:

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

SessionID: 18964

Yesterday I Couldn’t Even Spell ‘DBA’.

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2

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

Recovery that May or May Not have a Wizard

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mike Hays

Title: Recovery that May or May Not have a Wizard

Abstract:

The wizards that come with SQL Server help us accomplish many things including recovering the database; however, we can not use the wizards for all our data recovery issues. In this session we'll review recovery topics of page corruption, temporary storage loss, master database recovery, and other data recovery scenarios. We'll also determine which of these scenarios can be resolved with a wizard.

SessionID: 21137

Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Mark Skiles

Title: Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups

Abstract:

AlwaysOn is SQL Server 2012/2014’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity. In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously.

SessionID: 22396

Scary Things A Database Owner Can Do

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Paul Timmerman

Title: Scary Things A Database Owner Can Do

Abstract:

So you've setup your new SQL Server instance and it’s time to start adding databases to it. You followed security best practices at the instance level, but what about security within each database? Is that something you can control? Well, if like me, you work in a shop that mostly purchases software, then having users with database owner permissions is a reality, and likely not one you can change. But members of the db_owner role can only make changes that would adversely impact their own databases, right? Think again. During this session we’ll review some common database level settings and actions which can have a negative impact across the entire instance. We’ll discuss ways to mitigate these risks and monitor for their occurrence. Come learn how to not let poor choices made by a database owner impact your entire instance.

SessionID: 24592

Designing a Restore Strategy

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Frank Gill

Title: Designing a Restore Strategy

Abstract:

Do you back up your databases? If the answer is yes (and I really hope it is), do you test your restores? If a table gets dropped at 1:53PM, can you restore the database to 1:52PM using log backups? Can you use the WITH STANDBY parm to apply log backups to a read-only copy of a database?For the answers to these questions and a whole lot more about database restores, plus some nifty scripts, join me for this presentation.

SessionID: 24962

Microsoft Azure SQL Database for the DBA

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: MIKE DONNELLY

Title: Microsoft Azure SQL Database for the DBA

Abstract:

As we enter the brave new world of the cloud, one of the Windows Azure components DBA's are being asked to use is Microsfot Azure SQL Database. In this introductory session I will show you how to create databases in the cloud, explain the structure behind MASD and it's advantages/disadvantages. I will also give you a list of all of the things SQL Server does that MASD doesn't do...yet.

SessionID: 26383

Indexing Deep Dive

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Boles

Title: Indexing Deep Dive

Abstract:

SessionID: 26384

SQL Server 2014 New Features

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: SQL Server 2014 New Features

Abstract:

There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. When I thought of doing this session I initially wanted to have some demos, but there are SOOO many things to cover I couldn't fit in any demos in a 1 hour session!

SessionID: 28120

Getting Started with MDX

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

SessionID: 9607

Are You Maintaining Your SQL Servers?

Back to calendar

Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Andy Galbraith

Title: Are You Maintaining Your SQL Servers?

Abstract:

Are you performing all of the regular maintenance you should on your servers?Do you not run CHECKDB because "it takes too long"? How about Index Maintenance - does that take too long?Do you really have the appropriate backups in place?Do you have benchmark numbers in place to compare when your server is "slow"?Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.