SQLServerCentral Article

Dijkstra's Algorithm

Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of minimal cost between any pair of nodes in an undirected graph. His procedure is widely recognized as a fundamental tool for examining communication and transportation networks (eg. Google Maps) and is surprisingly simple. By his own admission, […]

External Article

Kickstart the year with our free Livestream! Navigating the database landscape in 2024

The key finding from our annual ‘State Of’ survey is that there’s a need for skill diversification to keep up with the pace of technological advances in IT world.

How will this skills gap affect you?

Whether you’re just starting out in your career, you’re a seasoned data professional or you’re a senior IT leader wanting to stay ahead of business growth, join our free livestream on January 23rd.

Redgaters Steve Jones, Ryan Booz and Beca Parker will introduce key findings from the survey and offer their thoughts on the big changes coming in 2024 and what you can do to thrive in this changing landscape.

Register now

Blogs

Denver Dev Day Oct 2024 Slides

By

Here are the slides from my talk today: CI in Azure DevOps If you...

Should I Learn PostgreSQL

By

I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...

A New Word: Hickering

By

hickering – n.  the habit of falling hard for whatever pretty new acquaintance happens...

Read the latest Blogs

Forums

Are We Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Are We Dinosaurs?

how to solve a conversion failure error

By Wren

Sample query reply appreciated Getting the following error: Conversion failed when converting the varchar...

Why does SSMS always pop up this window every time I get into it?

By Rod at work

For the last few weeks every time I get into SSMS 20.2 I am...

Visit the forum

Question of the Day

Code Blocks

What happens with this code:

DECLARE @Iteration INT = 0;

WHILE @Iteration < 10
    SELECT CustomerName,
        CustomerStatus
    FROM dbo.Customer
    WHERE CustomerID > 3;

    SET @Iteration += 1;

See possible answers