Nr: 470
SQLSaturday #470 - Washington DC 2015
SessionID: 39525
Automated SQL Server installation and configuration using PowerShell
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Jamie Wick
Title: Automated SQL Server installation and configuration using PowerShell
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
SessionID: 39625
Advanced SSIS Techniques
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Other
Speaker: David Dye
Title: Advanced SSIS Techniques
Abstract:
As an ETL developer using SQL Server Integration Services have you ever wondered how to:
- Import all .csv files from a folder
- Replace dynamic SQL using variables in SSIS
- How to configure the data flow buffer
- Create custom logging solutions
- Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
- Import/export multiple sources/destinations
- Use an execute SQL task with variables to replace dynamic SQL within a package
- Dynamically handle errors within any part of a package
SessionID: 40756
First Look at SQL Server 2016
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Heiges
Title: First Look at SQL Server 2016
Abstract:
Microsoft has been busy working on the next version of SQL Server - SQL Server 2016. We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB. Row Level Security allows you to add another layer of security to your environment. StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.
SessionID: 40851
I'm It - Survival Techniques for the Lone DBA
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Professional Development
Speaker: Monica Rathbun
Title: I'm It - Survival Techniques for the Lone DBA
Abstract:
Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
SessionID: 41253
Avoiding the Pitfalls of Database Change Automation
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Cindy Bean
Title: Avoiding the Pitfalls of Database Change Automation
Abstract:
Automation and Continuous Delivery are at the forefront of software development processes today. However, databases are being neglected because database code is different, harder to automate, and DBAs just don't seem to trust database automation. This is not surprising when you consider the number of incidents and instances of downtime that were caused by out-of-process updates, code overrides, and other database glitches. In this session, we will explain the options to automate database changes along with the benefits and issues with each option.
SessionID: 41269
Distributed Replay: Testing With Your Data, Your Way!
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Application Database Development
Speaker: Melody Zacharias
Title: Distributed Replay: Testing With Your Data, Your Way!
Abstract:
SessionID: 41321
Watch Brent Tune Queries
Event Date: 05-12-2015 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Brent Ozar
Title: Watch Brent Tune Queries
Abstract:
You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.
SessionID: 39571
SQL Server Storage Engine under the hood
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Thomas Grohser
Title: SQL Server Storage Engine under the hood
Abstract:
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements.
Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.
#160;
Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
SessionID: 39879
Service Broker: Introduction to wheeling and dealing
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Application Database Development
Speaker: William Wolf
Title: Service Broker: Introduction to wheeling and dealing
Abstract:
This session is an introduction to Service Broker basics. Service Broker is your way to process your data asynchronously in a single instance setting as well as use as a near real time ETL. Wheel and deal your data processing.
SessionID: 40354
Branding Yourself for a Dream Job
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Other
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 40570
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Ayman El-Ghazali
Abstract:
SessionID: 41133
Wheaton's Law for Technology Pros: Level up your customer service
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Professional Development
Speaker: Andy Mallon
Title: Wheaton's Law for Technology Pros: Level up your customer service
Abstract:
DBAs (and IT folk in general) have a terrible reputation for being stubborn, jerky curmudgeons. These guys exist, and working with them is a miserable experience--but they're a minority. Unfortunately, they are a memorable minority and they give the rest of us a bad name.
It can be hard to enforce the rules, do what's best for your environment, and offer outstanding customer support. It can be tough--rules mean telling people no. Rules mean making decisions that might make some people unhappy. In this session, we'll talk about some of these challenges and how to deal with them, all while obeying Wheaton's Law.
SessionID: 41157
T-SQL 101: Getting started with T-SQL
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Ravi Kumar
Title: T-SQL 101: Getting started with T-SQL
Abstract:
If you want to follow along in the class, please have SQL Server and AdventureWorks2012 database installed on your computer.
SessionID: 41501
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
Dimensional modeling is arguably one of the most important
fundamentals of business intelligence. It is still relevant even as
new technologies like PowerPivot and SSAS Tabular Models are becoming
more popular. Correctly modeling your organization's data not only
protects the most important asset your company has but ensures that
your data mart or data warehouse will be responsive and capable of
accommodating emerging requirements.
This session provides a deeper dive into
the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 40442
Disaster Recovery 101
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: Strategy and Architecture
Speaker: Tracy Boggiano
Title: Disaster Recovery 101
Abstract:
So you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn. Then we will talk about how to choose the best one to meet your business needs.
SessionID: 41217
Table Vars and Temp Tables – What you NEED to Know!
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: Application Database Development
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables – What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 41259
If You Build It, They Will Come--Creating Your Own Opportunities!
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: Professional Development
Speaker: Carlos L Chacon
Title: If You Build It, They Will Come--Creating Your Own Opportunities!
Abstract:
Often times we might feel like we are simply spinning our wheels and can't seem to move ahead. Perhaps we see others getting opportunities and can't quite place why more doesn't come our way. This session will discuss how we can put ourselves in the drivers seat when it comes to making opportunities so we can make some decisions about what we want to do rather than choosing from what is left.
SessionID: 41282
Building dynamic SSIS packages for more flexibility
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
Speaker: Matt Nelson
Title: Building dynamic SSIS packages for more flexibility
Abstract:
After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today's date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.
SessionID: 41323
How to Think Like the Engine
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Brent Ozar
Title: How to Think Like the Engine
Abstract:
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.
SessionID: 41865
TSQL Coding Techniques - Are You Playing with Fire?
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: Application Database Development
Speaker: Mindy Curnutt
Title: TSQL Coding Techniques - Are You Playing with Fire?
Abstract:
The good news? T-SQL is one of the easiest coding languages to learn.
The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master.
In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL and Parameter Sniffing.
Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!
SessionID: 42788
Understanding the Impact of Flash on SQL Server
Event Date: 05-12-2015 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael Wells
Title: Understanding the Impact of Flash on SQL Server
Abstract:
The concept of storing data on flash chips has been around since the late 80’s, but has traditionally been cost prohibitive in most cases. As the technology continues to improve we are seeing much higher capacities with significantly lower pricing, so the power of flash is no longer limited to just those companies with multi-million dollar technology budgets. This session will take a vendor-agnostic look at the different patterns for leveraging flash and what those mean for a SQL Server Database Administrator.
SessionID: 39534
Using BIML as an SSIS Design Patterns Engine
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Andy Leonard
Title: Using BIML as an SSIS Design Patterns Engine
Abstract:
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
SessionID: 40355
Get Testing with tSQLt
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: Application Database Development
Speaker: Steve Jones
Title: Get Testing with tSQLt
Abstract:
tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.
SessionID: 40519
Get Familiar with Spatial Data
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: Application Database Development
Speaker: Slava Murygin
Title: Get Familiar with Spatial Data
Abstract:
You've never worked with spatial data and would like to know how to do it.
We'll go through very basic SQL Server Spatial data functionality and draw some Spatial pictures using Management Studio.
SessionID: 40590
TFS for SQL/BI Developers
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: Application Database Development
Speaker: Dave Fackler
Title: TFS for SQL/BI Developers
Abstract:
If you do any kind of SQL Server or BI development, you eventually have to grapple with the problem of keeping multiple copies of your work. You either need to maintain stored procedure and DDL scripts or you have copies of SSIS and SSRS reports to keep up with. In most cases, this problem starts off small as you need to have development versus production copies of your code. But eventually, it becomes harder and harder to maintain your "source code" as your environment becomes more complex and as you potentially have to start working with a team of other developers. During this session, we'll talk about Team Foundation Server (TFS) and show you the different ways it can be used to keep up with all the different types of source code you might be responsible for -- from full database designs to complete BI solutions.
SessionID: 40604
SSIS: Design principles for robust ETL processes
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Rafael Salas
Title: SSIS: Design principles for robust ETL processes
Abstract:
Is the design of your ETL processes robust? Does your ETL process keep you awake at night?
Data integration is still the most common point of failure of data centric projects and choosing a mature ETL tool, such as SSIS, is not enough. In many cases this is due to improper planning and the use of questionable design principles. During this session we will look at ETL processes from a holistic point of view to identify key areas that are often neglected and that have the potential to affect the system reliability and increase its maintenance cost. We will use SSIS to evaluate key ETL architecture areas - such as re-start ability, monitoring, error handling, among others- and discuss design principles you can use to improve the architecture of your ETL processes going forward. You will find the session valuable regardless of you level of expertise in ETL.
SessionID: 41201
Making the Leap from Developer to DBA
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: Professional Development
Speaker: Amy Herold
Title: Making the Leap from Developer to DBA
Abstract:
You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
SessionID: 41359
Policy Based Management - Beyond the Basics
Event Date: 05-12-2015 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Patrick Keisler
Title: Policy Based Management - Beyond the Basics
Abstract:
Policy Based Management is a great feature of SQL Server and easy to implement; however, for most organizations you need a way to customize it to your enterprise. Join me for this session as we take a deeper dive into PBM to see how you can customize polices, evaluate those polices across your entire enterprise environment, track those changes over time, and deliver reports to management showing your progress.
SessionID: 40085
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
Speaker: Danette Riviello
Abstract:
SessionID: 41218
Window Functions in SQL Server
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: Application Database Development
Speaker: Wayne Sheffield
Title: Window Functions in SQL Server
Abstract:
SessionID: 41230
What Can Data Quality Services Do for You?
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: Other
Speaker: Mark Hudson
Title: What Can Data Quality Services Do for You?
Abstract:
In 2002, U.S. businesses lost an estimated $600 BILLION a year because of data quality problems. In 2012, Microsoft offered Data Quality Services (DQS) to reduce some of that loss. DQS enables analysts to recognize data quality defects and manage business rules to correct those data defects. Once defined, those business rules are available for use throughout the enterprise in SSIS packages so the data loaded is as clean as the business-defined rules. Standardizing and de-duplicating data are no match for DQS. Join me as I profile and standardize data before your very eyes.
SessionID: 41233
T-SQL for Application Developers - Attendees chose
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: Application Database Development
Speaker: Kevin Goff
Title: T-SQL for Application Developers - Attendees chose
Abstract:
That's right, attendees choose! I'll show 30 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 30 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
SessionID: 41250
A New Approach to Unit and Integration Testing in SSIS
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: BI Platform Architecture, Development Administration
Speaker: Reeves Smith
Title: A New Approach to Unit and Integration Testing in SSIS
Abstract:
In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This development pattern uses metadata authored by analysts to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.
SessionID: 42453
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: Other
Speaker: Chris Bell
Abstract:
SessionID: 42898
Only You Can Prevent Database Fires!
Event Date: 05-12-2015 - Session time: 15:05:00 - Track: DBA 1
Speaker: John Morehouse
Title: Only You Can Prevent Database Fires!
Abstract:
Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!