SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

All About SQL

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

sys.dm_db_wait_stats DMV

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

Read more

0 comments, 118 reads

Posted in All About SQL on 2 June 2016

PowerShell – Deleting those files

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

Read more

0 comments, 121 reads

Posted in All About SQL on 1 June 2016