Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Fooling SQL Server Expand / Collapse
Author
Message
Posted Monday, August 9, 2010 8:37 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:26 AM
Points: 31,078, Visits: 15,520
Comments posted to this topic are about the item Fooling SQL Server






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #966331
Posted Tuesday, August 10, 2010 3:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 8:35 AM
Points: 1,049, Visits: 3,008
I think this is one of those grey areas. I like my editorials to provoke thought, not to advertise. In this case, I think there is enough substance in the editorial for it to work, but I think it's a pretty close run thing. Taking the editorial in isolation, I'm glad I had the chance to read it, but I hope this doesn't signal a subtle shift towards using editorials as an extra bit of advertising real estate in the daily newsletter.

Semper in excretia, sumus solum profundum variat
Post #966467
Posted Tuesday, August 10, 2010 4:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 8, 2013 5:39 PM
Points: 263, Visits: 862
In the publishing game, they call this an "advertorial". You've done it justice.


James Stover, McDBA
Post #966524
Posted Tuesday, August 10, 2010 6:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:18 AM
Points: 162, Visits: 836
It's a bit on the heavy handed side in terms of the endorsement but it is an interesting concept- I was going to take a look to see if it might be beneficial for use during development phases of changes. When I went to click on the link however, the site won't redirect me.

Time to google.
Post #966621
Posted Tuesday, August 10, 2010 6:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 22, 2011 8:44 AM
Points: 395, Visits: 275
I thought the same thing that others did when I read this editorial: Why is it that this capability to restore a virtual database from a backup is being treated as a new capability when Idera's SQL Virtual Database product has been out for several months? Other than the fact that Red Gate sponsors this web site (which I very much appreciate), what is it that makes Red Gate's product worthy of highlight over Idera? Is there something I'm missing that makes it that much better?

Aaron
Post #966622
Posted Tuesday, August 10, 2010 8:56 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 6, 2014 12:59 PM
Points: 801, Visits: 1,962
This might be a cool tool to save your bacon on a bad day. I see one danger that has not been pointed out. This could get abused by someone just letting it run like this in production. They might think "Oh look. It's backed up all the time". Uh, no. It's not.

As to advertorializing well... Look at editorial columns in newspapers. They advocate positions and promote ideas (if not products) all the time. So what if people you know happen to spit out something good. How can you keep silent?

Shill this might turn out to be something needed when naught else will do.


ATB

Charles Kincaid

Post #966771
Posted Tuesday, August 10, 2010 9:00 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:26 AM
Points: 31,078, Visits: 15,520
Apologies to anyone that feels I crossed the line into too much advertising. I was asked to write something on this product, and I think I failed to editorialize on it properly.

I did think this particular feature was cool, and it is different. Idera's product is very cool as well, but it gives you a read only look. This one actually allows write back, so you could in fact, "mount" a database and test, or run your application against it and see where something failed. It's unique (for now), and I think a fairly innovative integration into SQL Server.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #966777
Posted Tuesday, August 10, 2010 9:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 22, 2011 8:44 AM
Points: 395, Visits: 275
So that's the difference between the two products. Thanks for clarifying. That is a significant difference and one worth taking into consideration when making a purchase.
Post #966780
Posted Tuesday, August 10, 2010 9:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 8:35 AM
Points: 1,049, Visits: 3,008
Reading the other replies, I think you're safe, Steve. Far better, though, that we let you know early (and when you haven't crossed the line) than after the fact.

Semper in excretia, sumus solum profundum variat
Post #966783
Posted Tuesday, August 10, 2010 9:06 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 985, Visits: 1,826
Speaking not about the product but the idea behind the editorial, I can't tell you how painful the size issue is. It causes reindex havoc for me because in my last job I HAD to restore the DB on a weekly basis to an environment that didn't have enough disk space for the expanded DB (but did for the data) so I had to shrink the files after a reindex, even though I knew it could make more problems for the fragmentation. I had no choice as the dang thing wouldn't restore otherwise. Something like what the editorial is about is critical to support developement environments IMO.
Post #966784
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse