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,428 reads
Articles
Fun with Powershell
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
LangChain Prompt Templates with OpenAI LLMs
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
Dimensional Modeling Case Study Part 2 - Days Dimension
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,891 reads
Query Exercise: Find the Best Time for Maintenance
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
Announcing the first Microsoft Fabric Community Conference!
Read a message from Bob Ward about the first Microsoft Fabric conference taking place in Las Vegas this March.
2024-02-05
1,488 reads
Fixing the Synapse Error "Available workspace capacity exceeded error (Livy session)"
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
2024-02-05
1,600 reads
Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error
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
SQL Window Functions Series: NTILE()
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,124 reads
Adding an AI Policy for Authors
SQL Server Central is changing their policy to respond to the increased use of AI technologies.
2024-02-02
295 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
Check sequential order of status of items
There is a table tblItems with below structure ( i cannot change the below...
Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers