Express.js or Next.js for your Backend Project
In this article, I will introduce two JavaScript frameworks that can be used to build backend projects.
Setting up for Team-based Database Development using Flyway Desktop
This article provides a simple demonstration of how a small team of developers might set up a Flyway Desktop project to manage, automate, and control database development.
Indexes: When Column Selectivity Is Not Always A Requirement
While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]
No Time for Testing
Testing software is important, but we always seem to find reasons not to. Steve Jones has a few thoughts about testing.
Should You Use SQL Server 2022’s STRING_SPLIT?
SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it.
A New Year, New Efforts
Happy New Year! You're going to be seeing a lot of summaries for 2022 and predictions for 2023 around this time of year. I'm not writing one of those. You'll also see people calling for new years resolutions and the like. I'm not going for that either. Nope, let's keep it simple. It is a […]
Looking Back at 2022
This is the last workday of 2022. Next week starts a new year, and as I've often done, I wanted to look back at the year. This time I decided to look back month by month, at some of the headlines and memorable data-related topics. I'm tackling things month-by-month. In January there was a set […]
T-SQL Language Changes in SQL Server 2022 Part 3
Learn about more of the T-SQL language changes in SQL Server 2022. This article is the third in a series and will cover the changes to the JSON functions.
Enabling digital transformation – and data modernization – with DevOp
Where does data fit into the digital transformation story? Discover how and why it deserves a place in this fascinating piece from Pramod Sadalage, principal consultant at Thought Works
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers