SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a...

SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a...

Deployment Contributor Logger

Niche tool of the day If you know what a deployment contributor is and have wanted to see what steps were in a plan and have got bored setting...

Session Action Metadata

Knowing how to access the deployed session metadata and the event metadata attached to that session, I will now begin the dive into how to find the same relevant...

Session Action Metadata

In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...

New SSRS features in SQL 2016 CTP 2.4

SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager...

Updating a view

I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...

Utility link for excel import to SQL

Utility link for excel import to SQL

Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...

What’s happening in Asia Pacific?

TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.

I...

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as...