Nr: 387
SQLSaturday #387 - Madison 2015
SessionID: 10304
PoShDBA: Practical PowerShell for the DBA
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 7
Speaker: Ben Miller
Title: PoShDBA: Practical PowerShell for the DBA
Abstract:
This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour.
SessionID: 10608
What's New in SQL Server 2014 OTHER THAN Hekaton?
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 6
Speaker: Bob Pusateri
Title: What's New in SQL Server 2014 OTHER THAN Hekaton?
Abstract:
When asked about new features in the SQL Server 2014 Database Engine, people tend to only think of one thing: In-Memory OLTP, commonly known by its code-name "Hekaton." While In-Memory OLTP is a great improvement, many other features may prove more helpful for day-to-day database activity. This session will investigate the other new features offered in 2014, including delayed durability, buffer pool extension, enhancements to backups, partitioning, statistics, columnstore indexes, security, and much more!
SessionID: 13326
Turbo-Charged Transaction Logs
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 1
Speaker: David Maxwell
Title: Turbo-Charged Transaction Logs
Abstract:
The transaction log is one of the most critical, yet often mis-understood components
of SQL Server. From out of control log growth to very long startup times, problems with the
transaction log can cause a lot of pain. In this session, we'll look at how the transaction log
works and how to optimize it's performance. You'll learn how to determine the right settings
for maximum throughput, and what to do when things get out of control.
SessionID: 18983
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 3
Speaker: Lee Berg
Abstract:
Topics include:
-Scheduling SQL Service Integration Services with System Center Orchestrator and Service Management Automation (SMA)
-Install and Configure and manage SQL environments using PowerShell DSC
-Monitoring and Reporting of Datacenter Operational Performance using Power BI
-Lots of other cool stuff!
SessionID: 20575
Do More With Less: SQL Central Management Server and SQL Agent Multi-Server Administration
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 8
Speaker: Mike Hillwig
Title: Do More With Less: SQL Central Management Server and SQL Agent Multi-Server Administration
Abstract:
SQL Server MVP Mike Hillwig will show you how to to deploy these two powerful features right out of the box without writing a single line of new code.
SessionID: 22129
Getting Started with Analysis Services Tabular mode
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 5
Speaker: Phillip Labry
Title: Getting Started with Analysis Services Tabular mode
Abstract:
SessionID: 22681
Mastering queries into XML data.
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 2
Speaker: Rick Bielawski
Title: Mastering queries into XML data.
Abstract:
If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session. After this hour I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.
SessionID: 8994
SSIS Grab Bag of Best Practices
Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 4
Speaker: Adam Belebczuk
Title: SSIS Grab Bag of Best Practices
Abstract:
SessionID: 13068
The "New" Power BI Self-Service Walkthrough
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 5
Speaker: Dan English
Title: The "New" Power BI Self-Service Walkthrough
Abstract:
In this session, we will discuss the changes that are coming and the new features that are provided with the Power BI Designer as Microsoft continues its roadmap with self-service BI. If you haven't seen this yet, Power BI features are now available in a standalone application outside of Excel! You will see with the new designer that you will be able to easily integrate data, create stunning and interactive visualizations, and even create cloud based Power BI dashboards to share and it is even Free!!
SessionID: 21769
Contained Database - Huh - What's a Contained Database?
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 3
Speaker: Patrick Brewer
Title: Contained Database - Huh - What's a Contained Database?
Abstract:
Many people have never heard of a Contained Database let alone know why they would use a Contained Database. In this session, I will go into the WHAT is a Contained Database, the HOW a Contained Database works, and the WHY I would use a Contained Database. We will use, both successfully and unsuccessfully, a Contained Database through Management Studio, Integration Services, Reporting Services, and a Web Application (Visual Studio MVC).
SessionID: 22402
An Introduction To Resource Governor in SQL Server
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 1
Speaker: Paul Timmerman
Title: An Introduction To Resource Governor in SQL Server
Abstract:
Do you have multiple databases with distinct workloads running on a single SQL Server Enterprise Edition instance? Have you ever had a runaway process or bad query from one system bring an entire instance to its knees, impacting a wide range of end users? If you answered yes to either of these questions, then come learn about Resource Governor for SQL Server. We’ll spend the first part of this introductory session going over the concepts you will need to know in order to implement Resource Governor successfully. Once we've covered the basics, we’ll spend the rest of the session working through a number of demos, reviewing exciting enhancements to Resource Governor in SQL Server 2014, and discussing scenarios in which you can use Resource Governor in your environment right away. Hardware resources are a valuable commodity. Learn how you can control them effectively in a multitenant environment, ensuring they are assigned where they need to be.
SessionID: 23600
SSMS Showdown
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 7
Speaker: Russ Thomas
Title: SSMS Showdown
Abstract:
SQL Server Management Studio (SSMS) is full of time-saving, quality-improving gems that many users have yet to discover. Join Jes Borland and Russ Thomas in a no-holds-barred SSMS tips and tricks showdown. In the tradition of the classic wizard's duel, each will present, in turn, a secret SSMS feature from their personal bag of tricks. Attendees will decide whose bag of tricks reign supreme in a round-by-round standoff. The ultimate winner is sure to be the attendee, who will leave with the set of tricks guaranteed to improve efficiency and overall quality of work.
SessionID: 23769
Is SQL Server AlwaysOn the Right High Availability and Disaster Recovery Plan for me?
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 6
Speaker: Ryan Adams
Title: Is SQL Server AlwaysOn the Right High Availability and Disaster Recovery Plan for me?
Abstract:
Do you need a high availability and disaster recovery solution for your mission critical databases? SQL Server AlwaysOn can help, but with Windows Clustering, Failover Cluster Instances, and Availability Groups it gets confusing and complicated fast. I'll clear up all the confusion by explaining the various components and exposing all the gotchas. There are different levels of protection and you will learn how to choose the right one for your environment. You will walk away with the knowledge and confidence to pick the right solution to give your critical databases a solid high availability and disaster recovery plan.
SessionID: 24988
Twice in a Lifetime: T-SQL Refactoring 101
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 2
Speaker: MIKE DONNELLY
Title: Twice in a Lifetime: T-SQL Refactoring 101
Abstract:
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: 26057
Dimensional Data Modeling Primer
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 4
Speaker: Terry Bunio
Title: Dimensional Data Modeling Primer
Abstract:
Are you curious about Facts, Dimensions, and type 2 slowly changing dimensions that those Data Warehouse people talk about? This session will provide an introduction to the different architectures proposed by the two Data Warehouse proponents, Bill Inmon and Ralph Kimball. We will present the theory and key concepts of Dimensional modeling and review why Dimensional modeling is important and the functionality a Data Warehouse can deliver that a normalized database cannot. We will also present some more advanced topics like heriarchies, snowflakes, recursive relationships, and bridge tables.
SessionID: 27832
Read Dirty to Me - Isolation Levels/User Impact
Event Date: 11-04-2015 - Session time: 10:30:00 - Track: Track 8
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: 10462
What is Biml and why are SSIS people talking about it?
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 1
Speaker: Bill Fellows
Title: What is Biml and why are SSIS people talking about it?
Abstract:
This session is designed for you, the experienced SSIS developer who's been hearing about Biml but hasn't taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.
SessionID: 12595
Right-Sizing Your SQL Server Virtual Machine
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 6
Speaker: David Klee
Title: Right-Sizing Your SQL Server Virtual Machine
Abstract:
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
SessionID: 15559
How to collect a baseline on all your servers and still get a good night's sleep.
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 7
Speaker: Jim Dorame
Title: How to collect a baseline on all your servers and still get a good night's sleep.
Abstract:
SessionID: 19667
Keeping the "Business" in Business Intelligence
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 5
Speaker: Mark Vaillancourt
Title: Keeping the "Business" in Business Intelligence
Abstract:
It is no accident the term “Business Intelligence” starts with “Business.” Any Business Intelligence initiative should, likewise, start with the needs of the Business. For many years, BI was seen as a technology project. This is one reason why so many BI initiatives fail. Rather than a Technology Project, BI is a Business Program. It must grow and evolve as the Business grows an evolves.
In this session, we will discuss the following:
-- Why BI is a worthwhile investment (using case study examples)
-- What criteria to use in determining the success of a BI initiative
-- Several reasons why BI initiatives fail
-- Critical Success Factors for BI
So much of the success for BI happens before the requirements are even gathered. Come learn how you can set yourself up for success with Business Intelligence.
SessionID: 24417
Introduction to Azure Machine Learning
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 2
Speaker: Scott Hietpas
Title: Introduction to Azure Machine Learning
Abstract:
This introduction will provide a brief history of machine learning and its practical uses. We will then dive into Microsoft's Azure ML offering and demonstrate how you can build a real-world use case using Azure ML Studio with a free trial account. If you have been curious about machine learning, this session will show you what you need to get started.
SessionID: 24605
How to Determine What Data Is Corrupt
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 3
Speaker: Frank Gill
Title: How to Determine What Data Is Corrupt
Abstract:
There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will. Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt. And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
SessionID: 24892
Every Byte Counts: Why Your Data Type Choices Matter
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 8
Speaker: Andy Yun
Title: Every Byte Counts: Why Your Data Type Choices Matter
Abstract:
Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!
When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
SessionID: 28298
Build ETL in 30 minutes or less with SSIS
Event Date: 11-04-2015 - Session time: 13:00:00 - Track: Track 4
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, repeatable ETL structure that's designed to insert or update your destination from nearly any source.
SessionID: 13685
Protecting Your Data with Encryption
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 3
Speaker: Ed Leighton-Dick
Title: Protecting Your Data with Encryption
Abstract:
We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.
SessionID: 19216
Somebody got BIDS Helper in my Data Tools
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 2
Speaker: Meagan Longoria
Title: Somebody got BIDS Helper in my Data Tools
Abstract:
SessionID: 19669
Power Query: Data Chemistry for the Masses
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 5
Speaker: Mark Vaillancourt
Title: Power Query: Data Chemistry for the Masses
Abstract:
This session will show how Power Query can be easily used to take advantage of data's properties to drive the change we need to support our goals.
We will discuss/demonstrate:
-- The simple process of accessing a wide variety of data sources
-- The ease with which simple transformations can be achieved using the Power Query Ribbon
-- Power Query's fantastic ability to travel through time to see every step taken with the data
-- The foundations of the Power Query Formula Language, informally known as "M"
-- Using "M" to take Power Query WAY beyond what the Ribbon has to offer.
Come learn about what may well be the most exciting member of the Power BI family.
SessionID: 19983
Index-fu - getting the most out of your indexes
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 1
Speaker: Michael DeFehr
Title: Index-fu - getting the most out of your indexes
Abstract:
SessionID: 21152
Deep Dive into Windows and AlwaysOn Capabilities for DR
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 6
Speaker: Michael Steineke
Title: Deep Dive into Windows and AlwaysOn Capabilities for DR
Abstract:
AlwaysOn Failover Cluster Instances, Availability Groups and Windows Server Clustering...this is an overview of these features in SQL 2012 and 2014 for D/R, overlaying Windows OS features. We'll discuss what you need to use when and why. We'll discuss options on how you can achieve a D/R strategy with all the features you have in Windows and SQL Server to best meet your needs. Review key architectural considerations to making sure you have a successful recovery after a disaster.
SessionID: 23159
Building an Enterprise Data Repository with BIML
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 8
Speaker: Rob Long
Title: Building an Enterprise Data Repository with BIML
Abstract:
SessionID: 27042
Administering SQL Servers for Development Teams
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 7
Speaker: Omni Resources Speaker Panel
Title: Administering SQL Servers for Development Teams
Abstract:
Administering production SQL Servers can be a complex job. How does this task change when the environment you’re supporting will be used as part of a development or testing environment? And what can the DBA do to best support development teams? This session will discuss the unique challenges that are part of servicing these special systems and highlight ways that a DBA can help development teams produce better code.
SessionID: 28295
Multi-Tenant Data Warehousing and ETL in Azure
Event Date: 11-04-2015 - Session time: 14:30:00 - Track: Track 4
Speaker: Zach Mattson
Title: Multi-Tenant Data Warehousing and ETL in Azure
Abstract:
The traditional monolithic data warehouse and supporting ETL can be difficult to design, tedious to develop and expensive if running in Microsoft Azure. What happens when your source systems can replicate as new customers come online, and they demand their data be available in a warehouse for reporting with minimal intervention? In this session, we will walk through a real world project using SQL Server and SSIS running in Microsoft Azure. Attendees can expect to learn some different techniques for use in their own ETL and warehousing projects as well as some of the pitfalls of building a data warehouse stored in SQL Azure.
SessionID: 12329
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 6
Speaker: Dave Bland
Abstract:
SessionID: 14637
Partition Switching - Moving a Lot of Data Very Quickly
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 1
Speaker: Gill Rowley
Title: Partition Switching - Moving a Lot of Data Very Quickly
Abstract:
You have a million rows you need to move into a table. Because of constraints, this import process is very slow. In this session I will show you how you can speed up this process greatly by partitioning the table and moving partitions from one table to another.
SessionID: 17547
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 4
Speaker: John Pertell
Abstract:
You’re a DBA at your company, and you’re in charge of keeping the production SQL servers humming. You know how to maintain and troubleshoot those instances for top performance. But now your boss has given you a new task: find out why the company reports are running so slowly and why the server itself seems unresponsive at times.
In this session we’ll talk about how to get the best performance from your SQL reporting server. We will discuss how to administer a SQL Server Reporting Service (SSRS) instance; how to install and configure the service for best performance, how to see what reports are currently running, and find which reports are bogging down the server.
This session will not cover report design scaling out, or SSRS for SharePoint.
SessionID: 21735
Pseudo-Constants in SQL
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 8
Speaker: Riley Major
Title: Pseudo-Constants in SQL
Abstract:
You know you’ve done it. Maybe it was the lucky number 7. Maybe it was an enigmatic X. Maybe you smooshed some words together in ALLCAPS. That should be easier to spot, right? Because some day you might need to change it—in every stored procedure, function, and view.
Magic numbers, codes, identifiers, constants, enumerations. Whatever you call them, all applications have them. Sure it’s quick and easy to sprinkle the values throughout your code, but that breeds mistakes, rigidity, and obfuscation. There has to be a better way!
Other languages give us real constants and enums—with IntelliSense and compilation-level enforcement. Well guess what-- SQL Server does too, sort of. Join us and learn to write clearer, easier to maintain code without sacrificing performance.
SessionID: 22680
Goodbye Next Next Next, Hello Automated Installs
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 3
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 26080
SQL Server 2014 and Power BI Features
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 5
Speaker: Ross LoForte
Title: SQL Server 2014 and Power BI Features
Abstract:
SessionID: 27579
DBA Monitoring and Maintenance Fundamentals
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 7
Speaker: Warren Sifre
Title: DBA Monitoring and Maintenance Fundamentals
Abstract:
The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
SessionID: 35907
TURNING YOUR DATA INTO A CORPORATE ASSET – BECOME A ROCK STAR!
Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 2
Speaker: Ted Krueger
Title: TURNING YOUR DATA INTO A CORPORATE ASSET – BECOME A ROCK STAR!
Abstract:
Here is your chance to STAND OUT, MAKE A DIFFERENCE, and BE A ROCK STAR! Avastone, in conjunction with Qlik, will show you how to leverage tools specifically targeted at data quality, data visualization, and turning your data into the corporate asset that will propel you, the company you work for, and your individual skill set forward. This presentation will focus on data as a corporate asset, ways to ensure that data maintains a high level of quality, and being able to visualize the data in a way that a company is able to make educated decisions. The two systems we will focus on during this presentation are SQL Server Data Quality Services and QlikSense. Managing data has taken on a heightened level of importance as companies strive to be more customer-centric in a bid to compete on a global level. The tools we will cover will make you a better steward of your data and push your company out in front of your competition.