Which version of SSIS-DTS Package Search is right for you
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,465 reads
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,465 reads
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-12
871 reads
Is employee data theft on the rise? I saw this blog post on the subject, but I had to take...
2009-08-11
792 reads
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,177 reads
I took the final, non-BI Microsoft SQL Server 2008 Certification Exam on Friday, so now I have finished all of...
2009-08-11
543 reads
Last week I posted about getting a new bluetooth speakerphone, so I thought I’d follow up with some notes about...
2009-08-11
514 reads
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
708 reads
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
951 reads
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,492 reads
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
2009-08-10
834 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