SQL DBA With A Beard
Archives: November 2014
A look at the SQL Assessment Intelligence Pack in Operational Insights
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data in one place. It can collect data from all of your machines either via SCOM or by using an agent. Once the data is… Read more
4 comments, 6,742 reads
Posted in SQL DBA With A Beard on 24 November 2014
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received the Blitz Result: No SQL Server Agent Alerts Configured and like a good and conscientious DBA you have set them up. Read more
2 comments, 6,965 reads
Posted in SQL DBA With A Beard on 18 November 2014
#tsql2sday #60 – Something New Learned – Problem Step Recorder
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and follows… Read more
7 comments, 2,383 reads
Posted in SQL DBA With A Beard on 11 November 2014
Generating T-SQL Randomly with Powershell
I have a lab on my laptop running various servers so that I can problem solve and learn and recently I wanted to add several months of data into a database. I had created a stored procedure to take some parameters perform some logic and insert the data.
To execute… Read more
1 comments, 526 reads
Posted in SQL DBA With A Beard on 5 November 2014
Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening I wrote a Powershell script to provide some alerts by email.
This is the script and how I worked my way through the solution. I hope it is of… Read more
8 comments, 4,453 reads
Posted in SQL DBA With A Beard on 4 November 2014