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.
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.
A software bug causes a lot of legal issues in the UK. It's something that upsets Steve, partially because the software wasn't well tested.
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.
Steve thinks that the growth of private clouds make sense, especially as more companies turn to platform engineering.
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.
SQL Server Central is changing their policy to respond to the increased use of AI technologies.
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).
I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop […]
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In its early days, it was missing several important features (like data compression). While that hole has been plugged, there are still other limitations and differences you should be aware o
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...
Comments posted to this topic are about the item On Being an "Expert"
Advice on how to script out existing Azure (logical) SQL Server logins and mapped...
Hi I have a sequence container which contains an execute package task which loads...
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers