Deployed Session Settings

Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...

PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)

The last week of October, we’ll be at the PASS Summit in Seattle, WA.  As some of you already know – and as I...

SQL Server – Various methods to generate unique number sequence

Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...

Table partitioning

What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's...

Fall Means Election Season

While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...

How to Create Scatter Chart in Power BI

There’s a saying that birds of the same feather flock together. When you throw your data on a scatter chart,...

SQL Saturday as an Attendee

Last week I did something that many people have already done. However this was my first experience, and I really...