Nr: 415
SQLSaturday #415 - Colorado Springs 2015
SessionID: 18252
Keynote
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Other
Speaker: Kevin Cox
Title: Keynote
Abstract:
What is the state of SQL Server? When is the next version coming? What are the big success features in SQL Server 2014?
SessionID: 35631
Event Date: 06-06-2015 - Session time: 09:10:00 - Track: DBA
Speaker: Chris Shaw
Abstract:
After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;
We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160;
These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.
SessionID: 35632
Row-Based Security in SSRS and SSAS
Event Date: 06-06-2015 - Session time: 09:10:00 - Track: BI
Speaker: Chris Hyde
Title: Row-Based Security in SSRS and SSAS
Abstract:
It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.
SessionID: 36050
Developing Production Quality SQL Code
Event Date: 06-06-2015 - Session time: 09:10:00 - Track: Development
Speaker: Paul Nielsen
Title: Developing Production Quality SQL Code
Abstract:
SessionID: 36228
Hadoop and SQL Together: Modern Data Warehouse Design Patterns
Event Date: 06-06-2015 - Session time: 09:10:00 - Track: NoSQL
Speaker: Josh Fennessy
Title: Hadoop and SQL Together: Modern Data Warehouse Design Patterns
Abstract:
No question about it, Hadoop is here and enterprises large and small are starting to embrace it. The adoption rate of Hadoop is making some EDW professionals anxious about this technology replacing their tried and true relational data warehouse. This is a worry that need not be had.
In this session, we'll go through several design patterns that show how Hadoop can augment an existing relational data warehoue, and show WHY we need both technologies to cover the broad spectrum of reporting an analytics.
This session is largely conceptual, although we will cover a few code examples to show how some of the Hadoop technologies work in conjunction with SQL Server as a data warehousing platform.
SessionID: 36417
Getting Started with Extended Events
Event Date: 06-06-2015 - Session time: 09:10:00 - Track: DBA
Speaker: Andy Galbraith
Title: Getting Started with Extended Events
Abstract:
Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
SessionID: 18866
SQL Server Backups and Restores A to Z
Event Date: 06-06-2015 - Session time: 10:30:00 - Track: DBA
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: 19433
Getting started with Dimensional Modeling
Event Date: 06-06-2015 - Session time: 10:30:00 - Track: BI
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: 36042
ETL is Dead
Event Date: 06-06-2015 - Session time: 10:30:00 - Track: BI
Speaker: Kevin Cox
Title: ETL is Dead
Abstract:
ETL may not be dead, there will always be use cases for it. But if we can get sub-second query response time over petabytes of data, why do you need all that other stuff? Come to this session to see a modern data pipeline.
SessionID: 36177
What’s this ‘Scaffolding a CRUD’ all about? Build a Website from
Event Date: 06-06-2015 - Session time: 10:30:00 - Track: Development
Speaker: Gabriel Villa
Title: What’s this ‘Scaffolding a CRUD’ all about? Build a Website from
Abstract:
So you have a SQL Server database, and you want a web site for your tables? Come see how to develop and deploy a simple .NET website against any SQL Server database. See firsthand how to use Microsoft’s Entity Framework, ASP.Net MVC and other tricks to develop a website by writing very little code. Take home the ability to create and deploy a simple website to your own database once this demonstration is seen.
SessionID: 36233
Sentiment Analysis with Big Data
Event Date: 06-06-2015 - Session time: 10:30:00 - Track: NoSQL
Speaker: Paco Gonzalez
Title: Sentiment Analysis with Big Data
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 16899
XQuery: get FLWORed
Event Date: 06-06-2015 - Session time: 13:00:00 - Track: Development
Speaker: Jennifer Kenney
Title: XQuery: get FLWORed
Abstract:
There are a number of difficult tasks in SQL querying that can be solved using XML and XQuery. Learn about pivoting, row concatenation, transactional processing techniques, and other things that can be accomplished by reshaping small data sets into XML.
SessionID: 20380
An Unexpected Journey: SQL Server 2000 to 2014
Event Date: 06-06-2015 - Session time: 13:00:00 - Track: DBA
Speaker: Michelle Poolet
Title: An Unexpected Journey: SQL Server 2000 to 2014
Abstract:
As a DBA yourself, I’m sure you’ve encountered instances where the SQL Server has been running fine, there’ve been no changes for ages, everything is stable, there’s no exposure to the outside world, and the last time anyone updated or applied a patch to the server was in February 2004… …and then the world intruded, and all of a sudden you’ve been given a directive to “bring that system up to date!” Now what? You’re faced with upgrading not only the SQL Server, but the Windows server as well (and a bunch of other applications), because Microsoft has announced that ALL support for Windows Server 2003 will be going away (far away!) this summer! And some clever person upstairs decided that it would be A GOOD THING to have this SQL Server exposed to the outside…and has commissioned the web dev team to build a whole suite of apps that WILL MAKE THE COMPANY MILLIONS! Where to start…
SessionID: 20601
The Augean Stables: Data Cleansing in the Modern Enterprise
Event Date: 06-06-2015 - Session time: 13:00:00 - Track: BI
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: 35954
Right-Sizing Your SQL Server Virtual Machine
Event Date: 06-06-2015 - Session time: 13:00:00 - Track: Architecture
Speaker: David Klee
Title: Right-Sizing Your SQL Server Virtual Machine
Abstract:
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
SessionID: 36056
Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and
Event Date: 06-06-2015 - Session time: 13:00:00 - Track: DBA
Speaker: Amy Herold
Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and
Abstract:
While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
SessionID: 18948
Why Be Normal?
Event Date: 06-06-2015 - Session time: 14:20:00 - Track: Architecture
Speaker: Leslie Andrews
Title: Why Be Normal?
Abstract:
SessionID: 36007
An Introduction to Hadoop Development
Event Date: 06-06-2015 - Session time: 14:20:00 - Track: NoSQL
Speaker: Carlos Bossy
Title: An Introduction to Hadoop Development
Abstract:
Big Data has moved beyond the hype and entered the mainstream as a tool for managing large and unstructured data sets, giving data architects more options for managing data. The Hadoop ecosystem has become the tool of choice and Microsoft has entered this arena with HDInsight in the cloud. For DBAs this means having a place to store data that can be accessed using a highly parallel framework. In this session you’ll see how to use the numerous tools available to store data in Hadoop, process it, manage it, and retrieve it. We’ll explore Sqoop and how its many options can be configured to import data by taking advantage of Hadoop’s massive parallelism. We will develop and run Map\Reduce code, with an emphasis on understanding what belongs in a mapper function versus what belongs in a reducer function, while demonstrating Hadoop Streaming with languages such as R and C#. Finally, Hive will be shown to exhibit the use of a high-level query language in Hadoop for those who prefer SQL.
SessionID: 36079
Are You Optimistic About Concurrency?
Event Date: 06-06-2015 - Session time: 14:20:00 - Track: Architecture
Speaker: Kalen Delaney
Title: Are You Optimistic About Concurrency?
Abstract:
What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency?
In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
SessionID: 36149
Powershell and the Art of SQL Server Deployment
Event Date: 06-06-2015 - Session time: 14:20:00 - Track: DBA
Speaker: Michael Fal
Title: Powershell and the Art of SQL Server Deployment
Abstract:
SessionID: 36245
Increase your SSIS Productivity with Biml
Event Date: 06-06-2015 - Session time: 14:20:00 - Track: BI
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 SSIS package development productivity to the next level. Creating template packages can add productivity to your SSIS development effort. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
In this session we will walk through various examples that will inspire you to make Biml your number one SQL Server Integration Services development tool. Learn how to use Biml scripts to create both staging tables and Integration Services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
In this session, you will learn:
- How to work with Biml and BimlScript
- Metadata options that can create robust Biml solutions
- Biml design methods that can work around some so the SQL Server Integration Services pain points.
SessionID: 10405
IO, IO, Why's my SQL Slow?
Event Date: 06-06-2015 - Session time: 15:40:00 - Track: DBA
Speaker: Brian Flynn
Title: IO, IO, Why's my SQL Slow?
Abstract:
This presentation will cover :
The difference between latency, throughput, IOPS, and how they relate.
Performance characteristics of several storage solutions.
Techniques for analyzing storage subsystem performance.
How database design and infrastructure interact and impact performance and scalability.
SessionID: 17991
SQL Server Maintenance Plans
Event Date: 06-06-2015 - Session time: 15:40:00 - Track: DBA
Speaker: Kat Long
Title: SQL Server Maintenance Plans
Abstract:
Most DBA’s know you need to be doing some form of maintenance on your databases: Backups, index rebuilding\reorganization, update statistics, integrity checks, and system cleanup. SQL Server offers some basic tasks to complete this needed maintenance. The session will cover setting up a maintenance plan including the tasks, schedules, and logging. From there, we will dive deeper into the basic task, find out what is going on behind the scene, and discuss when it is OK to use them and when you should create your own. At the end of the session you will know how to create a maintenance plan, how to log results and keep a history of success or failures, when you should use what SQL Server has provided and when you should create your own plan.
SessionID: 26968
The Life Cycle of a Query in 3D
Event Date: 06-06-2015 - Session time: 15:40:00 - Track: 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 DK2 Virtual Reality headset 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: 35842
Dashboards - More Than One Way To Visualize Data
Event Date: 06-06-2015 - Session time: 15:40:00 - Track: BI
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: 36212
Data Modeling 101
Event Date: 06-06-2015 - Session time: 15:40:00 - Track: Architecture
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!