Red Gate Dependency Tracker - Making Databases Into Moving Art
data structures are art
If anyone thinks that working with complex data structures is boring... I don't know what world they...
2016-04-27
1,055 reads
data structures are art
If anyone thinks that working with complex data structures is boring... I don't know what world they...
2016-04-27
1,055 reads
Figured I'd share a way to automate the SSMS 2016 updates until it gets it's own fancy self updater. I...
2016-04-26 (first published: 2016-04-19)
2,694 reads
Disclaimer: I have been provided with a free license because I am reviewing. This doesn't impact my assessment of the...
2016-04-14
1,191 reads
Moving system databases in SQL Server takes a bit of practice. I got that again, along with a dose of...
2016-04-01
8,203 reads
Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way...
2016-03-18
809 reads
Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a...
2016-03-18
444 reads
This turned out to be quite a challenge. I couldn’t find anything that made this very clean and straight forward...
2016-03-18
411 reads
the problem
An issue with SQL Server 2012 SP3 was identified that impacted EF4/5 due to additional datatypes in the dll....
2016-03-18
7,471 reads
If you want to create a TFS query that would identify work items that have changed, but were not changed...
2016-03-18
417 reads
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of...
2016-02-02
6,734 reads
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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