sqlsathistory

Nr: 436

Back to Main list

SQLSaturday #436 - Las Vegas 2015

Start Time (24h)	Speaker	Track	Title
08:30:00	Andrew Karcher	Other	A NoSQL Primer for the SQL Server Developer
08:30:00	Chris Bell	Enterprise Database Administration Deployment	You Want Me To Do What? SQL Security Basics
08:30:00	John Deardurff	Application Database Development	The PROCESS of Queries
08:30:00	Rick Heiges	Enterprise Database Administration Deployment	First Look at SQL Server 2016
08:30:00	Konstantin Melamud	Strategy and Architecture	Turbo Boost Performance: In Memory Tables index optimizations
08:30:00	Paresh Motiwala	Professional Development	DBA to Project Manager in 60 minutes flat
08:30:00	Amy Herold	Professional Development	Making the Leap from Developer to DBA
09:45:00	Ami Levin	Enterprise Database Administration Deployment	Physical Join Operators
09:45:00	Jeff Reinhard	Enterprise Database Administration Deployment	AlwaysOn Availability Groups Kickoff
09:45:00	Grant Fritchey	Application Database Development	Statistics and Query Optimization
09:45:00	Rick Lowe	Enterprise Database Administration Deployment	Why should I care about the plan cache?
09:45:00	John Sterrett	Enterprise Database Administration Deployment	Make Your SQL Server Queries Go Faster
09:45:00	William Wolf	Application Database Development	Tame the sibling rivalry of the Lock, Block and Deadlock sisters
11:00:00	Steve Stedman	Enterprise Database Administration Deployment	When Database Corruption Strikes - Will you be ready?
11:00:00	Andrew Kelly	Enterprise Database Administration Deployment	Collecting and Analyzing File Wait Statistics
11:00:00	Jason Horner	Enterprise Database Administration Deployment	Tricks from the DBA Inbox: Real World Performance Tuning
11:00:00	Paresh Motiwala	BI Platform Architecture, Development Administration	Setting up your BI Infrastructure
11:00:00	Aaron Cutshall	Application Database Development	The Lost Science of Set Theory
11:00:00	Randy Knight	Enterprise Database Administration Deployment	Understanding the SQL Server Transaction Log
12:30:00	John McAllister	Information Delivery	Master Data Management - Getting Started with SQL Server MDS
12:30:00	Mike Teel	Analytics and Visualization	How to Light up your SQL Server Investment with Pyramid Analytics BI
13:45:00	Joseph D'Antoni	Enterprise Database Administration Deployment	Picking the Right Fights with Your Server Team
13:45:00	Konstantin Melamud	BI Platform Architecture, Development Administration	Optimizing your data warehouse for OLAP Processing
13:45:00	Argenis Fernandez	Enterprise Database Administration Deployment	Zero-Downtime Upgrades: Rockstar DBA
13:45:00	Jason Brimhall	Enterprise Database Administration Deployment	A Masters Passport to Extended Events
13:45:00	Ben Thul	Application Database Development	Running with Scissors - SQLCLR and You
13:45:00	David McCarter	Professional Development	R#246;ck Yo#252;r Technical Interview (Part 1)
14:15:00	Dave Fackler	BI Platform Architecture, Development Administration	CSI: DW -- Anatomy of a VLDW!
15:00:00	Chris Bell	Enterprise Database Administration Deployment	Hacking Expos#233; - Using SSL to Secure SQL Server Connections
15:00:00	Brandon Leach	Enterprise Database Administration Deployment	Data Pages, Allocation Units, IAM chains... Oh My!
15:00:00	David Valentine	Application Database Development	T-SQL: Simple Changes That Go a Long Way
15:00:00	Carlos Bossy	BI Information Delivery	Use Hive and Hadoop for High Performance Data Warehousing
15:00:00	Eddie Wuerch	Enterprise Database Administration Deployment	What is a Latch, and Why Should I Care?
15:00:00	David McCarter	Professional Development	R#246;ck Yo#252;r Technical Interview (Part 2)
16:15:00	Ted Stathakis	BI Information Delivery	Graphs, Charts, Gauges, Sparklines Oh My!
16:15:00	Gigi Bell	Professional Development	Dealing With Difficult People
16:15:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL! - Director's Cut
16:15:00	Phil Helmer	Application Database Development	Building Your Way to Better Database Testing
16:15:00	Amy Herold	Enterprise Database Administration Deployment	Beginning Automation with Powershell
16:15:00	Wayne Sheffield	Enterprise Database Administration Deployment	SSMS Tips Tricks: Using What You've Already Got

SessionID: 36517

A NoSQL Primer for the SQL Server Developer

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Other

