A SQL Prompt AI Experiment with Window Clauses
SQL Prompt has an EAP with some AI capabilities. I was asked to do some testing, and while I’ve done relatively little, I did find some time to play...
2023-12-08 (first published: 2023-11-22)
430 reads
Databricks Unity Catalog primary key and foreign key constraints are not enforced
I’ve been building lakehouses using Databricks Unity catalog for a couple of clients. Overall, I like the technology, but there are a few things to get used to. This...
2023-12-06 (first published: 2023-11-22)
280 reads
T-SQL Tuesday #168–Roundup
Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. I didn’t get much of a chance to check out the posts as I was...
2023-11-21
36 reads
Understanding I/O Freeze in SQL Server 2022's TSQL Snapshot Backups
SQL Server 2022 introduces a new feature to enable application-consistent snapshot backups. TSQL Snapshot Backups enable the SQL Server to control the database quiesce without external tools. Using TSQL...
2023-12-08 (first published: 2023-11-21)
594 reads
“Surviving the Digital Heatwave: Lessons Learned from Singapore’s Datacenter Meltdown”
Today, we’re unpacking a real-world tech drama that unfolded in Singapore, offering a stark reminder about the vital role of Disaster Recovery (DR) planning and the often overlooked, yet...
2023-12-06 (first published: 2023-11-21)
431 reads
Importing Flat Files into Azure SQL DB
Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...
2023-12-04 (first published: 2023-11-20)
599 reads
2023-12-04 (first published: 2023-11-20)
925 reads
Microsoft Fabric is now GA!
After more than two years in development and six months in public preview, Microsoft Fabric is now generally available (GA). Here is the announcement made during Microsoft Ignite last...
2023-11-20
78 reads
Changing the Data Type of a Primary Key–#SQLNewBlogger
A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....
2023-12-01 (first published: 2023-11-20)
380 reads
Building Upon Your Productivity Momentum: Staying Productive For Life
Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...
2023-12-01 (first published: 2023-11-17)
261 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers