SSRS Error: Report Preview displays Access to the path ‘…\bin\Debug\Report.rdl’ is denied
While working on Reporting Services at a client site I came across this error when trying to preview a report...
2011-06-08
3,325 reads
Blog Posts
Top 10 virtualization benefits for the developer
Virtualization is becoming a hot topic lately, and there is no doubt it provides a ton of benefits. But you...
2011-06-08
1,102 reads
Using a Staging Environment for Tracking Down Bugs
A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.
Being able to...
2011-06-08
2,137 reads
Another Idea for SQLSaturday
I spend a lot of time just looking at events, watching for new ideas. At our recent SQLRally we had...
2011-06-07
640 reads
Colleges starting to offer business intelligence degrees
Interesting video on eWeek.com called Business Intelligence Takes Higher Education Students to the Head of the Class that talks about...
2011-06-07
1,223 reads
Combinations and Permutations
I ran into an interesting question from someone asking for all combinations of numbers. The thread was here, and it...
2011-06-07
15,774 reads
Free Dynamic SSIS Webinar Today
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say...
2011-06-07
636 reads
June 2011 – PASSMN Meeting Announcement
PASSMN has announced it’s June meeting. A little of the SQL and a little of the non-SQL. Get a brush...
2011-06-07
614 reads
On the exorcism of Ghost Records
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,882 reads
Planning Your Upgrade Well
Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...
2011-06-07
966 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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