This series is aimed at beginners in the SQL Server world or at those thrust into the role of DBA with little or no training.  As such we’ll be focusing on some common concepts and doing so at a very high level.  This series will not get especially technical nor will it cover topics in extreme detail.  Also, the demo information will be done using mostly UI from SSMS and wizards as applicable rather than scripting.  If being a full time SQL Server DBA is among your career goals you should consider this series of posts as only a starting point and seek further knowledgeRead More →

Thank you to everyone that attended my class “SSMS Tips and Tricks: Shortcuts for Impatient DBAs”.  As promised, please find the scripts and links below. Session Scripts:   Session Links: Apex SQL Refactor – http://www.apexsql.com/free/ AutoHotKey – https://autohotkey.com SentryOne Plan Explorer – https://www.sentryone.com/plan-explorer sp_whoisactive – http://sqlblog.com/files/folders/release/tags/who+is+active/default.aspxRead More →