In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...
2023-12-18 (first published: 2023-12-01)
604 reads
nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering...
2023-12-15
47 reads
I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw...
2023-12-15 (first published: 2023-11-27)
400 reads
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking about SQL Server on Linux.
2023-12-15 (first published: 2023-11-28)
207 reads
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...
2023-12-13 (first published: 2023-11-29)
325 reads
I presented “Microsoft Fabric for Dummies” at Cloudbrew and “How I saved 80% on my ADF costs” as a lightning talk at Data Meetup Groningen. Both slidedecks can be...
2023-12-13
13 reads
Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device https://******...
2023-12-13 (first published: 2023-11-27)
687 reads
SQL Server 2022 introduces an exciting feature: the ability to access the Query Store from a secondary replica in an Availability Group. This enhancement offers a significant advantage, allowing...
2023-12-11 (first published: 2023-11-22)
365 reads
I have curated the list of activities of a DBA or one can say Job Description of a DBA. DBA needs to adapt and keep learning new technologies
The...
2023-12-11 (first published: 2023-11-27)
1,812 reads
giltwrights – n. the imaginary committee of elders that keeps a running log of your mistakes, steadily building their case that you’re secretly a fraud, a coward, a doofus,...
2023-12-08
42 reads
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers