sqlsathistory

Nr: 387

Back to Main list

SQLSaturday #387 - Madison 2015

Start Time (24h) Speaker Track Title
09:00:00 Ben Miller Track 7 PoShDBA: Practical PowerShell for the DBA
09:00:00 Bob Pusateri Track 6 What's New in SQL Server 2014 OTHER THAN Hekaton?
09:00:00 David Maxwell Track 1 Turbo-Charged Transaction Logs
09:00:00 Lee Berg Track 3 Automate and Manage your Clouds and Datacenters using your SQL Toolbox
09:00:00 Mike Hillwig Track 8 Do More With Less: SQL Central Management Server and SQL Agent Multi-Server Administration
09:00:00 Phillip Labry Track 5 Getting Started with Analysis Services Tabular mode
09:00:00 Rick Bielawski Track 2 Mastering queries into XML data.
09:00:00 Adam Belebczuk Track 4 SSIS Grab Bag of Best Practices
10:30:00 Dan English Track 5 The "New" Power BI Self-Service Walkthrough
10:30:00 Patrick Brewer Track 3 Contained Database - Huh - What's a Contained Database?
10:30:00 Paul Timmerman Track 1 An Introduction To Resource Governor in SQL Server
10:30:00 Russ Thomas Track 7 SSMS Showdown
10:30:00 Ryan Adams Track 6 Is SQL Server AlwaysOn the Right High Availability and Disaster Recovery Plan for me?
10:30:00 MIKE DONNELLY Track 2 Twice in a Lifetime: T-SQL Refactoring 101
10:30:00 Terry Bunio Track 4 Dimensional Data Modeling Primer
10:30:00 Wendy Pastrick Track 8 Read Dirty to Me - Isolation Levels/User Impact
13:00:00 Bill Fellows Track 1 What is Biml and why are SSIS people talking about it?
13:00:00 David Klee Track 6 Right-Sizing Your SQL Server Virtual Machine
13:00:00 Jim Dorame Track 7 How to collect a baseline on all your servers and still get a good night's sleep.
13:00:00 Mark Vaillancourt Track 5 Keeping the "Business" in Business Intelligence
13:00:00 Scott Hietpas Track 2 Introduction to Azure Machine Learning
13:00:00 Frank Gill Track 3 How to Determine What Data Is Corrupt
13:00:00 Andy Yun Track 8 Every Byte Counts: Why Your Data Type Choices Matter
13:00:00 Zane Brunette Track 4 Build ETL in 30 minutes or less with SSIS
14:30:00 Ed Leighton-Dick Track 3 Protecting Your Data with Encryption
14:30:00 Meagan Longoria Track 2 Somebody got BIDS Helper in my Data Tools
14:30:00 Mark Vaillancourt Track 5 Power Query: Data Chemistry for the Masses
14:30:00 Michael DeFehr Track 1 Index-fu - getting the most out of your indexes
14:30:00 Michael Steineke Track 6 Deep Dive into Windows and AlwaysOn Capabilities for DR
14:30:00 Rob Long Track 8 Building an Enterprise Data Repository with BIML
14:30:00 Omni Resources Speaker Panel Track 7 Administering SQL Servers for Development Teams
14:30:00 Zach Mattson Track 4 Multi-Tenant Data Warehousing and ETL in Azure
16:00:00 Dave Bland Track 6 How to use Execution Plans to find Performance Issues
16:00:00 Gill Rowley Track 1 Partition Switching - Moving a Lot of Data Very Quickly
16:00:00 John Pertell Track 4 Getting Top Performance from SQL Reporting Service
16:00:00 Riley Major Track 8 Pseudo-Constants in SQL
16:00:00 Brian Davis Track 3 Goodbye Next Next Next, Hello Automated Installs
16:00:00 Ross LoForte Track 5 SQL Server 2014 and Power BI Features
16:00:00 Warren Sifre Track 7 DBA Monitoring and Maintenance Fundamentals
16:00:00 Ted Krueger Track 2 TURNING YOUR DATA INTO A CORPORATE ASSET – BECOME A ROCK STAR!

SessionID: 10304

PoShDBA: Practical PowerShell for the DBA

Back to calendar

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?

Back to calendar

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

Back to calendar

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

Automate and Manage your Clouds and Datacenters using your SQL Toolbox

Back to calendar

Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 3

Speaker: Lee Berg

Title: Automate and Manage your Clouds and Datacenters using your SQL Toolbox

Abstract:

This session will utilize SQL tools and techniques to manage Cloud and DataCenters Environments. Learn to use some of the latest SQL technologies to automate and manage your datacenter!

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

Back to calendar

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:

Two of the of the most under-utilized management features of SQL Server are the Central Management Server and the SQL Agent Multi-Server Administration tools. The CMS is a powerful little tool creates a catalog of servers that allows you to execute any query or script against multiple servers at the same time. The SQL Agent Multi-Server Administration (MSX) tool allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. When used in conjunction with each other, you have a powerful set of features that make managing your enterprise a lot simpler.

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

Back to calendar

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:

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data.

SessionID: 22681

Mastering queries into XML data.

Back to calendar

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

Back to calendar

Event Date: 11-04-2015 - Session time: 09:00:00 - Track: Track 4

Speaker: Adam Belebczuk

Title: SSIS Grab Bag of Best Practices

Abstract:

Interested in SQL Server Integration Services, but aren't sure where to start? Do you already use SSIS, but aren't sure if you're getting the most out of it? Are you looking for ways to increase the performance of your SSIS packages? Then join Brian Davis and Adam Belebczuk as they pull best practices and performance tuning tips and tricks from their SSIS Grab Bag.

SessionID: 13068

The "New" Power BI Self-Service Walkthrough

Back to calendar

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?

Back to calendar

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

Back to calendar

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

Back to calendar

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?

Back to calendar

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

Back to calendar

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:

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

Dimensional Data Modeling Primer

Back to calendar

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

Back to calendar

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?

Back to calendar

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

Back to calendar

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:

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

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.

Back to calendar

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:

Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions. With a few free quires and some SSIS magic you can capture a Baseline of your systems. With this you will be able to know exactly where to look and what might be amiss. Before you can say what is wrong with your system you need to know how it reacts under normal circumstances. This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.

SessionID: 19667

Keeping the "Business" in Business Intelligence

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer?

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Do you develop SSIS packages, SSRS reports or SSAS models (multidimensional or tabular)? Then this session is for you! We'll cover the capabilities this free tool provides as well as address some of the grating little quirks of BIDS/SSDT. Learn how to get a roles report or printer-friendly dimension usage from Analysis Services Multidimensional. Regain missing functionality in SSAS Tabular such as drillthrough actions, display folders, and HideMemberIf. Delete dataset cache files in SSRS to work around an annoying “feature”. Extend your SSIS capabilities: deploy packages from BIDS/SSDT, identify items with configuration/expressions, create packages based on templates, and find differences between packages. Learn about this perfect combination from Meagan Longoria and Bill Fellows and you'll never want to have your BIDS without the Helper again.

SessionID: 19669

Power Query: Data Chemistry for the Masses

Back to calendar

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:

ETL Developers have being doing chemistry with data for years in tools like SQL Server Integration Services. These tools require training, experience, and time that few business users have. But in the age of self-service BI, those business users need a way to shape data to support their analysis.

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

Back to calendar

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:

So you know the difference between a clustered and a nonclustered index. I won't review it again - I promise. This session will focus on expanding your understanding of indexes and what you can use them for. We will look at the internals of how they are structured, included columns, filtered indexes and indexed views. We will explore how to use indexes to enforce contraints beyond just simple uniqueness. Earn your SQL Black belt with this fun and informative session.

SessionID: 21152

Deep Dive into Windows and AlwaysOn Capabilities for DR

Back to calendar

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

Back to calendar

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:

Building out an Enterprise Data Warehouse can be extremely time consuming when developing the initial ETL building blocks. Using a Data Repository and BIML to centralize enterprise data can decrease Data Warehouse development time. It can be used as a central repository for ad-hoc reporting, and keep an audit trail of source system changes. This session will look at the benefits of centralizing data in its original format and how to automate the collection and auditing using BIML.

SessionID: 27042

Administering SQL Servers for Development Teams

Back to calendar

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

Back to calendar

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

How to use Execution Plans to find Performance Issues

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 6

Speaker: Dave Bland

Title: How to use Execution Plans to find Performance Issues

Abstract:

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.

SessionID: 14637

Partition Switching - Moving a Lot of Data Very Quickly

Back to calendar

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

Getting Top Performance from SQL Reporting Service

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 4

Speaker: John Pertell

Title: Getting Top Performance from SQL Reporting Service

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

Back to calendar

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

Back to calendar

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:

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.

SessionID: 26080

SQL Server 2014 and Power BI Features

Back to calendar

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:

Want to learn the newest features of the SQL Server product, ask questions directly to Microsoft, come to this session. This unique session is designed to help the DBA/DBA Manager/Business Analyst to better understand and be able to ask questions around the SQL Server 2014 mission critical, cloud and performance capabilities in the product, to gain the knowledge needed to leverage in their SQL Server solutions. Additionally, we will cover the new Power BI enhancements in preview that transform the way business insights are delivered by leveraging the capabilities build-in SQL Server 2014.

SessionID: 27579

DBA Monitoring and Maintenance Fundamentals

Back to calendar

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!

Back to calendar

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.