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.

The Failed One Laptop Per Child Project

I wrote about OLPC back in 2010 (and before that, somewhere back on a post I didnt port over here from SSC). It was a vision worth pursuing.  It failed though, for many reasons, perhaps not the least of the killer branding around the “$100 laptop” which turned out to… Read more

0 comments, 126 reads

Posted in SQLAndy on 30 July 2018

Zero Width Characters

Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of the Canary Trap (if you’re a Clancy fan).

Read more

0 comments, 159 reads

Posted in SQLAndy on 23 July 2018

Paper Model of Hubble Telescope

Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while doing some follow up reading on the Hale Telescope (because I just read a book about it). I haven’t attempted the model, but wanted to note it here in… Read more

1 comments, 2,058 reads

Posted in SQLAndy on 20 July 2018

Getting Schooled by Brent

Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training is good! I signed up with a few thoughts in mind:

  • I had not taken a class recently (I like to self learn, perhaps to a fault)
  • I was curious…

Read more

0 comments, 2,145 reads

Posted in SQLAndy on 19 July 2018

SQL Solver

A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective of someone that has once or twice rewritten a query to be faster and then discovered it was subtly different. I don’t think we have the equivalent. We can compare… Read more

0 comments, 186 reads

Posted in SQLAndy on 19 July 2018

Notes From SQLSaturday Houston 2018

Various and possibly amazing notes:

  • Because I waited too long the best flight I could get was into George Bush instead of Hobby, which meant driving around (literally, on the beltway) Houston and it left at a not-so-fun 7 am on Friday.
  • I got a car from Dollar. Got the…

Read more

0 comments, 173 reads

Posted in SQLAndy on 28 June 2018

South Florida Vacation Notes

I extended my trip to SQLSaturday South Florida for a couple days vacation. If I’m going to drive 3-1/2 hours may as well make the most of it.

Read more

0 comments, 191 reads

Posted in SQLAndy on 19 June 2018

What Twitter Account Should SQLSaturday Use?

Last week PASS sent out an email saying that on June 15 all the tweets from @sqlsat would be changed to come from @sqlpass (and no more “attending” tweets”). The next day the deadline was moved to June 22 in response to feedback. You can read the official post here Read more

0 comments, 192 reads

Posted in SQLAndy on 18 June 2018

Notes on SQLSaturday South Florida 2018


  • Due to travel delays I missed the speaker dinner. I missed the chance to catch up and meet new people, but I have to admit the introvert in me enjoyed a quiet evening before a busy Saturday. That’s not to suggest that I will plan to miss more, it’s…

Read more

1 comments, 173 reads

Posted in SQLAndy on 18 June 2018

Notes on the May 2018 SQLOrlando Meetup

Late writing notes!

  • 55 registered, 28 attended. Not bad, and about on track for expected 50% drop. Really, 28 made for a good meeting.
  • Posted to meetup, one email out to the oPASS/MagicPASS list, so by design not doing a lot of extra messaging.
  • First meeting downtown, but strangely almost…

Read more

0 comments, 179 reads

Posted in SQLAndy on 11 June 2018

SQLSaturday Orlando 2018 – Planning Update #2

Continuing the notes I wrote in Update #1, got a few more things done last week:

  • Received confirmation that the event was approved, good!
  • Logged in to the admin site and did these things (about 10 mins):
    • Set the call for speakers end date
    • Picked vegetarian as a lunch…

Read more

0 comments, 156 reads

Posted in SQLAndy on 5 June 2018

SQLSaturday Orlando 2018 Registration is Open

We’ve just opened up registration and the call for speakers for our 12th SQLSaturday here in Orlando. We did #1 back before we numbered them and this year we’re an astounding #801. It’s fun to watch that number keep increasing!

The call for speakers will end on July 20th. We… Read more

0 comments, 543 reads

Posted in SQLAndy on 1 June 2018

SQLSaturday Orlando 2018 – Planning Update #1

Each year I try to capture a little more on how to set things up here in Orlando. Right now its all in one spreadsheet with a bunch of tabs. Low tech, but good enough for now. Here’s what I’ve done so far:

  • Mar 1. Reserved our date for this…

Read more

1 comments, 193 reads

Posted in SQLAndy on 29 May 2018

Thoughts on the 2018 (and beyond) PASS Elections – Part 1

Last week Wendy Pastrick of the PASS Board posted PASS Election 2018 Timeline. It’s a good post for a few reasons:

  • It signals changes to an existing process (which leaves time for discussion/uproar as needed and any resulting course corrections)
  • It explains why the change is being made
  • It…

Read more

0 comments, 208 reads

Posted in SQLAndy on 16 May 2018

SQLOrlando Meetup Coming Up on May 23, 2018

We’ve been on a break with regards to most things SQL here in Orlando, but we’re getting things going again with a double-the-content meeting featuring Kendal Van Dyke and Tom Staab. This will be the first time we’ve held a meeting in downtown Orlando so I’m interested to see how… Read more

0 comments, 210 reads

Posted in SQLAndy on 8 May 2018

Good Seeing

I just finished reading The Perfect Machine about the construction of the Hale Telescope at Mount Palomar (here is a pretty good picture). Fascinating story with regard to both the people involved and the engineering. It took 21 years from getting the funds to when the first images were… Read more

0 comments, 184 reads

Posted in SQLAndy on 8 May 2018

Notes from SQLSaturday Jacksonville 2018


  • Great attendance, easily 400+
  • Lunch was smooth this year due to changing to boxed lunches
  • Rooms were in 2 different buildings. Sometimes you have to, but it always adds complexity
  • Speaker gift was a ‘survival kit’s with lots of useful bits including a USB C to HDMI/DVI/VGA (similar…

Read more

0 comments, 200 reads

Posted in SQLAndy on 7 May 2018

Benefits for Veterans

Wanted to share a few things I came across recently with regards to benefits for veterans:

  • You can get a printed VA card now by signing up via ID.me (ID.me also comes in handy for things like qualifying for incentives from car manufacturers). The card does not have your social…

Read more

0 comments, 249 reads

Posted in SQLAndy on 25 April 2018

Custard Indexes

Not sure how or why this popped into my head (and too late for April Fools!), but it amuses me to think about adding another layer of confusion to the clustered index discussions. Here’s your problem, you don’t have a custard key on that table!

Read more

0 comments, 307 reads

Posted in SQLAndy on 13 April 2018

Farewell, Robert Davis

Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering questions over the years, shared a lot of knowledge and hard won lessons about working with SQL.  For years to come people will be trying to find an answer and… Read more

2 comments, 2,808 reads

Posted in SQLAndy on 4 April 2018

Older posts