This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.
Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?
Read a message from Bob Ward about the first Microsoft Fabric conference taking place in Las Vegas this March.
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
I run this code on SQL Server 2019:
DBCC CLONEDATABASE(imdb, imdb_dev)I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023') GOWhat happens? See possible answers