sqlsathistory

Nr: 94

Back to Main list

SQLSaturday #94 - Salt Lake City 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Ben Miller	Room 300	SQL Server PowerShell with SQLPSX
00:00:00	Jason Brimhall	Room 309	Getting to Know your DB
00:00:00	Carlos Bossy	Room 309	See the Future with Visual Predictive Analytics
00:00:00	Chad Crawford	Room 300	[Table Fission - An Introduction to Partition
00:00:00	David Eichner	Room 308	Business Intelligence with SRS Report Builder
00:00:00	Doug Lane	Room 308	Devs are from Mars, Report Servers are from Venus
00:00:00	Gabriel Villa	Room 308	SQL Server Security and Intrusion Prevention
00:00:00	Jason Horner	Room 302	Totally Tabular – Exploring Denali SSAS Features
00:00:00	Marc Beacom	Room 309	Introduction to Integration Services
00:00:00	Michael Fal	Room 309	Managing and Auditing SQL Server Permissions
00:00:00	Mitchell Bottel	Room 302	Want a promotion? It’s up to you!
00:00:00	Mitchell Bottel	Room 302	Easily Manage your Servers with CMS and PMB
00:00:00	Martin Miller	Room 308	Index Management
00:00:00	Paul Turley	Room 309	Visual Report Design: Bringing Sexy Back
00:00:00	Randy Knight	Room 302	Understanding SQL Server XML Features
00:00:00	Randy Knight	Room 300	But it worked great in Dev! Performance for Devs
00:00:00	Jeff Renz	Room 309	Parallel Processing Database Architecture
00:00:00	Scott Golightly	Room 308	.NET for the DBA
00:00:00	Pat Wright	Room 300	MySQL Vs SQL Server Are they really different?
00:00:00	Christopher Shaw	Room 300	Utility Database
00:00:00	TJay Belt	Room 300	Documentation – you know you love it
00:00:00	TJay Belt	Room 302	Data File Sizes – How much is enough, if you don’t
00:00:00	William E Pearson III	Room 302	Attribute Discretization in Analysis Services (BI)
00:00:00	William E Pearson III	Room 308	Beyond Plateaux: Optimize SSAS with Best Practices

SessionID: 29012

SQL Server PowerShell with SQLPSX

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 300

Speaker: Ben Miller

Title: SQL Server PowerShell with SQLPSX

Abstract:

Everyone wants to be in the on the PowerShell sweetness, right? This session will cover in depth the options that you have for using PowerShell with a set of modules that already exist in a very robust package. SQLPSX is the name and it is diverse but powerful. From Database backup, to database maintenance and index maintenance, SQLPSX is there for you. Join me for a power packed session and get up to speed really fast in SQL PowerShell.

SessionID: 29287

Getting to Know your DB

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 309

Speaker: Jason Brimhall

Title: Getting to Know your DB

Abstract:

In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster.

SessionID: 29405

See the Future with Visual Predictive Analytics

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 309

Speaker: Carlos Bossy

Title: See the Future with Visual Predictive Analytics

Abstract:

Expand the value of your Business Intelligence infrastructure by delivering powerful forecasts and predictions using SQL Server Reporting Services visual capabilities. Using proven predictive models that forecast future buying patterns, foster care placement success, or customer income and net worth, you will see how to create appealing charts, graphs and maps that allow business users to include predictive analytics in their decision making process. In this session, Carlos Bossy will show you how to combine the visual features of SQL Server Reporting Services with the power of Data Mining and Analysis Services to take your organization’s BI competency to the next level.

SessionID: 29435

Table Fission - An Introduction to Partition|ing

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 300

Speaker: Chad Crawford

Title: Table Fission - An Introduction to Partition|ing

Abstract:

Partitioning technology distributes data in a single table among several individual filegroups. When implemented carefully, this allows DBAs to instantaneously move large amounts of data from one table to another. After this session, attendees will understand how partitioning works, when it is beneficial, and how to implement a basic setup. We will also illustrate partitioning in a practical "sliding window" demonstration. This will be a broad, high-level introduction to the technology.

SessionID: 29770

Business Intelligence with SRS Report Builder

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 308

Speaker: David Eichner

Title: Business Intelligence with SRS Report Builder

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

Devs are from Mars, Report Servers are from Venus

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 308

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 just hasn't been the same. You've been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you're even thinking about seeing other reporting products (!) In this session made for report developers, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven't been listening), and demonstrating some new -- and easy -- tricks you may not have known RS can do. After this session, you'll want to spend some time alone with your new old flame.

SessionID: 30173

SQL Server Security and Intrusion Prevention

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 308

Speaker: Gabriel Villa

Title: SQL Server Security and Intrusion Prevention

Abstract:

Is your data secured? Are you a victim of SQL Injection? You'll discover some commonly overlooked practices in securing your SQL Server databases. Learn about physical security, passwords, privileges and roles, and preventative best practices. I'll demonstrate auditing and we will take a quick look at some .Net code samples to use on your applications. Get up to speed on the new security features in "Denali", the next version of SQL Server. Takeaway the 20/20 vision to identify SQL Injection and other database vulnerabilities and how to prevent them.

SessionID: 30509

Totally Tabular – Exploring Denali SSAS Features

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 302

Speaker: Jason Horner

Title: Totally Tabular – Exploring Denali SSAS Features

Abstract:

This session provides an overview of the new tabular modeling features introduced in SQL Server CTP 3 code name "Denali". We will look at some of the key concepts in tabular model design including: relationships, calculated columns, measures, KPIs, and hierarchies.

SessionID: 31545

Introduction to Integration Services

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 309

Speaker: Marc Beacom

