sqlsathistory

Nr: 75

Back to Main list

SQLSaturday #75 - Columbus 2011

Start Time (24h) Speaker Track Title
00:00:00 Allen White Track 3 Let Service Broker Help You Scale Your Application
00:00:00 Allen White Track 4 Gather SQL Server Performance Data with PowerShell
00:00:00 Kevin Cross Track 2 Business SQL: Real World Analytics
00:00:00 Craig Purnell Track 2 Integrating SQL Server with Active Directory
00:00:00 Dave Rodabaugh Track 1 Backyard Grilling with Analysis Services
00:00:00 Louis Davidson Track 2 Characteristics of a Great Relational Database
00:00:00 Erin Stellato Track 4 Baseline Basics: Where to Start, What You Need
00:00:00 Eddie Wuerch Track 3 Find Performance Problems by Reading the Waits
00:00:00 Eddie Wuerch Track 4 TempDB Performance Troubleshooting and Optimizing
00:00:00 Jes Schultz Track 1 Reporting Services 201: From Basic To WOW!
00:00:00 Paul Hiles Track 3 Take Your Automation Scripts to the Next Level!
00:00:00 Paul Hiles Track 3 DMVs- What are they and why should a DBA care?
00:00:00 Rob Collie Track 1 PowerPivot: BI Massive Data Analysis for Humans
00:00:00 Sarah Barela Track 4 The 4-hour DBA: Automate, Audit and Relax
00:00:00 Sarah Barela Track 4 Build your own SQL Server Cloud
00:00:00 Sarah Barela Track 3 Oh, no! Disaster Strikes
00:00:00 Kevin Boles Track 2 SQL Server Partitioning from A to Z
00:00:00 Kevin Boles Track 2 SANs and SQL Server
00:00:00 William E Pearson III Track 1 Beyond Plateaux: Optimize SSAS via Best Practices
00:00:00 William E Pearson III Track 1 Getting Started with MDX

SessionID: 28931

Let Service Broker Help You Scale Your Application

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Allen White

Title: Let Service Broker Help You Scale Your Application

Abstract:

How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.

SessionID: 28933

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Allen White

Title: Gather SQL Server Performance Data with PowerShell

Abstract:

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 28961

Business SQL: Real World Analytics

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Cross

Title: Business SQL: Real World Analytics

Abstract:

For the Analytical Business User, we will explore some SQL syntax tricks and advanced techniques that will help you better take advantage of your application data. The goal of this session will be to learn how analytical functions, common table expressions and special keywords (e.g., PIVOT) can assist you in turning your data into useful business information! Furthermore, we will use Sales-based performance measure/trending style reports for our exploration of these tips...

SessionID: 29647

Integrating SQL Server with Active Directory

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Craig Purnell

Title: Integrating SQL Server with Active Directory

Abstract:

A discussion involving the various touch points between SQL Server and AD: ADSI - loading AD user information into

SQL Server for application integration; Registering SQL Server in AD for both browsing and replication; how to configure SQL Server to use Kerberos authentication; the use of service principal names on both server and client sides.

SessionID: 29988

Backyard Grilling with Analysis Services

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Dave Rodabaugh

Title: Backyard Grilling with Analysis Services

Abstract:

Like great grilling, great SSAS starts with fundamentals. We'll cook Rachel Ray's ingredients on the SSAS grill, showing all the basics for creating SSAS dimensions, measure groups, and performing basic calculations. Add a lettuce, tomato, mayonnaise, and you have a tasty cube!

SessionID: 30012

Characteristics of a Great Relational Database

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Louis Davidson

Title: Characteristics of a Great Relational Database

Abstract:

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be

SessionID: 30081

Baseline Basics: Where to Start, What You Need

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Erin Stellato

Title: Baseline Basics: Where to Start, What You Need

Abstract:

“The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Long-term collection and storage methods for data are reviewed to help you create a plan for building your own repository when you get back to the office on Monday. Tools covered include: Windows

SessionID: 30147

Find Performance Problems by Reading the Waits

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Eddie Wuerch

Title: Find Performance Problems by Reading the Waits

