Pragmatic Works is on YouTube !
I bet you didn’t know Pragmatic Works has our own YouTube channel ? Check it out at
There is some great...
2010-02-20
284 reads
I bet you didn’t know Pragmatic Works has our own YouTube channel ? Check it out at
There is some great...
2010-02-20
284 reads
A quick clarification on something I said the other day to a group of students in one of our quick...
2010-02-20
210 reads
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
266 reads
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
295 reads
Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...
2010-02-20
335 reads
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
392 reads
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
354 reads
Ok Guys and Gals. I know I have been a slow blogger thus far in 2010. To try and make...
2010-02-08
343 reads
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
487 reads
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-12-11
315 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