learning

External Article

6 New Courses Published on the Redgate University

  • Article

Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now!

2020-07-17

Blogs

Using SQLFluff

By

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

Marketing Analyst: The Data-Driven Superhero Your Company Needs

By

Want to blend your love of marketing with the power of data? Becoming a...

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

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

Create managed identity on Azure SQL MI/ Azure SQL DB using sql login

By curious_sqldba

  I am able to successfully create managed identity on Azure SQLMI & Azure...

Lower Your Attack Surface Area

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lower Your Attack Surface Area

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