Orlando SQL Server Users Group

Event Date/Time: Tuesday July 12 @ 6:00 PM

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

Map/Directions: Bing Map to Event Location

Speaker: Max Trinidad
Speaker Bio:

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.

Title: SQL : Let’s talk about SQL PowerShell

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. 

SQL Shot Speaker: Michael Sexton
Speaker Bio: Mike is a database architect with over 12 years experience in OLTP and BI environments.  He is an expert on data integration and master data management issues and has written books and articles on the subjects of data movement, transformation, ETL and data integration.  He is also a passionate about his adoptive state, Colorado and it abundant natural beauty.  He lives with a hot blonde in the suburbs of Denver.
SQL Shot Title: WTF?!?!?!? Logging and Error Handling For ETL

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.


SQL Speaker: Allen White
Speaker Bio:

Allen is a Practice Manager for Upsearch in Northeast Ohio. He's been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last six years. He's President of the Ohio North SQL Server User's Group and maintains a blog.

Title: Maintain SQL Server System and Performance Data with PowerShell

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SQL Shot: Jason Portillo and Lilly Schmidbauer
Speaker Bio:

Jason Portillo's expertise includes data manipulation and development. In addition, he knows C, C#, C++, T-SQL, and several more. He has been home schooled since he was 8 years old; furthermore, he has been learning programming languages since he was 12 years old. When he was 14, he won 3rd Place in a PSP programming competition utilizing C programming language.

Lilly Schmidbauer's expertise includes Database Administration, Reporting Solutions, Database Development, BI Development, Performance Tuning and Troubleshooting with more than 16 years of technical experience including five years of team building and technology training, and ten plus years of database administration (MSSQL 2000 / 2005 / 2008 / 2008R2 / 2012). She is an active member of PASS and SQL Saturday.

Title: Manipulating data with C# Utilizing SSIS

In this 15 minutes session, we will cover how to create a text file that includes:

  • File Header
  • Batch Header
  • Details
  • Batch Trailer
  • File Trailer

The purpose of the package is to retrieve the data utilizing a sql script and to produce a text output file with two level summaries.

SQL Speaker: Mike Antonovich
Speaker Bio:

Mike Antonovich is the Assistant Director of Web Services for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. They are also responsible for multiple .Net custom applications throughout the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007.

Title: Cube World for Flat Table Landers

This session will explore the tabular approach to building cubes in SQL Server Analysis Services 2012 for DBA’s more comfortable with relational databases. Starting with a ‘normal’ relational database, you will learn how to define your measure and dimensions, define hierarchies, and build functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as well for their more demanding models.


Cube World for Flat Table Landers

SQL Speaker: Jose Chinchilla
Speaker Bio:

Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Architect, President of Agile Bay, Inc. a full-service IT consulting firm specializing in BI and Data Warehousing. Jose has developed expertise developing Data Warehouses, OLAP Cubes, Master Data Management and Data Quality frameworks, and Performance Point dashboards using the SQL Server and SharePoint. He is also the current president of the Tampa Bay Business Intelligence User Group. You can follow Jose at his Blog or on Twitter @sqljoe.

Title: PowerPivot+Power View = Self-service BI Revolution

SQL Server 2012 introduced several new features and tools that have sparked the self-service BI revolution. Learn how PowerPivot and the new ad-hoc dashboarding tool called PowerView are revolutionizing the way Business Intelligence is being delivered and consumed by the end users themselves. In this session you will also understand what is the role of IT in this new self-service paradox.


SQL Speaker: Timothy P. McAliley
Speaker Bio:

Timothy is currently a Technical Trainer in the Enterprise Security Group at Symantec (www.symantec.com, SYMC). Timothy’s particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. Timothy is a Certified Technical Trainer (CTT), a Microsoft Certified Trainer (MCT), PMP, a CISA, a CISM, a CISSP, and ITIL V3 Foundations certified. Timothy also holds MCTS, MCITP certifications on Windows Server 2008, SQL Server 2005/2008, Exchange 2010 and SharePoint 2010. Timothy delivers training for SharePoint 2010, Windows Server 2008 R2, SQL Server 2008 R2, and Exchange 2010. He has spoken at SQL Saturday events in Jacksonville, Orlando, South Florida, and Tampa, as well as several information security speaking engagements in Jacksonville.

Title: Configuring and Maintaining SQL Server 2012 as a Windows Azure Virtual Machine

This session will cover an introduction to Windows Azure Virtual Machines and then we will explore the options for planning and configuring SQL Server 2012 as a Windows Azure Virtual Machine. You will see a demonstration of configuring SQL Server 2012 as a Windows Azure Virtual Machine, and then a demonstration of post-configuration tasks such as storage provisions and resource monitoring. You will also learn the basics of what you need to obtain a Windows Azure account and the different subscription options.