Title: Introduction to Integration Services

Abstract:

Just getting started with SQL Server Integration Services (SSIS)? Not sure where to start? Or have you been using SSIS for a little while now and are still trying to figure out the basics. The biggest barrier to learning something new is figuring out the first few steps. We will discuss what SSIS is, some lessons learned and some new features that are around the corner with the release of Denali.

SessionID: 31824

Managing and Auditing SQL Server Permissions

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 309

Speaker: Michael Fal

Title: Managing and Auditing SQL Server Permissions

Abstract:

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.

SessionID: 31924

Want a promotion? It’s up to you!

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 302

Speaker: Mitchell Bottel

Title: Want a promotion? It’s up to you!

Abstract:

Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career without looking like “That Guy”. We will discuss Social Medias, communities, volunteering and other ways to get your name out… What are the first steps? Come find out.

SessionID: 31925

Easily Manage your Servers with CMS and PMB

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 302

Speaker: Mitchell Bottel

Title: Easily Manage your Servers with CMS and PMB

Abstract:

In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.

SessionID: 31954

Index Management

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 308

Speaker: Martin Miller

Title: Index Management

Abstract:

This session will look at the basics of indexes in SQL Server, and will discuss strategies and techniques for managing indexes in large databases with high uptime requirements, including how to automate online and offline index maintenance operations, and how to collect and analyze index usage statistics to see which ones are helping your database's performance, and which ones are hurting it.

SessionID: 32167

Visual Report Design: Bringing Sexy Back

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 309

Speaker: Paul Turley

Title: Visual Report Design: Bringing Sexy Back

Abstract:

Do your users have the same old, mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns, best practices and visuals that pack more usable information into fewer, more usable reports. Use Reporting Services and other Microsoft BI tools to create dynamic, browse-able reports that answer important business questions at a glance and then let them explore the details to gain business insight and take action.

Sure, Business Intelligence is all the rage but you don’t have to invest in an entire BI platform to have fresh, usable reports. These design techniques apply to enterprise analytic solutions and smaller-scale operational reporting.

SessionID: 32382

Understanding SQL Server XML Features

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 302

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

But it worked great in Dev! Performance for Devs

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 300

Speaker: Randy Knight

Title: But it worked great in Dev! Performance 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: 32490

Parallel Processing Database Architecture

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 309

Speaker: Jeff Renz

Title: Parallel Processing Database Architecture

Abstract:

If you want to architect a parallel processing system, Data Vault should be your preferred architecture. In this session I will introduce you to the Data Vault design pattern and demonstrate the major performance advantages of this architecture. Data Vault hub, link and satellite tables allow for vertical and horizontal partitioning of data. When properly implemented, your database tables will provide the most index coverage of any indexing system and provide the fastest possible disk scan access. I will provide a real world example of a parallel manufacturing execution system that we developed at Abound Solar which implements the Data Vault architecture.

SessionID: 32816

.NET for the DBA

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 308

Speaker: Scott Golightly

Title: .NET for the DBA

Abstract:

With the introduction of SQL CLR DBAs are being thrust into the world of .NET. This session wil look at the basics of .NET and relate them to equivalent concepts in T-SQL. This session will help you to decipher the code that you are being asked to review so you can decide if it meets your quality bar before you apply it to your database.

SessionID: 33027

MySQL Vs SQL Server Are they really different?

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 300

Speaker: Pat Wright

Title: MySQL Vs SQL Server Are they really different?

Abstract:

I hear all the time that someone should upgrade from MySQL to SQL Server. Is it really an upgrade or just the same animal with a different face, we will discuss the differences between the engines, tools, administration and indexes. If you’d like to really find out how similar these two animals are you won’t want to miss this.

SessionID: 33128

Utility Database

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 300

Speaker: Christopher Shaw

Title: Utility Database

Abstract:

If you were asked what average runtime was of your slowest stored procedure, could you provide the answer? What if you needed to provide that information for last month? Do you review your error logs each day? Do you know the growth percentages of your databases for the past year or even the past month? If your database has an unusual growth event will you know about it?

In the utility database that we create during this session we will track stored procedure information along with information about the hard drives such as free space. We will look at how you can have the errors in your error logs emailed to you each day. The goal of this session is to help you automate and centralize as many of your day-to-day tasks as you can.

SessionID: 33679

Documentation – you know you love it

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 300

Speaker: TJay Belt

Title: Documentation – you know you love it

Abstract:

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge. Some of the documents and processes we will review are:

SessionID: 33680

Data File Sizes – How much is enough, if you don’t

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 302

Speaker: TJay Belt

Title: Data File Sizes – How much is enough, if you don’t

Abstract:

We often run a fine line between how much space we need, and how much space we have for our databases. Having too much drive space can be a waste of resources; however, running out of space is an obvious issue. Let’s find a way to straddle the line and determine just how much space we really need, give ourselves a bit more than that, and make it a regular process to baseline, then continue to monitor, make adjustments along the way if needed, and ultimately plan for just enough space to get us through the year on budget.

We’ll talk about a stand-alone tool that I used to determine space use for baseline, continued monitoring of the space used, and ensuring we have enough but not too much space.

SessionID: 34018

Attribute Discretization in Analysis Services (BI)

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 302

Speaker: William E Pearson III

Title: Attribute Discretization in Analysis Services (BI)

Abstract:

Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson discusses the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.

SessionID: 34020

Beyond Plateaux: Optimize SSAS with Best Practices

Back to calendar

Event Date: 10-09-2011 - Session time: 00:00:00 - Track: Room 308

Speaker: William E Pearson III

Title: Beyond Plateaux: Optimize SSAS with 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.

This site is open source. Improve this page.