What Will We Take For Granted Tomorrow?
A guest editorial from Tim Mitchell today looks at technology, and how quickly we become accustomed to it.
2010-06-07
127 reads
Editorial
Knowing What's Normal
This week Database Weekly has a lot of performance related posts and Steve Jones notes that those are not of much use unless you know you really do have a performance problem.
2010-06-07
157 reads
Limited Features or Limited Time?
A guest editorial today from Andy Warren. When someone is looking to introduce a free version of a product, what's the best way to tackle it?
2010-06-04
153 reads
Change the Edition or Change the Design?
Today Steve Jones talks about revisiting your design and perhaps thinking about buying another edition of SQL Server to take advantage of some feature.
2010-06-03
124 reads
Loud
Working in an office was quite a change for Steve Jones recently. He comments today that it might be something you need to consider when hiring others as well.
2010-06-02
173 reads
TCA
SQL Server has a lower TCA, total cost of administration, than Oracle. Steve Jones comments today on a few of the reasons.
2010-06-01
135 reads
Getting the Message
Regardless of the speed of your SQL routines there comes a time, for any server-based system, when you need to think "parallel" and "asynchronous". So why, Phil Factor wonders, does there seem to be so little interest in Service Broker?
2010-05-31
249 reads
2010-05-31
60 reads
Would You Do Your Hobby for a Living
Today we have a guest editorial from Andy Warren that asks about your hobbies, and would you trade your job for one of them?
2010-05-28
162 reads
Personal Privacy
A new technique to help anonymize medical research data has been developed, and could help with other types of data, but there is an issue.
2010-05-27
93 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers