SQLSaturday #292 - Detroit 2014
Event Date: 05/17/2014 00:00:00
Event Location:
- Lawrence Technological University
- 21000 West Ten Mile Road
- Southfield, Michigan
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: The Sqoop on Big Data from it’s humble beginnings to rise to notoriety
Abstract: Everywhere you turn in the technological literature people are talking and writing about Big Data. In this presentation you will learn about the origins of Hadoop, and how it is implemented today. In addition to the most infamous way of retrieving data from Hadoop, Map Reduce, there another way to manipulate the Hadoop data. It is possible to query the data from Hadoop in SQL Server through the use of Sqoop. In order to better understand the logic behind Sqoop, I will present information on the Hadoop components. Having this information will help you determine how the tools all fit together so that you will know which tools are the best choice for getting the desired answers from your data sources.
Speaker(s):
- Ginger Grant
Track and Room: BI - N/A
Title: Building a Database Deployment Pipeline
Abstract: The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.
Speaker(s):
- Grant Fritchey
Track and Room: Dev - N/A
Title: Partitioning System for “WORM” Tables
Abstract: This isn’t your typical talk on “partitioning”. This is a deep dive into all the problems that you’ll run into when partitioning new or existing “Write Once, Read Many” tables, such as large Audit Tables, and how to code around them. You’ll also learn the methods to support three of the best reasons for partitioning such monster tables… MUCH shorter nightly index maintenance, MUCH shorter and smaller backups, and MUCH shorter “Get back in business” piecemeal restores. We’ll also learn how to do the “impossible”… compact a File Group (one per partition) so that there’s virtually no unused space in the underlying file. After all, we don’t want to set any “free” disk-space to “Read Only”. Don’t let the “Advanced” rating of this session scare you away. Anyone with a decent handle on T-SQL (or wants one) will be able to understand this session because “all will be explained” and there will be oodles of well-documented code to back up the explanations.
Speaker(s):
- Jeff Moden
Track and Room: DBA - N/A
Title: What Just Happened? Why You Need to Constantly Monitor Your Environment
Abstract: You get back from lunch on a Friday and your inbox is exploding with emails from the users claiming the system is hanging. What do you do now? How are you going to figure out what is currently causing the issue and what started the problem in the first place?
In this session you’ll learn why it’s important to monitor what your server is doing and track any changes that have been made. You’ll learn about the components you can use to create your own solution as well as some real world examples of how correct monitoring can help you troubleshoot day-to-day issues. You’ll also see how it can help the new DBA get a grip on what’s going on in their environment.
Full-time monitoring can provide you with quick answers to many common issues; such as “random” system slow-downs, deadlocks, and that pesky SQL error the users see once every two months. Having a great infrastructure in place can leave you with more time for the fun stuff, like online training and post-lunch power naps.
Speaker(s):
- Mark Wilkinson
Track and Room: Wildcard 2 - N/A
Title: You’re the DBA. Now What?
Abstract: Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you’re a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.
Speaker(s):
- Gill Rowley
Track and Room: Wildcard 1 - N/A
Title: T-SQL For Beginning Developers
Abstract: This session will provide a variety of programing insights that I have used over many years of SQL development. This is aimed at developers who are beginning to write T-SQL. Topics will include functions, performance, thinking about how the optimizer works while writing code, debugging techniques, data architecture, CTEs, triggers and any topics you bring to the floor.
Speaker(s):
- Tom Groszko
Track and Room: Dev - N/A
Title: Getting Started Reading Execution Plans
Abstract: The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what’s important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You’ll learn where to start, what to look for first, and you’ll be better prepared to tune your queries. We’ll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.
Speaker(s):
- Grant Fritchey
Track and Room: Dev - N/A
Title: DIY Geocoding
Abstract: Do It Yourself Geocoding – Step-by-step instructions on how to build a CLR assembly that will allow you to directly query various web services for geospatial data. We will also learn how to ensure a high level of confidence in the accuracy of your geospatial data.
Speaker(s):
- Frank Murphy
Track and Room: Wildcard 2 - N/A
Title: SQL Audit - auditing doesn’t have to be boring
Abstract: Let’s face it, auditing isn’t fun. But if you’re a DBA, you need to know what’s going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we’ll cover what you can and can’t audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn’t have to be hard. And with the help of a little custom coding, it can even be fun.
Speaker(s):
- Colleen Morrow
Track and Room: DBA - N/A
Title: SQL Server 2014 - In-Memory OLTP
Abstract: SQL Server 2014 has added In-Memory OLTP capabilities that provide new high-end performance for mission critical applications. This session will describe the new in-memory features and the table and stored procedure changes to support in-memory. We will review the new in-memory architecture that has been added to the SQL Server database engine and show a few demos that illustrate the tremendous performance gains SQL Server 2014 delivers.
Speaker(s):
- Rick Brewis
Track and Room: DBA - N/A
Title: All About the SSIS Catalog (SSISDB)
Abstract: Wow, deployment of SSIS packages in SQL Server 2012 is radically different, when the new SSIS catalog is used (“Who Moved My Cheese?”). This session examines the “new” SSISDB, its architecture and functionality and compares that to the “old” method of Package Configurations in previous versions of SSIS.
Speaker(s):
- George Squillace
Track and Room: BI - N/A
Title: Extending SQL Server with Advanced Analytics and R
Abstract: The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.
Speaker(s):
- Michael Schulte
Track and Room: BI - N/A
Title: Achieving Compliance with SQL Server
Abstract: There are a plethora of regulatory compliance mandates that affect business today with names like Sarbanes-Oxley, PCI-DSS, and HIPAA. How does a database professional implement these controls in your SQL Server infrastructure? We will review the basics of the GRC (Governance, Risk Management, and Compliance) methodology. You will learn about the tools that you can use to achieve compliance such as TDE, Auditing, and Identity Management. Come to this session and learn how to build a compliant infrastructure that keeps the DBA team, the auditors and the business leaders happy.
Speaker(s):
- Craig Purnell
Track and Room: Wildcard 2 - N/A
Title: Big Data Trends with the Microsoft Parallel Data Warehouse
Abstract: Big Data is a hot topic in the news today. Many organizations are trying to develop their big data strategy but there is much confusion over the definition of the term and how it aligns to technology. Microsoft’s SQL Server Parallel Data Warehouse (PDW) provides a platform upon which to build your big data solution. This session will peel back the covers and discuss what big data means and provide a deep dive into the architecture of PDW.
Speaker(s):
- Christopher Campbell
Track and Room: BI - N/A
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract: So you’ve heard of Hekaton (In-Memory OLTP) but you aren’t sure where to start or if it’s for you or not. Maybe you’ve heard or read some information and not sure what’s true or not. There’s a number of misconceptions out there about Hekaton. By the end of this session you’ll have a better understanding of what Hekaton is and how it may be able to help you. We’ll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker(s):
- Brian Davis
Track and Room: Wildcard 2 - N/A
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract: Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it’s easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we’ll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
Speaker(s):
- Allen White
Track and Room: DBA - N/A
Title: Troubleshooting Your Network Connections
Abstract: Database professionals are often challenged to troubleshoot why a user cannot connect to a SQL Server instance. Attend this session to learn the basics of how SQL Server listens for connections and how it uses its browser service. Also learn what utilities the Windows operating system offers to help you in troubleshooting those connection issues.
Speaker(s):
- Mike Hays
Track and Room: Wildcard 1 - N/A
Title: Dynamic Connections in SSIS
Abstract: Have you ever had to import a ton of CSV or DBF files into a database? Did you create a separate connection object for each file in SSIS? I will show you how to create one connection object and dynamically change that as you navigate through the file system, greatly reducing your development time. Yes, we will be typing in this demo!
Speaker(s):
- Gill Rowley
Track and Room: Dev - N/A
Title: SQL Server 2014 Managed Backup to Windows Azure
Abstract: In this session you will learn how to configure, run, and monitor the new SQL Server 2014 feature SQL Server Managed Backup to Windows Azure. Also, SQL Server database recovery from Windows Azure will be covered. This session will also discuss interfacing with the Windows Azure Storage Service. Experiences from using SQL Server Managed Backup and practical guidance will be provided.
Speaker(s):
- John Gayer
Track and Room: Wildcard 1 - N/A
Title: The Most Important Dynamic Management Objects for New DBAs
Abstract: The Dynamic Management Objects are a very powerful set of tools available to SQL Data Professionals. There are so many though that it’s easy to get overwhelmed. Join Tim Ford, Creator of The Periodic Table of Dynamic Management Objects (http://thesqlagentman.com/go/periodic2012/) as he presents the most important DMOs for DBAs to start using immediately.
Speaker(s):
- Tim Ford
Track and Room: Wildcard 1 - N/A
Title: Hacking SQL Server - A Peek into the Dark Side
Abstract: Learn how to practice hacking without going to jail or getting fired. In this presentation we’ll be demonstrating how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks. We will focus mostly on detailed tactical defenses but also cover some higher level strategic defenses.
Speaker(s):
- Dustin Prescott
Track and Room: Dev - N/A
Title: How to Argue with Your Infrastructure Admins – and Win
Abstract: Do you feel like you spend hours going round-and-round with your system, storage, and virtualization administrators over SQL Server best practices? Are their application-agnostic requirements hurting your SQL Server’s performance, or worse, their reliability? David Klee (@kleegeek) will discuss valuable insight into how to start and work through the common conversations with them on the SQL Server infrastructure practices that matter to you the most, and how to succeed in getting what you need while keeping everyone happy.
Speaker(s):
- David Klee
Track and Room: Wildcard 1 - N/A
Title: SSIS Templates Can Make Your Life Easier
Abstract: How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
Speaker(s):
- Brian Davis
Track and Room: BI - N/A
Title: Power BI – Cloud Self-Service BI
Abstract: Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
Speaker(s):
- Ginger Grant
Track and Room: Wildcard 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.
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
George Squillace
Contact: http://www.e-Squillace.com
George has been in the I.T. industry for over twenty eight years and has been a professional trainer for over twenty years, an MCT since 1997. He has worked with and certified in every version of SQL Server since SQL Server 2000 along with a number of other industry certifications. He is very enthusiastic about the SQL Server product, especially the BI capabilities.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Frank Murphy
Twitter: - https://twitter.com/dfmurphy20
LinkedIn: Frank Murphy
Contact: http://www.baldmanrunning.com
Brotherhood Mutual is a nation-wide property/casualty insurer that focuses on churches and related organizations. Frank works in the Enterprise Risk Management department as a Geospatial Analyst, where a large portion of his duties involves manipulating spatial data.
Tom Groszko
I have been working with MS SQL since 2000 and prior to that with Oracle and Sybase SQL. I have been working with a variety of databases for many years. I also develop desktop applications with C++ and C#.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Gill Rowley
Twitter: - @BadgerBully
LinkedIn: Gill Rowley
Contact: http://gillrowley.wordpress.com
I#39;m a SQL Server DBA and Business Intelligence Consultant with over 10 years experience working with all versions of SQL Server dating back to SQL Server 7.0. When not playing with SQL Server I spend my time hunting, fishing, weightlifting, relaxing on my boat, playing men#39;s fast pitch softball, and playing with my rescued bull terrier Lola.
John Gayer
John Gayer has over forty of experience in information technology as a developer, database administrator, system architect, and manager. As a database administrator he has worked with the following commercial database management systems, System 2000, ADABAS, IMS, DB2, Oracle, and SQL Server. He has worked with all versions of SQL Server from SQL Server V7.0 thru SQL Server 2014.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Gill Rowley
Twitter: - @BadgerBully
LinkedIn: Gill Rowley
Contact: http://gillrowley.wordpress.com
I#39;m a SQL Server DBA and Business Intelligence Consultant with over 10 years experience working with all versions of SQL Server dating back to SQL Server 7.0. When not playing with SQL Server I spend my time hunting, fishing, weightlifting, relaxing on my boat, playing men#39;s fast pitch softball, and playing with my rescued bull terrier Lola.
Michael Schulte
Mike Schulte is a decision support analyst at Gateway Health Plan. He works with tools such as SQL, Tableau, R, SAS, Azure Machine Learning, and Spark to use data to support decisions. These days he is trying to change the world by supporting value-based healthcare initiatives, whereby healthcare costs are lowered while quality of care is improved! In his spare time, he teaches economics and philosophy courses, plays chess and directs chess tournaments, and rings bells in church bell towers.
Dustin Prescott
Twitter: - @nujakcities
LinkedIn: Dustin Prescott
Contact: http://nujakcities.wordpress.com
Dustin has worked for a large insurance company since graduating from Western Michigan University in 2006. Dustin has certifications from Microsoft, EMC, VMWare and Cisco. He currently wears three hats as a SQL/Storage/Virtualization administrator but enjoys a large array of other infrastructure and automation topics. He blogs about these topics at http://nujakcities.wordpress.com.
Rick Brewis
Contact: http://www.microsoft.com/sqlserver
Rick Brewis is a veteran of Microsoft for over nine years. He is a Technology specialist focusing on SQL Server, Business Intelligence, Data Warehouse, and beginning a journey into Big Data and cloud computing. Rick has worked in the database arena for Oracle Corporation, Digital Equipment, and also has experience with Sybase, Ingres, and database management and development tools.
Colleen Morrow
Twitter: - @ClevelandDBA
LinkedIn: Colleen Morrow
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
Mike Hays
LinkedIn: Mike Hays
Contact: http://www.thesqlreport.com/
Mike has been working with Microsoft SQL Server for the last twenty years. Currently working as a Database Administrator for a diversified energy company, he has also worked in the retail, manufacturing, banking sectors. He holds a Master’s degree in Computer Information Science from Cleveland State University. He currently resides in Ohio with his girlfriend Alexia, her two children and their dog Lanna.
Mark Wilkinson
Twitter: - http://twitter.com/m82labs
Contact: http://www.m82labs.com
I am a father of 4, and live in Raleigh North Carolina. I love fixing problems, and learning new technologies that can help me fix those problems faster and better than I did the time before.
In my spare time I like to read, speak, and learn new things. I currently work as a Database Administrator at ChannelAdvisor where I solve fairly interesting problems on fairly large databases.
You can often find me on Twitter where I talk about SQL, beer, and anything else I find interesting.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Christopher Campbell
Contact: http://www.blue-granite.com
Chris Campbell is the Analytics Platform Practice Lead at BlueGranite, Inc. His team focuses on data warehouse and big data solutions specializing in SQL Server, SQL Server Parallel Data Warehouse and Hadoop. BlueGranite is a premier Microsoft partner with expertise in data analytics and business intelligence solutions on the Microsoft data platform.
Sponsors
The following is a list of sponsors that helped fund the event: