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...

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...

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...

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...

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...

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...

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...

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...

Upcoming PASS Free Training

Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.

January, 2017

Tuesday,January,31
Introduction to Oracle SQL and PL...

SCOPE_IDENTITY() or @@IDENTITY

I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...