More SQL Injection
Why are sites still being hit by SQL Injection on a large scale? Steve Jones talks about a recent large scale attack that affected over a million sites.
2011-11-17
592 reads
Editorials
Do You Want to be a DBA in Space?
With the DBA in Space contest ending this week, Steve Jones has some thoughts on the contest, and what he'd do if he were to win.
2011-11-16
81 reads
Network Databases? Is it time to change?
Today Steve responds to a blog post from Microsoft that talks about the viability of placing our database files on network shares.
2011-11-15
161 reads
Don't Criticize Code
For anyone eager for a long-term career in IT Development, humility and tact are probably more important habits to acquire than demon coding-skills. Phil Factor explains why.
2011-11-14
317 reads
The Industry Problem
We have less people studying technical subjects and an apparent shortage of technical talent in the IT field. Steve Jones thinks we might have an industry wide problem.
2011-11-14
228 reads
First Impressions
Today we have a guest editorial from Andy Warren that examines the first impressions that you create when you meet someone.
2011-11-11
126 reads
License By Core
Microsoft recently announced changes in the licensing for SQL Server 2012 and Steve Jones has a few thoughts on the topic.
2011-11-09
297 reads
Real Time Dangers
Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.
2011-11-08
136 reads
Going Green in Software Development
Today Steve Jones talks about the impact of better software programming on the energy use in your company's data center.
2011-11-07
98 reads
Never offend a captive audience
Write what you choose to when the reader can, in turn, choose not to read your work; but when you are writing about Technology, you have a captive audience. They need to read your work to keep abreast of the technology. Don't gratuitously offend them. It is not the action of a gentleman, D____it!
2011-11-07
119 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