SQLSaturday #241 – Cleveland 2014

UpSearch proudly participated at PASS SQLSaturday #241 – Cleveland 2014. The event was held February 8, 2014 at Hyland Software, Building 1, 28500 Clemens Rd., Westlake, OH 44145. UpSearch’s Brian Davis, Kendal Van-Dyke and Allen White volunteered to make four presentations.

Kendal Van Dyke – Building Your Own SQL Server Virtual Playground

Abstract: 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 a cluster? Or maybe you want to try out the latest features in SQL 2012…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.

Session Level: Intermediate

Kendal Van Dyke – Discover, Document, & Diagnose Your Servers on Your Coffee Break

Abstract: Documentation is the bane of every DBA’s existence. We all know we should do it but it’s time consuming; by the time you’re finally done it’s probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that? You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you’ll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches – all while you’re on a coffee break. You’ll look like a rock star without writing a line of code on your own or having to ask management to sign a check. Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office

Session Level: Beginner

Allen White – 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.
Session Level: Intermediate

We appreciate the Ohio North SQL Server User Group’s team effort to host SQLSaturday #241 – Cleveland 2014. If you live in the Greater Cleveland, OH area, consider getting involved with ONSQL.

About PASS SQLSaturday

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.