sqlsathistory

Nr: 171

Back to Main list

SQLSaturday #171 - Pittsburgh 2012

Start Time (24h) Speaker Track Title
00:00:00 Colleen Morrow Room AB310 So I started this blog... now what?
00:00:00 Colleen Morrow Room AB314 Searching for the Holy Grail of DDL Auditing
00:00:00 Cory Stevenson Room AB316 Getting Started with Report Services: The Setup
00:00:00 Craig Purnell Room AB310 Upgrade Roadmap: Let’s delve into SQL Server 2012
00:00:00 Dan Clark Room AB308 Building Your First Tabular Model
00:00:00 Dean Richards Room AB308 Don’t Panic DBAs! Databases on VMware Made Easy
00:00:00 Konstatin Melamud Room AB309 Code Tuning- Introduction to Execution Plans
00:00:00 Donald Scott Room AB310 SharePoint COOP Using 2008R2 Log Shipping
00:00:00 Carlton Ramsey Room AB308 An Introduction to Master Data
00:00:00 Carlton Ramsey Room AB314 How PowerShell helps me as a DBA
00:00:00 Eric Kepes Room AB310 MicroORMs – Keeping Your DBA Happy
00:00:00 Ira Warren Room AB308 Creating a Metadata Mart w/ SSIS - Data Governance
00:00:00 Jay Holliday Room AB309 Full-Text Search, it's not just for documents
00:00:00 Joseph D'Antoni Room AB314 SQL 2012 -- All About HA and DR
00:00:00 John Sterrett Room AB314 Performance Tuning for Pirates
00:00:00 Matt Velic Room AB309 Communicate for Great Good!
00:00:00 Tim Corey Room AB309 Before You Optimize: Understanding Execution Plans
00:00:00 Mike Hillwig Room AB314 Defy the Defaults!
00:00:00 Mike Hillwig Room AB314 Seven SQL Agent Jobs You Should be Running
00:00:00 Mike Hillwig Room AB316 How Not to Be a Cranky DBA
00:00:00 Michael John Room AB316 Top Development and Design Mistakes
00:00:00 Nate Locklin Room AB308 Spatial Data in SQL Server Reporting Services
00:00:00 Rick Heiges Room AB316 Basic Monitoring with Perfmon
00:00:00 Rushabh Mehta Room AB316 Introduction to Data Quality Services
00:00:00 Sam Nasr Room AB310 14 New T-SQL Functions
00:00:00 Sam Nasr Room AB309 Using Filetables
00:00:00 Tony Scotto di Carlo Room AB310 Data center migration, data centric point of view
00:00:00 Justin Dearing Room AB309 MongoDB for the Relational DBA
00:00:00 Adam Belebczuk Room AB308 Introduction to SQL Server Service Broker
00:00:00 A.J. Mee Room AB316 SQL Server 2012's Net-New BI Capabilities

SessionID: 11771

So I started this blog... now what?

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB310

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 what makes a great blog, overcoming obstacles common to new (and even experienced) bloggers, building authority and credibility, and setting you on the road to blogging stardom.

SessionID: 11772

Searching for the Holy Grail of DDL Auditing

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314

Speaker: Colleen Morrow

Title: Searching for the Holy Grail of DDL Auditing

Abstract:

Who altered this view and how? When was that index created? What happened to my stored procedure? From SQL Trace to SQL Audit and everything in between, we'll explore various methods of auditing events in SQL Server, how they work, and the inherent strengths and shortcomings of each in an epic quest to find the perfect DDL audit solution.

SessionID: 11877

Getting Started with Report Services: The Setup

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316

Speaker: Cory Stevenson

Title: Getting Started with Report Services: The Setup

Abstract:

In the SQL Server tool box there is a great tool called SQL Server Report Services. With five different interfaces, Report Services can be a bit challenging to setup and configure. Our focus will include setup, configuration, and deployment. When you walk away from this session, you will understand terms like BIDS, SSRS, Report Builder, and Crescent. Also, as part of this session we will cover the differences between SQL 2008 R2 and SQL 2012. If you are looking for steps to start developing your repertoire of SQL Server Report Services, this is definitely a session to attend!

