2018-09-03
39 reads
Editorials
2018-08-31
84 reads
Why not take a risk and try something new?
When we risk failure, we also have the opportunity for success, so try something new today.
2018-08-30
83 reads
Data Clarity
The ways in which we collect and use data aren't always apparent to our customers. Perhaps we should do better.
2018-08-29
37 reads
Protecting Our Stream of Data
We can't protect against all hacks, but can we prove they weren't our fault?
2018-08-28
46 reads
'Comedy Limited' with SQL Server
Phil Factor is not amused by SQL Server's handling of the comma-separated value (CSV) file format.
2018-08-27
521 reads
Fun at Work
Today Steve asks about the fun times you might have had at work and captured in pictures.
2018-08-24
98 reads
2018-08-23
65 reads
2018-08-22
194 reads
2018-08-21
66 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