Introduction I recently passed the Google Cloud Professional Data Engineer certification exam, Professional Data Engineer Certification. It took me about five month to prepare for this, and I would like to share my thoughts of why I decided to take it on and how I prepared for it. At the moment, Google cloud (GCP) is […]
2021-03-15
9,677 reads
Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools.
2019-07-04 (first published: 2017-08-31)
3,911 reads
Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.
2018-05-04 (first published: 2015-10-01)
4,372 reads
What are the most popular SQL implementations for Hadoop? How different are they from T-SQL?
2015-11-24
5,164 reads
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
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