SQLSaturday #190 Denver–Ben Miller and TJay Belt

Ben Miller and TJay Belt presented at the Denver SQLSaturday event on Sept. 28, 2013.

Ben’s topic was “SMO Internals for High Performance PowerShell

Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.


 

TJay’s topic was “Documentation—You Know You Love It

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.

 

 
 
Loading Map....

Date/Time
Date(s) - 09/28/2013
8:00 AM - 5:30 PM

Location
Cherry Creek Presbyterian Church - Community Life Center

Categories