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.

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, 178 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,556 reads

Posted in SQLAndy on 4 April 2018

Jacksonville, South Florida, and Houston

Just crossed off my quarterly goal of planning SQLSaturday attendance for the next quarter (I’m writing this on March 31st!). I’ll be going to Jacksonville, South Florida, and Houston. Looking ahead I probably won’t do any in Q3 and will resume with SQLSaturday Orlando in October. I try to do… Read more

0 comments, 129 reads

Posted in SQLAndy on 2 April 2018

Thursday Night at the PASS Summit

It’s early days for thinking about the Summit, but as I wrote the post for yesterday about not submitting I was thinking about Game Night (which I hope continues) and trying to think what else we might do for a small(er) group given that we have rooms available. That took… Read more

0 comments, 150 reads

Posted in SQLAndy on 30 March 2018

No Summit Submission This Year

I had three ideas I considered submitting this year:

  • Devops for the DBA
  • SQL Checklists
  • Learning Plans v2

I’ve presented the first topic a few times in different forms, still not quite figure out. I did the one on checklists once, but while I think its valuable, it needs some… Read more

0 comments, 113 reads

Posted in SQLAndy on 29 March 2018

SQLSaturday Orlando 2018 – Planned for October 6

Just a quick note that we’ve reserved the date for our 12th SQLSaturday here in Orlando. It will be held on October 6, 2018, at our usual location at Seminole State College. Expect the call for speaker and registration to open up on June 1st. We’ll also publish information then… Read more

0 comments, 123 reads

Posted in SQLAndy on 28 March 2018

Parsing the PASS Blog Posts about FY 19 and SQLSaturday

In February PASS President Grant Fritchey posted PASS Priorities FY 19 followed by An Open Letter to SQLSaturday Organizers, and then held an online town hall for SQLSaturday organizers in March to address some of the questions generated by the two posts. For all the messaging, the story remains… Read more

4 comments, 1,407 reads

Posted in SQLAndy on 27 March 2018

Notes on SQLSaturday Tampa 2018

Quick notes:

  • Same location as previous years, good!
  • Parking was same place, but it was confused by a pay-to-park event on the same day. The attendants knew to let SQLSaturday attendees in at new charge, but I’m betting a few paid without asking or turned away
  • Some of the rooms…

Read more

0 comments, 133 reads

Posted in SQLAndy on 26 March 2018

Notes on Orlando Code Camp 2018

  • Good crowd, well organized
  • Took down registration early, perhaps 10 am, and that confused a few late(r) attendees (I like to keep the table staffed until after lunch, not just for check-in but also as a focal point if someone needs assistance)
  • Lunch was Jason’s Deli. Simple, good.
  • More staffing…

Read more

2 comments, 26 reads

Posted in SQLAndy on 18 March 2018

Farewell, Tom Roush

My friend Tom died yesterday. I just heard the news a few hours ago and while it will take some time to process,  I wanted to write something now, because of all the things Tom loved, surely reading and writing was high on the list and writing something about him… Read more

1 comments, 301 reads

Posted in SQLAndy on 31 January 2018

The Future of the SQLSaturday Tools

Every year when many of the SQLSaturday event leaders meet at the Summit the topic of improvements to the tools comes up. Certainly the site has seen changes  and improvements over the years,  plus at least two new coats of paint (on the public site), but it’s never enough (with… Read more

2 comments, 1,754 reads

Posted in SQLAndy on 8 November 2017

Notes on the 2017 PASS Summit

Just a few notes:

  • Weather on Wed was great, ok on Thurs, cold on Fri. Have had worse years!
  • Felt like I saw fewer people this year (that I knew), in part due to arriving Wed after lunch and in part to many of them skipping the event due to…

Read more

0 comments, 271 reads

Posted in SQLAndy on 8 November 2017

Monday Night Networking Dinner 2017

It’s on! Free registration at EventBrite.

I wrote last month about not being able to make it to Seattle on Monday to help organize the annual Networking Dinner. Good news though, Lisa Bohm has volunteered to organize the event this year. It will be held at Yard House,… Read more

0 comments, 299 reads

Posted in SQLAndy on 29 October 2017

SQLSaturday Orlando 2017 Notes – Part 3

This year we held our fourth Student to IT Pro Seminar for the students at Seminole State College. It runs from 9 am to 1130, concurrent with SQLSaturday but in a different building. Here is the schedule from this year:

Time Description
 8:30 to 9:00  Check-in & Informal Networking

Read more

0 comments, 269 reads

Posted in SQLAndy on 22 October 2017

SQLSaturday Orlando 2017 Notes – Part 2

SQLSaturday is really three sites. The public facing one (www) plus one for event admins and one for HQ to do overall admin. Most of the notes in this post apply to the site for event admins. These are all from my perspective which is biased in a few ways;… Read more

0 comments, 270 reads

Posted in SQLAndy on 22 October 2017

SQLSaturday Orlando 2017 Notes – Part 1

Part 1 will be about things we did (or didn’t) do and some lessons learned. In Part 2 I will share some thoughts on the SQLSaturday tools/web site. Part 3 isn’t really about SQLSaturday, rather our student seminar that we run concurrently. I’ll get to Part 2 and 3 as… Read more

0 comments, 286 reads

Posted in SQLAndy on 19 October 2017

Non Profit Umbrella Org – Good Idea?

Note: Published too soon, so lots of edits from the first version. Sorry for any confusion.

I had a question from my earlier post about SQLOrlando with regards to setting up an umbrella organization, basically asking “instead of each Chapter doing all this work, why not have one org?”. Great… Read more

2 comments, 1,082 reads

Posted in SQLAndy on 14 October 2017

More Notes on Non Profit Status

Following up on my post about forming a non profit here in Orlando, here are some notes that might help you get through the process a little faster:

  1. In the corporate filing for the state, use the IRS recommended language: Said corporation is organized exclusively for charitable, religious, educational, and…

Read more

0 comments, 301 reads

Posted in SQLAndy on 14 October 2017

SpeedPASS Download Naming Convention

This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was surprised/dismayed to see that when I unzipped the download the filenames were all named with a less than helpful format; b9d73479-5a04-42a3-9f11-a56af7b56beb.pdf. The goal was to be able to quickly find… Read more

2 comments, 1,362 reads

Posted in SQLAndy on 9 October 2017


We’ve haven’t had a good solution for managing money for SQLSaturday and our groups here in Orlando. In the early days I’d put the money in my business account, keep the receipts, figure out what was left to accrue for the next year, and let the accountant do the rest.… Read more

3 comments, 270 reads

Posted in SQLAndy on 12 September 2017

Older posts