The Cloud of Destiny
Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.
2013-10-15 (first published: 2009-04-13)
582 reads
Editorial
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
2009-04-13
258 reads
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
2013-11-04 (first published: 2009-04-10)
628 reads
Ruthless
Managing your time is a skill that is important in your career. Steve Jones talks a little today about why you might want to develop this skill.
2009-04-09
135 reads
Falling Over our Assumptions
There's a saying about what it says about a person to assume something. However it's something we all do every day. Phil Factor brings us a guest editorial about assumptions in SQL code.
2020-06-25 (first published: 2009-04-08)
827 reads
Managing Risk
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-07
103 reads
The Disappearing DBA
During a "difficult period", a developer often sinks from view. When things are going well, suddenly they are the gunslinger, the hotshot. The DBA often looks on wistfully. For him, the "fame trajectory" seems to work in reverse.
2009-04-06
1,128 reads
Manners
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
2013-10-10 (first published: 2009-04-06)
346 reads
The T-SQL Paradigm
This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?
2013-11-01 (first published: 2009-04-03)
756 reads
Portable Data Centers
Is the next data center for your SQL Servers going to be portable? Steve Jones comments on some of the changes being put forth by Microsoft and others.
2009-04-02
98 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