Nr: 129
SQLSaturday #129 - Rochester 2012
SessionID: 12042
Introducing Query Optimization
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: A
Speaker: Christopher Crane
Title: Introducing Query Optimization
Abstract:
SessionID: 12418
Replication- A fresh look peek behind the scenes
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: F
Speaker: David Benoit
Title: Replication- A fresh look peek behind the scenes
Abstract:
SessionID: 12698
SRS Report Builder for Business Intelligence
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: B
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: 14756
Top Tips for Writing Better T-SQL Queries
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: E
Speaker: Grant Fritchey
Title: Top Tips for Writing Better T-SQL Queries
Abstract:
SessionID: 14757
Common Backup Problems and How to Deal With Them
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: F
Speaker: Grant Fritchey
Title: Common Backup Problems and How to Deal With Them
Abstract:
SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore.
SessionID: 14760
Deadlocks and what to do about them
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: F
Speaker: Grant Fritchey
Title: Deadlocks and what to do about them
Abstract:
SessionID: 14761
What to Look for in Execution Plans
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: E
Speaker: Grant Fritchey
Title: What to Look for in Execution Plans
Abstract:
SessionID: 15684
Extend Your Knowledge with Extended Events!
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: D
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15685
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: D
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: 15686
Looney Tuner? No, there IS a method to my madness
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: D
Speaker: Janis Griffin
Title: Looney Tuner? No, there IS a method to my madness
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 15779
Fast Track to Spatial Reporting
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: D
Speaker: Jason Thomas
Title: Fast Track to Spatial Reporting
Abstract:
SSRS 2008 R2 has opened a new realm of reporting possibilities by including the spatial data support. By the end of this session, you should be familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps , creating squarified TreeMap reports and many more interesting tips and tricks revolving around them.
SessionID: 16790
Getting Started with Background Jobs in PowerShell
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: C
Speaker: Jeff Hicks
Title: Getting Started with Background Jobs in PowerShell
Abstract:
One of the great features in Windows PowerShell is the ability to push long runningPowerShell commands and scripts into the background and retrieve results later. This session will explain the requirements for jobs, how to create them, receive results and troubleshoot.
SessionID: 16791
PowerShell v3 WorkFlows
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: C
Speaker: Jeff Hicks
Title: PowerShell v3 WorkFlows
Abstract:
PowerShell has always made it easy to get a lot done with minimal effort. Now, in v3.0 it is even easier with longer running and more complicated tasks using workflow. This session will explain the magic behind the mystery and demonstrate how to create PowerShell workflows
SessionID: 16792
Jobs and Tasks in PowerShell 3.0
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: C
Speaker: Jeff Hicks
Title: Jobs and Tasks in PowerShell 3.0
Abstract:
PowerShell 3.0 offers a few ways to handle tasks and jobs that might need to run more than once or when certain conditions are met. This demo-heavy session will show how to use the new scheduled tasks cmdlets in PowerShell 3.0 and the new features of PowerShell's job infrastructure.
SessionID: 22477
But it worked great in Dev! Perfomance for Devs
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: D
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: 22479
Understanding SQL Server XML Features
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: C
Speaker: Randy Knight
Title: Understanding SQL Server XML Features
Abstract:
The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.
SessionID: 22480
Understanding Transaction Isolation Levels
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: C
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 23539
Discover the power of Visual Studio db projects
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: E
Speaker: Robert Schoedel
Title: Discover the power of Visual Studio db projects
Abstract:
SessionID: 23540
SQL 2012 Master Data Services (MDS)
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: E
Speaker: Robert Schoedel
Title: SQL 2012 Master Data Services (MDS)
Abstract:
Many business have sought to centralize and increase the efficiency of access to key domain data needed to run the business. This data is often mastered in different parts of the organization, is kept in different formats, and is subject to different revision policies and schedules.
SessionID: 26760
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: A
Speaker: Tim Costello
Abstract:
SessionID: 26762
Dimensional Design primer: What you need to know
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: A
Speaker: Tim Costello
Title: Dimensional Design primer: What you need to know
Abstract:
Everybody wants a data warehouse. What IS a data warehouse? How is it different from a data mart? Star Schema? Snowflakes? The dimensional bus? In this session we'll cover all the key concepts you need to know to better understand what a data warehouse is and how to start building one.
SessionID: 26763
Data Visualization primer: What you need to know
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: A
Speaker: Tim Costello
Title: Data Visualization primer: What you need to know
Abstract:
Anyone can make a bar chart. The tricky part is recognizing the right time to use a bar, line or shape in your viz. What makes a data visualization 'work' ? How do colors, size and proximity affect visual analysis? In this session we'll break down the 'need to know' parts of data visualization and arm you with the know how to go out there and build stunning, interactive dashboards that tell the story of your data.
SessionID: 26764
ELT: Old school data loading with tsql
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: A
Speaker: Tim Costello
Title: ELT: Old school data loading with tsql
Abstract:
The tide seems to be shifting from ETL (Extract Transform Load) to ELT (Extract Load Transform). In this session we'll talk about the best practices of ELT. We'll cover some t-sql design patterns that can help you get an ELT project going and a few tips to help you make that package more maintainable and easier to support.
SessionID: 27853
An Overview of PowerPivot
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: B
Speaker: William E Pearson III
Title: An Overview of PowerPivot
Abstract:
In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”
SessionID: 27855
Becoming DAX: An Introduction ...
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: B
Speaker: William E Pearson III
Title: Becoming DAX: An Introduction ...
Abstract:
SessionID: 27860
Getting Started with MDX
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: B
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
SessionID: 27862
Overcoming Barriers and Avoiding Mistakes with BI
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: B
Speaker: William E Pearson III
Title: Overcoming Barriers and Avoiding Mistakes with BI
Abstract:
A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.
SessionID: 34593
New High Availability options with SQL Server 2012
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: F
Speaker: Andy Roberts
Title: New High Availability options with SQL Server 2012
Abstract:
Introduction to new availability options in SQL Server 2012 including enhancements to Failover and the new AlwaysOn Availability Groups to provide multiple readable secondaries!
SessionID: 34594
The biggest and baddest SQL Installs in the World
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: F
Speaker: Andy Roberts
Title: The biggest and baddest SQL Installs in the World
Abstract:
What are the largest SQL Server OLTP and DW implementations in the world and how do they scale?
SessionID: 34595
SQL Server 2012 T-SQL Enhancements
Event Date: 12-05-2012 - Session time: 00:00:00 - Track: E
Speaker: Andy Roberts
Title: SQL Server 2012 T-SQL Enhancements
Abstract:
There are several interesting additions to T-SQL, this session will focus on what they are, why they were added to the product and how you can benefit from using them.