Speaker: Andrew Karcher

Title: A NoSQL Primer for the SQL Server Developer

Abstract:

You have all probably heard about this "NoSQL" thing and wondered what is about, how does it differ from SQL Server and how will this affect me. You might want to just stick your head in the sand and ignore it, but as database professionals it is always good to know about what other technologies might be out there to compliment your existing solutions. We will not be going deep into any one solution, but by the end of this session, the goal will be that you understand the following:

1. The different types of NoSQL databases
2. Some use cases where they might be applicable
3. Some of the major solutions out there for each one

SessionID: 36599

You Want Me To Do What? SQL Security Basics

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: You Want Me To Do What? SQL Security Basics

Abstract:

You've done it! You have a database now! Maybe not of your own choice, but you have one. What do you do now to get it secured properly? Come learn the basics of SQL Security to start down the path of proper database protection.

SessionID: 38171

The PROCESS of Queries

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Application Database Development

Speaker: John Deardurff

Title: The PROCESS of Queries

Abstract:

This session focuses on the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.

SessionID: 38221

First Look at SQL Server 2016

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30: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: 38337

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 38530

DBA to Project Manager in 60 minutes flat

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30:00 - Track: Professional Development

Speaker: Paresh Motiwala

Title: DBA to Project Manager in 60 minutes flat

Abstract:

As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.

In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.

SessionID: 39052

Making the Leap from Developer to DBA

Back to calendar

Event Date: 12-09-2015 - Session time: 08:30: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: 36516

Physical Join Operators

Back to calendar

Event Date: 12-09-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ami Levin

Title: Physical Join Operators

Abstract:

SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.

SessionID: 36531

AlwaysOn Availability Groups Kickoff

Back to calendar

Event Date: 12-09-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Reinhard

Title: AlwaysOn Availability Groups Kickoff

Abstract:

A run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies

SessionID: 37044

Statistics and Query Optimization

Back to calendar

Event Date: 12-09-2015 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Statistics and Query Optimization

Abstract:

There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.

SessionID: 37916

Why should I care about the plan cache?

Back to calendar

Event Date: 12-09-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick's "Why should I care" series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV's for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why DBAs drink in the morning (allegedly).

SessionID: 38344

Make Your SQL Server Queries Go Faster

Back to calendar

Event Date: 12-09-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Make Your SQL Server Queries Go Faster

Abstract:

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries, and apply proper indexes while avoiding common mistakes. Finally we will cover coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.

SessionID: 38731

Tame the sibling rivalry of the Lock, Block and Deadlock sisters

Back to calendar

Event Date: 12-09-2015 - Session time: 09:45:00 - Track: Application Database Development

Speaker: William Wolf

Title: Tame the sibling rivalry of the Lock, Block and Deadlock sisters

Abstract:

Deadlocks present a problem to many DBAs. Deadlocks can be minor occurrences or major issues making SQL Server continually choose a victim like constantly quarreling siblings.

We will review locking, blocking and deadlocking. We will review isolation levels. When would be an appropriate time to use each. We will also review how to identify locks and deadlocks and how to lessen the family fighting.

SessionID: 36511

When Database Corruption Strikes - Will you be ready?

Back to calendar

Event Date: 12-09-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Steve Stedman

Title: When Database Corruption Strikes - Will you be ready?

Abstract:

You are working along month after month with no problems in your database. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or something even scarier. Do you know what to do now? We will walk through 3 or 4 actual corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you should do to protect yourself when corruption strikes. Learn what to avoid that will make things worse. You will leave with a checklist of steps to take when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.

SessionID: 37438

Collecting and Analyzing File Wait Statistics

Back to calendar

Event Date: 12-09-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Kelly

Title: Collecting and Analyzing File Wait Statistics

Abstract:

Is your SQL Server instance running at its peak performance level? Probably not but the real question is do you know why not? Is your disk subsystem too slow or are you lacking enough CPU’s or is it something else? It is very easy to capture and analyze the file wait statistical information that is automatically provided by the SQL Server instance with several key DMV’s so why not utilize them. We will see how you can stop chasing your tail and focus on which area of SQL Server performance bottlenecks are doing you the most harm. This should be part of every DBA’s arsenal so come make it part of yours as well.

SessionID: 38500

Tricks from the DBA Inbox: Real World Performance Tuning

Back to calendar

Event Date: 12-09-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Horner

Title: Tricks from the DBA Inbox: Real World Performance Tuning

Abstract:

In this heavily demo based session, we show some techniques for performance tuning common problems faced by DBA's Including: how to identify the problem, resolve the issue, and test the solution. Along the way we will also discuss some of theory behind the solutions. We all know there is no such thing as DBCC GO_FASTER but this session is the next best thing.

