The other day, I was in a Twitter discussion interviewing people for technical positions. This reminded me of one of my favorite things to do in interviews… reading the list of qualifications/skills and asking questions about its contents. If you put it on the resume, I assume you know something about it and are willing […]
2023-07-15
138 reads
2023-07-14
152 reads
2023-07-12
150 reads
Today Steve talks about bare metal servers and virtual machines. He wonders if any of you still run bare metal.
2023-07-10
352 reads
Two weeks ago, I had the opportunity to hear a keynote by Vik Fearing at Swiss PGDay 2023. He talked about Property Graphs and the Graph Query Language (not to be confused with GraphQL), a recent addition to the SQL:2023 standard. The discussion was mostly theoretical in nature because only Oracle has a current implementation […]
2023-07-08
99 reads
2023-07-07 (first published: 2018-09-13)
388 reads
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
2023-07-05 (first published: 2018-09-21)
285 reads
We have a guest editorial today from Mala Mahadevan on the changing data community.
2023-07-03
144 reads
I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I […]
2023-07-01
75 reads
If you found out you were being laid off, would you be ready? Steve thinks you should be lightly planning for this to happen.
2023-06-30
157 reads
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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