All About SQL

SQL server and Java?

I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to...

2019-07-29

78 reads

Azure SQL Elastic Jobs

The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases.  Targets can be in...

2019-07-11

170 reads

Microsoft MVP #2

It is always a dark art trying to suss out why he/she is an MVP? Do they deserve it? What does it take? Why can’t I get it? The...

2019-07-05

16 reads

Blogs

Use Jupyter Notebooks to Help People on StackOverFlow

By

I am sat in the PowerShell Saturday in Hamburg. You can see me on...

ACM Lecture at SELU

By

Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Read the latest Blogs

Forums

Needed to find all possible Dates Overlaps from a single Table

By Hell-1934

Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...

Optimize Cursor

By GrassHopper

I inherited this script that has a cursor and I know this query can...

Unable to add secondary node existing node due to DCOM is unavaialble

By maroju1

Dear Team, This is Naveen, Hope all are doing well. I need emergency help...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers