Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...
2016-12-12
12 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
358 reads
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus...
2016-11-22
557 reads
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus around scenarios and solutions for databases in Microsoft's...
2016-11-22
3 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
2,119 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.
First time deployment
Backup / restore...
2016-11-11
6 reads
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
353 reads
Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2
Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...
2016-11-07
12 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
195 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...
2016-11-02
9 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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