SessionID: 12035

Upgrade Roadmap: Let’s delve into SQL Server 2012

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB310

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

Building Your First Tabular Model

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308

Speaker: Dan Clark

Title: Building Your First Tabular Model

Abstract:

With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine (This is the same engine used by PowerPivot.) To use the new xVelocity engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to create calculations, measures, and KPI’s. DAX is similar to the expression language used in excel and it should be easier to use than MDX and appeal to a broader audience.

This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded).

SessionID: 13046

Don’t Panic DBAs! Databases on VMware Made Easy

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308

Speaker: Dean Richards

Title: Don’t Panic DBAs! Databases on VMware Made Easy

Abstract:

Many of our customers are either virtualizing databases or planning to do so soon. We hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

SessionID: 13229

Code Tuning- Introduction to Execution Plans

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309

Speaker: Konstatin Melamud

Title: Code Tuning- Introduction to Execution Plans

Abstract:

Topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules. Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type.

SessionID: 13370

SharePoint COOP Using 2008R2 Log Shipping

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB310

Speaker: Donald Scott

Title: SharePoint COOP Using 2008R2 Log Shipping

Abstract:

Many organizations never plan for disaster. Ken and Don will present a solution that can assist any shop to ensure mission critical SharePoint farms continue to operate throughout the course of an unplanned production downtime. The speakers will speak about topics that are pertinent to ensuring continuity of operations, how to plan for disaster, and how to use Log Shipping to ensure content is copied to a secondary farm to ensure accessibility and uptime.

SessionID: 13650

An Introduction to Master Data

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308

Speaker: Carlton Ramsey

Title: An Introduction to Master Data

Abstract:

This session will provide an introduction to Master Data. We will discuss what Master Data is and discuss Master Data Management. Master Data Management is the process of migrating data into a single source so that the information to be shared by multiple systems and applications in the organization. Merging data into this single source we can remove duplicates and improve data quality.

SessionID: 13651

How PowerShell helps me as a DBA

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314

Speaker: Carlton Ramsey

Title: How PowerShell helps me as a DBA

Abstract:

I will share some stories, discuss the Power of PowerShell and provide some example scipts.

SessionID: 13752

MicroORMs – Keeping Your DBA Happy

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB310

Speaker: Eric Kepes

Title: MicroORMs – Keeping Your DBA Happy

Abstract:

Developers like the reduced complexity and increased productivity that an ORM can bring while DBAs don't care for the data models that often result. Using an ORM with an existing data model is often a nightmare. But writing all of that data mapping code is such a pain! What if we could have a solution that gave us the best of both worlds and made the developers AND the DBAs happy? MicroORMs might be the answer. In this session, we’ll explore PetaPOCO, a MicroORM.

SessionID: 15503

Creating a Metadata Mart w/ SSIS - Data Governance

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308

Speaker: Ira Warren

Title: Creating a Metadata Mart w/ SSIS - Data Governance

Abstract:

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.

SessionID: 16031

Full-Text Search, it's not just for documents

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309

Speaker: Jay Holliday

Title: Full-Text Search, it's not just for documents

Abstract:

Full-text search is an often overlooked feature of SQL Server that can be used for more than searching documents. This session will cover setting up and using full-text search to handle some of those dirty data situations we've all inherited without using the dreaded "LIKE '%text%'". As an example, we will demonstrate how full-text search can be used to find names in poorly formatted data like 'mailing address' or 'billing address' fields. It will also cover how to handle noise words that may match some names and synonyms for first names to create a really robust solution that goes beyond what could be done with plain old SQL.

SessionID: 16174

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314

Speaker: Joseph D'Antoni

Title: SQL 2012 -- All About HA and DR

Abstract:

Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.

SessionID: 17699

Performance Tuning for Pirates

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314

Speaker: John Sterrett

Title: Performance Tuning for Pirates

Abstract:

If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.

SessionID: 19875

Communicate for Great Good!

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309

Speaker: Matt Velic

Title: Communicate for Great Good!

Abstract:

“No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. Blogging can land a book deal. In-house team lunch-and-learns can lead to community presentations. Most of all, good communication can be the skill that saves your job or opens the door to new horizons.

SessionID: 20043

Before You Optimize: Understanding Execution Plans

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309

Speaker: Tim Corey

Title: Before You Optimize: Understanding Execution Plans

Abstract:

You know what your query does, but do you know how it does it? Do you know what type of resources your query uses? Come to this session to find the answers to these questions and more as we walk through reading execution plans. We will see how SQL breaks down the execution of your query and what each step tells us about the overall query. If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.

SessionID: 20561

Defy the Defaults!

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314

Speaker: Mike Hillwig

Title: Defy the Defaults!

Abstract:

Installing SQL Server is easy, right? You just insert the install media, click Next a bunch of times, and you'll have a working database server in just a few minutes. At least that's what many of our non-DBA colleagues think. Not so fast, says veteran DBA Mike Hillwig. SQL Server has lots of default settings that can be potential performance killers, and we'll look at a bunch of them. These include things like where data files live, data file growth, basic security settings, and the services being installed. And while we're at it, we'll look at a bunch of the good defaults and talk about why they shouldn't be touched.

SessionID: 20562

Seven SQL Agent Jobs You Should be Running

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314

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

How Not to Be a Cranky DBA

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316

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

Top Development and Design Mistakes

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316

Speaker: Michael John

Title: Top Development and Design Mistakes

Abstract:

There are many mistakes made repeadedly that are never caught in the database design and subsequent development efforts that affect performance, logic, and casue pain for the DBA.

This session will point these issues out, and help you prevent and identify these issues.

SessionID: 21697

Spatial Data in SQL Server Reporting Services

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308

Speaker: Nate Locklin

Title: Spatial Data in SQL Server Reporting Services

Abstract:

This presentation will offer a tutorial for using maps in SQL Server 2012 Reporting Services reports. Sample applications and use of ESRI shapefiles will be included in the demonstration.

SessionID: 22973

Basic Monitoring with Perfmon

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316

Speaker: Rick Heiges

Title: Basic Monitoring with Perfmon

Abstract:

Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.

SessionID: 23117

Introduction to Data Quality Services

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316

Speaker: Rushabh Mehta

Title: Introduction to Data Quality Services

Abstract:

Data Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.

SessionID: 23828

14 New T-SQL Functions

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB310

Speaker: Sam Nasr

Title: 14 New T-SQL Functions

Abstract:

The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.

SessionID: 23829

Using Filetables

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309

Speaker: Sam Nasr

Title: Using Filetables

Abstract:

The FileStream feature was introduced with SQL Server 2008 allowing BLOBs to be managed by the DB. In 2012, FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system.

SessionID: 27043

Data center migration, data centric point of view

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB310

Speaker: Tony Scotto di Carlo

Title: Data center migration, data centric point of view

Abstract:

Data center migrations are all the rage these days and the SQL Server DBA is one of the most important accessories. When an organization decides to change data centers, of all the very important servers that will be migrated, the ones with the company data will be the most watched. Like other projects, a good plan followed by good execution is required. In this session you’ll learn about the research, design, planning, process, and execution to migrate SQL Servers from one DC to another. I’ll go over lessons learned, whether to go it alone or brings in help, discuss pros and cons of migration techniques, big decisions like keeping the same server names, when to and not to virtualize, downtime considerations, data sync, and more.

SessionID: 28337

MongoDB for the Relational DBA

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309

Speaker: Justin Dearing

Title: MongoDB for the Relational DBA

Abstract:

NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there's not RELATIONAL in DBA.

On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.

On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to.

SessionID: 8980

Introduction to SQL Server Service Broker

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308

Speaker: Adam Belebczuk

Title: Introduction to SQL Server Service Broker

Abstract:

In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.

SessionID: 9106

SQL Server 2012's Net-New BI Capabilities

Back to calendar

Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316

Speaker: A.J. Mee

Title: SQL Server 2012's Net-New BI Capabilities

Abstract:

Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including: · Power View · BI Semantic Model (BISM) · Data Quality Services · Master Data Management · Columnstore Index