sqlsathistory

Nr: 119

Back to Main list

SQLSaturday #119 - Chicago 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Bill Fellows	Track 5	Kama Sutra of SSIS: A guide to loving ETL
00:00:00	Christina Leo	Track 4	What's Buried in the Plan Cache?
00:00:00	Craig Purnell	Track 4	Upgrade Roadmap: Let’s delve into SQL Server 2012
00:00:00	David Klee	Track 3	Virtualizing Business Critical SQL Servers
00:00:00	Andy Thiru	Track 2	SQL Azure Intro and What’s New
00:00:00	Erin Stellato	Track 3	DBCC Commands: The Quick and the Dangerous
00:00:00	Eddie Wuerch	Track 8	Join Us! Getting Started as a Technical Speaker
00:00:00	Hope Foley	Track 5	Performance Tuning 2012 SSIS Data Loads
00:00:00	Josh Fennessy	Track 5	Administering the BI Stack
00:00:00	Mark Vaillancourt	Track 6	MDX Trek: First Contact
00:00:00	Norman Kelm	Track 5	The Script Task, powerhouse of SSIS
00:00:00	Rob Farley	Track 7	SARGability
00:00:00	Rob Farley	Track 7	Analytic T-SQL Functions in 2012
00:00:00	Ross LoForte	Track 3	Microsoft Big Data
00:00:00	Luke Jian	Track 1	Optimizing SQL Server I/O with Solid State Drives
00:00:00	MIKE DONNELLY	Track 4	Advancements in CDC with SSIS in SQL 2012
00:00:00	Ted Krueger	Track 8	Ask the Experts - Anything and Everything
00:00:00	Kevin Boles	Track 1	SQL Server 2012 Column Store Index
00:00:00	Tim Chapman	Track 7	Writing Faster SQL Server Queries
00:00:00	Aaron King	Track 8	A Complete BI Solution in About an Hour!
00:00:00	Allan Hirt	Track 1	Is That A Failover Cluster On Your Laptop/Desktop?
00:00:00	Argenis Fernandez	Track 4	Troubleshooting SQL Server with SysInternals Tools
00:00:00	Ben DeBow	Track 2	Build Your Own SQL Server Private Cloud
00:00:00	Bob Pusateri	Track 1	The Skinny on Data Compression
00:00:00	Brent Ozar	Track 2	BLITZ! One Hour SQL Server Takeovers
00:00:00	Colleen Morrow	Track 8	So I started this blog... now what?
00:00:00	David Eichner	Track 7	SRS Report Builder for Business Intelligence
00:00:00	Janis Griffin	Track 6	Don't Panic, DBAs! Databases on VMware made easy.
00:00:00	Jes Schultz	Track 7	Reporting Services 201: From Basic To WOW!
00:00:00	Jason Strate	Track 4	Getting to Know Index Operation Stats
00:00:00	Michael Sexton	Track 5	Error Handling in ETL
00:00:00	Scott Shaw	Track 6	Licensing SQL Server in a Virtual Environment
00:00:00	Shelly Noll	Track 8	NoSQL: Know Your Enemy
00:00:00	Mark Tabladillo	Track 1	Enterprise Data Mining with SQL Server
00:00:00	Ted Krueger	Track 6	Query Tuning for Developers and DBAs
00:00:00	Tim Ford	Track 3	The Periodic Table of Dynamic Management Objects
00:00:00	Thomas Norman	Track 2	Compliance and Auditing in Sql Server
00:00:00	Warren Sifre	Track 2	Introduction to FileTables in SQL 2012
00:00:00	Aaron Lowe	Track 6	Writing Professional Database Code
00:00:00	Arie Jones	Track 3	Master Data Services in SQL Server 2012

SessionID: 10421

Kama Sutra of SSIS: A guide to loving ETL

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Bill Fellows

Title: Kama Sutra of SSIS: A guide to loving ETL

Abstract:

Slow running packages? SSIS consuming all your resources? No idea what it's doing?

After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.

SessionID: 11598

