How to compare two SSAS databases with a custom MDX query

[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...

SQL and the other technologies

Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Data charted looks like in the...

Worth Reading – Something I learned while unemployed by Rod Falanga

SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to...

CloudProPT – The New Cloud/Azure Community in Portugal

I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for...

Data Channel - Interview 03 - Hamish Watson on DevOps and Azure

Dear All,

After a short break, we are back with the 3rd interview on #DataChannel. Mr.Hamish Watson, Community Lead from Christchurch,...

Finding Sysadmins with dba tools–GetDbaRoleMember

I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing...

Friday Reading 2017-01-26

Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been...

Microsoft SQL Server 2016 Cumulative update 1 (CU1)

Microsoft just announced Microsoft SQL Server 2016 Cumulative update 1 (CU1)

Microsoft reference: [Click Here]

Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin

Retrieve a List of Files from FTP using SSIS

The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”...

SCOPE_IDENTITY() or @@IDENTITY

I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...