Microservices for Databases
The idea of using microservices is gaining traction, but Steve Jones notes that the issues of databases might prevent adoption for many applications.
2018-12-10 (first published: 2015-04-02)
265 reads
Editorial
2015-04-01
314 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
153 reads
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
105 reads
Software Engineering in Practice
Is there a need for apprenticeships in the data world? Should we consciously seek to view our first year as an apprenticeship? Should companies provide learning paths for new hires?
2018-10-31 (first published: 2015-03-30)
180 reads
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
1,255 reads
Mastery – Repetition, Variations, and Depth
Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.
2019-05-31 (first published: 2015-03-25)
290 reads
Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
458 reads
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
2015-03-23
123 reads
Common Mistakes
This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.
2018-06-22 (first published: 2015-03-20)
533 reads
Blogs
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...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
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
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
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