Orlando SQL Server Users Group

Event Date/Time: Wednesday Sept 14 @ 6:30 PM (1st speaker starts at 7:00)
Location:

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

Map/Directions: Bing Map to Event Location

SQL Shot 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: Are you ready for some endpoints??
Abstract:

In this presentation you will learn what a SQL Server endpoint is, how to create them and a live demo of the creation process.  Once we have created the endpoint, you will learn how to consume it and use it in a .NET application.   Rodney will show you how to use endpoints to get football matchups from a database and how to match them up to your favorite snacks!  


Speaker: Ryan Parsley
Speaker Bio:

Ryan is a graphic designer with some history of development work.  He lives in that place found where form meets function.  When not rounding the corners and dropping the shadows for Linxter, Ryan enjoys talking with developers on http://cloudplumbing.com

Title: Modern Web Concepts
Abstract:

In this session, Ryan will share his thoughts and process to creating web sites and apps. It will be frontend centric, as that is his area of expertise, and will be more about concepts than code sharing. The goal of this presentation is to promote some "best practices" that will help you make better websites with less frustration (as well as dispel a few myths).

Event Date/Time: Tuesday Nov 8 @ 6:30 PM (1st speaker starts at 7:00)
Location:

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

Map/Directions: Bing Map to Event Location

SQL Speaker: Ron Dameron
Speaker Bio:

Ronald Dameron is a Lead Database Administrator for the largest life insurer in the United States. He is currently exploring how PowerShell can simplify his life as a DBA. He is a previous speaker at SQL Saturday Tampa, Orlando, South Florida and the Tampa SQL User group. He has published articles at www.simple-talk.com, sqlserverpedia.com and RonaldDameron.blogspot.com on his experience. Follow him on Twitter at @RonDBA.

Title: SQL Server Security - Good Enough for Government Work
Abstract:

Learn how to use United States Department of Defense(DoD) guidance to prepare SQL Server for government work.  The Defense Information Systems Agency has published extensive guidance on how to prepare IT infrastructure prior to use on a DoD project.  I will review the DoD Information Assurance Certification and Accreditation Process as it pertains to Microsoft SQL Server.  


Speaker: Sebastian Meine
Speaker Bio:

Sebastian is a principal trainer and consultant with sqlity.net llc (http://sqlity.net) and CTO for TSTS Inc, a company that provides an online personalized training and workout solution (http://www.tanyastroh.com). He specializes in T-SQL Test Driven Development (TDD) and performance and shares his passion and knowledge regularly with audiences world-wide through his writings and speaking engagements.

After receiving his PhD in Computer Science, Sebastian moved to the United States to begin his career as a software developer for a global Fortune 50 company. He quickly rose to the role of software architect, functioning as a SQL performance and TDD expert, assuming responsibility for the code quality and performance of dozens of large-scale database installations nationwide.

Title: Mining XML Query Plans
Abstract:

Execution plans contain a lot of information that can guide you in your performance tuning process. Since SQL 2005 it is possible to retrieve the execution plans stored in the cache using DMVs and DMFs. However, as they are stored in XML format it can be cumbersome and difficult to extract the information you need. In this session, you will learn how the XML query plan is structured and how to use SQL Server’s built-in XQuery language to extract information. Examples include indexes that the optimizer indicates would increase performance if implemented and queries that use table scans or nested loop joins.

 

Speaker Bio: Ken Tucker
Speaker:

Ken Tucker is a Microsoft MVP, President of Space Coast .NET user group, and Ineta Membership mentor for Florida.  Ken currently works for Amovius as a developer.

Title: SilverLight MVVM
Abstract:

The MVVM pattern is a common way to develop SilverLight apps. In this demo, Ken will look at some of the MVVM frameworks available and walk through creating an application.


SQL Shot Speaker: Bradley Ball
Speaker Bio: Bradley Ball is a MCITP SQL 2005 & MCTS 2008 Database Administrator 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 the United States. He is currently a Sr. SQL Database Administrator for Publix Supermarkets. Bradley can be found blogging on http://sqlballs.blogspot.com and on twitter here.
Title: Transparent Data Encryption
Abstract: Bradley will be doing a quick lightening round on Transparent Data Encryption, and will show off a script to automate certificate backups.

Event Date/Time: Tuesday June 14 @ 6:00 PM
Location:

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


Speaker: Michael Wells
Speaker Bio:

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.

Title: Using PowerShell to Rapidly Deploy SQL Server
Abstract:

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.

 

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

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

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

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.

 

Event Date/Time: Tuesday August 9 @ 6:00 PM
Location:

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

Map/Directions: Bing Map to Event Location

Speaker: Bradley Ball
Speaker Bio:

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

Title: Page and Row Compression How, When, and Why
Abstract:

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.


SQL Shot 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.

SQL Shot Title: Availability Groups and High Availability/Disaster Recovery (HADR) for SQL Denali
Abstract:

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

 

Speaker: Norman Bowen
Speaker Bio:

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.

Title: Steps, Best Practices & Considerations for Successful Data Conversions
Abstract:

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


Duo Demo: Karla Landrum & Jack Corbett
Title: Social Networking in the Workplace
Abstract: Karla Landrum will be doing a brief demonstration on the benefits of using Twitter from a marketing perspective.  Jack Corbett will be doing a brief demonstration on LinkedIn and the benefits of using that this tool for personal and business use.

Sponsor Demo: Rodney Landrum
Title: RedGate SQL Scripts Manager
Abstract: Rodney Landrum will be presenting a demonstration on RedGate’s SQL Scripts Manager, a powerful, reliable, and automated scripting tool compiled with scripts from SQL Server experts for the community.

 

March 2011 Archive

Speaker Bio: Ken Tucker
Speaker:

Ken Tucker is a Microsoft MVP, President of Space Coast .NET user group, and Ineta Membership mentor for Florida.  Ken currently works for Amovius as a developer.

Title: SilverLight MVVM
Abstract:

The MVVM pattern is a common way to develop SilverLight apps. In this demo, Ken will look at some of the MVVM frameworks available and walk through creating an application.


SQL Shot Speaker: Bradley Ball
Speaker Bio: Bradley Ball is a MCITP SQL 2005 & MCTS 2008 Database Administrator 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 the United States. He is currently a Sr. SQL Database Administrator for Publix Supermarkets. Bradley can be found blogging on http://sqlballs.blogspot.com and on twitter here.
Title: Transparent Data Encryption
Abstract: Bradley will be doing a quick lightening round on Transparent Data Encryption, and will show off a script to automate certificate backups.

April 2011 Archive

Speaker: Norman Bowen
Speaker Bio:

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.

Title: Steps, Best Practices & Considerations for Successful Data Conversions
Abstract:

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


Duo Demo: Karla Landrum & Jack Corbett
Title: Social Networking in the Workplace
Abstract: Karla Landrum will be doing a brief demonstration on the benefits of using Twitter from a marketing perspective.  Jack Corbett will be doing a brief demonstration on LinkedIn and the benefits of using that this tool for personal and business use.

Sponsor Demo: Rodney Landrum
Title: RedGate SQL Scripts Manager
Abstract: Rodney Landrum will be presenting a demonstration on RedGate’s SQL Scripts Manager, a powerful, reliable, and automated scripting tool compiled with scripts from SQL Server experts for the community.

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids