World is changing so DBA should

I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...

SQL Server 2016 In-Memory OLTP and After Trigger Support

SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project...

Azure Cognitive Services API’s with SQL Server 2016 CLR

[read this post on Mr. Fox SQL blog] Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that have the ability to do some truly amazing...

Azure Cognitive Services API’s with SQL Server 2016 CLR

[read this post on Mr. Fox SQL blog]
Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that...

SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects

Abstract
This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with...

The Clustered Index Is Vital To Your Database Design

This is post #9 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...

Load Testing Results Might Not Be What You Think

Bottlenecks in your testing tools, infrastructure, or methodology might just hurt your load test results, and the results can skew...

Never miss a Great Value IT Training Deal Again

As regular readers of the blog will be aware, over the summer of 2016 here at gethynellis.com we have teamed...

Converting SQL Agent Job Duration to TimeSpan using PowerShell

When you look in msdb for the SQL Agent Job duration you will find that it is an int.

This is...

SQL Server Interview Questions And Answers

This is post going to be more like a list of question for self assessment. So I will not be...