sqlsathistory

Nr: 112

Back to Main list

SQLSaturday #112 - Birmingham 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Bob Cheatham	HSB 129A	SQL Server 2012 - What's New
00:00:00	Christopher Price	HSB 129D	What's new in SSIS 2012?
00:00:00	Louis Davidson	HSB 129C	What Sequence objects are (and are not)
00:00:00	Geoff Hiten	HSB 129B	SQL 2012 AlwaysOn
00:00:00	Geoff Hiten	HSB 129B	Moving Day - Successful SQL Migrations
00:00:00	Jim Wooley	HSB 129B	Building Testable Applications with EF 4
00:00:00	Jim Wooley	HSB 129B	Managing Database Changes with Visual Studio
00:00:00	Jorge Segarra	HSB 129D	STOP! Consolidate and Listen!
00:00:00	Jorge Segarra	HSB 129C	Policy-Based Management in a Nutshell
00:00:00	Jorge Segarra	HSB 129C	SQL University: Back That Thang Up!
00:00:00	Kathy Gibbs	HSB 129D	Lunch Session - Advanced Performance Tuning Tips
00:00:00	Kathy Gibbs	HSB 129C	Best Practices for Monitoring Databases on VMware
00:00:00	Kevin Boles	HSB 129D	SQL Server 2012 Column Store Index
00:00:00	Kevin Boles	HSB 129D	SQL Server 2012 TSQL Enhancements and Additions
00:00:00	Kevin Boles	HSB 129D	Windowing Functions: THE Reason to Upgrade to 2012
00:00:00	Tim Radney	HSB 129B	Know Backups and Know Recovery
00:00:00	Tim Radney	HSB 129B	Getting involved and Getting ahead
00:00:00	Christopher Price	HSB 129C	Introduction to Master Data Services 2012
00:00:00	Christopher Price	HSB 129C	Data Quality Services 2012
00:00:00	Sven Aelterman	HSB 129A	What's New for Developers in SQL Server 2012
00:00:00	Sven Aelterman	HSB 129A	Introduction to FileTables
00:00:00	Sven Aelterman	HSB 129A	Upgrading SSIS Packages to SQL Server 2012
00:00:00	Aaron Nelson	HSB 129D	Time Saving Tips Tricks for SSMS 2012
00:00:00	Robert Cain	HSB 129A	Make SQL Server Pop with PowerShell
00:00:00	Robert Cain	HSB 129A	Become a PowerShell Pop Star

SessionID: 10535

SQL Server 2012 - What's New

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129A

Speaker: Bob Cheatham

Title: SQL Server 2012 - What's New

Abstract:

During this session we will discuss the new features within SQL Server 2012. I will demonstrated some of the new Reporting features such as Power View and PowerPivot. I will also demonstrate Master Data Servcies and explain the importance of MDS within an organization. I will also explain the benefits of implementing SQL Server 2012 AlwaysON as well as other new components that exist.

SessionID: 11972

What's new in SSIS 2012?

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Christopher Price

Title: What's new in SSIS 2012?

Abstract:

A brave new world is on the SSIS horizon. The release of Integration Service 2012 brings a significant number of new features and improvements to SSIS which offer you a host of new possibilities. From the new SSIS Catalog, to variables, data taps and the new Project and Deployment model, there is a lot to be excited about as Microsoft once again raised the bar for data integration tools. Join us as we will explore the ins and outs of what’s available as we learn how to leverage the latest in the SSIS toolset to make it work for you.

SessionID: 13452

What Sequence objects are (and are not)

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129C

Speaker: Louis Davidson

Title: What Sequence objects are (and are not)

Abstract:

SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more.

SessionID: 14487

SQL 2012 AlwaysOn

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129B

Speaker: Geoff Hiten

Title: SQL 2012 AlwaysOn

Abstract:

AlwaysOn is the new High Availability technology suite for Microsoft SQL Server 2012 that allows for multiple HA and DR solutions along with hardware reuse and reporting scale-out.

SessionID: 14488

Moving Day - Successful SQL Migrations

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129B

Speaker: Geoff Hiten

Title: Moving Day - Successful SQL Migrations

Abstract:

Moving day is one of life's most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving your home or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful migration using examples focused on SharePoint workloads.

SessionID: 16859

Building Testable Applications with EF 4

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129B

Speaker: Jim Wooley

Title: Building Testable Applications with EF 4

Abstract:

Entity Framework 4 brings the ability to separate the data models from the data access implementation. We'll show how to build your application models using the EF 4 POCO templates and be able to test them without accessing your database using repositories and Mocks.

SessionID: 16860

Managing Database Changes with Visual Studio

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129B

Speaker: Jim Wooley

Title: Managing Database Changes with Visual Studio

Abstract:

As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio to help manage these changes better.

SessionID: 17391

STOP! Consolidate and Listen!

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Jorge Segarra

Title: STOP! Consolidate and Listen!

Abstract:

In today's economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less!

SessionID: 17392

Policy-Based Management in a Nutshell

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129C

Speaker: Jorge Segarra

Title: Policy-Based Management in a Nutshell

Abstract:

We will be learning an overview of this powerful new feature in SQL Server 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 Server environment using this awesome new feature!

SessionID: 17393

SQL University: Back That Thang Up!

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129C

Speaker: Jorge Segarra

Title: SQL University: Back That Thang Up!

Abstract:

In this session we cover backups and restores from beginning to end. Want to know how to do point-in-time restores? Don't understand what the different recovery models mean? How do you handle backups for different size databases? All of these questions and more will be answered in this session.

SessionID: 17970

Lunch Session - Advanced Performance Tuning Tips

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Kathy Gibbs

Title: Lunch Session - Advanced Performance Tuning Tips

Abstract:

Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. The speaker will use real-life case studies to demonstrate the techniques.

SessionID: 17971

Best Practices for Monitoring Databases on VMware

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129C

Speaker: Kathy Gibbs

Title: Best Practices for Monitoring Databases on VMware

Abstract:

SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

SessionID: 26365

SQL Server 2012 Column Store Index

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Kevin Boles

Title: SQL Server 2012 Column Store Index

Abstract:

Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

SessionID: 26368

SQL Server 2012 TSQL Enhancements and Additions

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Kevin Boles

Title: SQL Server 2012 TSQL Enhancements and Additions

Abstract:

The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!

SessionID: 26369

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26680

Know Backups and Know Recovery

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129B

Speaker: Tim Radney

Title: Know Backups and Know Recovery

Abstract:

It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan?

In this session Tim Radney will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.

SessionID: 26681

Getting involved and Getting ahead

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129B

Speaker: Tim Radney

Title: Getting involved and Getting ahead

Abstract:

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability. PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out. The rewards of the SQL Community are endless.

SessionID: 29616

Introduction to Master Data Services 2012

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129C

Speaker: Christopher Price

Title: Introduction to Master Data Services 2012

Abstract:

Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.

SessionID: 29617

Data Quality Services 2012

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129C

Speaker: Christopher Price

Title: Data Quality Services 2012

Abstract:

We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.

SessionID: 33298

What's New for Developers in SQL Server 2012

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129A

Speaker: Sven Aelterman

Title: What's New for Developers in SQL Server 2012

Abstract:

Currently in Release Candidate, SQL Server 2012 offers several new features and improvements. This session will cover the ones that are most of interest to application developers, including enhancements to T-SQL, FILESTREAM and developer tools (including SSIS).

SessionID: 33299

Introduction to FileTables

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129A

Speaker: Sven Aelterman

Title: Introduction to FileTables

Abstract:

SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read "folders"). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs.

It may be valuable to attend the Introduction to FILESTREAM session also.

SessionID: 33300

Upgrading SSIS Packages to SQL Server 2012

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129A

Speaker: Sven Aelterman

Title: Upgrading SSIS Packages to SQL Server 2012

Abstract:

SQL Server Integration Services has received significant upgrades in SQL Server 2012. How to effectively upgrade SSIS packages to take advantage of the new SSIS features is the main driver behind this session. Primarily focused on upgrading packages from SSIS 2008, some notes will also be made about upgrading from SSIS 2005.

SessionID: 8870

Time Saving Tips Tricks for SSMS 2012

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129D

Speaker: Aaron Nelson

Title: Time Saving Tips Tricks for SSMS 2012

Abstract:

SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!

SessionID: 9708

Make SQL Server Pop with PowerShell

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129A

Speaker: Robert Cain

Title: Make SQL Server Pop with PowerShell

Abstract:

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects). Learn how to handle common DBA tasks, such as checking the status of various services, validating backups, and checking for disk usage. You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Come see how to make your SQL Server Pop with PowerShell.

SessionID: 9709

Become a PowerShell Pop Star

Back to calendar

Event Date: 12-05-2012 - Session time: 00:00:00 - Track: HSB 129A

Speaker: Robert Cain

Title: Become a PowerShell Pop Star

Abstract:

So you've heard about this cool scripting language from Microsoft called PowerShell. Maybe you've even thought "I need to learn something about that." Well today is your lucky day, in this session we'll take you from a PowerShell "noob" to Pop Star in one fast paced demo filled session. We'll start with the basics, cmdlets, variables, and providers. Then we'll look a quick look programming fundamentals, such as as branching, looping, script blocks and variable scoping. Finally we'll get into the advanced, fun stuff like functions, error handling, working with file types and wrap it up with creating a spiffy user interface. They'll be rolling out the red carpet when you get back to work Monday for the newest PowerShell Pop Star.

This site is open source. Improve this page.