sqlsathistory

Nr: 66

Back to Main list

SQLSaturday #66 - Colorado Springs 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Bill Fellows	Track 1	45 new 2005/2008 TSQL features in 45 minutes
00:00:00	Carlos Bossy	Track 1	A Data Mining Solution
00:00:00	Meredith Ryan-Smith	Track 3	Helpdesk to DBA in 60-ish minutes
00:00:00	Chris Randall	Track 3	"Beyond BIDS" - Caring for and Feeding a SQL Serve
00:00:00	Dean Richards	Track 2	Best Practices for SQL Server on VMWare
00:00:00	Doug Lane	Track 2	Make it fast, make it pretty (SSRS)
00:00:00	Gabriel Villa	Track 3	Securing your SQL Server
00:00:00	Glenn Berry	Track 2	Hardware 201: Selecting Database Hardware
00:00:00	Kat Long	Track 1	Networking Session 4
00:00:00	Kat Long	Track 2	Networking Session 5
00:00:00	Kat Long	Track 3	Networking Session 6
00:00:00	Kat Long	Track 1	Lunch\Meet the experts\WIT
00:00:00	Kat Long	Track 2	Lunch\Meet the experts\WIT 2
00:00:00	Kat Long	Track 3	Lunch\Meet the experts\WIT 3
00:00:00	Kat Long	Track 1	Break 1
00:00:00	Kat Long	Track 2	Break 2
00:00:00	Kat Long	Track 3	Break 3
00:00:00	Kat Long	Track 1	Networking 7
00:00:00	Kat Long	Track 2	Networking 8
00:00:00	Kat Long	Track 3	Networking 9
00:00:00	Kat Long	Track 1	Networking 10
00:00:00	Kat Long	Track 2	Networking 11
00:00:00	Kat Long	Track 3	Networking 12
00:00:00	Kat Long	Track 1	Break 4
00:00:00	Kat Long	Track 2	Break 5
00:00:00	Kat Long	Track 3	Break 6
00:00:00	Mark Halstead	Track 1	SQL Server Performance tuning
00:00:00	Randy Knight	Track 3	Visual Studio 2010 Database Projects
00:00:00	Steve Jones	Track 1	The Modern Resume - Building Your Brand
00:00:00	Christopher Shaw	Track 1	Welcome
00:00:00	Christopher Shaw	Track 2	Welcome
00:00:00	Christopher Shaw	Track 3	Welcome
00:00:00	Christopher Shaw	Track 1	Networking Session 1
00:00:00	Christopher Shaw	Track 2	Networking Session 2
00:00:00	Christopher Shaw	Track 3	Networking Session 3
00:00:00	Ted Malone	Track 2	Managing the Data Tier Application Lifecycle
00:00:00	TJay Belt	Track 3	Documentation. You know you love it
00:00:00	Thomas Norman	Track 2	Policy Based Management
00:00:00	William E Pearson III	Track 1	Becoming DAX: An Introduction

SessionID: 29037

45 new 2005/2008 TSQL features in 45 minutes

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Bill Fellows

Title: 45 new 2005/2008 TSQL features in 45 minutes

Abstract:

Too busy to read BOL to figure out what they've added? This purely demo based presentation will give you a taste of what new language features are available to make your life easier. Sure, you might know about CTEs and windowing functions, but what about the new data types (geospatial, xml, etc), DMOs and query hints. Stop in and see if I can rattle off a feature a minute.

SessionID: 29416

A Data Mining Solution

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Carlos Bossy

Title: A Data Mining Solution

Abstract:

One of my clients, the Department of Human Services, wants to predict which children that leave foster care will have to return to foster care at later date. Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to develop a data mining model using Analysis Services from conception to deployment using internal and external data, and you will see how to get and display results. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.

SessionID: 29579

Helpdesk to DBA in 60-ish minutes

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Meredith Ryan-Smith

Title: Helpdesk to DBA in 60-ish minutes

Abstract:

Most ‘accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available.

SessionID: 29656

"Beyond BIDS" - Caring for and Feeding a SQL Serve

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Chris Randall

Title: "Beyond BIDS" - Caring for and Feeding a SQL Serve

Abstract:

Are you a Business Intelligence developer? Have you built a SQL Server Reporting Services, Analysis Services or Integration Services solution? Have you deployed to a test server and are wondering "Now what?" Or are you a production SQL Server DBA who's been informed that since SSAS, SSIS or SSRS have "SQL" in their name, you have to take over the day-to-day management of a SQL BI project? This fast-paced session will look at what it takes to manage and administer projects created with the SQL Server BI products. We'll look at the management tools, deployment lifecycles, security capabilities and disaster recovery processes for these products. We'll see why, if you're a developer, you might still need your DBA, or if you're a DBA, you might

SessionID: 29865

Best Practices for SQL Server on VMWare

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Dean Richards

Title: Best Practices for SQL Server on VMWare

Abstract:

More and more companies are virtualizing with VMWare, and SQL Server databases are moving in that direction as well. This presentation will explore the fundamentals of running SQL Server in a VMWare environment. 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 SQL Server / VMWare environment.

SessionID: 29965

Make it fast, make it pretty (SSRS)

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Doug Lane

Title: Make it fast, make it pretty (SSRS)

Abstract:

