Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

January

10

January 2017 WISSUG meeting

  • In-Person @ 833 E Michigan St Milwaukee, Wisconsin, United States (map)
  • 16:30 - 18:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

January 2017 WISSUG meeting

Zero to Hero with PowerShell and SQL Server    Presented by Robert Cain (Arcanecode.com)

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects) library.  Learn how to handle common DBA tasks, such as backups, reviewing error logs, and checking the status of SQL Jobs. You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to make your SQL Server pop with PowerShell.

 

 

Robert Cain   

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team mate at Linchpin People, and co-author of 5 books.

 

A popular speaker, Robert has presented at events such as the SQL PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications,  and nuclear power.

Join the Meeting!  Now using GoToWebinar

We are now using GoToWebinar for a better remote attendee experience.

Please be aware of the following: 

  1. You must register (any time before the meeting) here: WISSUG Chapter Meeting Link   

  2. Choose the appropriate meeting date from the presented list.

  3. After registering, you will receive a confirmation email to join the webinar.

  4. Phone-in audio is not supported; you must use your computer connection for audio.

 

Upcoming WISSUG Meetings

14 Feb 2017 – Dr. Tom Lane - SSAS 2016 Tabular model development.

Mar 2017 – N O    M E E T I N G

Apr 2017 – N O   M E E T I N G

 

Featured Presentation:

Zero to Hero with PowerShell and SQL Server

Robert Cain, Owner Arcane Training and Consulting, LLC

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects) library. Learn how to handle common DBA tasks, such as backups, reviewing error logs, and checking the status of SQL Jobs. You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to make your SQL Server Pop with PowerShell.

About Robert:
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate's SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.

Supplementary Materials

The following event attachments are available to you:

 

 

 

PASSChapterLogo.jpg

sql_micro_sm.gif

PASSChapterLogo100.jpg

Powered by Office 365

sql_micro_sm.gif

sql_ca_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids