Posts

SQLSaturday #320 – Raleigh 2014

SQL Server Team - blog - August 2014

UpSearch at SQLSaturday #320

UpSearch proudly sponsored PASS SQLSaturday #320 – Raleigh 2014. The event was held September 6, 2014 at the Wake Tech Northern Campus, 6600 Louisburg Road, Raleigh, NC 27616. UpSearch’s sponsor raffle giveaway was a FREE SQL Server Health Check, a $2,000 value.

Sponsor Raffle Winner

Congratulations Geetha Namballa and Fujitsu America, Inc.

Geetha Namballa won UpSearch’s sponsor raffle. Her organization receives a FREE SQL Server Health Check.

Presentations

The UpSearch team (pictured left to right: Allen White and Brian Davis) also supported SQLSaturday #320 – Raleigh 2014 by making four presentations:

SQL Server Team Allen White and Brian Davis

Allen White presented on how to use PowerShell to efficiently manage SQL Server.

Allen White presented on how to use Server Broker.

Brian Davis presented on how to use SSIS Templates.

Brian Davis presented on how to automate SQL Server installs.

Goodbye Next, Next, Next...Hello Automated Installs!

Special Mentions

We appreciate the Triangle SQL Server User Group’s (triPASS) team effort to host SQLSaturday #320– Raleigh 2014. If you live near Raleigh, N.C. consider getting involved in triPASS and find them on Twitter at .

And to all of our SQL Server BFFs, like Paul Turley and Randy Knight, thank you for making SQLSaturdays so much fun!

 

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides the tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. 

At the local event level, SQLSaturday events:

  • Encourage increased membership for the local user group
  • Provide local SQL Server professionals with excellent training and networking opportunities
  • Help develop, grow, and encourage new speakers

To learn more about PASS SQL Saturday visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round UpSearch provides as needed Microsoft SQL Server DBA Services across the globe. We specialize in helping leaders protect, unlock and optimize data’s value.

To learn more about UpSearch visit https://upsearch.com.

 

Automate Your ETL Infrastructure with SSIS and PowerShell

 

About the Presentation

 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

Presentations (Upcoming & Past)

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is a Microsoft SQL Server MVP and Practice Leader at UpSearch.

For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data’s usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for almost 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

Learn more about Allen White at  https://upsearch.com/allen-white.  

About UpSearch

up-social-round       UpSearch provides as needed Microsoft SQL Server DBA Services across the globe. We specialize in helping leaders protect, unlock and optimize data’s value.

SQLSaturday #299 – Columbus 2014

SQL Server Team - blog - August 2014

UpSearch at SQLSaturday #299

UpSearch proudly sponsored PASS SQLSaturday #299 – Columbus 2014.  The event was held Jun 14, 2014 at the Bishop James A. Griffin Student Center (Bldg 17) on the beautiful Ohio Dominican University campus located at 1215 Sunbury Road, Columbus, OH 43219. UpSearch’s Allen White and Brian Davis volunteered to make four presentations.

Sponsor Raffle Winner

Congratulations Scott Thomas and Fiserv!

Scott Thomas won UpSearch’s sponsor raffle. His organization, Fiserv, receives a FREE SQL Server Health Check.

Presentations

The UpSearch team (pictured left to right: Brian Davis and Allen White) also supported SQLSaturday #299 – Columbus 2014 by volunteering to make four presentations:

SQLSaturday #299 Columbus - June 14 2014

Brian Davis presented Getting Started with Hekaton and how Hekaton can help you.

gettingstartedwithhekaton

Brian Davis made a presentation on how to use SSIS Templates.

by Brian Davis

Allen White presented how to keep your data warehouse updated using SQL Server Service Broker messages from your OLTP database.

Allen White made a presentation on how to use PowerShell to efficiently manage SQL Server.

Special Mentions

We appreciate the Columbus SQL Server User Group’s team effort to host SQLSaturday #299 – Columbus 2014. If you live in the Greater Columbus, Ohio area, consider getting involved with Columbus PASS (CBusPASS).

And finally, a special thank you to Chris Bell of WaterOx Consulting for making a SQLSaturday #299 – Columbus 2014 quick review.

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides the 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

up-social-round

UpSearch provides as needed Microsoft SQL Server DBA Services across the globe. We specialize in helping leaders protect, unlock and optimize data’s value.

To learn more about UpSearch visit https://upsearch.com.