SSMS is, well, it's what we mostly have from Microsoft. It's been around a long time, but it is getting regularly released. There are new versions about every quarter, and there are bug fixes and minor enhancements. Azure Data Studio appears to be where Microsoft would like most of us to move, but I, and […]
2020-12-04
300 reads
Can you catch minor code changes that might cause issues? Steve advocates for more testing to ensure you can.
2020-12-03
112 reads
Do we care or worry if our databases need to handle encrypted data? Steve has a few thoughts about why we may or may not be concerned.
2020-12-02
125 reads
GPS data is used by many applications. Steve notes that managing data like this might be hard inside organizations.
2020-12-01
67 reads
Tesla updates their cars over the air while many other companies require you to move slow and visit a dealer. Steve thinks we can be more like Tesla as developers if we move to DevOps.
2020-11-30
82 reads
I was having a conversation with my 14-year-old grandson Thomas the other day. He was telling me that is signed up to take a programming class in school next term and sees a future career in technology. He loves playing video games, so maybe developing them would be a good choice. He also was thinking […]
2020-11-28
189 reads
Today Steve asks if there are things you might wish your employer would do for you this holiday season.
2020-11-27
106 reads
2020-11-26
61 reads
2020-11-25
70 reads
Lots of contact tracing apps are out there. Do you know which ones collect which types of data and what they do with it?
2020-11-24
161 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