sqlsathistory

Nr: 158

Back to Main list

SQLSaturday #158 - New York City 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Edwin Sarmiento	Track 1	Implementing SQL Server 2012 on Windows Server Cor
00:00:00	Edwin Sarmiento	Track 8	Deploying SQL Server 2012 Multi-site Clusters
00:00:00	Ben DeBow	Track 8	Surviving Your Peak Database Load
00:00:00	Brian Knight	Track 2	Performance Tuning SQL Server Integration Services
00:00:00	Brian Knight	Track 2	Data Cleansing with SSIS 2012
00:00:00	Brent Ozar	Track 2	Building Faster SQL Servers
00:00:00	Brent Ozar	Track 2	Real-Life SQL 2012 Availability Group Deployments
00:00:00	Christina Leo	Track 3	What's Buried in the Plan Cache?
00:00:00	Dan Clark	Track 5	Mastering Date-Time Based Analysis in DAX
00:00:00	Hilary Cotter	Track 5	Replicaton Technologies
00:00:00	Ira Warren	Track 8	(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
00:00:00	Jason Thomas	Track 7	Advanced Charting Techniques in SSRS
00:00:00	John Miner	Track 5	Full Text Indexing Basics
00:00:00	Kevin Kline	Track 1	SQL Server Internals Architecture
00:00:00	Kevin Kline	Track 7	Team Management Fundamentals
00:00:00	Kevin Goff	Track 2	What's new in SQL Server 2012 - from A to Z
00:00:00	Kevin Goff	Track 2	SQL Server 2012 Columnstore index
00:00:00	Leonard Lobel	Track 3	Introducing SQL Server Data Tools
00:00:00	Leonard Lobel	Track 3	Programming T-SQL Enhancements in SQL Server 2012
00:00:00	Linchi Shea	Track 6	Running SQL Server on Solid State Drives
00:00:00	Marc Jellinek	Track 6	Introduction to Data Quality Services
00:00:00	Mark Broadbent	Track 4	Moves like Jagger - Upgrading to SQL Server 2012
00:00:00	Mark Broadbent	Track 4	READPAST Furious-Transactions.Locking.Isolation.
00:00:00	Martin Schoombee	Track 5	Temporal Fact Tables: The Road Less Traveled
00:00:00	Mark Stacey	Track 7	Slowly changing dimensions- an integrated approach
00:00:00	Michael Corey	Track 4	Virtualizing Tier-1 SQL Server Databases On VMware
00:00:00	Mike Hillwig	Track 6	Seven SQL Agent Jobs You Should be Running
00:00:00	Mike Hillwig	Track 4	How Not to Be a Cranky DBA
00:00:00	Peter Myers	Track 7	Self-Managed BI with PowerPivot
00:00:00	Peter Myers	Track 6	Enriching Applications with SSAS Data Mining
00:00:00	Randy Knight	Track 3	But it worked great in Dev! Perfomance for Devs
00:00:00	Rick Morelan	Track 8	SQL 2012 Error Handling. Pick your Destiny
00:00:00	Ron Johnson	Track 8	Creating a Performance Baseline for SQL Server
00:00:00	Robert Pearl	Track 3	Much Ado about Indexes - Tips, Tricks and Tuning..
00:00:00	SB Chatterjee	Track 1	[Get-PowerShell
00:00:00	Scott Klein	Track 1	SQL Azure - What is it and why do I need it?
00:00:00	Scott Klein	Track 1	SQL Azure Scalability with Federations
00:00:00	Steve Simon	Track 3	Alright,WHY is the server REALLY running so slow!
00:00:00	Tim Radney	Track 8	Know Backups and Know Recovery
00:00:00	Todd McDermid	Track 5	Real World Integration Services: Excel Spreadsheet
00:00:00	William E Pearson III	Track 7	SSAS 2012 Tabular vs. Multidimensional
00:00:00	AJ Mendo	Track 6	Without A SQLTrace - Getting To Know Extended Even
00:00:00	Alex Grinberg	Track 6	Shred SQL Server XML.
00:00:00	Allan Hirt	Track 4	SQL Server Dos and Don'ts: Keys to DBA Nirvana
00:00:00	Andrew Brust	Track 1	Microsoft's Big Play for Big Data
00:00:00	Andrew Brust	Track 4	Hadoop and its Ecosystem Components in Action
00:00:00	Andrew Novick	Track 7	Writing Faster Stored Procedures and Functions

SessionID: 10124

Implementing SQL Server 2012 on Windows Server Cor

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Edwin Sarmiento

Title: Implementing SQL Server 2012 on Windows Server Cor

Abstract:

SQL Server DBAs have relied so much on graphical user interface (GUI) to administer and manage database servers. So, why take away the GUI? If you’re more into using the command-line and PowerShell to manage your servers, come to this session to learn how to implement SQL Server 2012 on Windows Server Core

SessionID: 10126

Deploying SQL Server 2012 Multi-site Clusters

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Edwin Sarmiento

Title: Deploying SQL Server 2012 Multi-site Clusters

Abstract:

This is a demo-driven session that will focus on designing and implementing a multi-site, geographically dispersed SQL Server 2012 Failover Cluster instance across multiple data centers. We will cover the considerations on implementing such an architecture to address high availability and disaster recovery requirements for your mission-critical databases.

SessionID: 10179

Surviving Your Peak Database Load

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Ben DeBow

Title: Surviving Your Peak Database Load

Abstract:

Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these time frames is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible.

SessionID: 10500

Performance Tuning SQL Server Integration Services

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Brian Knight

Title: Performance Tuning SQL Server Integration Services

Abstract:

In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server's resourcing. Lastly, discover SQL Server 2008 and 2012 features that will make SSIS more efficient.

SessionID: 10503

Data Cleansing with SSIS 2012

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Brian Knight

Title: Data Cleansing with SSIS 2012

Abstract:

In this session, you'll learn how to cleanse your data and apply simple to complex business rules in SSIS. Learn how to solve complex data problems quickly in SSIS using Data Quality Services (DQS). The speaker will show you how to incorporate scripting into your SSIS data flow to find and fix bad data. Then he'll show how to use advanced fuzzy logic to satisfy data duplication issues. Lastly, he’ll show you how to implement advanced data cleansing and normalization in SQL Server 2012 SSIS with DQS and MDS.

SessionID: 10734

Building Faster SQL Servers

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Brent Ozar

Title: Building Faster SQL Servers

Abstract:

SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field.

SessionID: 10735

Real-Life SQL 2012 Availability Group Deployments

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Brent Ozar

Title: Real-Life SQL 2012 Availability Group Deployments

Abstract:

You want to deploy AlwaysOn, but you're concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he's found in real-life deployments of AlwaysOn.

SessionID: 11588

What's Buried in the Plan Cache?

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Christina Leo

Title: What's Buried in the Plan Cache?

Abstract:

Creating a query plan can be a time consuming and expensive process. To avoid repeating these costly steps, SQL Server stores its query plans, in the plan cache where they can be reused as needed.

In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.

SessionID: 12901

Mastering Date-Time Based Analysis in DAX

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Dan Clark

Title: Mastering Date-Time Based Analysis in DAX

Abstract:

A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them. This session is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them.

SessionID: 14971

Replicaton Technologies

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Hilary Cotter

Title: Replicaton Technologies

Abstract:

Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and

troubleshooting techniques.

SessionID: 15498

(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Ira Warren

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Abstract:

Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census" has written a series of white papers on record linkage and particular a technique called "Blocking Indexs". In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of "real world" examples(Code) and you will leave a master of record linkage and the concepts behind it

SessionID: 15900

Advanced Charting Techniques in SSRS

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Jason Thomas

Title: Advanced Charting Techniques in SSRS

Abstract:

SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.

This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level.

SessionID: 17026

Full Text Indexing Basics

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: John Miner

Title: Full Text Indexing Basics

Abstract:

Today's large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan. I will be introducing the brother's grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.

SessionID: 18160

SQL Server Internals Architecture

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Kline

Title: SQL Server Internals Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - ...and much more.

SessionID: 18161

Team Management Fundamentals

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Kevin Kline

Title: Team Management Fundamentals

Abstract:

Considering a promotion into management? This session will teach you the

fundamental skills needed to effectively lead an IT team. Topics include motivational skills, conflict resolution skills, communication skills and project/job tracking skills. Attendees will also learn:

1. How to motivate a team and keep the members of that team focused and on task.
2. How to resolve conflicts, address performance problems, and handle project/job missteps.
3. How to gain support for your ideas, earn upper management support, and communicate with top management.

SessionID: 18313

What's new in SQL Server 2012 - from A to Z

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Goff

Title: What's new in SQL Server 2012 - from A to Z

Abstract:

In this presentation, I'll go through all the new features in SQL Server 2012. I won't cover any one area heavily - the goal is just to identify (and in some cases, briefly show) as many new features as possible....from the new columnstore index, to T-SQL enhancements, to a greatly iimproved SSIS tool, to a new model for creating analytic databases, and more. SQL Server 2012 has a large amount of new functionality that helps all sorts of database developers. After this presentation, I can almost promise you'll be VERY interested in upgrading to SQL Server 2012.

SessionID: 18316

SQL Server 2012 Columnstore index

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Goff

Title: SQL Server 2012 Columnstore index

Abstract:

It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well

SessionID: 19016

Introducing SQL Server Data Tools

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Leonard Lobel

Title: Introducing SQL Server Data Tools

Abstract:

With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and SQL Azure databases. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the next generation of database tools for developers!

SessionID: 19020

Programming T-SQL Enhancements in SQL Server 2012

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Leonard Lobel

Title: Programming T-SQL Enhancements in SQL Server 2012

Abstract:

As SQL Server evolves, so does Microsoft continue to improve and enhance Transact SQL (T-SQL). In SQL Server 2012, T-SQL remains the primary language for programming the relational database engine. In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of SQL Server. We’ll dive into powerful new windowing enhancements with the OVER clause, running and sliding aggregations, new T-SQL functions (all 22 of them!), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, and rich metadata discovery techniques. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won’t want to miss out on this session!

SessionID: 19158

Running SQL Server on Solid State Drives

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Linchi Shea

Title: Running SQL Server on Solid State Drives

Abstract:

Solid State Drives (SSD) are becoming one of the mainstream storage solutions, and many firms have started placing SQL Server database files on SSD in hope of gaining performance. However, how to best run SQL Server on SSD is not a settled question. Conflicting opinions abound. This session is packed with first-hand data points, sharing with you the results from a series of extensive performance tests on SSD, either with or without SQL Server. You will learn the basic performance characteristics of SSD, and what SQL Server/SSD configurations may give you best results.

SessionID: 19420

Introduction to Data Quality Services

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Marc Jellinek

Title: Introduction to Data Quality Services

Abstract:

Get an overview of the problem domain, architecture and solution space for Data Quality Services. See how Data Quality Services works hand-in-hand with Master Data Management to create master data, matching rules and leverage both to deduplicate data

SessionID: 19542

Moves like Jagger - Upgrading to SQL Server 2012

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Mark Broadbent

Title: Moves like Jagger - Upgrading to SQL Server 2012

Abstract:

In this diverse session we will take an in-depth look at moving to the SQL 2012 platform and the upgrade strategies at your disposal. Specifically we will take a deep dive into preparing and reporting for upgrade, upgrade strategies, performing the upgrade and knowing the upgrade was successful.

This session will also look at several advanced scenarios such as migrating to SQL Server 2012 on Server Core, AlwaysOn Availability Groups and AlwaysOn Fail-over Clustered Instances.

Attend this must see session and you too can have the “Moves like Jagger”.

SessionID: 19543

READPAST Furious-Transactions.Locking.Isolation.

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Mark Broadbent

Title: READPAST Furious-Transactions.Locking.Isolation.

Abstract:

Do you really understand SQL Servers’ Concurrency behaviour?

Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ_UNCOMMITTED is safe for reporting? Is being Optimistic really better than being Pessimistic? Can SQL Server 2012 be the solution to all our problems or our worst nightmare?

I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner.

SessionID: 19748

Temporal Fact Tables: The Road Less Traveled

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Martin Schoombee

Title: Temporal Fact Tables: The Road Less Traveled

Abstract:

Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate.

In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations.

SessionID: 20102

Slowly changing dimensions- an integrated approach

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Mark Stacey

Title: Slowly changing dimensions- an integrated approach

Abstract:

There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.

In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services

SessionID: 20232

Virtualizing Tier-1 SQL Server Databases On VMware

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Michael Corey

Title: Virtualizing Tier-1 SQL Server Databases On VMware

Abstract:

An SQL Server database is resource-intensive by its very nature and one of the most resource-intensive Business Critical applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing SQL Server on VMware.

Key Takeaway 1 Key Database Best Practices Key Takeaway 2 Common Mistakes How to Avoid Them Key Takeaway 3 Many resources available and where to find them

SessionID: 20569

Seven SQL Agent Jobs You Should be Running

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Mike Hillwig

Title: Seven SQL Agent Jobs You Should be Running

Abstract:

See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down.

Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment.

You'll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.

SessionID: 20570

How Not to Be a Cranky DBA

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Mike Hillwig

Title: How Not to Be a Cranky DBA

Abstract:

Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.

SessionID: 22212

Self-Managed BI with PowerPivot

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Peter Myers

Title: Self-Managed BI with PowerPivot

Abstract:

SQL Server 2012 PowerPivot will allow analysts to use Excel 2010 to load and prepare large volumes of data from various data sources to create a data model. The data model can then be enriched with calculations to become a data source for Excel PivotTable, PivotChart and CUBE function reports.

And as compelling as these BI experiences can be that’s not the end of the story. A PowerPivot workbook deployed to SharePoint Server 2010 can be used to create even more compelling BI experiences using Reporting Services and PerformancePoint Services.

In this presentation learn about the fundamentals of PowerPivot data model creation, and the exciting ways PowerPivot data models can be used to visualize and share data.

SessionID: 22214

Enriching Applications with SSAS Data Mining

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Peter Myers

Title: Enriching Applications with SSAS Data Mining

Abstract:

Data mining as a technology is designed to analyze large volumes of data looking for patterns that accurately predict behavior. These patterns can then be used to derive knowledge about data, and in turn this knowledge can be used to enhance application designs and the user experience. In this presentation, you will be introduced to Microsoft SQL Server 2005 and 2008 Data Mining and demonstrations on how to develop data mining models that can be embedded into your applications. Demonstrations are based on SQL Server 2008 R2 Data Mining. This presentation is a must for any developer looking to embed “Artificial Intelligence” into their solution design to take their applications to the next level.

SessionID: 22518

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Randy Knight

Title: But it worked great in Dev! Perfomance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

SessionID: 23010

SQL 2012 Error Handling. Pick your Destiny

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Rick Morelan

Title: SQL 2012 Error Handling. Pick your Destiny

Abstract:

Gone are all the spaghetti errors of past versions of SQL. For example did you know that BEGIN TRAN…COMMIT TRAN is not enough to make everything work together? People are often shocked when they see the demo in this talk where the first statement fails and all others statements still commit. This can still happen to you in SQL 2012 if you are not aware of the options. In fact did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action and control it. This is possible with or without structured error handling. See both ways to control the outcome to the way you want it.

SessionID: 23046

Creating a Performance Baseline for SQL Server

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Ron Johnson

Title: Creating a Performance Baseline for SQL Server

Abstract:

Creating a performance baseline for a SQL Server instance provides many benefits including defining a starting point for optimization efforts, documenting the server, a reference point for capacity planning, and providing a reference for ongoing performance comparison. This session will provide a detailed presentation of an approach for collecting, storing, and presenting performance metrics for use in developing a baseline performance assessment of a SQL Server instance.

SessionID: 23543

Much Ado about Indexes - Tips, Tricks and Tuning..

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Robert Pearl

Title: Much Ado about Indexes - Tips, Tricks and Tuning..

Abstract:

In my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client's indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo ways in which you can correlate the worst performing queries with missing indexes

SessionID: 24013

Get-PowerShell | Get-SQLServer

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: SB Chatterjee

Title: Get-PowerShell | Get-SQLServer

Abstract:

PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).

SessionID: 24123

SQL Azure - What is it and why do I need it?

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Scott Klein

Title: SQL Azure - What is it and why do I need it?

Abstract:

This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about.

SessionID: 24124

SQL Azure Scalability with Federations

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Scott Klein

Title: SQL Azure Scalability with Federations

Abstract:

With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits.

SessionID: 25198

Alright,WHY is the server REALLY running so slow!

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Steve Simon

Title: Alright,WHY is the server REALLY running so slow!

Abstract:

SSRS 2012: Having just completed a PRACTICAL dashboard to answer JUST this exact question, we shall be looking at how to create a reporting tool that will provide YOUR management with all their answers. We shall be focusing on the plethora of information that may be reaped from Dynamic Managment Views (DMV) and see how KPI's may be incorporated into the mix.

SessionID: 26697

Know Backups and Know Recovery

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Tim Radney

Title: Know Backups and Know Recovery

Abstract:

You say you have a backup strategy, but what is your recovery strategy?

In this session I will demonstrate several methods for performing much-needed backups and how to recover those backups to include FULL, DIFFERENTIAL, FILE GROUP, and TRANSACTION LOG. He will also demo performing a peace meal restore as well as backing up and restoring the tail end of the log after the data file becomes corrupt.

I will discuss industry best practices for backing up and recovering your data. The goal of this session is to educate you on the various backup strategies so you can decide which is best for your organization, demonstrate how to recover your databases, and to create the desire for you to go back and validate your current strategies

SessionID: 26943

Real World Integration Services: Excel Spreadsheet

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Todd McDermid

Title: Real World Integration Services: Excel Spreadsheet

Abstract:

You rarely hear of a data integration project that doesn't involve a spreadsheet as a source document, a lookup reference, or an output. It's the ambiguously ubiquitous container for business data because it's so flexible and familiar to users. Unfortunately, the same features those business users crave tend to cause huge problems for data professionals.

In this session we'll look at typical integration issues with Excel, explain why they occur, and show you more options than just the Excel Source or COM API. In a world where spreadsheets are the "database of choice" for business users, knowing how to get SSIS to interact reliably with Excel is an essential skill.

SessionID: 28050

SSAS 2012 Tabular vs. Multidimensional

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: William E Pearson III

Title: SSAS 2012 Tabular vs. Multidimensional

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.

SessionID: 9112

Without A SQLTrace - Getting To Know Extended Even

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: AJ Mendo

Title: Without A SQLTrace - Getting To Know Extended Even

Abstract:

If you have wanted to learn how to use Extended Events and have had a hard time trying to figure out where to start then this session is for you. This session is designed for someone that has never used Extended Events before. After this session you will know the basics of how to setup and use this highly scalable and configurable architecture to trouble shoot server issues. You will see how to use them in SQL 2008 and how they have been beefed up in SQL 2012. This will be a demo rich session so come prepared to finally get to know Extended Events.

SessionID: 9226

Shred SQL Server XML.

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Alex Grinberg

Title: Shred SQL Server XML.

Abstract:

Practical XML usage for SQL Server 2005 and up. Working examples how to load, create, and shred the XML using XPath query methods. The XML tips and tricks.

SessionID: 9234

SQL Server Dos and Don'ts: Keys to DBA Nirvana

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Allan Hirt

Title: SQL Server Dos and Don'ts: Keys to DBA Nirvana

Abstract:

Bad Windows builds? No HA? No backups? SQL Server considered the non-mission critical platform yet you have hundreds of instances? Over the years I've seen most, if not all of, the good, bad, and ugly of being a SQL Server DBA from being both a full time employee as well as a consultant. If you want to skip 20 years of ups and downs, come to this session to hear how you can be a better DBA for your SQL Server deployments, avoid pitfalls, and hopefully laugh at a few of my misadventures over the course of my career.

SessionID: 9477

Microsoft's Big Play for Big Data

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Andrew Brust

Title: Microsoft's Big Play for Big Data

Abstract:

Big Data entails collecting and analyzing large volumes of data obtained from Web, social media, scientific and other pools of fast-growing event-driven data. Recently, Microsoft announced its Windows Server and Windows Azure implementations of Hadoop, the open source distributed processing engine widely used in Big Data implementations. And the plot thickens, as Microsoft also fits SQL Server business intelligence (BI) tools on top of Hadoop, to make the analysis part of Big Data work with familiar and accessible Microsoft technologies.

Come to this session to get an overview of Big Data, Hadoop and its integration with te Microsoft BI stack. See how your skills can be applied to this rapidly growing part of the industry.

SessionID: 9478

Hadoop and its Ecosystem Components in Action

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Andrew Brust

Title: Hadoop and its Ecosystem Components in Action

Abstract:

It’s one thing to have a high-level understanding of Big Data, Hadoop and MapReduce; it’s quite another to feel comfortable working with the tools. In this demo-heavy session, ZDNet Big Data blogger and Visual Studio magazine columnist Andrew Brust will take a look at actual MapReduce code and see Hadoop ecosystem components HBase, Hive, Pig and Mahout in action.

SessionID: 9674

Writing Faster Stored Procedures and Functions

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Andrew Novick

Title: Writing Faster Stored Procedures and Functions

Abstract:

Stored procedures and functions are the mainstay of SQL Server coding. In this presentation you will learn techniques to locate problem code and to improve it's performance. Step 1 is to discover where the time is going using server traces, code to analyzes the traces, and the new Extended Events. Once we know where the time is going we look at strategies to improve performance: Managing indexes on temp tables and why heaps are often the best choice for temp tables; determining if an index is helping; Rewriting scalar and multi-statement functions as inline functions and why it’s so important; mastering minimally logged operations and the “Go Faster” switch. Each technique is illustrated with examples

This site is open source. Improve this page.