Nr: 307
SQLSaturday #307 - Iowa City 2014
SessionID: 11140
Data Visualization with SQL Server 2012
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Chaitanya Khaladkar
Title: Data Visualization with SQL Server 2012
Abstract:
SessionID: 12508
How to Argue with Your Infrastructure Admins – and Win
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:
SessionID: 12509
SQL Server Virtualization 101
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
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
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!
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
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
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Jason Strate
Abstract:
SessionID: 16830
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: James Borland
Abstract:
SessionID: 16831
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: James Borland
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!
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
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
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’.
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
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
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
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
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
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
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Kevin Boles
Title: Indexing Deep Dive
Abstract:
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
SessionID: 26384
SQL Server 2014 New Features
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
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?
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.