Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
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.
2024-02-09
2,459 reads
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.
2024-02-09
2,459 reads
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.
2024-02-09
Learn how to get started with a few sample prompt templates by using the gpt-4 LLM within OpenAI and LangChain in a Databricks notebook.
2024-02-09
Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.
2024-02-07
1,908 reads
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?
2024-02-07
Read a message from Bob Ward about the first Microsoft Fabric conference taking place in Las Vegas this March.
2024-02-05
1,497 reads
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
2024-02-05
1,775 reads
I'm receiving the following error when attempting to run a T-SQL MERGE statement: "Msg 8672, Level 16, State 1, Line 123. The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row.
2024-02-05
Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
4,222 reads
SQL Server Central is changing their policy to respond to the increased use of AI technologies.
2024-02-02
303 reads
By Steve Jones
One of the things that many DBAs struggle with is managing space across an...
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
Comments posted to this topic are about the item The Cloud Security Problem, which...
Thanks in Advance! I'm having trouble grouping all counts and sums on one line...
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers