Ransomware vs. AI
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
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?
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.
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.
Serious Software Glitches
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.
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.
More Private Clouds
Steve thinks that the growth of private clouds make sense, especially as more companies turn to platform engineering.
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.
Adding an AI Policy for Authors
SQL Server Central is changing their policy to respond to the increased use of AI technologies.
Deploying Azure SQL Database Using an ARM Template
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).
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers