Drive
What motivates people? What makes them happy at their jobs? Steve Jones talks about Drive, the book by Dan Pink, and the possibility that people actually like doing their jobs and are willing to work.
2011-02-24
213 reads
Editorial
Commuting Pain
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
2011-02-23
232 reads
Archiving Little Used Data
How do you decide what to archive? Steve Jones says that you need to come up with a method as our data sizes grow larger and larger all the time.
2011-02-22
283 reads
What's Your Code Quality?
Today we have an editorial reprinted from Jan 3, 2006 as Steve is on vacation. What's the quality of your code? Do you measure it? And does it matter?
2011-02-21
273 reads
Getting Up To Speed on SQL Server Denali
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
2011-02-21
487 reads
2011-02-18
144 reads
The Stairway Series
Today we launch a new series of content aimed at providing basic knowledge to people new to a section of SQL Server. Steve Jones comments on the way this series came about.
2011-02-17
701 reads
What Sarbanes-Oxley Won't Do
Today we have a reprint of an editorial from Dec 4, 2005 as Steve is on vacation.
2011-02-16
177 reads
Data Quality
Today we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.
2011-02-15
265 reads
Careful Blogging
Today we have a reprint of an editorial from Sept 22, 2005. In this one, Steve Jones reminds you that blogging is a public event and you want to be careful about what you write.
2011-02-14
116 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