SessionID: 38529

Setting up your BI Infrastructure

Back to calendar

Event Date: 12-09-2015 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paresh Motiwala

Title: Setting up your BI Infrastructure

Abstract:

We know BI in bits and pieces. But imagine if you had to setup the BI infrastructure from scratch.

What do we need to consider, which players do we consider, what are the components, the HA/DR scenario for the same, what technology to use? These are the questions we will attempt to answer along the way. What are the best practices involved in creating a BI infrastructure. We can discuss whether to outsource this project or rise above our DBA job and do it ourselves. We will also briefly discuss Copy Data Virtualization and inclusion of Cloud.

SessionID: 38574

The Lost Science of Set Theory

Back to calendar

Event Date: 12-09-2015 - Session time: 11:00:00 - Track: Application Database Development

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

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 12-09-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Randy Knight

Title: Understanding the SQL Server Transaction Log

Abstract:

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

SessionID: 37381

Master Data Management - Getting Started with SQL Server MDS

Back to calendar

Event Date: 12-09-2015 - Session time: 12:30:00 - Track: Information Delivery

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

How to Light up your SQL Server Investment with Pyramid Analytics BI

Back to calendar

Event Date: 12-09-2015 - Session time: 12:30:00 - Track: Analytics and Visualization

Speaker: Mike Teel

Title: How to Light up your SQL Server Investment with Pyramid Analytics BI

Abstract:

I will be covering the following during the session:

1. Overview on "Who is Pyramid Analytics"
2. Demo on the BI Office Suite
3. Discussion on the recent MSFT Joint Collaboration agreement with Pyramid Analytics

SessionID: 38078

Picking the Right Fights with Your Server Team

Back to calendar

Event Date: 12-09-2015 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Joseph D'Antoni

Title: Picking the Right Fights with Your Server Team

Abstract:

Being a DBA is more challenging than ever—virtualized infrastructure, tiered storage and the cloud mean you may not know where you servers are, what disks your data is on, and you have less control than ever. In order to keep your databases performing and to provide an optimal environment you have to pick your battles. You have limited capital, and you only want to pick the most important fights.

In this session you will learn about how to choose battles and win (with data!): • How to configure storage and file systems for SQL Server • Why you should always compress your backups • How your virtual machines should be configured for SQL Server • What rights you and your servers need in Active Directory • Many more and more importantly—which battles NOT to fight After attending this session, you will have a good understanding of how to talk with your peers in the infrastructure teams and make sure the key SQL Servers in your environment have the resources they need to perform great.

SessionID: 38338

Optimizing your data warehouse for OLAP Processing

Back to calendar

Event Date: 12-09-2015 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.

SessionID: 38737

Zero-Downtime Upgrades: Rockstar DBA

Back to calendar

Event Date: 12-09-2015 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Argenis Fernandez

Title: Zero-Downtime Upgrades: Rockstar DBA

Abstract:

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure?

You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

In this session you will:

• Understand how rolling upgrades are better than in place upgrades
• Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
• Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

This is a demo-intensive session, so you can see rolling upgrades live and up close.

If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!

SessionID: 38892

A Masters Passport to Extended Events

Back to calendar

Event Date: 12-09-2015 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: A Masters Passport to Extended Events

Abstract:

As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.

It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

SessionID: 39054

Running with Scissors - SQLCLR and You

Back to calendar

Event Date: 12-09-2015 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Ben Thul

Title: Running with Scissors - SQLCLR and You

Abstract:

Have you ever tried to do something in the database that T-SQL just didn't seem quite up to the task? Or perhaps you've been a little jealous of the application developers and their fancy Visual Studio and whatnot. Whatever your reason for wanting to learn about the CLR, you've come to the right place! In this session you'll learn how to extend the capabilities of your database with CLR stored procedures, functions, aggregates, and data types.

SessionID: 39160

R#246;ck Yo#252;r Technical Interview (Part 1)

Back to calendar

Event Date: 12-09-2015 - Session time: 13:45:00 - Track: Professional Development

Speaker: David McCarter

Title: R#246;ck Yo#252;r Technical Interview (Part 1)

Abstract:

Have you ever not gotten a job because you weren’t prepared for the interview? Would you like a big raise? Do you need motivation to rock your career? I’ve interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. Whether you are looking for a new position within your company or at a new company. This session will include crazy and strange interview stories from engineers just like you! This session includes tips to get you started, working with recruiters, getting prepared, the technical interview and more. You will also learn what is the #1 question you need to ask during an interview… it’s a game changer!

SessionID: 37546

CSI: DW -- Anatomy of a VLDW!

Back to calendar

Event Date: 12-09-2015 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dave Fackler

