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


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: August 2013

Building a Better Litter Box

First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped the shark again (is it possible to do it more than once?)! Still, it’s every bloggers right to inject a small amount of whimsy into what they write and I’m… Read more

0 comments, 1,422 reads

Posted in SQLAndy on 30 August 2013

Notes From The August 2012 OPASS Meeting

  • Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll confess to thinking that MDM is one of those dreams that is rarely achieved in most organizations.
  • Jen Underwood did a presentation on predictive analytics. Lots of good background on…

Read more

0 comments, 612 reads

Posted in SQLAndy on 23 August 2013

Need Recommendations on Being a Better Listener

This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be better at many things and also part of research for an upcoming project. The book was a good starting point for me, with some ideas on the different types of… Read more

0 comments, 682 reads

Posted in SQLAndy on 19 August 2013

Interview Candidates for Skills, Aptitude, Maybe Both

Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory I want to hire someone that can do a hundred percent of those on day one. The other technique is aptitude hiring – asking questions that can reveal the interest… Read more

0 comments, 2,432 reads

Posted in SQLAndy on 15 August 2013

Be The Connector

Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven by someone needing to fill a position or someone needing work, but that’s by no means the only scenario – it can just as easily be some common interest that… Read more

0 comments, 840 reads

Posted in SQLAndy on 14 August 2013

OPASS Meeting W/ Luis Figueroa & Jen Underwood–August 22, 2013

Luis Figueroa will be presenting Getting started with Master Data Services 2012 and then Jen Underwood will be presenting Practical Predictive Analytics – looks to be a nice evening of learning!

Get all the details on the oPASS site.

Read more

0 comments, 640 reads

Posted in SQLAndy on 13 August 2013

Create A Job Feed For Your LinkedIn Group

LinkedIn groups have the option to enable a Jobs section and associated discussion area. Potential employers can post jobs directly to the group site – if they know the group is there and if they feel like investing the time. Think about how many different groups might be out there… Read more

0 comments, 809 reads

Posted in SQLAndy on 12 August 2013

Share Your Ideas for Improving PASS on September 9th (Suggestion Tsunami!)

My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch up. We talk about how we’re doing in life and how we think things are going in the world of PASS and the SQL Server community. If you’ve never met… Read more

0 comments, 1,021 reads

Posted in SQLAndy on 8 August 2013

SQLSaturday Numbers For Period Ending June 30, 2013

Just saw this in the PASS Connector:

The SQLSaturday numbers are in for our fiscal year, which ended June 30, with a total of 81 SQLSaturday events (49 US/32 international) compared to 61 events (37 US/24 international) the previous year.

That feels like good, sustainable growth. I hope the trend… Read more

0 comments, 650 reads

Posted in SQLAndy on 7 August 2013

Five Weeks Until SQLSaturday #232 In Orlando

Time has flown by and we’re just five weeks from SQLSaturday #232 on September 14th, 2013. It’s a time of excitement and a bit of chaos for those of us on the organizing team. We’re trying to finalize the budget, order shirts for the speakers, get evaluation cards printed, and… Read more

0 comments, 554 reads

Posted in SQLAndy on 6 August 2013

Ebooks From The Library–Overdrive Media Console

Recently I installed the Android version of the Overdrive Media Console on my Nexus 7. It’s a free app. Install via the Play store and it’s ready to go in a minute. You enter your zip code to help locate your library, pick the library you use, and then enter… Read more

0 comments, 783 reads

Posted in SQLAndy on 6 August 2013

Embedding Flash Video in a Blog Post

I recently needed to figure out how to embed Flash streaming video in a blog post. LiveWriter does Youtube ok and I thought about moving the content, but was looking for something I could get done faster. I had used the JWPlayer for streaming on a web page and they… Read more

0 comments, 566 reads

Posted in SQLAndy on 5 August 2013

Presenting PCI for the SQL DBA on August 8, 2013

I’ll be doing my PCI for the SQL DBA presentation on August 8th at 1 pm Eastern for the PASS Security Virtual Chapter. Visit the chapter page for more info, or you can register directly for the webinar. Hope you’ll attend!

Read more

0 comments, 798 reads

Posted in SQLAndy on 5 August 2013

Review: The Phoenix Project

Back in April Steve Jones mentioned reading a review of The Phoenix Project by mutual friend Thomas LaRock. It’s a book about IT written as a story that covers the trials and mishaps that all of us will identify with – corrupted data, SAN failure, too many projects, unrealistic… Read more

0 comments, 696 reads

Posted in SQLAndy on 2 August 2013

Notes on Moderating a 24 Hours of PASS Presentation

Last night (8pm Eastern) I had my first run as a 24HOP moderator and wanted to share some thoughts on it:

  • I usually use the microphone on my laptop, but in test we were getting echo in some places. I fixed it by turning down the speaker volume. Definitely recommend…

Read more

0 comments, 606 reads

Posted in SQLAndy on 1 August 2013

How Will Your Product Fare Over Time?

I like to look at things that have been in use for a while to see how they hold up. Sometimes it’s a way to be smarter or more cost efficient the next time. Sometimes a reminder to sweat the small stuff. Sometimes it is just interesting.

Here’s one example.… Read more

0 comments, 727 reads

Posted in SQLAndy on 1 August 2013