SQLSaturday #363 Nashville–Randy Knight and Ben Miller
Randy Knight—President and Principal Consultant at SQL Solutions Group and a Microsoft Certified Master—and Ben Miller—Principal Consultant, MCM and Microsoft MVP—both presented at the Nashville SQLSaturday event on January 17, 2015.
Randy’s topic was Understanding the SQL Server Transaction Log
The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.
Ben’s topic was PoShDBA: Practical PowerShell for the DBA
This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and “I have to have it now” stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour.
Find full event details on the Nashville event site.
Date(s) - 01/17/2015
8:30 AM - 5:30 PM