sqlsathistory

Nr: 306

Back to Main list

SQLSaturday #306 - Redmond 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Robert Davis	Queen Ann	DBA Code Reviews Done Dirt Cheap
00:00:00	David Lydston	Montlake	Data Mining in the Microsoft Stack
00:00:00	David Eichner	Montlake	SRS Report Builder for Business Intelligence
00:00:00	Greg Larsen	Capital Hill	Alice’s SQL Server DBA Training Plan
00:00:00	Joe Chang	Capital Hill	Automating Execution Plan Analysis
00:00:00	Jimmy May	Capital Hill	Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit
00:00:00	Kalen Delaney	Capital Hill	Unblock yourself -- Optimistic concurrency in Hekaton
00:00:00	Piotr Palka	Montlake	SSIS - manage concurrent processing using SQL Server Broker
00:00:00	Rich Baumet	Pioneer Square	T-SQL - Temporary Objects
00:00:00	Rick Morelan	Pioneer Square	SQL Aggregation Queries Tips and Tricks
00:00:00	Ron Talmage	Queen Ann	SQL Server Upgrade Strategies
00:00:00	Russel Loski	Montlake	SSIS project deployments with multiple developers
00:00:00	Scott Stauffer	Montlake	"I've got the Power" with PowerBI and the PASS Community!
00:00:00	Chuck Lathrope	Queen Ann	Inside and out of Transactional Replication
00:00:00	Kevin Boles	Pioneer Square	Common TSQL Mistakes
00:00:00	Theresa Iserman	Queen Ann	Backup and Recovery Basics
00:00:00	Trent Mera	Queen Ann	Dell Software tools for SQL Server performance management
00:00:00	Trent Mera	Pioneer Square	SQL Server Waits reveal which of your statements most need tuning
00:00:00	Vern Rabe	Pioneer Square	Practical Fundamentals of Query Performance Tuning
00:00:00	John McAllister	Queen Ann	Master Data Management - Getting Started with SQL Server MDS
00:00:00	Argenis Fernandez	Capital Hill	Peace of Mind: Making DBCC CHECKDB Go Faster

SessionID: 11457

DBA Code Reviews Done Dirt Cheap

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Queen Ann

Speaker: Robert Davis

Title: DBA Code Reviews Done Dirt Cheap

Abstract:

Do you know what code is going onto your production systems? How can you support something you haven't seen?

Whether you currently do code reviews or think it might be a good practice to start doing, this session will help you make the most of the code review process. For DBAs, we'll cover key things to look for such as looking for potential problems. For developers, this will be insight for you into how DBAs think when reviewing your code so you have a better idea what to expect.

SessionID: 12419

Data Mining in the Microsoft Stack

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Montlake

Speaker: David Lydston

Title: Data Mining in the Microsoft Stack

Abstract:

If you want to be a successful business intelligence analyst in today’s market, you need to bring more to the table than fancy dashboards and drill through pivot tables. Now, you need sophisticated cluster analysis, decision-trees and bona fide product recommendations. In this session I’ll show you where to find the free Microsoft tools that allow you to tap into these features of SQL Server Analysis Services 2008 R2 and beyond. After this session you will be able to create everything above without learning R, or stepping out of the Microsoft BI stack. You’ll see how you can create fantastic data visualizations that are better than you could accomplish in the same time with years of experience in expensive statistical packages like SAS or SPSS. More importantly than the how’s, you’ll leave knowing the when’s to use these powerful data science tools.

SessionID: 12798

SRS Report Builder for Business Intelligence

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Montlake

Speaker: David Eichner

Title: SRS Report Builder for Business Intelligence

Abstract:

Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!

SessionID: 14835

Alice’s SQL Server DBA Training Plan

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Capital Hill

Speaker: Greg Larsen

Title: Alice’s SQL Server DBA Training Plan

Abstract:

Congratulations on landing your first SQL Server DBA Job. Do you have a DBA Training Plan?

In this presentation we will follow Alice as she steps into her first days as a new DBA. We will travel with Alice as she navigates through SQL Server Land following her DBA Training Plan. We will be watching Alice as she discovers, learns, and actually performs those typical tasks to maintain a SQL Server environment. In this presentation Alice will discover the following and more: • Monitoring your server • Backup / Recovery • Managing Databases • Managing and Monitor Resources • Installation considerations • Managing Security and Auditing • SQL Server version management As Alice travels through SQL Server Land we will be watching Alice as she performs her on the job training exercises. These demos that Alice will be working through should provide those attending with some examples that will walk us through the actual mechanics of what Alice will need to deal with as SQL Server

SessionID: 16091

Automating Execution Plan Analysis

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Capital Hill

Speaker: Joe Chang

Title: Automating Execution Plan Analysis

Abstract:

Many SQL Server performance issues can be solved with the information available from the DMVs, even if it is collected only after the problem occurred. But management might ask why something that was not an issue yesterday became an issue today i.e., who is to blame? On modern server systems with many powerful processors cores and massive memory, problems may be infrequent, but they do still occur. And so we may have neglected to collect and archive data on a routine basis. It is equally important to collect sufficient information to fully diagnose and a resolve a problem. Too many (all?) third party tools seem to stop after identifying a problem on the presumption that the the DBA’s responsibility ends with passing this information to someone else. To this end, I have automated the collection and partial analysis of index usage, query execution statistics and executions plans in my own tool ExecStats (http://www.qdpma.com/ExecStats/SQLExecStats.html)

SessionID: 16844

Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Capital Hill

Speaker: Jimmy May

Title: Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit

Abstract:

Columnstore indexes were introduced in SQL Server 2012 have been wholly re-architected optimized for SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads are a hybrid technology leveraging the best of off-disk in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at sub-second response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, big wins at customer sites inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit why columnstore manifests my motto, “Change the world or go home!”

SessionID: 17850

Unblock yourself -- Optimistic concurrency in Hekaton

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Capital Hill

Speaker: Kalen Delaney

Title: Unblock yourself -- Optimistic concurrency in Hekaton

Abstract:

SQL Server 2014's In-Memory OLTP allows truly optimistic locking and no latching! In this session, we see how rows can be inserted, deleted and updated without the need for latches or locks.

SessionID: 22245

SSIS - manage concurrent processing using SQL Server Broker

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Montlake

Speaker: Piotr Palka

Title: SSIS - manage concurrent processing using SQL Server Broker

Abstract:

In this session we will do a case study for a typical situation in industries like telecommunication or healthcare. We have a stream of multiple relatively small files incoming from external system and we need to load them to SQL Server database in near-real-time. Typical examples are CDR billing files, HL7 diagnostic results or medical claims.

In this session we will cover how we can use WMI event watchers to monitor for incoming files and we examine option for managing worker treads loading the files. We will look into SQL Server broker queues, conversations between treads and activation to achieve robust solution.

SessionID: 22629

T-SQL - Temporary Objects

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Pioneer Square

Speaker: Rich Baumet

Title: T-SQL - Temporary Objects

Abstract:

When to use what when it comes to temp tables, table variables, CTEs and more! Developers have a lot of options but they are quite different. In this session we will go through the different types and look at the significant differences with the different options, you may think twice about what you choose!

SessionID: 23018

SQL Aggregation Queries Tips and Tricks

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Pioneer Square

Speaker: Rick Morelan

Title: SQL Aggregation Queries Tips and Tricks

Abstract:

In your OLTP database you often need to find category or yearly totals. Most people are familiar with getting totals by using GROUP BY with an aggregate function. What if you want get market share reports like how each product is selling as it’s percentage of the total category. You can combine aggregate functions with individual records without even using GROUP BY or nesting your queries.

• Learn about aggregation queries that combine totals in the same records set as your row data. • Learn to write aggregation queries that don’t use the GROUP BY keywords • See how aggregate table data by groups or partitions using all types of aggregate keywords

SessionID: 23567

SQL Server Upgrade Strategies

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Queen Ann

Speaker: Ron Talmage

Title: SQL Server Upgrade Strategies

Abstract:

Upgrading your SQL Servers requires planning and decision making. In this session you'll learn about the parameters for deciding the type of upgrade strategy to choose based on your system constraints. In addition, you'll learn about how to put together an upgrade checklist that includes workflow and inter-team handoffs that can guide the upgrade process.

SessionID: 23681

SSIS project deployments with multiple developers

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Montlake

Speaker: Russel Loski

Title: SSIS project deployments with multiple developers

Abstract:

Before SQL Server 2012, it was easy to develop several SSIS packages in a project and deploy each package as you complete it. However SQL Server 2012 introduces the project deployment model. With its awesome features comes the limitation that you can no longer deploy a single package. You must deploy the whole project every time! How do you deploy a project that contains a mix of deployed packages, ready to deploy packages and packages in development?

In this session I demonstrate common problems that arise in the package development lifecycle that affect project deployment. I will then demonstrate how to use Team Foundation Server to address these problems. I will develop the story for handling packages at various stages of development using TFS.

SessionID: 24063

"I've got the Power" with PowerBI and the PASS Community!

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Montlake

Speaker: Scott Stauffer

Title: "I've got the Power" with PowerBI and the PASS Community!

Abstract:

Power Query

Power Pivot Power Query Power Map

Let's use public SQL Server community data to highlight capabilities of the Latest Microsoft BI Toolset

SessionID: 24990

Inside and out of Transactional Replication

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Queen Ann

Speaker: Chuck Lathrope

Title: Inside and out of Transactional Replication

Abstract:

Replication in SQL Server is great tool for scaling out your master database(s) onto other servers for reporting and remote site access with near real-time data propagation. In this session, I will cover LAN and WAN data replication tricks-of-the-trade to offload work from your master servers. Using these techniques, you can improve your performance and monitoring of your existing installations or gain knowledge and confidence to implement new solution for your company.

SessionID: 26389

Common TSQL Mistakes

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Pioneer Square

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FIFTY times now and it is always very highly rated!

SessionID: 26887

Backup and Recovery Basics

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Queen Ann

Speaker: Theresa Iserman

Title: Backup and Recovery Basics

Abstract:

As a DBA, two of your most important responsibilities are backing up data and knowing how to recover it. In this presentation, we’ll talk about backup types, recovery models and recovery point objectives. I’ll demonstrate backing up data and recovering it to a point in time. By the end of the session, you’ll know what a copy-only backup is, when to take a tail-log backup and what it means to restore a database with no recovery.

SessionID: 27103

Dell Software tools for SQL Server performance management

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Queen Ann

Speaker: Trent Mera

Title: Dell Software tools for SQL Server performance management

Abstract:

Spotlight on SQL Server gives real-time alerts and brings together all of your critical SQL Server metrics onto a single dashboard-type screen, color-coded for problem severity and clickable for drilling down to the details and causes of problems. Performance Analysis for SQL Server enables you to see how each statement hitting your SQL Server contributed to overall workload, over whatever time range you are interested in. Performance Analysis also provides advisories on improving the performance of your SQL Server, covering coding tips, configuration and other best practices.

SessionID: 27104

SQL Server Waits reveal which of your statements most need tuning

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Pioneer Square

Speaker: Trent Mera

Title: SQL Server Waits reveal which of your statements most need tuning

Abstract:

Abstract for 60 min session: In this session, I will show you how SQL Server Waits reveal which of your statements most need tuning. SQL Waits expose the specific workload generated by each statement running against your SQL Server. Methods for capturing this information will be shown, and ideas for aggregating and viewing the data over various time ranges will be discussed.

SessionID: 27382

Practical Fundamentals of Query Performance Tuning

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Pioneer Square

Speaker: Vern Rabe

Title: Practical Fundamentals of Query Performance Tuning

Abstract:

Do you need to write some queries and not sure how to make sure they will perform well? Do you already have some poorly performing queries and don’t know where to start to improve them? In this session I’ll start with a little bit of optimizer basics, then show you how to avoid some query writing pitfalls that result in poor performance. I’ll then show you how to read the execution plan and use other tools to help identify why a query is performing poorly, and how to fix it. I’ll have several examples of how seemingly insignificant changes to a query can have drastic effect on performance.

SessionID: 34674

Master Data Management - Getting Started with SQL Server MDS

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Queen Ann

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

Peace of Mind: Making DBCC CHECKDB Go Faster

Back to calendar

Event Date: 31-05-2014 - Session time: 00:00:00 - Track: Capital Hill

Speaker: Argenis Fernandez

Title: Peace of Mind: Making DBCC CHECKDB Go Faster

Abstract:

Along with backups, consistency checks are arguably the two most important tasks that DBAs need to perform regularly. Our databases are getting bigger every day, and CHECKDB run times, along with its performance impact to Production systems, keep increasing. In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like Transaction log and VLF management, tempdb configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey's consistency checks were taken from 7 days down to 6 hours.

This site is open source. Improve this page.