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: March 2014

Follow Up on The Unusable User–Question Of The Day

I posted about one of my questions of the day called The Unusable User last week and wanted to return to post some final stats and thoughts on how it turned out. First the stats:



Overall the comments on the question were good, especially about the style. I’m… Read more

0 comments, 1,175 reads

Posted in SQLAndy on 31 March 2014

SQLServerCentral Editorial: The Perfect Environment

I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them here, so trying to resume doing so. Today it’s The Perfect Environment, which is, as you might guess, discussing to what degree you strive for perfection and how far… Read more

0 comments, 522 reads

Posted in SQLAndy on 28 March 2014

Building the SQLSaturday Orlando Marketing Plan–Part 1

I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the main event as well as any seminars we host on Thursday or Friday. We’ve hit a cap the last few years, never getting beyond the 275-300 range (I’ll get exact… Read more

0 comments, 486 reads

Posted in SQLAndy on 28 March 2014

Can’t See The Forest For the Logins–Question of the Day

My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing for score. It’s another question where you have to infer some to get the answer. So far it’s proving to be a tough question, be sure to read the… Read more

0 comments, 432 reads

Posted in SQLAndy on 28 March 2014

Speaking at OPASS – April 2014

If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a long time ago! I’ll be back at oPASS in April doing two presentations (to make up for missing 2013!):

Building A Learning Plan

What should you learn next? How…

Read more

0 comments, 617 reads

Posted in SQLAndy on 26 March 2014

The Unusable User–Question Of The Day

My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for an incentive to give it a try? Here are the early stats, it’s definitely a hard question (or badly written? nah):



I’ll post follow up on… Read more

0 comments, 683 reads

Posted in SQLAndy on 26 March 2014

Notes From the Orlando Code Camp

  • Nice to have a SQL track! Looked like it averaged 20-25 attendance per session.
  • Ran smooth, thanks to Esteban Garcia and the volunteers from ONETUG
  • Had a couple great conversations about PCI and security after my presentation
  • Ran into quite a few people I know on the code side, reminds…

Read more

0 comments, 520 reads

Posted in SQLAndy on 24 March 2014

Notes From the March 2014 oPASS Meeting

  • Rodney Landrum presenting
  • Lots of free form demos, very light on slides – nice change
  • Looked at Power Pivot, Power Query, and Power Map
  • Pivot vs Query is confusing, when to use what? Query seems to support more data sources
  • Nice demo of pulling in SQLSaturday upcoming events from web…

Read more

0 comments, 596 reads

Posted in SQLAndy on 24 March 2014

Speaking At SQLSaturday #298 in Jacksonville on May 10, 2014

Got the email confirmation yesterday that I’m on the schedule – looking forward to being back in Jacksonville.

Read more

0 comments, 496 reads

Posted in SQLAndy on 24 March 2014

More On Alas Snapshot

Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than ran yesterday. Overall the comments on the question were positive, it was interesting (and intuitive I guess) to see that the detailed explanation of all the answers was appreciated. So… Read more

0 comments, 440 reads

Posted in SQLAndy on 21 March 2014

Meetings In Glass Houses

If you’ve followed my writing for a while you’ll know I’m a fan of translucency (transparency) in most things business. Right now I’m working next to a meeting room that has glass walls – talk about transparency! It seems like a good idea, it lets in a lot of light… Read more

0 comments, 512 reads

Posted in SQLAndy on 20 March 2014

Alas, Poor Snapshot, I Knew Him Well (Question Of the Day)

My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve got 5 minutes go give it a try and let me know what you think, with comments on the question or here.

Read more

0 comments, 484 reads

Posted in SQLAndy on 20 March 2014

Submitting PASS Summit Sessions

I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one be about PCI and security because I enjoy the topic and have some experience I’d like to share. Career planning is always interesting to me. As is mentoring, networking, SQLSaturday,… Read more

0 comments, 629 reads

Posted in SQLAndy on 19 March 2014

Why Am I Here? You’re On Retainer

That’s just one of about a hundred great lines from episode 1 of Farmed and Dangerous. A company with the initials of IFIB. The scene where the team is talking about the boss is good (listen for the remark about ticks). It’s free with a couple minutes of commercials… Read more

0 comments, 601 reads

Posted in SQLAndy on 19 March 2014

A Nicely Made Smoke Detector

This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a lot to installing any smoke detector, most have two screws that go into the ceiling and a cover that pops off so you can replace the 9v battery. Sounds easy… Read more

0 comments, 640 reads

Posted in SQLAndy on 19 March 2014

Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!

I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server track. Jason Carter will be speaking, as will Kendal Van Dyke, Max Trinidad, Richie Rump, Robert Biddle, and myself. Thirteen tracks of learning! Even if you… Read more

0 comments, 523 reads

Posted in SQLAndy on 18 March 2014

A Minute About Minute Key

You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let you make your own copies of common key types:



I tried it out over the weekend. Quick, painless, and if anything not very exciting to watch. I didn’t… Read more

0 comments, 675 reads

Posted in SQLAndy on 18 March 2014

Rodney Landrum Presenting at oPASS on March 20, 2014

Almost time for another meeting! This month Rodney Landrum is presenting Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL Servers:

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now…

Read more

0 comments, 499 reads

Posted in SQLAndy on 17 March 2014

Some Notes On Writing A Question Of The Day

I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest question, Schema Renaming Fun. I’ve got a couple more in the pipeline (The Unusable User,  and Alas Poor Snapshot, I Knew Him Well). Lessons learned/thought of so far:

  • Make…

Read more

0 comments, 460 reads

Posted in SQLAndy on 13 March 2014

You Broke My Tail Light

That’s the first thing I heard when I answered the phone recently. I was working on an change I needed to make, missed a call, called back (thinking it might be related to the change) and no one answered, then they called back again. It went something like this:


Read more

0 comments, 727 reads

Posted in SQLAndy on 13 March 2014

Older posts