Title: CSI: DW -- Anatomy of a VLDW!

Abstract:

Put on your CSI caps as we delve into the anatomy of a Very Large Data Warehouse environment! During this case study session, we'll take a look at the data warehouse environment at the Department of Veterans Affairs. The VA is the largest healthcare organization in the US and has an extensive national DW and BI infrastructure, now in its seventh year of evolution. We'll take a look at the database infrastructure, the data loading process, and the various reporting and analytics solutions that provide over 150,000 knowledge workers and report consumers with timely data and information. We'll also take a look at some of the processes in place to support the myriad of extended reporting and analytics teams throughout the VA who build and manage second-tier downstream data marts and other reporting solutions.

SessionID: 36602

Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Back to calendar

Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: Hacking Expos#233; - Using SSL to Secure SQL Server Connections

Abstract:

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data?

We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! We will then secure our database connections with a simple self-signed SSL certificate. Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. *Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.

SessionID: 37402

Data Pages, Allocation Units, IAM chains... Oh My!

Back to calendar

Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Oh My!

Abstract:

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

SessionID: 37549

T-SQL: Simple Changes That Go a Long Way

Back to calendar

Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Application Database Development

Speaker: David Valentine

Title: T-SQL: Simple Changes That Go a Long Way

Abstract:

Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance and functionality of your queries. We will dive into a few TSQL tricks with features that include Common Table Expressions, Table-Valued Parameters, OUTPUT INTO, Window Functions and COALESCE.

SessionID: 38964

Use Hive and Hadoop for High Performance Data Warehousing

Back to calendar

Event Date: 12-09-2015 - Session time: 15:00:00 - Track: BI Information Delivery

Speaker: Carlos Bossy

Title: Use Hive and Hadoop for High Performance Data Warehousing

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

What is a Latch, and Why Should I Care?

Back to calendar

Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddie Wuerch

Title: What is a Latch, and Why Should I Care?

Abstract:

Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!

SessionID: 39161

R#246;ck Yo#252;r Technical Interview (Part 2)

Back to calendar

Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Professional Development

Speaker: David McCarter

Title: R#246;ck Yo#252;r Technical Interview (Part 2)

Abstract:

Part 2 of this sessions. Make sure you attend Part 1 first.

SessionID: 36571

Graphs, Charts, Gauges, Sparklines Oh My!

Back to calendar

Event Date: 12-09-2015 - Session time: 16:15:00 - Track: BI Information Delivery

Speaker: Ted Stathakis

Title: Graphs, Charts, Gauges, Sparklines Oh My!

Abstract:

Are you tired of the classic pick parameter/run report routine? If you’re not I bet your users are. Leverage Reporting Services (SSRS) to turn those same reports into an interactive “dashboard” where users simply click their way around the data. Add some graphical splash to make you reports come alive. In this session designed for people comfortable with SSRS looking to take their implementation to a new level we will go beyond charts and graphs and explore other representations of data. You will see how utilizing dynamic action buttons in report headers combined with sub reports and drill through reports can significantly improve user interaction and analysis of the data. Come see what you can do without a great deal of effort to take your SSRS solution to a new height.

SessionID: 38374

Dealing With Difficult People

Back to calendar

Event Date: 12-09-2015 - Session time: 16:15:00 - Track: Professional Development

Speaker: Gigi Bell

Title: Dealing With Difficult People

Abstract:

John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.

SessionID: 38820

Revenge: The SQL! - Director's Cut

Back to calendar

Event Date: 12-09-2015 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

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

Building Your Way to Better Database Testing

Back to calendar

Event Date: 12-09-2015 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Phil Helmer

Title: Building Your Way to Better Database Testing

Abstract:

Test Data Builders. Ever heard of them? That's ok. Neither did I before I went looking for a convenient way to set up test data in SQL Server. I will show you what they are and how they work. More importantly, you will learn an easy way to get started and what you can do with them that could make your professional value grow and earn more money. I will also cover some of the design decisions you need to make so that they'll fit your needs.

SessionID: 39050

Beginning Automation with Powershell

Back to calendar

Event Date: 12-09-2015 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.

SessionID: 39422

SSMS Tips Tricks: Using What You've Already Got

Back to calendar

Event Date: 12-09-2015 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Wayne Sheffield

Title: SSMS Tips Tricks: Using What You've Already Got

Abstract:

Almost everyone uses SSMS to write queries and to browse around on the server – but do you use all of the features that SSMS offers to increase your productivity? Come to this session, consisting mostly of demos, to see features built-in to SSMS that will improve your experience and productivity. Time permitting, we’ll also go into some 3rd party products that also increase your productivity in SSMS.

This site is open source. Improve this page.