Avoid Errors With using SNAPSHOT Isolation From Transactions Under Different Isolation Levels
For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...
2018-05-05
104 reads
For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...
2018-05-05
104 reads
There are multiple ways you can install MySQL, MySQL is compatible for almost all the Operating System. it would be...
2018-05-05
285 reads
Congrats to Michael, Eric, John, all the organizers and volunteers, and all the speakers for a successful Spring Houston Tech Fest 2018. It was a pleasure for the wife...
2018-05-05
5 reads
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,359 reads
MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...
2018-05-04
276 reads
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
339 reads
Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure...
2018-05-04
1,116 reads
In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. This article will...
2018-05-04
2,292 reads
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-04 (first published: 2018-04-24)
2,508 reads
Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection...
2018-05-03
305 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