Abstract:

Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing!

SessionID: 30148

TempDB Performance Troubleshooting and Optimizing

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Eddie Wuerch

Title: TempDB Performance Troubleshooting and Optimizing

Abstract:

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill performance, including prevention, detection, and resolution of these problems.

SessionID: 30778

Reporting Services 201: From Basic To WOW!

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 1

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:

SessionID: 32207

Take Your Automation Scripts to the Next Level!

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Paul Hiles

Title: Take Your Automation Scripts to the Next Level!

Abstract:

DBA’s traditionally have a library of T-SQL scripts which they use in automating their job. PowerShell, Microsoft’s newest scripting language, can take those T-SQL scripts to the next level. PowerShell and the SMO (Server Management Objects) library allow a DBA to create scripts that will interact with the OS and SQL Server at the same time. In this session we reveal the power of automating SQL Server with PowerShell by reviewing a number of scripts that have been migrated from T-SQL to PowerShell. This session will include scripts that will backup databases, interrogate a server, and script out objects from a database.

SessionID: 32208

DMVs- What are they and why should a DBA care?

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Paul Hiles

Title: DMVs- What are they and why should a DBA care?

Abstract:

DMVs - Dynamic Management Views and Functions are the DBA’s looking glass into the internals of SQL Server. They will give a DBA a snapshot on how the database is performing and potential problem areas. In this session, we will review a number of DMVs describing the types of information that can be captures and how it might be used. This review will include index statistics, query performance, memory utilization to name a few.

SessionID: 32552

PowerPivot: BI Massive Data Analysis for Humans

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Rob Collie

Title: PowerPivot: BI Massive Data Analysis for Humans

Abstract:

The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :)

SessionID: 32781

The 4-hour DBA: Automate, Audit and Relax

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Sarah Barela

Title: The 4-hour DBA: Automate, Audit and Relax

Abstract:

Do you feel that you are overworked and always fighting fires and never can get ahead? In this session, I will help you identify what is important to your job and how to find the time to address those critical tasks. I will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores. The flip side of automation is auditing. Routine auditing your server is essential to avoid nasty surprises that can lead to a loss of control. We will create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office.

SessionID: 32783

Build your own SQL Server Cloud

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 4

Speaker: Sarah Barela

Title: Build your own SQL Server Cloud

Abstract:

There is no hotter term right now than cloud computing, however, exactly what this means is a mystery to many. We will begin by defining what cloud computing is and the benefits the technology offers the DBA. You may see the benefits of the cloud, but are not comfortable trusting your sensitive data to this nebulous cloud. The goal of this session is to provide you a blueprint to design and build your own SQL Server cloud, where you can control the server availability and performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud. In this session, I will show you how to use features like the resource governor, dynamic management views, policy based management and others to automate yo

SessionID: 32784

Oh, no! Disaster Strikes

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Sarah Barela

Title: Oh, no! Disaster Strikes

Abstract:

No matter how much we prepare, when disaster strikes we all feel a moment of panic. For some that panic quickly passes as we get down to work to fix the problem. For others the panic continues to grow as we search for a solution. Of course back up is crucial, but in this session I will provide useful real world best practices that will show how to recover from disaster and more importantly how to prepare for the inevitable. Specifically how to recover from common disaster scenarios. For example, what to do when the master database is corrupt, a drive array with half your database files fails, a hardware failure, a SQL injection attacks wipes out whole tables and many more.

SessionID: 33452

SQL Server Partitioning from A to Z

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Boles

Title: SQL Server Partitioning from A to Z

Abstract:

SQL Server Partitioning from A to Z

We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.

SessionID: 33454

SANs and SQL Server

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Boles

Title: SANs and SQL Server

Abstract:

Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability.

SessionID: 34220

Beyond Plateaux: Optimize SSAS via Best Practices

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: William E Pearson III

Title: Beyond Plateaux: Optimize SSAS via Best Practices

Abstract:

Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.

SessionID: 34225

Getting Started with MDX

Back to calendar

Event Date: 11-06-2011 - Session time: 00:00:00 - Track: Track 1

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.

This site is open source. Improve this page.