SQLSaturday #427 - Sioux Falls 2015

Event Date: 07/18/2015 00:00:00

Event Location:

  • University Center
  • 4801 N Career Ave Avera Hall
  • Sioux Falls, South Dakota

PDF of Schedule

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: Effective Reporting through SSRS Advanced Authoring Features

Abstract: Effective reporting is not simply the output of data, but the meaningful presentation of that data in a manner that informs the user. SQL Server Reporting Services provides a myriad of features to create a clear, instructive, and interactive experience. This session will demonstrate techniques to utilize SSRS advanced authoring features to facilitate more informative communication. These features include: nesting data regions, leveraging scope, geographic/geometric reporting, complex charting, rich formatting, incorporating managed code assemblies, intuitive drilldown, data from multiple datasets in a single data region, datasets that update source data, and more.

Speaker(s):

  • Brian Larson

Track and Room: BI/Other - Room 250


Title: Automated Enterprise-wide SQL Server Auditing

Abstract: Do you have many SQL instances in your enterprise? Do you have to maintain multiple dev/test/uat/pre-prod/prod environments? Need to spin up new instances often? Do you need a way to ensure these environments are all set up correctly and consistently and be notified of changes to them? If so, you need an enterprise-wide auditing system! I will be presenting my free system that does the following: 1) Collects information an all of your SQL instances daily, 2) sends you a report of any changes that have occurred (new/old/changed values), 3) lets you set up rules for all/some of servers and checks these rules on a daily basis (ie - backup compression should be turned on, Max memory should be less than 2TB, etc) and will even send you the SQL to fix any rules that failed.

Speaker(s):

  • Nem Schlecht

Track and Room: DBA - Room 245


Title: Database Snapshots - Making Your Job Easier

Abstract: Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier? If any of these appeal to you, then you should be familiar with database snapshots within SQL Server. Available since SQL Server 2005, use of this feature can make your life a lot easier.We’ll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot. Once we’ve covered the basics, we’ll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.

Speaker(s):

  • Paul Timmerman

Track and Room: ETL/DB Dev - Avera Hall


Title: Common T-SQL Coding Mistakes and how to Mitigate them

Abstract: Just because you can do it, does not mean that you should.

There are several programming design patterns that work great in object orientated code that do not scale well inside of SQL Server.

In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

Speaker(s):

  • William Wolf

Track and Room: BI/Other - Room 250


Title: A First Look at SQL Server 2016

Abstract: Microsoft has been busy working on the next version of SQL Server - SQL Server 2016. We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB. Row Level Security allows you to add another layer of security to your environment. StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.

Speaker(s):

  • Rick Heiges

Track and Room: ETL/DB Dev - Avera Hall


Title: Continuous Integration for Databases

Abstract: Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

Speaker(s):

  • Steve Jones

Track and Room: ETL/DB Dev - Avera Hall


Title: SSAS Multidimensional vs. SSAS Tabular – Which one do I use?

Abstract: With the release of SQL Server 2012, we were introduced to two possible options when it came to Analysis Services. This ultimately presented a question…”Which one do I use SSAS multidimensional or SSAS tabular”?

Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014. This session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012/2014.

Speaker(s):

  • Alan Faulkner

Track and Room: BI/Other - Room 250


Title: Panel Discussion - Developing SQL Skills

Abstract: Panel discussion on developing SQL Server skills featuring Steve Jones, Paul Timmerman, Bill Preachuk, Brian Larson, and Alan Faulkner. This panel will discuss how and why they became involved with PASS, some strategies for developing great presentations, and suggestions about how to advance your career. .

Speaker(s):

  • Erin Dempster

Track and Room: DBA - Avera Hall


Title: How to collect a baseline on all your servers and still get a good night’s sleep.

Abstract: Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions. With a few free quires and some SSIS magic you can capture a Baseline of your systems. With this you will be able to know exactly where to look and what might be amiss. Before you can say what is wrong with your system you need to know how it reacts under normal circumstances. This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.

Speaker(s):

  • Jim Dorame

Track and Room: DBA - Room 245


Title: Hadoop for the SQL Server Developer/DBA

Abstract: How does The Hortonworks Data Platform (HDP) and Microsoft HDInsight fit into our neat tidy database world? In this beginner-friendly technical session you’ll learn about Big Data from the ground up with a focus on what SQL Server professionals need to know. Find out technical details about what HDFS, MapReduce and YARN actually are how they work. Discover the Hadoop ecosystem and the projects within. Learn how Hadoop complements the traditional relational database world. Discover real-world data tasks/use cases that Hadoop can accomplish.

