sqlsathistory

Nr: 38

Back to Main list

SQLSaturday #38 - Jacksonville 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Nelson	1406	PowerShell for the Data Professional
00:00:00	Aaron Nelson	1202 (Auditorium)	Virtualize This!
00:00:00	Adam Jorgensen	Business Intelligence -1102	Introduction to SharePoint 2010 BI and PowerPivot
00:00:00	Andy Warren	1400	Introduction to Statistics
00:00:00	Brian Knight	Business Intelligence -1102	Iron Chef Competition: Loading a Data Warehouse
00:00:00	Brian McDonald	Business Intelligence -1102	Introduction to SQL Server Reporting Services 2008
00:00:00	Bradley Schacht	Business Intelligence -1102	Introduction to SQL Server Integration Services
00:00:00	Brandie Tarvin	1404	T-SQL 102: Aliases and Table Joins
00:00:00	Sumeet Bansal	1406	Accelerating SQL with Solid State Technology
00:00:00	Dean Richards	1202 (Auditorium)	Response Time Analysis of SQL Server Performance
00:00:00	Dean Richards	1402	Tuna Helper for SQL Server DBA's
00:00:00	Eric Humphrey	1400	High Anxiety with ORMs
00:00:00	Eric Wisdahl	1402	SSIS Configurations, Expressions and Constraints
00:00:00	Eric Wisdahl	1406	An Introductory Look at Execution Plans
00:00:00	Michael Flora	Business Intelligence -1102	Mini - SSIS for the DBA
00:00:00	Mustika Nengah	1404	Accessing Cube using ADOMD.NET
00:00:00	Jeff Cole	1400	Heterogeneous Data Integration with SSIS CDC
00:00:00	Jonathon Moorman	1406	Basics of Sql Server Profiler
00:00:00	Jonathon Moorman	1402	Everything you wanted to know about IDENTITY colum
00:00:00	Jorge Segarra	1404	SQL University 101: Starting the SQL Journey
00:00:00	Jorge Segarra	1400	Policy-Based Management: Administration Made Easy
00:00:00	Devin Knight	Business Intelligence -1102	Introduction to Data Warehousing
00:00:00	Mike Davis	Business Intelligence -1102	Building your First Cube in Analysis Services 2008
00:00:00	Michael Antonovich	1406	XML 101 for the SQL Developer
00:00:00	Michael Antonovich	1406	Publishing Access Applications to SharePoint
00:00:00	Troy Gallant	1404	Introduction to Transactional Replication
00:00:00	Plamen Ratchev	1202 (Auditorium)	Common SQL Programming Mistakes
00:00:00	Plamen Ratchev	1202 (Auditorium)	Refactoring SQL for Performance
00:00:00	Jared Nielsen	1402	SQL and SEO - Database Design and Web Marketing
00:00:00	Robby Robertson	1402	SSIS Deployment Strategies
00:00:00	Rodney Landrum	1202 (Auditorium)	Demystyfying SQL Code and Object Deployments
00:00:00	Shawn Harrison	1404	Using Parameters in SSRS
00:00:00	Shawn McGehee	1404	SQL Server 2008 Resource Governor
00:00:00	Steve Schneider	1400	Encryption How-To 101
00:00:00	Timothy McAliley	1400	ITIL V3 for the Database Administrator
00:00:00	Elijah Baker	1202 (Auditorium)	Table Partitioning: The Basics
00:00:00	Vikas Hawaldar	1402	Introduction to Data Mining using SQL 2008

SessionID: 28389

PowerShell for the Data Professional

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1406

Speaker: Aaron Nelson

Title: PowerShell for the Data Professional

Abstract:

In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet using PowerShell.

SessionID: 28390

Virtualize This!

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1202 (Auditorium)

Speaker: Aaron Nelson

Title: Virtualize This!

Abstract:

With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop

SessionID: 28512

Introduction to SharePoint 2010 BI and PowerPivot

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Adam Jorgensen

Title: Introduction to SharePoint 2010 BI and PowerPivot

Abstract:

Lets take your BI implementation to the next level with SharePoint 2010 BI and PowerPivot. We'll go through excel services, performancepoint services, and pulling it all together in SharePoint 2010.

SessionID: 28730

Introduction to Statistics

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1400

Speaker: Andy Warren

Title: Introduction to Statistics

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

Iron Chef Competition: Loading a Data Warehouse

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Brian Knight

Title: Iron Chef Competition: Loading a Data Warehouse

Abstract:

In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You'll see a battle between two SSIS experts (Brian Knight and Adam Jorgensen), attempting to load the data warehouse the best way. You'll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition.

SessionID: 29277

Introduction to SQL Server Reporting Services 2008

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Brian McDonald

Title: Introduction to SQL Server Reporting Services 2008

Abstract:

SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this introductory session, I will cover topics like:

• What is reporting services and what can it be used for?
• New Features included in 2008 R2
• Architectural Overview
• Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access.

SessionID: 29334

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Bradley Schacht

Title: Introduction to SQL Server Integration Services

Abstract:

This session will get you past the learning curve of SSIS. Brad covers creating an end to end package that covers many of the concepts in SSIS. He covers, looping over a set of files, processing each file and then archiving. This session will be great for anyone who is a beginner to SSIS.

SessionID: 29341

T-SQL 102: Aliases and Table Joins

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1404

Speaker: Brandie Tarvin

Title: T-SQL 102: Aliases and Table Joins

Abstract:

For the beginner and intermediate T-SQL coder, this is a class on how to use aliases and joins to your advantage. This session introduces the topics and throws in a few tips tricks that can help you find exactly the data you need.

SessionID: 29622

Accelerating SQL with Solid State Technology

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1406

Speaker: Sumeet Bansal

Title: Accelerating SQL with Solid State Technology

Abstract:

Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how MS SQL Servers perform.

This session will address:

1. On overview of solid state technology options for SQL Server
2. Why solid state makes a difference?
3. An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices
4. Customer proof: Wine.com case study

SessionID: 29878

Response Time Analysis of SQL Server Performance

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1202 (Auditorium)

Speaker: Dean Richards

Title: Response Time Analysis of SQL Server Performance

Abstract:

Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response Time based performance analysis to solve the most difficult performance related issues. Designed for the SQL Server DBA, Developer or anyone concerned with performance.

SessionID: 29879

Tuna Helper for SQL Server DBA's

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1402

Speaker: Dean Richards

Title: Tuna Helper for SQL Server DBA's

Abstract:

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.

SessionID: 30060

High Anxiety with ORMs

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1400

Speaker: Eric Humphrey

Title: High Anxiety with ORMs

Abstract:

Object Relational Mappers (ORMs) are often praised by developers and despised by DBAs. I'll show that like most tools, ORMs have their place if used responsibly. Also, how they can get out of hand if not monitored.

SessionID: 30126

SSIS Configurations, Expressions and Constraints

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1402

Speaker: Eric Wisdahl

Title: SSIS Configurations, Expressions and Constraints

Abstract:

This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.

SessionID: 30128

An Introductory Look at Execution Plans

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1406

Speaker: Eric Wisdahl

Title: An Introductory Look at Execution Plans

Abstract:

In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented.

SessionID: 30190

Mini - SSIS for the DBA

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Michael Flora

Title: Mini - SSIS for the DBA

Abstract:

During the brief 15 minutes I will show you how to loop through a list of servers to gather information. With this knowledge you can build your own SQL server monitoring tool.

SessionID: 30353

Accessing Cube using ADOMD.NET

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1404

Speaker: Mustika Nengah

Title: Accessing Cube using ADOMD.NET

Abstract:

Accessing multidimensional data such as SSAS’s cubes and KPI from .NET client applications using ADOMD.NET . ActiveX Data Objects Multi-dimensional (ADOMD) provides easy access to multi-dimensional data from client applications (Web, Console, or Windows application). This session shows you how to use ADOMD.NET to retrieve data and metadata from an SSAS instance.

SessionID: 30654

Heterogeneous Data Integration with SSIS CDC

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1400

Speaker: Jeff Cole

Title: Heterogeneous Data Integration with SSIS CDC

Abstract:

This session will focus on Microsoft and partner technologies that enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), and that work with data from Oracle, Teradata, and other heterogeneous sources. You will learn how Microsoft high-speed Connectors by Attunity can be leveraged with change-data-capture (CDC) technologies integrated with SSIS to enable data replication. Use cases highlighting real-time data warehousing and operational reporting, as well as maintenance of data consistency between operational databases and applications will also be outlined.

SessionID: 30675

Basics of Sql Server Profiler

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1406

Speaker: Jonathon Moorman

Title: Basics of Sql Server Profiler

Abstract:

An introduction to the basic elements of the Sql Server Profiler. An overview, from a sql developer perspective, of useful events, useful column data, how to apply filters, how to execute, how to search results and a look at canned and custom templates.

SessionID: 30676

Everything you wanted to know about IDENTITY colum

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1402

Speaker: Jonathon Moorman

Title: Everything you wanted to know about IDENTITY colum

Abstract:

From IDENTITY seed and increment, to specifying specific values, we'll look at IDENTITY columns at all angles to find their strengths and limitations.

SessionID: 31023

SQL University 101: Starting the SQL Journey

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1404

Speaker: Jorge Segarra

Title: SQL University 101: Starting the SQL Journey

Abstract:

On my blog I've started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know. This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources!

SessionID: 31024

Policy-Based Management: Administration Made Easy

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1400

Speaker: Jorge Segarra

Title: Policy-Based Management: Administration Made Easy

Abstract:

We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!

SessionID: 31423

Introduction to Data Warehousing

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Devin Knight

Title: Introduction to Data Warehousing

Abstract:

In this session you will learn how to plan for a Data Warehousing project. Why you need one, what the key steps are to developing one and designing a plan to have a successful project will all be discussed. You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse. This session will focus more on the concepts of development rather than demonstrating the development itself.

SessionID: 31681

Building your First Cube in Analysis Services 2008

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: Business Intelligence -1102

Speaker: Mike Davis

Title: Building your First Cube in Analysis Services 2008

Abstract:

In this session Mike builds a cube from a basic data warehouse. He shows also covers the basics of what a data warehouse is and explains dimensional modeling. He shows how to create the cube, including dimensions, hierarchies, and calculations.

SessionID: 31804

XML 101 for the SQL Developer

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1406

Speaker: Michael Antonovich

Title: XML 101 for the SQL Developer

Abstract:

This session defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML.

SessionID: 31805

Publishing Access Applications to SharePoint

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1406

Speaker: Michael Antonovich

Title: Publishing Access Applications to SharePoint

Abstract:

This sessions is designed for user with experience developing Access applications. It will focus on Access 2010 with SharePoint 2010 to explore the different degrees of publishing Access and how it solve issues many IT departments have with Access including: Access databases are never backed up. Every copy of the XYZ Access database has different data in it. Publishing form and report updates to dozens or hundreds of users is a nightmare. We will then dive deep into how IT departments can publish an Access application to Access Services on SharePoint with Web forms, reports, queries, and macros that eliminate the need for Access on the client machine entirely.

SessionID: 32133

Introduction to Transactional Replication

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1404

Speaker: Troy Gallant

Title: Introduction to Transactional Replication

Abstract:

SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.

SessionID: 32252

Common SQL Programming Mistakes

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1202 (Auditorium)

Speaker: Plamen Ratchev

Title: Common SQL Programming Mistakes

Abstract:

Become a better SQL coder by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them.

SessionID: 32253

Refactoring SQL for Performance

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1202 (Auditorium)

Speaker: Plamen Ratchev

Title: Refactoring SQL for Performance

Abstract:

Many people live by the motto “If it’s not broken, don’t fix it”. But if you believe that you are missing all enhancements introduced in newer versions of SQL Server (2005/2008). These new features can help you develop better solutions with improved performance, scalability, and maintainability. Learn how to craft a better query using the new MERGE statement, ranking functions, and more. Practical examples with tips and tricks.

SessionID: 32338

SQL and SEO - Database Design and Web Marketing

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1402

Speaker: Jared Nielsen

Title: SQL and SEO - Database Design and Web Marketing

Abstract:

Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded.

Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing.

SessionID: 32546

SSIS Deployment Strategies

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1402

Speaker: Robby Robertson

Title: SSIS Deployment Strategies

Abstract:

Now that you've built it, how do you get it out there for consumption? This session will focus on highly configurable and data-driven solutions for SSIS package deployment. We will discuss a variety of topics as they relate to package implementation and delivery, including: The pros and cons of file system vs. SQL Server deployment, package configuration methods, package security, using meta-data to drive package flexibility, deployment and execution automation techniques.

SessionID: 32615

Demystyfying SQL Code and Object Deployments

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1202 (Auditorium)

Speaker: Rodney Landrum

Title: Demystyfying SQL Code and Object Deployments

Abstract:

From everyday movement of code and data, standards must be set and met depending on the size of your company and your available resources. Rodney will discuss SQL deployments best practices using industry standard tools. From SSIS, stored procedures, SQL objects such as tables and indexes, to the data itself, deploying SQL code from one environment to another is not always as straight forward as you may think.

SessionID: 32908

Using Parameters in SSRS

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1404

Speaker: Shawn Harrison

Title: Using Parameters in SSRS

Abstract:

In this session, Shawn will cover the basics of using parameters in reports and work up to a more intermediate level such as using parameters in stored procedures and cascading parameters.

SessionID: 32910

SQL Server 2008 Resource Governor

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1404

Speaker: Shawn McGehee

Title: SQL Server 2008 Resource Governor

Abstract:

Working with limited resources in the hardware and software fields can be troubling for a DBA. Making things work smoothly when sharing servers among many applications can be a difficult and time consuming task. With SQL Server 2008 a new feature has been given to the DBA world that can make the process much easier. We will take a look at the resource governor from the ground up in this session and build a solution to alleviate some of the issues that come with sharing hardware.

SessionID: 33202

Encryption How-To 101

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1400

Speaker: Steve Schneider

Title: Encryption How-To 101

Abstract:

Learn how to implement SQL 2005 Encryption using 2-way and 1-way encryption and why you would use either.

Learn what a DBA needs to know and what the developer needs to know.
Learn how to maintain encryption...backup and restore issues as well as cross-server issues. This will include a live demonstrations of the concepts presented.

SessionID: 33660

ITIL V3 for the Database Administrator

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1400

Speaker: Timothy McAliley

Title: ITIL V3 for the Database Administrator

Abstract:

Conducting database administration within an ITIL framework can improve change management, reduce operational risks and stabilize your environment. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3) and review a few examples of scaled deployments of the ITIL V3 process framework.

SessionID: 33806

Table Partitioning: The Basics

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1202 (Auditorium)

Speaker: Elijah Baker

Title: Table Partitioning: The Basics

Abstract:

This session will go over what database table partitioning is and what the structures are to implement it. There will also be some general information on partitioning strategies. If you ever looked into table partitioning and just wanted a little more information this session is for you.

SessionID: 33835

Introduction to Data Mining using SQL 2008

Back to calendar

Event Date: 08-05-2010 - Session time: 00:00:00 - Track: 1402

Speaker: Vikas Hawaldar

Title: Introduction to Data Mining using SQL 2008

Abstract:

Session will present the development lifecycle of a Datamining engine using SQL Server 2008.

This site is open source. Improve this page.