sqlsathistory

Nr: 81

Back to Main list

SQLSaturday #81 - Birmingham 2011

Start Time (24h) Speaker Track Title
00:00:00 Aaron Nelson Level 400 Quickly Gather Performance Data with PowerShell
00:00:00 Aaron Nelson Level 400 New PowerShell features in SQL Denali
00:00:00 Alex Tocitu Level 200 .NET in SQL for the DBA
00:00:00 Alex Tocitu Level 300 PowerShell and SQL for the DBA
00:00:00 Andy Warren Level 100 Building a Professinal Development Plan
00:00:00 Andy Warren Level 100 Introduction to SQL Server Statisics
00:00:00 Louis Davidson Level 200 Database Design Fundamentals
00:00:00 Louis Davidson Level 200 Characteristics of a Great Relational Database
00:00:00 Geoff Hiten Level 500 SQL “Denali” AlwaysOn High Availability Solutions
00:00:00 Janis Griffin Level 400 SQL Server on VMware
00:00:00 Janis Griffin Level 200 Looney Tuner? No, there IS a method to my madness
00:00:00 Janis Griffin Level 400 Performance Management – 2008 MDW - How Why
00:00:00 Jarrett Vance Level 300 Entity Framework 4.1 Code First
00:00:00 John Welch Level 200 Do More (ETL) with Less (Effort) - Automating SSIS
00:00:00 John Welch Level 500 Handling Advanced Data Warehouse Scenarios in SSIS
00:00:00 Ken Simmons Level 200 Enforcing Compliance With Policy-Based Management
00:00:00 Chris Eargle Level 100 Fundamental OOP with C#
00:00:00 Nathan Mourfield Level 100 SQL Developer's Intro to SSAS
00:00:00 Rob Volk Level 400 Revenge: The SQL!
00:00:00 Rob Schoenborn Level 500 Olap Security using AS Stored Procedures
00:00:00 Sven Aelterman Level 300 What's New in SQL Server "Denali" - For Developers
00:00:00 Sven Aelterman Level 300 Entity Framework v4.1: What's New in 2011
00:00:00 Sven Aelterman Level 500 Storing BLOBs in SQL Server using FILESTREAM
00:00:00 Kevin Boles Level 300 SQL Server Partitioning from A to Z
00:00:00 Kevin Boles Level 500 Transaction Log Deep Dive
00:00:00 Kevin Boles Level 500 File IO Stalls and Wait Stats: Tune Like a Guru!!
00:00:00 Tim Radney Level 300 It's TEMPDB Why Should You Care
00:00:00 Tim Radney Level 100 You inherited a database, now what?
00:00:00 William E Pearson III Level 400 Design and Implement BI Like Edison!
00:00:00 William E Pearson III Level 100 Getting Started with MDX

SessionID: 28381

Quickly Gather Performance Data with PowerShell

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 400

Speaker: Aaron Nelson

Title: Quickly Gather Performance Data with PowerShell

Abstract:

Continuously gathering performance data to log history and developing a performance baseline is a really important task in any environment. Having quick access to what’s happening right now is equally important. In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info. We’ll also take a look at how to Visualize the data using charts.

SessionID: 28383

New PowerShell features in SQL Denali

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 400

Speaker: Aaron Nelson

Title: New PowerShell features in SQL Denali

Abstract:

This session will cover the new features of PowerShell in SQL Denali. The new module for SQL Server, the new module for SSAS, and the new Replica cmdlets for High Availability databases.

SessionID: 28577

.NET in SQL for the DBA

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 200

Speaker: Alex Tocitu

Title: .NET in SQL for the DBA

Abstract:

This talk will go over some of the best practices of software engineering as they apply to SQL Server CLR projects. We will also show how to build a small library of utilities, stored procedures, functions, etc., that should help you remove some of SQL Server built-in functional barriers.

SessionID: 28578

PowerShell and SQL for the DBA

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 300

Speaker: Alex Tocitu

Title: PowerShell and SQL for the DBA

Abstract:

SessionID: 28705

Building a Professinal Development Plan

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 100

Speaker: Andy Warren

Title: Building a Professinal Development Plan

Abstract:

A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.

SessionID: 28706

Introduction to SQL Server Statisics

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 100

Speaker: Andy Warren

Title: Introduction to SQL Server Statisics

Abstract:

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.

SessionID: 30014

Database Design Fundamentals

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 200

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).

SessionID: 30015

Characteristics of a Great Relational Database

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 200

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

SQL “Denali” AlwaysOn High Availability Solutions

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 500

Speaker: Geoff Hiten

Title: SQL “Denali” AlwaysOn High Availability Solutions

Abstract:

AlwaysOn is the new High Availability branding for Microsoft SQL Server that combines the best in Clustering, Mirroring, and Log Shipping for a simple, seamless experience. See what Microsoft is building into SQL Server Codename “Denali” and how you can plan for this new way to increase database availability in your shop.

SessionID: 30456

SQL Server on VMware

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 400

Speaker: Janis Griffin

Title: SQL Server on VMware

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

Looney Tuner? No, there IS a method to my madness

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 200

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

