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

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

Intro to the Social DBA with a bit of #SQLHelp

Are you a Social DBA? 
No I don’t mean that you are a DBA and attend a myriad of merry mixers,...

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

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...

SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and...

Power Bi, PowerShell and SQL Agent Jobs

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...

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