UpSearch at SQLSaturday #241
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.
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
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
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.