What's Buried in the Plan Cache?

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4

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 potentially 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: 12018

Upgrade Roadmap: Let’s delve into SQL Server 2012

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Craig Purnell

Title: Upgrade Roadmap: Let’s delve into SQL Server 2012

Abstract:

We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them

SessionID: 13260

Virtualizing Business Critical SQL Servers

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: David Klee

Title: Virtualizing Business Critical SQL Servers

Abstract:

Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotchya’s will be discussed in this dynamic dialog session.

SessionID: 13901

SQL Azure Intro and What’s New

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Andy Thiru

Title: SQL Azure Intro and What’s New

Abstract:

In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, scaling and sharding databases with SQL Azure Federations and syncsynchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure.

SessionID: 13944

DBCC Commands: The Quick and the Dangerous

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Erin Stellato

Title: DBCC Commands: The Quick and the Dangerous

Abstract:

There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.

SessionID: 14050

Join Us! Getting Started as a Technical Speaker

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Eddie Wuerch

Title: Join Us! Getting Started as a Technical Speaker

Abstract:

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session

SessionID: 15013

Performance Tuning 2012 SSIS Data Loads

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Hope Foley

Title: Performance Tuning 2012 SSIS Data Loads

Abstract:

Importing data is as common to SQL Server as bacon is to a savory breakfast sandwich. As most of us love to eat those breakfast sandwiches, SQL Server Integration Services (SSIS) loves to eat data in an Import/Export kind of way. Although a green chain of boxes in SSIS can be the ruling “Happy Dance” of any DBA or SQL Developer, we must still consider the performance of those tasks. In this session, we will go through performance tuning in SSIS 2012 after a successful SSIS package has been developed. When we are finished with this session, not only will you still have the mystic of green colors of successful execution of your SSIS import and export tasks, but the turbo boosters will be turned on as well.

SessionID: 16717

Administering the BI Stack

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Josh Fennessy

Title: Administering the BI Stack

Abstract:

More often than not, a SQL DBA will also be requested (or required) to administer other applications in the SQL universe. These applications are often the BI stack, SSIS, SSRS, and SSAS. In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work. At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations.

This session will focus on the SSIS, SSRS, and SSAS engines in this session. Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only.

SessionID: 19641

MDX Trek: First Contact

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Mark Vaillancourt

Title: MDX Trek: First Contact

Abstract:

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

SessionID: 21507

The Script Task, powerhouse of SSIS

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Norman Kelm

Title: The Script Task, powerhouse of SSIS

Abstract:

Everyday more DBAs and SQL developers are given responsibility for ETL development. They have a strong SQL background with little or no .Net language programming experience. As they progress with SSIS, they can come up against perceived limitations in the capabilities of SSIS using only the built-in tasks. What they may not realize is the extensibility available to SSIS via the Script Task. This presentation will provide them with the tools they need to move beyond that perceived limitation. Updated for SSIS 2012.

SessionID: 23173

SARGability

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Rob Farley

Title: SARGability

Abstract:

SARGability is such a significant thing in the database world, and goes far beyond "Keep your columns on the left and functions on the right". In this talk, you'll be able learn principles that will affect not only how easily your data can be located, but also the way that joins are performed and more. You can even learn ways to tune poorly performing queries without having to rewrite anything.

SessionID: 23175

Analytic T-SQL Functions in 2012

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Rob Farley

Title: Analytic T-SQL Functions in 2012

Abstract:

There are a bunch of new T-SQL functions in SQL Server 2012, and as usual there's a combination of the "this is really useful" and the "...but there's a caveat". In this presentation, Rob will take you through the new analytic functions, show you how they seriously enhance your reporting ability, and show you some of the ways that they don't behave the way you might expect. You may not be using SQL Server 2012 yet, but you're bound to recognise some of the problems that these functions solve.

SessionID: 23452

Microsoft Big Data

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Ross LoForte

Title: Microsoft Big Data

Abstract:

Want to learn Microsoft solutions around Big Data integrating structured and unstructured data to unleashing insights on all data.

