SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fooling SQL Server


Fooling SQL Server

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)

Group: Administrators
Points: 138881 Visits: 19406
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
My Blog: www.voiceofthedba.com
majorbloodnock
majorbloodnock
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2395 Visits: 3064
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
James Stover
James Stover
Right there with Babe
Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)Right there with Babe (715 reputation)

Group: General Forum Members
Points: 715 Visits: 862
In the publishing game, they call this an "advertorial". You've done it justice.


James Stover, McDBA

Steph Locke
Steph Locke
Mr or Mrs. 500
Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)Mr or Mrs. 500 (511 reputation)

Group: General Forum Members
Points: 511 Visits: 870
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.
Aaron C. Sentell
Aaron C. Sentell
Mr or Mrs. 500
Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)

Group: General Forum Members
Points: 571 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
Charles Kincaid
Charles Kincaid
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3159 Visits: 2384
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. Rolleyes

ATBCharles Kincaid
Steve Jones
Steve Jones
SSC Guru
SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)

Group: Administrators
Points: 138881 Visits: 19406
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
My Blog: www.voiceofthedba.com
Aaron C. Sentell
Aaron C. Sentell
Mr or Mrs. 500
Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)

Group: General Forum Members
Points: 571 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.
majorbloodnock
majorbloodnock
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2395 Visits: 3064
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
jeff.mason
jeff.mason
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2591 Visits: 2137
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search