SQLSaturday #342 - Mobile 2014
Event Date: 09/27/2014 00:00:00
Event Location:
- University of South Alabama Shelby Hall
- 150 Jaguar Dr
- Mobile, Alabama
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Everything You Ever Knew About SSIS Is Null and Void
Abstract: With the release SQL Server Integration Services 2012, Microsoft did a massive overhaul to the deployment platform for SSIS. Gone is the old file based deployment system and MSDB. New to SSIS is the Integration Services Catalog.
Along with the catalog came many new improvements, such as package and project parameters. No longer do you have to mess around with ugly configuration files, or the mess of passing data between packages. Also included are new reports which you can use to examine your packages as they run, or see the status of past runs.
In this session we’ll look at how the new project based deployment model simplifies your SSIS coding. We’ll also take a dive into the catalog, uncovering the wealth of information it can provide.
Speaker(s):
- Robert Cain
Track and Room: Track 4 - N/A
Title: Zero to Hero with PowerShell and SQL Server in 1 Session
Abstract: There are two kinds of people in the SQL Server world. Those who are using PowerShell, and those that will be. In this session you’ll learn how to become one of the “cool kids” using PowerShell.
We’ll begin with a super fast paced introduction to PowerShell starting with a quick overview of the two environments you can use PowerShell in, command windows and the ISE (Integrated Scripting Environment). Next you’ll learn about cmdlets, variables, functions, and logic flow. But wait, there’s more! After that we’ll learn how to interact with SQL Server using the SQL Provider. For the last dance we limbo, going low level with the the SQL Managment Object library, also known as SMO.
Don’t be left behind, learn how to leverage the power of PowerShell in your SQL Server environment.
Speaker(s):
- Robert Cain
Track and Room: Track 4 - N/A
Title: Aspect Oriented Programming
Abstract: Have you heard of cross-cutting concerns? Do you fret about making the slightest change to your code-base? How does the sound of a new requirement make you feel? If you answered positively to any of the aforementioned questions, you will want to learn about AOP. AOP is a technique for localizing your cross-cutting concerns, such as transactions, security, logging and prevent them from littering what your code was originally intended to handle, namely, your business. Don’t let cross-cutting concerns strangle your code base. Come learn about the PostSharp library, a library for the .NET framework that will aid you in keeping your code clear of cross-cutting concerns.
Speaker(s):
- Daniel Rosales
Track and Room: Track 3 - N/A
Title: What’s New in PowerShell Version 5?
Abstract: With PowerShell version 4 being announced at TechEd last year and two preview versions of PowerShell version 5 already being released this year, it shows how committed Microsoft is to PowerShell and that it’s not going away any time soon which is why you can’t afford to ignore PowerShell or put off learning it any longer. During this session, scripting games winner Mike F Robbins will cover the new features that are in the preview version of PowerShell version 5 to include the cmdlets in the OneGet module, the NetworkSwitch module, the PowerShellGet module and much more that you’ll have to come to this session to find out about! This session is based off of a preview version of PowerShell version 5 so everything shown is subject to change.
Speaker(s):
- Mike Robbins
Track and Room: Track 2 - N/A
Title: Learn PowerShell or Die! for the DBA
Abstract: Learn PowerShell or Die! That is, learn PowerShell or your career in IT will die. PowerShell is one of those technologies that as a DBA you’ll either love or hate, but believe it or not DBA’s already have the mindset for scripting since you live and work with T-SQL day in and day out. During this session, scripting games winner Mike F Robbins will demonstrate the different methods of retrieving information from your SQL Servers to include a way to simply wrap your existing T-SQL code inside of a PowerShell one-liner, working with SQL Server in PowerShell as if it were a file system, and creating reusable tools via functions in PowerShell that use SMO to retrieve just about any information about your SQL Servers that you could imagine.
Speaker(s):
- Mike Robbins
Track and Room: Track 2 - N/A
Title: Managing Access Control with PowerShell
Abstract: Access control in Windows, while very powerful, can be very complicated. Working with security descriptors one object at a time through the GUI is fairly straightforward, but that doesn’t help when you need to verify and/or configure settings for multiple objects at the same time. There are utilities available to handle this in an automated fashion, but most only work with certain types of objects, and they each have their own syntax. Fortunately, PowerShell has the ability to replace most, if not all, of those utility applications. In this session, we’ll cover ways to use PowerShell to view and edit access control lists for almost any object in Windows that is secured with a security descriptor, including files, folders, registry keys, services, processes, WMI namespaces, Active Directory objects, and more. We’ll cover using both native PowerShell commands, .NET methods, and the free PowerShell Access Control script module.
Speaker(s):
- Rohn Edwards
Track and Room: Track 4 - N/A
Title: Design and Implement BI like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker(s):
- William E Pearson III
Track and Room: Track 3 - N/A
Title: Getting Started with MDX
Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker(s):
- William E Pearson III
Track and Room: Track 3 - N/A
Title: Fundamentals of Disaster Planning Recovery
Abstract: In this session, we’ll cover the basics of Disaster Planning and key operational items to consider when establishing software systems. We’ll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.
Speaker(s):
- Michael Viron
Track and Room: Track 1 - N/A
Title: ** Reporting Services Support /Tips/Tricks **
Abstract: I challenge you to bring your SSRS report issues to this session. Together we will try to find a way to solve your reporting issues. To help with solving your reporting issues, it would be great if you could bring the t-sql scripts to create the required schema and data. It would also be great to bring the report files that need to be updated.
If you don’t have any reporting issues, I’ll have a few reports to show you. These reports are a lot more complex then most of the reports you need to create. Though they will demonstrate some tips and tricks.
Speaker(s):
- Ryan Duclos
Track and Room: Track 1 - N/A
Title: Lessons Learned from Starting Software Development Projects
Abstract: In this session we’ll cover key lessons learned from both creating new divisions, product launches, and starting new organizations. These can help speed up the initial startup phases, decrease expenses, and build a successful team-based environment.
Speaker(s):
- Michael Viron
Track and Room: Track 4 - N/A
Title: The Elephant in the Room; A DBA’s Guide to Hadoop
Abstract: The term “Big Data” has risen to popularity in the last few years, and encompasses data platforms outside of the traditional RDBMS (like SQL Server). The purpose of this session is to introduce SQL Server DBA’s to Hadoop, and to promote understanding of how schema-less data can be collected and accessed in coordination with the traditional SQL models. We’ll cover the basic vocabulary of the Hadoop platform, Microsoft’s integration efforts, and demonstrate how to get started with “big data”.
You can download my slides at: http://codegumbo.com/index.php/code-etc/
Please follow me on twitter: https://twitter.com/codegumbo
Speaker(s):
- Stuart Ainsworth
Track and Room: Track 1 - N/A
Title: Introducing the SSAS 2012 BI Semantic Model, aka Tabular
Abstract: New to SQL Server Analysis Services 2012 is the BI Semantic Model, also known as the Tabular model. In this session you’ll learn about the newest way to do analytics in SQL Server. We’ll compare and contrast it with the traditional Multidimensional Model, then see how to create your first “cube” using the Tabular mode. Finally we’ll look at some of the reporting options for using your new Tabular database, including SSRS, Excel, and PowerView.
Speaker(s):
- Robert Cain
Track and Room: Track 1 - N/A
Title: Windows Server 2012 R2 High Availability for SQL Server
Abstract: With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? What’s needed for geo-clustering? Come learn from a Windows Server admin and (accidental) DBA who’s been building SQL Server clusters since 2000 (the year and the version!). We’ll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it’s pretty cool!).
Speaker(s):
- Sven Aelterman
Track and Room: Track 2 - N/A
Title: What’s in your toolbelt?
Abstract: This session is intended to cover some basic database administration tasks and some different approaches to monitoring, deployment, and scripting. We’ll use the Red Gate Toolbelt to address some basic problems, but we’ll also discuss these challenges from a more general layer. We’ll also cover some basic performance tuning, and discuss how baseline analysis can help in quickly identifying problems.
Speaker(s):
- Stuart Ainsworth
Track and Room: Track 1 - N/A
Title: Data Warehouse Indexes
Abstract: A datawarehouse environment is used differently than a transactional environment, so architecture and indexing strategies should also be different. In this presentation, we review what the ultimate goal of an index really is, what the point of a data warehouse is, and how they relate to each other. You will also learn common practices for indexing the different types of warehouse tables, specifically dimension tables, fact tables, and staging tables. We will review cases when it is useful to have summary level fact tables, in addition to detail level fact tables. Then, lastly, we will look at the benefits, and gotchas, of using columnstore indexes.
Speaker(s):
- Glenda Gable
Track and Room: Track 3 - N/A
Title: Microsoft Azure SQL Database
Abstract: SQL Database is part of the Microsoft Azure platform. The SQL Database component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft data-centers around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations.
***It is assumed that you have familiarity with SQL Server.
Speaker(s):
- Ryan Duclos
Track and Room: Track 1 - N/A
Title: SQL Server Internals
Abstract: A semi-deep dive into the internal parts of SQL Server that make it work including system tables, Information Schema views, and how table definitions, stored procedures, etc. are really stored and managed. Find out why everything you know about databases is an elaborate illusion.
Speaker(s):
- Matthew Roberts
Track and Room: Track 2 - N/A
Title: Managing a Technical Team: Lessons Learned
Abstract: I got promoted to management a couple of years ago, and despite what I previously believed, there were no fluffy pillows and bottles of champagne awaiting me. My team liked me, but they didn’t exactly stoop and bow when I entered the room. I’ve spent the last year relearning everything I thought I knew about management, and what it means to be a manager of a technical team. This session is intended for new managers, especially if you’ve come from a database (or other technical) background.
Speaker(s):
- Stuart Ainsworth
Track and Room: Track 4 - N/A
Title: The Binary Language of Music
Abstract: Take a fascinating journey into how our minds work and discover how binary and mathematical patterns found in music can be used to learn the underlying language of music theory.
Speaker(s):
- Brian Rigsby
Track and Room: Track 2 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Michael Viron
Twitter: - mviron
LinkedIn: Michael Viron
Michael Viron has a wide range of experience as a senior IT manager amp; business owner. As Director of IT amp; Software Engineering at KAMedData, Inc, he has been heavily involved in coordinating numerous product launches amp; both company amp; division startups. A key team member, his main responsibilities include technical operations, project management, security, short and long range technical planning, and development. As owner of General Education Online, he handles both IT and business operations.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Mike Robbins
Twitter: - @mikefrobbins
LinkedIn: Mike Robbins
Contact: http://mikefrobbins.com/
Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.
Sven Aelterman
Twitter: - @svenaelterman
LinkedIn: Sven Aelterman
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
Rohn Edwards
Twitter: - @magicrohn
LinkedIn: Rohn Edwards
Contact: http://rohnspowershellblog.wordpress.com
Rohn Edwards is a Windows system administrator and a PowerShell enthusiast. He is the co-founder of the Mississippi PowerShell User Group.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Ryan Duclos
Contact: http://about.me/rduclos
Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.
Mike Robbins
Twitter: - @mikefrobbins
LinkedIn: Mike Robbins
Contact: http://mikefrobbins.com/
Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Glenda Gable
Twitter: - @ggable313
Contact: http://sql313.com
Glenda has worked with databases in some form or another for 13 years, and loves working with data. She has worked in the healthcare, state park, construction licensing, and not-for-profit industries. She currently works for LHC Group in Lafayette, LA in BI, handling everything from servers/software maintenance to reporting and all the ETL transactions in between. Glenda is the President of the Acadiana SQL User Group in Lafayette and speaks at local events.
Ryan Duclos
Contact: http://about.me/rduclos
Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.
Daniel Rosales
Daniel Rosales has been programming in IT for over 10 years.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Matthew Roberts
Matthew Roberts is a native of Lucedale, MS where he returned after two decades of adventures which included working as an industrial electrician, a stint in the Army working with communications satellite systems, network field service, running a hospital help desk, creating an Air Force technical training system, and two years at Guantanamo Bay, Cuba. After returning home, he joined Rural Sourcing Inc. as a Technical Lead for their Mobile, AL development center.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Brian Rigsby
Twitter: - @ZenDeveloper
Contact: http://zendeveloper.blogspot.com
Brian#39;s formal education is in music, but he is an eighteen year software development veteran. His unorthodox presentation style is both inspirational and entertaining.
Michael Viron
Twitter: - mviron
LinkedIn: Michael Viron
Michael Viron has a wide range of experience as a senior IT manager amp; business owner. As Director of IT amp; Software Engineering at KAMedData, Inc, he has been heavily involved in coordinating numerous product launches amp; both company amp; division startups. A key team member, his main responsibilities include technical operations, project management, security, short and long range technical planning, and development. As owner of General Education Online, he handles both IT and business operations.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Sponsors
The following is a list of sponsors that helped fund the event: