Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.
2024-11-20
903 reads
Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.
2021-03-03 (first published: 2016-06-22)
8,713 reads
Learn how PowerShell can be used to manage files and folders in your Data Lake.
2021-01-06 (first published: 2017-10-04)
1,792 reads
Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]
2020-07-01
1,531 reads
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
2020-04-08
2,929 reads
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
2020-04-08
85 reads
Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.
2020-03-04 (first published: 2016-10-05)
4,192 reads
An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.
2020-02-26 (first published: 2016-06-15)
15,175 reads
In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.
2019-10-30 (first published: 2016-07-06)
7,020 reads
Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.
2019-07-31 (first published: 2018-03-28)
2,325 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers