We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises and in the cloud, has some interesting trade-offs. The biggest is write latency from the...
2022-12-09 (first published: 2022-11-25)
681 reads
I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...
2022-12-02 (first published: 2022-11-15)
284 reads
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL Server virtual machine performance tuning tips with our friends at Sanity Solutions on July 21st...
2022-07-13 (first published: 2022-06-25)
400 reads
We’ve been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not...
2022-06-10 (first published: 2022-05-18)
526 reads
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-17
33 reads
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-16
49 reads
Have you ever wondered why Windows Server doesn’t show disk performance metrics in Task Manager, but your Windows 10/11 OS does? It’s a really silly difference. Let’s fix that....
2022-05-06 (first published: 2022-04-26)
8,100 reads
I live my life in the field of information technology. Most of the topics that I work with are making databases speedy and more readily available. As such, most...
2022-05-04 (first published: 2022-04-25)
193 reads
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-04
43 reads
I’m thrilled to be presenting the second part of a four-part webinar series with ActualTech Media called “Optimizing SQL Server on VMware Data Protection and Disaster Recovery” this Friday,...
2022-03-14
28 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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