All I want for Christmas…Meme Monday

Categories: Meme Monday, News, Professional, SSC
Comments: No Comments
Published on: December 5, 2011

This is a good way to start monday, with a meme.  This month Thomas LaRock has provided us with the theme and his entry here.

I thought of following along with a blog to match the song “Two front teeth” but don’t have nearly enough creative juices for that.

Suffice it to say that I really liked the SQLClippy idea from Tom.

So here is my contribution/want list for Christmas from MS for SQL Server (To the tune of “I Want A Hippopotamus For Christmas”)

I want a multipartner-mirror for Christmas
Only a multipartner-mirror will do
Don’t want a GUID, no poorly coded Toy
I want a multipartner-mirror to play with and enjoy

I want a multipartner-mirror for Christmas
I don’t think Microsoft will mind, do you?
They won’t have to use our replication flue
Just bring it with the SP, that’s the easy thing to do

I can see me now on Christmas morning, creeping down the stairs
Oh what joy and what surprise when I open up my eyes
To see a mirror hero standing there


Get the jist?  Like Logshipping on Steroids.  But maybe that is the point of AlwaysOn in 2012.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

December 2011
« Nov   Jan »


  • @SQLAmerica: The IIF function (introduced in 2012) doesn't seem to work in SQL Server versions 2008, 2012 and 2014.Do I need something enabled? #SQLHelp
  • @SQLSoldier: @dev_b That was an optimization added in (I think) SQL 2012. But don't think that means its free. It still takes a lock, etc. #sqlhelp
  • @dev_b: #SQLHelp Looking at fn_dblog, LOP_DELETE_ROWS is invoked only when the column value changes? 2/2
  • @dev_b: #SQLHelp ORM updates all columns with the existing values, is SQLserver is smart to ignore those or will it updates all columns in a row?1/2
  • @Kevin3NF: @buddingeek @bflippin If they try to get you to use one service for all SQL on all servers,tell them one hack takes down the farm #SQLHelp
  • @skreebydba: @SQLSoldier Okay, thanks. #sqlhelp is the best thing going because of folks like you.
  • @SQLSoldier: @skreebydba Look at, yes. Be able to read them, no. They're not in a readable format and the format is not documented. #sqlhelp
  • @buddingeek: @bflippin have already asked my windows team to create a dedicated domain service account for sql agent jobs . #sqlhelp
  • @skreebydba: @SQLSoldier Robert, thanks for the rapid response. Is there a way to look at the contents? fn_dblog() etc... #sqlhelp
  • @SQLSoldier: @skreebydba The commands needed to revert the rollback the database to the point before it recovered the db to bring it online. #sqlhelp

Welcome , today is Thursday, September 29, 2016