Holding Code in Your Head
Steve has a few thoughts on software development and coding today when working in teams and trying to keep the entire solution in your head.
2021-05-03
526 reads
Editorials
No-code Software Engineering
The idea that software engineers might be better with no-code tools is a direction Steve thinks is misaligned with the problem. We should help developers learn to be better.
2021-05-01
179 reads
Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
426 reads
Ransomware May Get Worse
Criminal groups using ransomware are working together, which is bad news for all organizations.
2021-04-29
243 reads
2021-04-28
107 reads
A Cloud Database for Statistics
A company decides to move to the cloud and outsource database administration.
2021-04-27
113 reads
2021-04-26
113 reads
Looking Forward to SQL Server vNext
Releases of on-premises SQL Server arrived quite rapidly for a few years with seven releases during the years spanning 2008 and 2019. While it has technically been less than two years since SQL Server 2019 reached general availability in November 2019, it feels like ages since we have heard any news about what’s coming next. […]
2021-04-24
1,833 reads
Office FOMO
There are many things we may miss about the office, but one of them is the chance to interact with and impress management.
2021-04-23
131 reads
2021-04-22
79 reads
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