Hampton Inn Lake Mary
850 Village Oak Lane
Lake Mary, FL 32746

Bradley Ball is a MCITP SQL 2005 & MCTS 2008 DBA with over 10 years of IT experience.  Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of theUnited States.  He is currently a Sr. SQL DBA Staff Specialist for Publix Supermarkets.  He has presented at SQL Saturdays 62 & 74, for the MAGICPASS & OPASS SSUG’s, SQL Rally, and at the PASS Summit in 2011. Bradley can be found blogging on http://www.sqlballs.com

Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. Get an overview into how eachversion of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tablefs Update and Scan pattern’s affect the compression types you should consider. And what you should youtake into consideration for additional overhead.

Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has authored three books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP.

Rodney will be giving the group a high level overview of your HADR options and how you can leverage this technology for reporting applicaitons.

Hampton Inn Lake Mary
850 Village Oak Lane
Lake Mary, FL 32746

Max is from Puerto Rico, has been working with computers since 1979. Throughout the many years, he has worked with various types of databases such as: Dbase, OS/400-DB2, MySQL and MSSQL. Also, provided support to Windows Servers 2003/2008, Windows 7, SQL Servers Applications, Microsoft Virtualization Technologies, and has built some Visual Studio solutions. He is a Microsoft PowerShell MVP and has been since 2008, and he also is MVP SAPIEN Technologies since 2010.

This is an overview of how to understand SQL PowerShell and its difference with PowerShell v2. Covering some PowerShell basic, and see how SMO can assist in extending your PS Script. Also, I’ll be showcasing some of the tools that can provide and extend you PowerShell scripting. This session is intended to help the audience realized the benefits of learning PowerShell. 

Your code is as close to perfect as possible.  It runs like freshly tuned skis over fresh champagne powder (ok, that is probably an analogy lost on folks in Florida. Work with me here).  Then the unthinkable happens.  It is 2 AM and the NOC calls.  Your job has failed!  You fire up the VPN and check your beautiful creation and find that one small change on the source system has caused one row of data … one row out of hundreds of thousands … to fail, causing your entire ETL job to fail.  WTF?!?!?! (Where’s That From?!?!?!)

The next morning, bleary eyed and overdosed on caffeine you drag yourself to the cube of the developer responsible for the source system.  You show the developer the data and exclaim “WTF?!?! (Where’s that from?!?!?)”
The developer now provides you with the epitome, the sine qua non, the gold standard of communications between the development team and the BI team….

“Sorry dude, I thought they told you about this.”

As Florida and Colorado both have the death penalty, murder is not an option, so what can you do to preserve your sanity and stay out of jail?  This seminar will explore those possibilities.

Rikka Asian Bistro
1541 International Parkway, Ste. 1001
Lake Mary, FL 32746

Michael is a Database Administrator for a large financial firm in the Tampa Bay area. He has been working in IT since 2000 and has been administered all versions of SQL Server from 2000 and up. Michael runs the Sarasota SQL Server User Group located in Sarasota, FL and has presented at numerous SQL Saturday, CodeCamp, and User Group events.

This session will cover a PowerShell project that is designed to allow organizations to rapidly deploy new SQL Server instances to their environment. The process includes automating all aspects of the SQL Server install from Operating System pre-configurations, the SQL Server install, to deploying standard SQL objects such as databases, tables, jobs, and stored procedures.

Norm is a data professional with a broad range of data experiences, primarily in Database & Application Development/Support and Reporting, and some DBA experience. Along with SQL Server, Norm has worked with Oracle, Sybase, and DB2. He holds MCTS certifications in Business Intelligence and Database Administration, and a Masters in Computer Science, and is versed with the Microsoft BI Stack of tools. Norm’s career passion is making data as valuable as possible, by designing and developing database solutions, performing data analysis, and making relevant data easily available to decision makers.Norm is currently on contract at a medium-sized Healthcare firm in Altamonte Springs where he fills the role of a Data & Reporting Analyst/Developer.

In this session, we will cover the various stages/steps of a data conversion project including concept, project planning, analysis, development and QA. We will also discuss some best practices, and other considerations that might not be directly a part of the data conversion, but is related to, or can be impacted by it.

Download the slide deck for this presentation here