Power BI NFL Fantasy Football 2016 Reports

If you have followed my blog for the past year or so you may remember when I posted a Power...

Resolve Microsoft SQL Server Error Code 824

Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the...

SQL Saturday Charlotte is Coming!

That’s right, SQL Saturday Charlotte is coming September 17, 2016.  Next to the annual PASS Summit, this is my favorite...

Filtering Objects with DLM Dashboard

I’ve been looking at some of the features of DLM Dashboard as I go through work building database development pipelines....

ForumSurfer – a RSS reader for the SQL Server online community

Today I published the first release of ForumSurfer, a RSS reader designed explicitly to be a tool for the SQL...

Organizing a SQL Saturday – Part 2 – The Team

A lot of these types of events are pulled together by the local user group. If there is none, it...

Power BI with Narrative Science: Look Who's Talking?

[2016-Aug-31] Someone said a picture is worth a thousand words and this is true that in most cases a visual representation...

Sql Server - Find and Replace a value across all tables in database

Find and Replace a value across all tables in database

In my project I faced this problem due to typing mistakes....

Sql Server - Monitoring the Performance of All Stored Procedures

Monitoring the Performance of All Stored Procedures 

Every Project suffer from this problem, over the time they
have developed many stored procedure...

Sql Server - Monitoring the Performance of All Stored Procedures

Monitoring the Performance of All Stored Procedures 

Every Project suffer from this problem, over the time they
have developed many stored procedure...