Events

SQLServerCentral Editorial

What Sport Would You Play?

  • Editorial

We’re halfway through the Olympics, with all the usual drama – highs, lows, special interest stories - and even a surprise hero in Yusuf Dikec at the 10-meter air pistol (the memes have been strong with this one). As I was talking with my children this week, one of them asked, “So dad, what sport […]

You rated this post out of 5. Change rating

2024-08-04 (first published: )

47 reads

External Article

Meet Redgate at PASS Virtual Summit

  • Article

Redgate are Gold sponsors of PASS Virtual Summit, which this year is available to all online. It's time to accelerate your data career by joining Redgate's Advocates who will be presenting a variety of sessions, as well as demo solutions throughout the week of 11 - 13 November. See what's happening and register today.

2020-11-09 (first published: )

Technical Article

SQL in the City Summits – UK, US & Down Under

  • DatabaseWeekly

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

You rated this post out of 5. Change rating

2019-04-05

Technical Article

5th annual “Seattle Freecon”

  • Article

On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.

You rated this post out of 5. Change rating

2018-11-02 (first published: )

3,203 reads

SQLServerCentral Article

Registration Now Open for SQL Cruise Alaska in August 2017

  • Article

It’s been a while since SQL Cruise has been in Alaska, but come August 12 2017 we are returning in a big way for our 13th event since our founding in 2010, bringing one of the most sought-after minds in Microsoft SQL Server for a week of instruction, conversation, and insight: Bob Ward. The SQL […]

5 (2)

You rated this post out of 5. Change rating

2017-05-19

378 reads

External Article

Database Continuous Integration Workshop - London, UK

  • Article

Join this workshop on July 8, 2015 to learn how to: link your source control repository to a build system, trigger database builds automatically when you make a change, use DLM tools to test your database changes, and lay the foundations for package-based deployment of your database. Register while space is available.

2015-05-22

6,320 reads

Blogs

DATEADD Truncates the Number Parameter: #SQLNewBlogger

By

This was an interesting thing I saw in a Question of the Day submission....

Our SQL Server is Slow! What Do I Do First?

By

Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...

Using SQLFluff

By

I thought I didn’t care about linting, and lately, I haven’t written a lot...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Eliminate a function by writing out the code is now throwing an error

By stevec883

/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...

SQL Server Migration - Redirecting Old Instance Connections to New AG Listener

By Wecks

Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...

Visit the forum

Question of the Day

A Strange Choice

What is returned when I run this code in SQL Server 2022?

CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci

See possible answers