SQL Speaker: Chuck Heinzelman
Speaker Bio:

Chuck Heinzelman is a Senior Program Manager with the BPD Customer Experience team at Microsoft. He has been involved in the SQL Server community for over 10 years. He is a founding member of the Wisconsin SQL Server User Group, a frequent presenter at the PASS Community Summit, and a long-time PASS volunteer. When not working with technology, you can find him working on his 112 year-old house and learning from his son and daughter.

Title: Reporting Services 2012 and SharePoint—New Features and Configuration Options

With SQL Server 2012, Reporting Services in SharePoint integrated mode has taken a huge step forward – both in terms of functionality and the installation/configuration experience.  During our time together, we’ll talk about the new features that were released with SQL Server 2012, as well as walk through upgrading a SharePoint integrated SQL Server 2008 R2 reporting environment to SQL Server 2012 and configuring a new SharePoint integrated SQL Server 2012 reporting environment from scratch.

SQL Shot: Ray Payano
Speaker Bio:

Ray has been workign with SQL Server for 14 years. He started out as an Access developer and progressed into SQL Server. He has worked for companies such as Cigna Healthcare, Louis Vuitton and ISC/NASCAR. Currently Ray is the Senior Lead DBA for Adventist Health Systems - multistate division. He is an MCTS in SQL Server 2005 and 2008, and currently working on his MCITP.

Title: My SQL Server Toolbox - Queries No DBA Should Be Without

SQL queries that can be used on a daily basis to help troubleshoot performance issues on SQL Server.


SQL Speaker: Rodney Landrum
Speaker Bio:

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.

Title: CSI - Taking a Stab at Column Stored Indexes

Want to know if your queries will scream when taking advantage of Column Store Indexes? In this introductory session, you will learn what a Column Store Index is, how it differs from a traditional index and why it promises astounding query results for large data volumes, typical of a data warehouse. You will also learn the important caveats and challenges of implementing this promising new feature of SQL Server 2012 and decide if implementing a CSI solution is a good choice for your data.


SQL Speaker: Devin Knight
Speaker Bio:

Devin is a BI consultant at Pragmatic Works Consulting. He authored the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS, Code Camps and several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).

Title: Extending Reporting Services with Custom Code

The Reporting Services expression language can be a powerful tool for customizing report data and layout, but often times you will find it is lacking functionality that is easily available in .Net. While this session is not designed to teach you .Net it will show you some commonly used .Net functions for Reporting Services. We will also talk about the difference between custom code that is embedded in a report and external assemblies imported into Reporting Services.


Extending SSRS with Custom Code
Embedded Code Examples

SQL Speaker: Brian Kelley
Speaker Bio:

Brian is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as a database administrator / architect for AgFirst Farm Credit Bank where he can concentrate on his passion: SQL Server.

Title: The Dirty Business of Auditing

Auditing is often a dirty word among DBAs because it equates to more work with little perceived business value. However, auditing is a necessary evil for most businesses and it usually falls to the DBA to ensure SQL Server is properly audited. In this session we'll look at what the operating system and SQL Server provide for us in order to meet the requirements of internal and external auditors, regulatory legislation, and even overbearing system owners who want to know everything about what's going on in their application. We'll consider what tools to use to quickly implement the properly level of auditing to meet the need.


The Dirty Business of Auditing
SQL Server Audit Checklist
The Dirty Business of Auditing SQL Script Examples


SQL Speaker: Kendal Van Dyke
Speaker Bio:

Kendal Van Dyke is a practiced IT professional with over a decade of experience in SQL Server development and administration. Kendal is currently a Senior Technical Consultant with Insource Technology in Houston, TX, where he helps companies keep their SQL Servers running in high gear. Kendal is also a Microsoft MVP for SQL Server, President of the PASS chapter MagicPASS in Orlando, and serves on the PASS Board of Directors

Title: Building Your Own SQL Server Virtual Playground

As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up clustering? Or maybe you want to try out the latest SQL 2012 release candidate...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.


Building Your Own SQL Server Virtual Playground


SQL Speaker: Andy Warren
Speaker Bio:

Andy Warren is an independent consultant specializing in SQL Server based in Orlando. Over the course of his career he has written more than 100 technical articles, was a founder of SQLServerCentral.com, relaunched the Orlando SQL Server User Group (oPASS), served for three years on the PASS Board of Directors, and has been a SQL MVP since 2008. He blogs most days at SQLAndy on a wide range of topics and spends a lot of time teaching and thinking about professional development and mentoring. 

Title: Building Your Professional Development Plan

Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.


Back to Top