Designing a fast, elegant report for Reporting Services can be challenging. In this session, we'll cover design methods you can start using right away to create faster reports with fewer headaches and in less time. We'll also look at how to deal with potentially frustrating aspects of report appearances like border behavior, multi-column layouts, and unwanted blank pages.

SessionID: 30177

Securing your SQL Server

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Gabriel Villa

Title: Securing your SQL Server

Abstract:

Become aware of some commonly overlooked practices in securing you SQL Server databases. Learn about physical security, passwords, privileges and roles, restricting or disabling system stored procedures and preventative best practices. And most importantly, discuss the most commonly used security threat: SQL injection and learn how to prevent them.

SessionID: 30255

Hardware 201: Selecting Database Hardware

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Glenn Berry

Title: Hardware 201: Selecting Database Hardware

Abstract:

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.

SessionID: 31215

Networking Session 4

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Kat Long

Title: Networking Session 4

Abstract:

Networking Session 4

SessionID: 31216

Networking Session 5

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kat Long

Title: Networking Session 5

Abstract:

Networking Session 5

SessionID: 31217

Networking Session 6

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Kat Long

Title: Networking Session 6

Abstract:

Networking Session 6

SessionID: 31218

Lunch\Meet the experts\WIT

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Kat Long

Title: Lunch\Meet the experts\WIT

Abstract:

Lunch\Meet the experts\WIT

SessionID: 31219

Lunch\Meet the experts\WIT 2

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kat Long

Title: Lunch\Meet the experts\WIT 2

Abstract:

Lunch\Meet the experts\WIT 2

SessionID: 31220

Lunch\Meet the experts\WIT 3

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Kat Long

Title: Lunch\Meet the experts\WIT 3

Abstract:

Lunch\Meet the experts\WIT 3

SessionID: 31221

Break 1

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Kat Long

Title: Break 1

Abstract:

Break 1

SessionID: 31222

Break 2

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kat Long

Title: Break 2

Abstract:

Break 2

SessionID: 31223

Break 3

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Kat Long

Title: Break 3

Abstract:

Break 3

SessionID: 31224

Networking 7

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Kat Long

Title: Networking 7

Abstract:

Networking 7

SessionID: 31225

Networking 8

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kat Long

Title: Networking 8

Abstract:

Networking 8

SessionID: 31226

Networking 9

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Kat Long

Title: Networking 9

Abstract:

Networking 9

SessionID: 31227

Networking 10

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Kat Long

Title: Networking 10

Abstract:

Networking 10

SessionID: 31228

Networking 11

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kat Long

Title: Networking 11

Abstract:

Networking 11

SessionID: 31229

Networking 12

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Kat Long

Title: Networking 12

Abstract:

Networking 12

SessionID: 31230

Break 4

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Kat Long

Title: Break 4

Abstract:

Break 4

SessionID: 31231

Break 5

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Kat Long

Title: Break 5

Abstract:

Break 5

SessionID: 31232

Break 6

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Kat Long

Title: Break 6

Abstract:

Break 6

SessionID: 31724

SQL Server Performance tuning

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Mark Halstead

Title: SQL Server Performance tuning

Abstract:

SQL Server performance tuning with an emphasis on finding the bottlenecks, Query design problems and database design problems.

SessionID: 32409

Visual Studio 2010 Database Projects

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Randy Knight

Title: Visual Studio 2010 Database Projects

Abstract:

Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.

SessionID: 32926

The Modern Resume - Building Your Brand

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Steve Jones

Title: The Modern Resume - Building Your Brand

Abstract:

Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job.

SessionID: 33122

Welcome

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Christopher Shaw

Title: Welcome

Abstract:

Welcome to SQL Saturday #66. We will be covering the schedule for the day and what attendee's can expect from the training and from the "Special Networking Events".

SessionID: 33123

Welcome

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Christopher Shaw

Title: Welcome

Abstract:

Welcome\Keynote

SessionID: 33124

Welcome

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Christopher Shaw

Title: Welcome

Abstract:

Welcome\KeyNote

SessionID: 33125

Networking Session 1

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Christopher Shaw

Title: Networking Session 1

Abstract:

Networking Session 1

SessionID: 33126

Networking Session 2

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Christopher Shaw

Title: Networking Session 2

Abstract:

Networking Session 2

SessionID: 33127

Networking Session 3

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

Speaker: Christopher Shaw

Title: Networking Session 3

Abstract:

Networking Session 3

SessionID: 33325

Managing the Data Tier Application Lifecycle

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Ted Malone

Title: Managing the Data Tier Application Lifecycle

Abstract:

Introduced with SQL Server 2008 R2 and Visual Studio 2010, Data Tier Applications (DACs) help to simplify the development lifecycle of SQL Server database applications. DACs can be integrated into larger Visual Studio application projects and make for a very integration application development lifecycle. In this session, you will learn about DACs and how to use Visual Studio to build SQL Server Data Tier Applications. This session will also discuss creating DACs from existing database structures and will demonstrate how to integrate existing databases into Visual Studio application solutions.

SessionID: 33684

Documentation. You know you love it

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 3

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.

SessionID: 33695

Policy Based Management

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 2

Speaker: Thomas Norman

Title: Policy Based Management

Abstract:

Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers.

SessionID: 34276

Becoming DAX: An Introduction

Back to calendar

Event Date: 12-02-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: William E Pearson III

Title: Becoming DAX: An Introduction

Abstract:

The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate largely upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions.

This site is open source. Improve this page.