Troubleshooting Connectivity with UDL files
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and...
2010-10-24
12,115 reads
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and...
2010-10-24
12,115 reads
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and this was the first package being placed into production...
2010-10-24
18 reads
Only 3 more weeks until the PASS Summit and it’s time for another countdown post. I’ve done a few of...
2010-10-23
751 reads
Okay SQL Community, I need your help! Patrick Leblanc, Adam Jorgensen, Mike Davis and myself have submitted a precon for...
2010-10-23
564 reads
Monday
PASS Data Warehousing/BI Virtual Chapter - Applied MDX - Kevin Geoff
Tuesday
PASS Application Development Virtual Chapter - Refactoring SQL Applications - Jeremiah Peschka
Pragmatic Works - Pro...
2010-10-22
863 reads
It’s been quite a few years since I updated the Hawaiian shirt wardrobe. I bought a series of 5 shirts...
2010-10-22
724 reads
Bill Graziano posted our 2011 budget today. This runs from Jul 1, 2010, through Jun 30, 2011. I hope you’ll...
2010-10-22
674 reads
Let’s Anaylze An Index!We’ve got through the first three parts of this continued series on the Index Analysis query last...
2010-10-22
614 reads
One more from the ‘new book’ shelf at the library, All Things at Once is an auto biography of Mika...
2010-10-22
705 reads
This coming Wednesday I'll be speaking for SQL Lunch on the topic of Auditing Database Permissions in SQL Server. The abstract for...
2010-10-22
517 reads
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...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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