SQLSaturday Orlando 2017 Goes Live

Today we’re starting on our 11th SQLSaturday here in Orlando. Normally we rotate the leadership between oPASS and MagicPASS, but...

Top Function – Performance Gain

Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...

VSTS– Hosted Agent is the Default for Releases

In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...

SQL Graph, part I

This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically...

SQL Server Debugging BAD_PAGE_PROCESS Waits

I was recently debugging a slow running SQL instance, when checking the wait stats I noticed a lot of BAD_PAGE_PROCESS...

Friday Reading 2017-06-02

The weather in Dublin has reverted to type (aka rain) but hopefully we’ll get some sun this weekend! This week...

SQL Server Memory Metrics

A very quick post for today, recently I have been working on some code to gather metrics around SQL Server...

SSRS Custom Shared Schedule

Reporting Services
 

Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power...

Technology Gender Gap By State

This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...

Azure Robots – Index Performance Recommendation

They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made....