Twas 2 Days Before Xmas or Thank you SQLFamily

Twas 2 days before Xmas & all through the office,

not a creature was stirring not even old Maurice.

With merriment going on...

Blink – Year is gone

As the door begins to knock I start to wonder who it can be. As I begin to open it...

Last Weeks Top “Reading” Links #114

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of...

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is...

[OT] Blog is in maintenance mode

I’m spending part of this holiday break repaying some technical debt on my website.  Among other things, I am importing...

Change Tracking–an easy way to track your changes TIP#78

 
I am pretty much sure by the title of this post you had idea of the post content. Although I...

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why...

Easy way to reseed identity column ? TIP #77

 
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...