Performance Management – 2008 MDW - How Why

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 400

Speaker: Janis Griffin

Title: Performance Management – 2008 MDW - How Why

Abstract:

Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools.

SessionID: 30488

Entity Framework 4.1 Code First

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 300

Speaker: Jarrett Vance

Title: Entity Framework 4.1 Code First

Abstract:

EF Code First provides an elegant and powerful way to work with data. In this session, we will learn how to mark up our model with metadata, automatically generate a database, and efficiently query for objects using LINQ. You will learn why the code-only approach of the library means that model layers end up being flexible and easy to customize.

SessionID: 30973

Do More (ETL) with Less (Effort) - Automating SSIS

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 200

Speaker: John Welch

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Abstract:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

SessionID: 30975

Handling Advanced Data Warehouse Scenarios in SSIS

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 500

Speaker: John Welch

Title: Handling Advanced Data Warehouse Scenarios in SSIS

Abstract:

So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.

SessionID: 31292

Enforcing Compliance With Policy-Based Management

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 200

Speaker: Ken Simmons

Title: Enforcing Compliance With Policy-Based Management

Abstract:

As the demand for data keeps growing and security and compliance keep tightening, the role of the DBA has become an increasingly critical part of maintaining compliance within the organization. This session will cover real world examples you can use with Policy-Based Management to ensure you have the proper server configuration and security settings in place along with the appropriate encryption and auditing options for your environment.

SessionID: 31468

Fundamental OOP with C#

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 100

Speaker: Chris Eargle

Title: Fundamental OOP with C#

Abstract:

Do you want to learn or have a refresher on the fundamentals of object-oriented programming and C#? This session is perfect for the DBA who must occasionally code and the developer who wants a deeper understanding of C# and OOP.

SessionID: 32092

SQL Developer's Intro to SSAS

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 100

Speaker: Nathan Mourfield

Title: SQL Developer's Intro to SSAS

Abstract:

This session covers a basic overview of SSAS in 08. The session will go over how cube and dimensions are build and developed, basic data mining, and the other information SQL Devs and Data Analysts need to know moving into Analysis Services.

SessionID: 32590

Revenge: The SQL!

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 400

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!

SessionID: 32675

Olap Security using AS Stored Procedures

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 500

Speaker: Rob Schoenborn

Title: Olap Security using AS Stored Procedures

Abstract:

The demand is increasing for analytical data on the web for dashboards and ad-hoc analysis. Companies are using this data to provide immediate insight into their business. Data as a service model requires that users can only access the data they have permission to use. This session discusses a method of using an Analysis Services Stored Procedure to secure both dimensions and measures in SQL Analysis Services based on Security Authentication from either Performance Point, Share Point or via Excel Web Services (MSMDPUMP) layer. This mechanism can also be extended to provide custom application security to a SSAS cubes.

SessionID: 33285

What's New in SQL Server "Denali" - For Developers

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 300

Speaker: Sven Aelterman

Title: What's New in SQL Server "Denali" - For Developers

Abstract:

Currently in CTP1, the next version of SQL Server, codename "Denali", offers several new features and improvements. This session will cover the ones that are most of interest to application developers, including enhancements to FILESTREAM, T-SQL and developers tools (including SSIS).

SessionID: 33288

Entity Framework v4.1: What's New in 2011

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 300

Speaker: Sven Aelterman

Title: Entity Framework v4.1: What's New in 2011

Abstract:

Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a "code only" approach, which has many benefits, including for testability and long-term evolution of your code.

SessionID: 33289

Storing BLOBs in SQL Server using FILESTREAM

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 500

Speaker: Sven Aelterman

Title: Storing BLOBs in SQL Server using FILESTREAM

Abstract:

SessionID: 33459

SQL Server Partitioning from A to Z

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 300

Speaker: Kevin Boles

Title: SQL Server Partitioning from A to Z

Abstract:

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

Transaction Log Deep Dive

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 500

Speaker: Kevin Boles

Title: Transaction Log Deep Dive

Abstract:

Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.

SessionID: 33461

File IO Stalls and Wait Stats: Tune Like a Guru!!

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 500

Speaker: Kevin Boles

Title: File IO Stalls and Wait Stats: Tune Like a Guru!!

Abstract:

When you know how to find out WHAT your queries are waiting on you get a very good clue about how to fix them - or help the server as a whole in many cases. Lots of stuff here you will want to put in your bag of tuning tricks! I could be putting myself out of work teaching stuff like this! :-D

SessionID: 33609

It's TEMPDB Why Should You Care

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 300

Speaker: Tim Radney

Title: It's TEMPDB Why Should You Care

Abstract:

TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.

SessionID: 33610

You inherited a database, now what?

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 100

Speaker: Tim Radney

Title: You inherited a database, now what?

Abstract:

You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to.

SessionID: 34158

Design and Implement BI Like Edison!

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 400

Speaker: William E Pearson III

Title: Design and Implement BI Like Edison!

Abstract:

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

SessionID: 34161

Getting Started with MDX

Back to calendar

Event Date: 30-07-2011 - Session time: 00:00:00 - Track: Level 100

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.