2014-07-16
2,747 reads
2014-07-16
2,747 reads
The complexity of financial trading systems is too much for an amateur approach, as the losses of various Bitcoin exchanges show.
2014-07-15
330 reads
Phil Factor ponders a cull of some of SQL Server's worst-behaving functions.
2014-07-10
304 reads
Phil Factor fluffs the feathers of the shared sandbox model of development.
2014-07-02
138 reads
As a data guy, I always smile when application developers refer to ‘their’ data. If only it were that simple.
2014-06-30
366 reads
Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?
2014-06-26
115 reads
It's not new and I'm already doing it. Phil Factor, a.k.a. Methuselah, on Agile, DevOps and Continuous Delivery.
2014-06-16
131 reads
Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.
2014-06-09
95 reads
Phil Factor ponders why improvements to source control and versioning so often lag behind the pace of progress in development as a whole.
2014-06-02
149 reads
The early signs are that we can now run a SQL-based relational database with distributed execution plans over commodity hardware, leaving just the task of splicing together of the result to the engine itself, then why can’t Microsoft or Oracle do it?
2014-05-26
192 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