Nr: 104
SQLSaturday #104 - Colorado Springs 2012
SessionID: 29005
Your own Private Cloud for SQL
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Ben DeBow
Title: Your own Private Cloud for SQL
Abstract:
Can SQL Server be offered as a service (SQLaaS) in your own private cloud? Can it provide application teams with the ability to easily procure an instance of SQL Server quickly? You may have some elements of this created in your environment but how do you create the full service offering? Creating a SQLaaS offering is a lot easier than you think and many companies are now ready for this change. In this session, you will learn how to design a SQL Server service offering for the Private Cloud that will enable your organization to react faster to the increasing project demands.
SessionID: 29044
Kama Sutra of SSIS: A guide to loving ETL
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
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: 29421
Using Columnstore Indexes in SQL Server 2012
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Carlos Bossy
Title: Using Columnstore Indexes in SQL Server 2012
Abstract:
SessionID: 29585
Backup Basics - Know your options
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Meredith Ryan-Smith
Title: Backup Basics - Know your options
Abstract:
Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.
SessionID: 29657
SQL Azure: Future-Proofing Your SQL Career
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Chris Randall
Title: SQL Azure: Future-Proofing Your SQL Career
Abstract:
SQL Azure's not just coming; it's here. In your role as the local expert on all-things-SQL-Server, you will need to know how to talk intelligently about it. You may also want to be able to whip up an impromptu SQL Azure demo for co-workers and decision makers. This demo-heavy session will help get you to that point.
We'll look at what kind of usage scenarios work best for SQL Azure. We'll look at what SQL Azure does, and what it doesn't do. We walk through the process of creating, loading and querying databases, at what management tools are available, and how you will create and manage your account. We'll explore what cost-efficient ways there are for an individual to get access, and how to monitor the costs on an ongoing basis.
SessionID: 29794
SQL Report Builder for Business Intelligence
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: David Eichner
Title: SQL Report Builder for Business Intelligence
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users to create charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.
SessionID: 29975
Devs are from Mars, Report Servers are from Venus
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Doug Lane
Title: Devs are from Mars, Report Servers are from Venus
Abstract:
Do you remember what it was like to fall in love? Wasn't it wonderful?
Lately it hasn't been the same. There's no spark anymore. You've been stuck doing the same old charts and tables. Maybe Reporting Services won't tell you what's wrong, and you're even thinking about seeing other reporting products.
In this session, Doug will re-ignite your passion for RS by reminding you how reports perform best, what RS has been trying to tell you (but you haven't been listening), and show you some new -- and easy -- tricks you may not have known RS can do. You'll leave knowing more about troubleshooting with the execution log views, understanding how to design reports for high performance, how to deal with blank pages, and more.
SessionID: 30273
7 Ways to Fix Bad Parameter Sniffing
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Grant Fritchey
Title: 7 Ways to Fix Bad Parameter Sniffing
Abstract:
SessionID: 30499
PowerShell for the Reluctant DBA / Developer
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Jason Horner
Title: PowerShell for the Reluctant DBA / Developer
Abstract:
This presentation will provide a brief overview of how to get started with powershell and will be demo intensive.
Demo topics will include common challenges that database professional's face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices.
SessionID: 30820
GASP Real-time user defined sets in SSAS
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Josh Fennessy
Title: GASP Real-time user defined sets in SSAS
Abstract:
This session will highlight some of the power of SharePoint lists, third party SSIS providers, and many-to-many relationships in SSAS cubes. Additionally, the flexibilty of this solution will be shown though the use of several different user reporting tools.
SessionID: 30839
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Jim Murphy
Title: AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.
SessionID: 30900
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Joe Sack
Abstract:
While a SQL Server consultant may encounter various one-off situations over the course of a career, there are also several patterns and scenarios which repeat themselves with only minor variations. In this presentation Joe Sack will walk through common scenarios based on his experiences as a field engineer at Microsoft and also as a consultant with SQLskills.
SessionID: 30993
Reporting DBs behind Virtual IP's
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: John Halunen Aubra Moore
Title: Reporting DBs behind Virtual IP's
Abstract:
Tips, tricks and architecture options to successfully use Virtual IP's to give your users 100% reporting database uptime with a minimum of pain (and most importantly, learn from our mistakes, its much easier). This session describes how we used VIP's (virtual IP's) to present 10TB of datawarehouse to thousands of users to run user generated reports 24x7x365 with good maintenance and recoverability practices.
SessionID: 31136
Discovering the Plan Cache
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Strate
Title: Discovering the Plan Cache
Abstract:
SessionID: 31184
Database Design Contentious Issues
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 31560
Introduction to Data Warehousing
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Marc Beacom
Title: Introduction to Data Warehousing
Abstract:
Just starting or thinking of starting a data warehousing project but not sure where to begin. Or still not sure if your organization needs a data warehouse. This discussion is geared towards answering the what and why (or why not) of data warehousing.
SessionID: 31723
PowerShell and VBScript for the DBA
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Mark Halstead
Title: PowerShell and VBScript for the DBA
Abstract:
There are times when T-SQL, DMV's and system tables can't tell you what you need to know or do what you need to do. Knowing the basics of PowerShell VBScript can provide functionality when you need to work "outside of the box".
SessionID: 31826
Eating the Elephant: SQL Server Table Partitioning
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Michael Fal
Title: Eating the Elephant: SQL Server Table Partitioning
Abstract:
Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.
SessionID: 31862
ETL as MDM
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Michael Sexton
Title: ETL as MDM
Abstract:
SessionID: 32432
But it worked great in Dev! Perfomance for Devs
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
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: 33075
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Thomas LaRock
Abstract:
SessionID: 33316
Development Mise en Place
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Keith Tate
Title: Development Mise en Place
Abstract:
Chefs and cooks have a process called mise en place (MEEZ ohn plahs) which translates to "put in place". For cooks this means "organize and prepare" their stations. They have everything they need ready and in the right place. It also means to remove all distractions.
In this session I will show how developers and DBAs can use this method to better organize their time and efforts to get more done with less rework.
SessionID: 33326
To the Cloud and Back Again!
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Ted Malone
Title: To the Cloud and Back Again!
Abstract:
This session will discuss developing applications that make use of SQL Azure databases, and will address some of the challenges of off-premise data. This session will also discuss developing Windows Azure applications that take advantage of on-premise databases and the various security mechanisms that are involved. Attendees will learn how hybrid cloud solutions are architected and built. Attendees will also learn about the various security implications of cloud and on-premises data applications.
SessionID: 33572
Dimenional Modeling 101
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Thomas LeBlanc
Title: Dimenional Modeling 101
Abstract:
This session is going to help create a dimensional Data Mart from the AdventoureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications. A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting.
SessionID: 33674
The Periodic Table of Dynamic Management Objects
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Tim Ford
Title: The Periodic Table of Dynamic Management Objects
Abstract:
SessionID: 33700
PBM and you!
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Thomas Norman
Title: PBM and you!
Abstract:
SessionID: 33799
Predictive Analytics - You Can, Too!
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: Troy Ketsdever
Title: Predictive Analytics - You Can, Too!
Abstract:
Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…
SessionID: 33821
Edge Case Testing for the Database Professional
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: Vicky Harp
Title: Edge Case Testing for the Database Professional
Abstract:
SessionID: 34358
PowerPivot for Excel
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: PowerPivot for Excel
Abstract:
Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities.
SessionID: 34818
10 Things That Every DBA Should Know!
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV
Speaker: John Morehouse
Title: 10 Things That Every DBA Should Know!
Abstract:
Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand.