sqlsathistory

Nr: 415

Back to Main list

SQLSaturday #415 - Colorado Springs 2015

Start Time (24h) Speaker Track Title
00:00:00 Kevin Cox Other Keynote
09:10:00 Chris Shaw DBA Tips for SQL Server Performance and Resiliency
09:10:00 Chris Hyde BI Row-Based Security in SSRS and SSAS
09:10:00 Paul Nielsen Development Developing Production Quality SQL Code
09:10:00 Josh Fennessy NoSQL Hadoop and SQL Together: Modern Data Warehouse Design Patterns
09:10:00 Andy Galbraith DBA Getting Started with Extended Events
10:30:00 Keith Tate DBA SQL Server Backups and Restores A to Z
10:30:00 Marc Beacom BI Getting started with Dimensional Modeling
10:30:00 Kevin Cox BI ETL is Dead
10:30:00 Gabriel Villa Development What’s this ‘Scaffolding a CRUD’ all about? Build a Website from
10:30:00 Paco Gonzalez NoSQL Sentiment Analysis with Big Data
13:00:00 Jennifer Kenney Development XQuery: get FLWORed
13:00:00 Michelle Poolet DBA An Unexpected Journey: SQL Server 2000 to 2014
13:00:00 Michael Sexton BI The Augean Stables: Data Cleansing in the Modern Enterprise
13:00:00 David Klee Architecture Right-Sizing Your SQL Server Virtual Machine
13:00:00 Amy Herold DBA Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and
14:20:00 Leslie Andrews Architecture Why Be Normal?
14:20:00 Carlos Bossy NoSQL An Introduction to Hadoop Development
14:20:00 Kalen Delaney Architecture Are You Optimistic About Concurrency?
14:20:00 Michael Fal DBA Powershell and the Art of SQL Server Deployment
14:20:00 Reeves Smith BI Increase your SSIS Productivity with Biml
15:40:00 Brian Flynn DBA IO, IO, Why's my SQL Slow?
15:40:00 Kat Long DBA SQL Server Maintenance Plans
15:40:00 Todd Kleinhans DBA The Life Cycle of a Query in 3D
15:40:00 Jeff Renz BI Dashboards - More Than One Way To Visualize Data
15:40:00 Leslie Weed Architecture Data Modeling 101

SessionID: 18252

Keynote

Back to calendar

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

Tips for SQL Server Performance and Resiliency

Back to calendar

Event Date: 06-06-2015 - Session time: 09:10:00 - Track: DBA

Speaker: Chris Shaw

Title: Tips for SQL Server Performance and Resiliency

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

Back to calendar

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

Back to calendar

Event Date: 06-06-2015 - Session time: 09:10:00 - Track: Development

Speaker: Paul Nielsen

Title: Developing Production Quality SQL Code

Abstract:

Most of the training we receive as SQL Server professionals has code developed for the purpose of demoing or providing training for a specific feature. I’ve developed my share of demo code and it serves it purpose. This session is different. I’ll quickly demo my company’s application (so you can get a sense of what it does), and then walk through many key portions of the actual T-SQL code showing you how the techniques I’ve used to make it production worthy with a focus on robustness, security, and performance. note: this session includes a LOT of dynamic SQL.

SessionID: 36228

Hadoop and SQL Together: Modern Data Warehouse Design Patterns

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Every database professional knows the database design ideal and we have all seen that ideal on numerous occasions - databases in perfect third normal form; constraints and relational integrity rigorously enforced; elegant error handling in every SQL statement; data so clean you can eat off it.

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

Back to calendar

Event Date: 06-06-2015 - Session time: 13:00:00 - Track: Architecture

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

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and

Back to calendar

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?

Back to calendar

Event Date: 06-06-2015 - Session time: 14:20:00 - Track: Architecture

Speaker: Leslie Andrews

Title: Why Be Normal?

Abstract:

Is your database normal? While being different and off-beat can be good for your personal life it is not a happy situation for your database to live in. Databases like to be normal! Join me for a fun and informational session on how to create a normal database and find out why it is important. We will also talk about how to make a database normal using queries so you can benefit from normalcy without having to go through major psychotherapy.

SessionID: 36007

An Introduction to Hadoop Development

Back to calendar

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?

Back to calendar

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

Back to calendar

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:

In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS. This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration. You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.

SessionID: 36245

Increase your SSIS Productivity with Biml

Back to calendar

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:

SessionID: 10405

IO, IO, Why's my SQL Slow?

Back to calendar

Event Date: 06-06-2015 - Session time: 15:40:00 - Track: DBA

Speaker: Brian Flynn

Title: IO, IO, Why's my SQL Slow?

Abstract:

Disk I/O can be a significant performance bottleneck for SQL Server. And when physical I/O is the suspected culprit, the first thought is to purchase more storage. But expensive hardware upgrades don’t necessarily ensure a faster database. So how do you determine how much I/O is contributing to poor performance? How can you assess the performance of a specific workload on different types of storage? And how do you decide which infrastructure is best for a specific storage solution?

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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!