Nr: 171
SQLSaturday #171 - Pittsburgh 2012
SessionID: 11771
So I started this blog... now what?
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
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
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:
SessionID: 12035
Upgrade Roadmap: Let’s delve into SQL Server 2012
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
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
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:
SessionID: 13229
Code Tuning- Introduction to Execution Plans
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB309
Speaker: Konstatin Melamud
Title: Code Tuning- Introduction to Execution Plans
Abstract:
SessionID: 13370
SharePoint COOP Using 2008R2 Log Shipping
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
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308
Speaker: Carlton Ramsey
Title: An Introduction to Master Data
Abstract:
SessionID: 13651
How PowerShell helps me as a DBA
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
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
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB308
Speaker: Ira Warren
Abstract:
SessionID: 16031
Full-Text Search, it's not just for documents
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
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
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314
Speaker: John Sterrett
Abstract:
SessionID: 19875
Communicate for Great Good!
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
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!
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB314
Speaker: Mike Hillwig
Title: Defy the Defaults!
Abstract:
SessionID: 20562
Seven SQL Agent Jobs You Should be Running
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
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
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316
Speaker: Michael John
Title: Top Development and Design Mistakes
Abstract:
This session will point these issues out, and help you prevent and identify these issues.
SessionID: 21697
Spatial Data in SQL Server Reporting Services
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
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316
Speaker: Rick Heiges
Title: Basic Monitoring with Perfmon
Abstract:
SessionID: 23117
Introduction to Data Quality Services
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Room AB316
Speaker: Rushabh Mehta
Title: Introduction to Data Quality Services
Abstract:
SessionID: 23828
14 New T-SQL Functions
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
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
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
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
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
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