SQL Saturday #80 – Wheeling, WV

I attend SQL Saturday #80 this past weekend in Wheeling, WV.  Many thanks to John Sterrett (Twitter | Blog) for putting a wonderful event.  The event offered us three different tracks with six sessions each.

The first two sessions I attend where on PowerShell by Ed Wilson aka the Scripting Guy.  I just recently starting playing with PowerShell to automate some data collection on my over 90 servers.  He gave us the basics of starting with PowerShell and what commands to start with to help you explore PowerShell.  He also told us some tools you could use to create PowerShell scripts like Primal Forms, ShowUI, Primal Script, PowerShell Plus, and PowerGUI.  This provided me with a better foundation to continue with to get my scripts where I want them to be.

Up next for me was Take Your Automation Scripts to the Next Level by Paul Hiles.  Of particular interest to me was his script that he uses to get compressed backups by zipping the backup files with 7zip.  This something I never thought about automating to help with those server administrators not wanting to give us enough space to house backups.

Then I attened Abi Chapagai‘s presentation on High Availability Solutions in SQL Server.  He went through basics of log shipping, clustering, mirroring, and replication.

Next up was Allen White with Automate Policy-Based Management using PowerShell.  Allen encouraged everyone in the room to get involved in the SQL community stating if he could do anybody could.  Then he went through the process of creating a Policy in PowerShell and how you have to construct the polices that use more than two conditions.

Finally, James Gaines presented Automating Database Source Control.  He demonstrated how to use Red-Gate’s SQL Source Control with Microsoft’s Team Foundation Server to automatically deploy database changes. I’ve been waiting for my one of my SQL Server 2000 systems to be upgraded so we can start to use source control.  Maybe now I can push this on to my newest SQL Server 2008 R2 system.

 

Tracy Boggiano
Follow me

Tracy Boggiano

Database Administrator at ChannelAdvisor
Tracy has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Management and Analytics. She has worked on SQL Server 6.5 and up including currently SQL 2017 CTP 2.0. She enjoys monitoring, performance tuning, and high availability and disaster recovery technologies. Tracy is currently a co-organizar the for special interest group for Advanced DBA Topics for the TriPASS user group.

She also tinkered with databases in middle school to keep her sports card collection organized.

Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court.This is her passion outside of SQL Server and favorite job.More information about this program in North Carolina can be found at http://volunteerforgal.org or the national organization CASA at http://www.casaforchildren.org.
Tracy Boggiano
Follow me