Speaker(s):

  • Bill Preachuk

Track and Room: ETL/DB Dev - Avera Hall


Title: Tegile - Lunch Session

Abstract: Presentation from Tegile.

Speaker(s):

  • Erin Dempster

Track and Room: DBA - Avera Hall


Title: Advanced Troubleshooting Your SQL Connections

Abstract: Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect. It becomes more challenging when we find nothing is wrong with the way SQL Server is running. In this session we review common mistakes to the configuration of network settings. We’ll also show how to troubleshoot the SQL Server Browser. We’ll cover how to test for firewall issues. Finally we’ll discuss why SQL Server is blamed for dropping its connections.

Speaker(s):

  • Mike Hays

Track and Room: DBA - Room 245


Title: “But It Sounded So Simple!”: Building a Messaging System in Service Broker

Abstract: There’s a lot of general verbiage and API documentation about Service Broker, but how do you fit the queues, services, contracts, and conversations together to actually make something that will work reliably in production? In this session you’ll follow the architecture, design, implementation, and troubleshooting of a simple but production-tested Service Broker messaging framework and get a battlefield-level view of the pitfalls and the payoffs involved in Service Broker development.

Speaker(s):

  • Matt Wigdahl

Track and Room: BI/Other - Room 250


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Nem Schlecht

Twitter: - nemws1

I’ve been a Server Administrator and DBA for 20+ years and have worked with multiple operating systems (UNIX variants, Mac OS X and Windows) and database engines (MySQL/MariaDB, Oracle, PostgreSQL, SQLite, and MSSQL). I currently work a lot with PowerShell and automation as well as supervising a group of awesome systems administrators. I’ve worked for a large state university system, a start-up company, and everything in-between (including my own consulting company). I currently work for Border States Electric as an I.T. Supervisor.

Erin Dempster

Twitter: - https://www.twitter.com/em_dempster

LinkedIn: Erin Dempster

Contact: https://www.endlessreporting.com

Erin currently serves as a SQL Developer II at Trean Corporation in Wayzata, Minnesota. With over 15 years of experience with SQL Server, as a developer and as an administrator, she has dabbled with most areas in the SQL Server realm. Areas of expertise include database design, query tuning and SQL Server Integration Services.

Brian Larson

Twitter: - @Brian_Larson

LinkedIn: Brian Larson

Contact: http://sqlmag.com/author/brian-larson

Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”

Bill Preachuk

Twitter: - @BillPreachuk

LinkedIn: Bill Preachuk

Bill Preachuk is employed by Hortonworks as a Hadoop Solutions Engineer. He is also a SQL Server MCTS with plenty of years spent in the SQL Server DBA/Developer/DW trenches.

Bill has been in IT since 1991 and has presented at PASS Summit , multiple SQLSaturdays, and PASS/Hadoop/Analytics user group meetings in the Twin Cities, Wisconsin, Iowa, Winnipeg, and Ukraine. He also served 2 years on the Board of PASSMN - The Minnesota SQL Server User Group.

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.

Paul Timmerman

Contact: http://blogs.lessthandot.com/index.php/author/mndba/

Paul is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQLSaturday conferences.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Jim Dorame

Twitter: - @DBAJD

LinkedIn: Jim Dorame

Contact: http://www.jamesdorame.com/

Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.

Alan Faulkner

Twitter: - #FalconTekNik

LinkedIn: Alan Faulkner

Contact: http://falconteksolutionscentral.com/

I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation.

Erin Dempster

Twitter: - https://www.twitter.com/em_dempster

LinkedIn: Erin Dempster

Contact: https://www.endlessreporting.com

Erin currently serves as a SQL Developer II at Trean Corporation in Wayzata, Minnesota. With over 15 years of experience with SQL Server, as a developer and as an administrator, she has dabbled with most areas in the SQL Server realm. Areas of expertise include database design, query tuning and SQL Server Integration Services.

Matt Wigdahl

Twitter: - @mlwigdahl

LinkedIn: Matt Wigdahl

Contact: http://wigdahl.net

Matt Wigdahl is Director of Software Quality at ScriptPro LLC and a SQL Server MCP. He has configured, developed with, and optimized queries for SQL Server for over 15 years, on both sides of the developer / DBA line.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx

Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page