Tag Archives: SQL

Monitoring CPU

As part of a licensing project, it was found to be very useful to get an overview of current servers CPU across the SQL estate. There was an expensive 3rd party software solution that was reporting high CPU usage on … Continue reading

Posted in Management Studio, Performance Tuning | Tagged , , , , | Leave a comment

5 things in 5 minutes presentation- Data & Gravy

It was 2nd year attending the great data event hosted in Leeds (for those who don’t know its near Manchester and not far from Lancashire), last year I did a full hour presentation. This year I wasn’t as organised submitting … Continue reading

Posted in PowerShell, Productivity, SQL Notebooks, Tips & Tricks, TSQL | Tagged , , , , , , , , , , | 2 Comments

SQL Server Security ( Post 2)

Have you any issues? (re-post from http://blog.solutionsctrl.com/sql-security-part-2) Can you answer yes to all these questions:- • Do you have a defined security policy that tells you what are acceptable settings? • Have you and do you regularly check compliance against these? … Continue reading

Posted in SQL Security | Tagged , | 1 Comment