Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
332 reads
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
332 reads
Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e....
2017-11-08 (first published: 2017-10-27)
11,326 reads
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
407 reads
Just a few notes:
Weather on Wed was great, ok on Thurs, cold on Fri. Have had worse years!Felt like I...
2017-11-08
433 reads
With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...
2017-11-08 (first published: 2017-10-26)
1,615 reads
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
815 reads
Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server...
2017-11-08
377 reads
Photo by Jaanus Jagomägi on Unsplash
Interested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on Tuesday November 14, 2017 at 1PM Eastern at the...
2017-11-07
4 reads
Photo by Jaanus Jagomägi on UnsplashInterested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on...
2017-11-07
330 reads
Better late than never: The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), released an appliance update...
2017-11-07
1,046 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