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

SQLAndy

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Archives: February 2016

Building With Iron Pipe

For a while I’ve been wanting to do a project that used black iron pipe for the main structure. Kind of a Lego’ish appeal for grown ups, if such a thing is possible. It’s strong and not hard to work with as long as you can stick to the stock… Read more

0 comments, 451 reads

Posted in SQLAndy on 16 February 2016

Moving to Open Live Writer

I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well enough and I’ve liked having an offline editor. It moved to open source after years of stagnating (though it still worked well enough!) and I’ve finally moved to that version Read more

0 comments, 564 reads

Posted in SQLAndy on 11 February 2016

Speaking at OPASS on February 25, 2016

Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database restores. It’s a still evolving presentation, but one that I think engages attendees. They know how to restore, they know why, so it’s just layering some ideas on top of… Read more

0 comments, 480 reads

Posted in SQLAndy on 2 February 2016

Pausing PASSWatch & What’s Next

I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard to call it a success, based both on stopping it and not accomplishing as much as I hoped, yet I don’t see it as a failure either. I learned a… Read more

0 comments, 498 reads

Posted in SQLAndy on 2 February 2016

SSC Question of the Day: DBCC Error 6

My latest question of the day on SQLServerCentral is DBCC Error 6. Text of the question below:

As the on-call DBA, you received calls of timeouts and errors on a SQL 2012 SP3 instance used for testing. You track the issue to IO requests that are taking longer than…

Read more

0 comments, 506 reads

Posted in SQLAndy on 2 February 2016

SSC Editorial: Design a Better SQL Server Pricing Model

Design a Better SQL Server Pricing Model ran on January 21, 2016 and as you can guess from the title is about the challenges we have with the current pricing model…and how we might improve it. Nothing simple about that, from our perspective or from that of Microsoft. Ultimately it… Read more

0 comments, 495 reads

Posted in SQLAndy on 1 February 2016