This session on the Big Data solution running Hadoop on Windows and Windows Azure, then integrating the Microsoft BI solution to provide a conbined view of all data. During the session, the attendees will get a peek on a demo Hadoop Azure running a Big Data MapReduce solution, then using PowerPivot and PowerView to view the data.

SessionID: 24316

Optimizing SQL Server I/O with Solid State Drives

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Luke Jian

Title: Optimizing SQL Server I/O with Solid State Drives

Abstract:

Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure

SessionID: 24971

Advancements in CDC with SSIS in SQL 2012

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: MIKE DONNELLY

Title: Advancements in CDC with SSIS in SQL 2012

Abstract:

There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I'll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter.

SessionID: 26063

Ask the Experts - Anything and Everything

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Ted Krueger

Title: Ask the Experts - Anything and Everything

Abstract:

Take advantage of the deep wealth of knowledge from our experts at SQL Saturday by asking them anything and everything you may want to know or troubleshoot about SQL Server

SessionID: 26341

SQL Server 2012 Column Store Index

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: SQL Server 2012 Column Store Index

Abstract:

Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

SessionID: 26751

Writing Faster SQL Server Queries

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Tim Chapman

Title: Writing Faster SQL Server Queries

Abstract:

Poor database performance is the Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.

SessionID: 28567

A Complete BI Solution in About an Hour!

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Aaron King

Title: A Complete BI Solution in About an Hour!

Abstract:

In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.

SessionID: 28616

Is That A Failover Cluster On Your Laptop/Desktop?

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Allan Hirt

Title: Is That A Failover Cluster On Your Laptop/Desktop?

Abstract:

Over the years, one of the most common questions I am asked is, "How can I configure a cluster on my machine?" Ask no more! Production should never be the only place you have clusters. Having the ability to create a cluster that you can use as a sandbox for testing or as an instruction tool for presentations and demonstrations is something every DBA should have in their arsenal.

This session will demystify the "magic" behind configuring a cluster on your laptop or desktop using either Vmware Workstation or Microsoft's Hyper-V in Windows Server 2008 R2, and show how to configure things like the virtual machines, the domain controller, and the iSCSI storage solution.

SessionID: 28794

Troubleshooting SQL Server with SysInternals Tools

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Argenis Fernandez

Title: Troubleshooting SQL Server with SysInternals Tools

Abstract:

In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.

SessionID: 28999

Build Your Own SQL Server Private Cloud

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Ben DeBow

Title: Build Your Own SQL Server Private Cloud

Abstract:

Do you know what SaaS and DaaS are? If not, you should. SQL Server as a service (SaaS) and database as a service (DaaS) are otherwise known as the private cloud – the ability to offer your customers (external or internal) a reliable, scalable, and manageable way to easily deploy SQL Server systems and databases. At the end of the day they essentially want to push a button and get what they asked for. This is what the private cloud experience should enable for them. While you may do some of this now, come learn how to take it to the next level and design a service offering that will enable your organization to be agile, yet not leave you tearing out your hair worrying about it.

SessionID: 29121

The Skinny on Data Compression

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Bob Pusateri

Title: The Skinny on Data Compression

Abstract:

SQL Server's data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we'll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you're getting the most out of them.

SessionID: 29205

BLITZ! One Hour SQL Server Takeovers

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Brent Ozar

Title: BLITZ! One Hour SQL Server Takeovers

Abstract:

You’re minding your own business in your corner office – well, no, you’re a DBA, so it’s just your cubicle – when somebody says, “Did you know about this SQL Server over here?” Suddenly, you have to find out what the server’s doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.

SessionID: 29590

So I started this blog... now what?

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Colleen Morrow

Title: So I started this blog... now what?

Abstract:

Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.

SessionID: 29782

SRS Report Builder for Business Intelligence

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 7

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.

SessionID: 30484

Don't Panic, DBAs! Databases on VMware made easy.

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Janis Griffin

Title: Don't Panic, DBAs! Databases on VMware made easy.

Abstract:

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.

SessionID: 30787

