I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.
Archives: June 2016
Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the idea! A way to analyse wait stats at the database level just like Azure SQL Database? Yes please…. https://connect.microsoft.com/SQLServer/feedback/details/2647332/sys-dm-db-wait-stats-dmvFiled … Continue reading
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored procedure (SQLCLR), however after some homework I now have a PowerShell script that will delete files based on a variable … Continue reading