Nr: 349
SQLSaturday #349 - Salt Lake City 2014
SessionID: 10283
TSQL Best Practices for SQL Engine Kindness
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3180
Speaker: Ben Miller
Title: TSQL Best Practices for SQL Engine Kindness
Abstract:
This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
SessionID: 10285
PoShDBA: Practical PowerShell for the DBA
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 5180
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: 10869
SQL 2012 Extended Events
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3160
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 10870
Reporting Services for Mere DBAs
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3160
Speaker: Jason Brimhall
Title: Reporting Services for Mere DBAs
Abstract:
As a DBA in the modern era, you may be required from time to time to do something outside of your comfort zone. One of these things may be to become quickly acquainted with SSRS. Even better is that you may be required to do things you have not considered in a standard report. In this session, you will learn how to implement a framework to help provide a common ground for your reports. This session will delve into fun topics such as dynamic grouping and dynamic sorting. We are not talking about the interactive sorting that your accountant may use. Attendees will also be introduced to a few quick methods of exporting Reports from the report server - this is from a DBA perspective after-all!
SessionID: 15732
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 170
Speaker: Janis Griffin
Abstract:
SessionID: 16853
Columnstore Indexes in SQL Server 2014: Flipping the DW /faster Bit
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 160
Speaker: Jimmy May
Title: Columnstore Indexes in SQL Server 2014: Flipping the DW /faster Bit
Abstract:
Columnstore indexes were introduced in SQL Server 2012 have been wholly re-architected optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads are a hybrid technology leveraging the best of off-disk in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, big wins at customer sites inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit why columnstore manifests my motto, “Change the world or go home!”
SessionID: 16854
To The Cloud, Infinity, Beyond: Top 10 Lessons Learned at MSIT
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 160
Speaker: Jimmy May
Title: To The Cloud, Infinity, Beyond: Top 10 Lessons Learned at MSIT
Abstract:
Session Summary:
Microsoft IT's Cloud strategy involves migrating hundreds of applications to Azure. The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important— painful—ones.
Session Abstract:
As part of the team leading the migration effort from Microsoft IT's on-prem servers to The Cloud, I've collected a number of best practices that can save your organization weeks or months of effort untold dollars in development implementation costs. Those who think the only tool required to move SQL instances from the datacenter to IaaS VMs is a forklift have a hard lesson to learn. In fact, it's much, much more challenging than that. This session will introduce the Top 10 Lessons Learned in the MSIT migration effort provide actionable guidance that customers can begin using immediately.
SessionID: 17303
Master Data Management - Getting Started with SQL Server MDS
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 1170
Speaker: John McAllister
Title: Master Data Management - Getting Started with SQL Server MDS
Abstract:
This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS
SessionID: 20599
The Augean Stables: Data Cleansing in the Modern Enterprise
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3160
Speaker: Michael Sexton
Title: The Augean Stables: Data Cleansing in the Modern Enterprise
Abstract:
Unfortunately we’ve only seen this ideal in textbooks and sample databases designed by vendors.
The databases we see in the real world are… less than ideal shall we say. Of course, we use other phrases for what we see but human resources frowns on such terms and this is, after all, a family friendly presentation.
Database professionals in Greece circa 600 BCE may have access to the Alpheus and Peneus rivers to cleanse their particular stables but we modern folks need to rely on the tools on our own computers such as SQL and SSIS. Mike will review various techniques and tools for data cleansing that will help you wash away the muck to get to the data gold standard.
SessionID: 21165
Simple things you can do to make the Query Optimizer more efficient!
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 170
Speaker: Mike Tutor
Title: Simple things you can do to make the Query Optimizer more efficient!
Abstract:
SessionID: 22576
Understanding Transaction Isolation Levels
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 1170
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 22579
Understanding SQL Server XML Features
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3170
Speaker: Randy Knight
Title: Understanding SQL Server XML Features
Abstract:
The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.
SessionID: 22781
Increase your SSIS productivity with Biml
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 160
Speaker: Reeves Smith
Title: Increase your SSIS productivity with Biml
Abstract:
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
SessionID: 23598
Make SQL Server Management Studio Bark Like a Dog
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3160
Speaker: Russ Thomas
Title: Make SQL Server Management Studio Bark Like a Dog
Abstract:
SessionID: 24060
Understanding Your Processes Through Operation Intelligence
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 5180
Speaker: Scott Heffron
Title: Understanding Your Processes Through Operation Intelligence
Abstract:
SessionID: 24879
Integrate SQL Server with hadoop
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 5180
Speaker: Pat Wright
Title: Integrate SQL Server with hadoop
Abstract:
SessionID: 26564
Fun with Availability Groups
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 170
Speaker: Christopher Wolff
Title: Fun with Availability Groups
Abstract:
Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
SessionID: 26912
Database Release Management: Tips to help organize it
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3170
Speaker: TJay Belt
Title: Database Release Management: Tips to help organize it
Abstract:
SessionID: 27756
Table Vars Temp Tables - What you NEED to Know!
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 1170
Speaker: Wayne Sheffield
Title: Table Vars 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 represent 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: 27757
Windowing Functions in SQL Server 2012
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 1170
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 28230
SQL Query Tuning
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 160
Speaker: Willis Godwin
Title: SQL Query Tuning
Abstract:
Explore proven methods to rapidly identify and fix inefficient SQL. This course will include but is not limited to the following:
- Sight recognition of inefficient or troublesome SQL.
- Understanding how to use STATISTICS IO and TIME.
- Basic understanding of an execution plan to evaluate indexes and sheer amount of data at each stage.
SessionID: 34909
Handling database evolution with Liquibase
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 110
Speaker: David Gonzalez
Title: Handling database evolution with Liquibase
Abstract:
We always keep versions of our code in a source control system, but how about the database? How can we reduce the pain of updating the database model when working on a team, or even knowing when do we need to update it? What can we do if we want to rollback to a previous version of the database? Liquibase is a pretty awesome library that will help you update, maintain and control your database model, as any other asset in your project.
SessionID: 34910
Unstructured Data Deep Learning
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 3170
Speaker: David Gonzalez
Title: Unstructured Data Deep Learning
Abstract:
SessionID: 8945
The Lost Science of Set Theory
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 1180
Speaker: Aaron Cutshall
Title: The Lost Science of Set Theory
Abstract:
Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.
SessionID: 9351
Database Decoder Ring
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 180
Speaker: Andrea Allred
Title: Database Decoder Ring
Abstract:
I recently took over a new database that I needed to query and report from but I didn't know what was there and how it all connected. Join me on my journey of tips and tricks to decode your next new database. There will be some T-SQL, some Interface work and a little bit of Sherlocking while avoiding locking.
SessionID: 9859
I’m New, Select Me!
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Room 180
Speaker: Thomas Norman
Title: I’m New, Select Me!
Abstract:
I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA! Feeling overwhelmed, not sure where to begin. I know I have data and maybe lots of it. I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends. For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends. Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.