Reporting Services 201: From Basic To WOW!

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 7

Speaker: Jes Schultz

Title: Reporting Services 201: From Basic To WOW!

Abstract:

You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to "wow", using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with: - Report properties such as headers, footers and backgrounds - Tablix properties such as ToolTip and NoRows - How to build and customize a matrix - How to effectively use lists, an often-overlooked feature - Adding charts to make reports visually appealing and easy to understand

SessionID: 31134

Getting to Know Index Operation Stats

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Jason Strate

Title: Getting to Know Index Operation Stats

Abstract:

There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information.

SessionID: 31841

Error Handling in ETL

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Michael Sexton

Title: Error Handling in ETL

Abstract:

Too often ETL systems do not incorporate error handling. When things break at 2 AM – and they ALWAYS break at 2 AM – some poor on call person must get out of bed and deal with something that should have been caught and handled by the code itself. This session will cover ways for you to help your poor on-call colleagues get a full night’s sleep, thereby gaining you their eternal gratitude.

SessionID: 32803

Licensing SQL Server in a Virtual Environment

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Scott Shaw

Title: Licensing SQL Server in a Virtual Environment

Abstract:

Presentation on licensing, huh. Boring? Maybe. Important? Absolutely! Being a DBA isn't just all fun and games. There are also some serious things to take care of. Licensing SQL Server is one of those and doing it right can mean the difference between a few thousand dollars or a few hundred thousand dollars. This session will discuss how to license SQL Server specifically for the transition from a physical to a virtual environment. You'll find that maybe, more than anything else, it will be the way SQL Server is licensed that determines how you configure your entire virtual infrastructure.

SessionID: 32918

NoSQL: Know Your Enemy

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 8

Speaker: Shelly Noll

Title: NoSQL: Know Your Enemy

Abstract:

A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice.

SessionID: 33091

Enterprise Data Mining with SQL Server

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Mark Tabladillo

Title: Enterprise Data Mining with SQL Server

Abstract:

This presentation describes SQL Server Data Mining (SSDM) for SQL Server Professionals. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.

SessionID: 33344

Query Tuning for Developers and DBAs

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Ted Krueger

Title: Query Tuning for Developers and DBAs

Abstract:

As a seasoned DBA, we often forget the basics of query tuning may be an area others haven’t been introduced to. Tuning can be a mystery for developers and DBAs that are starting out with SQL Server. Each operation and its cost can lead to lengthy research escapades, determining if the work is even worth the time to attempt a change in the overall execution plan. This session is going to discuss the basics of tuning; however, we can't end there. The second half of the session, the discussion portion, will focus on the key operations in the execution plan. The overall goal of the session is to take away knowledge on how to start with a query and use execution plans to refine it and turn it into a finely tuned process.

SessionID: 33671

The Periodic Table of Dynamic Management Objects

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Tim Ford

Title: The Periodic Table of Dynamic Management Objects

Abstract:

Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yield interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!

SessionID: 33710

Compliance and Auditing in Sql Server

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Thomas Norman

Title: Compliance and Auditing in Sql Server

Abstract:

I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let's look at what we can do to help us pass audits and comply with the laws around us. I need to install TDE, what do I do? Move the database to other server, can I do that? I used certificates, can I change them. I don’t like governments making me do all this stuff, it complicates my database. What does TDE do to my backups? Can I remove it? Auditing, no, let’s run for the hills. Let’s see how Sql Server can help us with these issues.

SessionID: 33854

Introduction to FileTables in SQL 2012

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Warren Sifre

Title: Introduction to FileTables in SQL 2012

Abstract:

What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this fucntionality can help you manage your data in whatever forms it exists.

SessionID: 8896

Writing Professional Database Code

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Aaron Lowe

Title: Writing Professional Database Code

Abstract:

As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let's discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night.

SessionID: 9811

Master Data Services in SQL Server 2012

Back to calendar

Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Arie Jones

Title: Master Data Services in SQL Server 2012

Abstract:

Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models, working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data.

This site is open source. Improve this page.