Nr: 331
SQLSaturday #331 - Denver 2014
SessionID: 10599
VLDBs: Lessons Learned
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 5 - DBA 1
Speaker: Bob Pusateri
Title: VLDBs: Lessons Learned
Abstract:
VLDBs (Very Large Databases) play in a different league: common maintenance operations can take much longer to run, and some settings and features that work well on smaller databases become much less effective. These downsides generally have a negative impact on users, however through some creativity and changes in our game plan we can have highly performant VLDBs. This session will cover a wide variety of tips and tricks assembled from years of working with databases up to 40TB in size.
SessionID: 10871
SQL 2012 Extended Events
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 5 - DBA 1
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 11370
Get to Know HDInsight and Start Mining Big Data
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 2 - Business Intelligence
Speaker: Carlos Bossy
Title: Get to Know HDInsight and Start Mining Big Data
Abstract:
In this introductory session, you will learn the fundamentals of HDInsight and Hadoop, you'll see how to provision your own cluster in minutes, and you'll know how to put the cluster to work by the end of the session. Practical examples that show clustering techniques and text analysis of unstructured and semi-structured data will be shown allowing attendees to implement their own cluster with minimal administration overhead.
SessionID: 11532
Ten T-SQL Techniques with Tally Tables
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 3 - T-SQL
Speaker: Chris Hyde
Title: Ten T-SQL Techniques with Tally Tables
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 12612
SQL Server Virtualization 201
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 6 - DBA 2
Speaker: David Klee
Title: SQL Server Virtualization 201
Abstract:
So you have finally virtualized your SQL Servers. Now what? How can virtualization be embraced to simplify and streamline operations? What about making the systems more resilient to failure? How can it be used to improve uptime and simplify some of the more common architectures? High availability, disaster recovery, backups, and new server provisioning are discussed in this interactive session.
SessionID: 13184
Women in Tech Panel
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 7 - Professional Dev
Speaker: Denver WIT
Title: Women in Tech Panel
Abstract:
SessionID: 13683
Service Broker: The Queue Continuum
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 4 - DB Dev/DBA
Speaker: Ed Leighton-Dick
Title: Service Broker: The Queue Continuum
Abstract:
Pop quiz: How can SQL Server help developers build scalable, distributed, and asynchronous applications? Service Broker is the answer! In this presentation, I'll show you what it is; talk about when and why you might want to use it in your applications; walk through an example of how to set it up; and share a few lessons learned from our successful implementations.
SessionID: 14665
Power BI – Cloud Self-Service BI
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 2 - Business Intelligence
Speaker: Ginger Grant
Title: Power BI – Cloud Self-Service BI
Abstract:
Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
SessionID: 14696
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 5 - DBA 1
Speaker: Glenn Berry
Abstract:
SessionID: 15855
Cloudy with a Chance of SQL
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 4 - DB Dev/DBA
Speaker: Jason Horner
Title: Cloudy with a Chance of SQL
Abstract:
You have heard all of the buzzwords and hype surrounding Microsoft Azure and the Cloud but what is it really and more importantly how can you use it effectively to solve the most important problems facing your organization today. We will look at both Windows Azure SQL Databases and using Azure VM's to host SQL Server.
Let Microsoft Certified Master of SQL Server Jason Horner show you how to apply your existing DBA skills to leverage SQL Server in the cloud.
SessionID: 16892
Introduction to Execution Plans Query Tuning
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 8 - Half-Day
Speaker: Jason Kassay
Title: Introduction to Execution Plans Query Tuning
Abstract:
There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is under-performing, hogging resources or timing out, one of the first things you want to examine is the query execution plan. The Query Optimizer, Execution Plans Query Tuning are the three key topics covered. At the end of the session you will walk away with the confidence to diagnose and tune queries.
SessionID: 18440
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 3 - T-SQL
Speaker: Kathi Kellenberger
Abstract:
SessionID: 18441
Writing Better T-SQL Queries with Window Functions
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 3 - T-SQL
Speaker: Kathi Kellenberger
Title: Writing Better T-SQL Queries with Window Functions
Abstract:
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
SessionID: 18862
SQL Server Backups and Restores A to Z
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 6 - DBA 2
Speaker: Keith Tate
Title: SQL Server Backups and Restores A to Z
Abstract:
Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do? If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options.
The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.
SessionID: 19144
Data Modeling 101
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 1 - Modeling/ETL
Speaker: Leslie Weed
Title: Data Modeling 101
Abstract:
Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West. We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task. We will go over some different modeling techniques around Normalized, Dimensional and Data Vault options. And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast. Yee-Haw!
SessionID: 19210
Choose Your Geospatial/Mapping Adventure
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 2 - Business Intelligence
Speaker: Meagan Longoria
Title: Choose Your Geospatial/Mapping Adventure
Abstract:
SessionID: 19431
Getting started with Dimensional Modeling
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 1 - Modeling/ETL
Speaker: Marc Beacom
Title: Getting started with Dimensional Modeling
Abstract:
Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we've all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.
SessionID: 20597
SSIS Logging Reconsidered
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 1 - Modeling/ETL
Speaker: Michael Sexton
Title: SSIS Logging Reconsidered
Abstract:
SessionID: 22784
ETL with Microsoft Power Query for Excel
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 1 - Modeling/ETL
Speaker: Reeves Smith
Title: ETL with Microsoft Power Query for Excel
Abstract:
Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing.
This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.
SessionID: 22932
Dashboards - More Than One Way To Visualize Data
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 2 - Business Intelligence
Speaker: Jeff Renz
Title: Dashboards - More Than One Way To Visualize Data
Abstract:
Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.
SessionID: 23346
Revenge: The SQL! - Director's Cut
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 3 - T-SQL
Speaker: Rob Volk
Title: Revenge: The SQL! - Director's Cut
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 23448
How to Pass Microsoft MCSA exams in Three Weeks
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 7 - Professional Dev
Speaker: Rose Zarling
Title: How to Pass Microsoft MCSA exams in Three Weeks
Abstract:
Rose will share how she studied and passed the Microsoft exams in three weeks. She will share not only how she passed the exams, but also how you can set your own goals to pass the exams. So if you have ever dreamed of obtaining your Microsoft certifications come hear how you can apply what she did so that you too can pass your certifications!
SessionID: 23760
SQL 2012 AlwaysOn Quickstart
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 5 - DBA 1
Speaker: Ryan Adams
Title: SQL 2012 AlwaysOn Quickstart
Abstract:
In this presentation I'll explain what the SQL Server AlwaysOn high availability and disaster recovery solution is all about. I'll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We'll discuss how these three things come together to protect your databases. We'll finish with a dive into availability group configuration, the new capabilities it gives us, and what's new in SQL Server 2014.
SessionID: 24559
Get Testing with tSQLt
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 3 - T-SQL
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: 24561
Branding Yourself for a Dream Job
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 7 - Professional Dev
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: 24615
Reporting Services In An AlwaysOn World
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 2 - Business Intelligence
Speaker: Brandon Tucker
Title: Reporting Services In An AlwaysOn World
Abstract:
SessionID: 25152
Cardinality Estimates in Microsoft SQL Server 2014
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 6 - DBA 2
Speaker: Thomas LaRock
Title: Cardinality Estimates in Microsoft SQL Server 2014
Abstract:
SessionID: 25937
Advanced Statistics Management: Setting Up SQL Server For Success
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 5 - DBA 1
Speaker: Seth Washeck
Title: Advanced Statistics Management: Setting Up SQL Server For Success
Abstract:
The optimizer uses statistics to generate a cardinality estimate which, in turn, affects query plan decisions as well as system resources. In this session we're going to step through the process of evaluating the statistics present (or not present) and present a methodology for analyzing the presence of skew, candidate filtered statistics, and their efficacy in an environment. Additionally, we'll look at the impacts of the new Cardinality Estimator in SQL Server 2014 on plan generation This would, ultimately, be an excellent addition to any periodic SQL Server health check.
SessionID: 26478
SQL Injection
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 4 - DB Dev/DBA
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
SessionID: 26565
Fun with Availability Groups
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 6 - DBA 2
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: 26634
Scripting in SSIS
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 1 - Modeling/ETL
Speaker: Tim Mitchell
Title: Scripting in SSIS
Abstract:
In this session, we will explore both the Script Task and Script Component tools within SSIS. We will discuss the reasons why one might need to include scripting as part of an ETL strategy, as well as examining some use cases where scripting is a good fit. We will follow up with several demonstrations of how to solve specific ETL challenges using the Script Task and Script Component in SSIS.
SessionID: 26963
The Life Cycle of a Query in 3D
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 4 - DB Dev/DBA
Speaker: Todd Kleinhans
Title: The Life Cycle of a Query in 3D
Abstract:
Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift Virtual Reality Headset for 3D Gaming and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
SessionID: 27540
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 1 - Modeling/ETL
Speaker: Andy Vold
Abstract:
SessionID: 27764
Table Vars Temp Tables - What you NEED to Know!
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 4 - DB Dev/DBA
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: 27823
Read Dirty to Me - Isolation Levels/User Impact
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 6 - DBA 2
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: 34785
Introduction to Powershell for the SQL Server DBA
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 8 - Half-Day
Speaker: Michael Fal
Title: Introduction to Powershell for the SQL Server DBA
Abstract:
Maybe you've only heard of Powershell. Maybe you've seen a little bit of Powershell code, but still don't understand how it works. You've been telling yourself for months now that you need to learn it. Why wait? The time to get started with Powershell is now.
In this half day session, we will build the foundation for using Powershell as a database administrator. Three areas will be covered:
- Powershell fundamentals - How the language works and how to write it
- Powershell/SQL Server integration - Functionality written specifically for SQL Server
- Application of Powershell - Use cases and code examples that leverage Powershell for database management
This session is intended for database administrators of all levels who have minimal experience with Powershell. Attendees who participate in this session will leave with a solid foundation of Powershell and how to apply it in their own environments.
SessionID: 8947
The Lost Science of Set Theory
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 3 - T-SQL
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: 9070
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 2 - Business Intelligence
Speaker: Alan Faulkner
Abstract:
A journey through a compilation of best practices accumulated over multiple business intelligence, data warehousing projects, and published content in relation to SQL Server Analysis Services. From dimension design to SSAS Engine internals this session will take you through steps to assists in getting your SSAS cubes better optimized to better match the needs of your end users.
SessionID: 9411
Making the Leap from Developer to DBA
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 7 - Professional Dev
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: 9614
Are You Maintaining Your SQL Servers?
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 4 - DB Dev/DBA
Speaker: Andy Galbraith
Title: Are You Maintaining Your SQL Servers?
Abstract:
Are you performing all of the regular maintenance you should on your servers?Do you not run CHECKDB because "it takes too long"? How about Index Maintenance - does that take too long?Do you really have the appropriate backups in place?Do you have benchmark numbers in place to compare when your server is "slow"?Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.
SessionID: 9854
I’m New, Select Me!
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: Track 6 - DBA 2
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.