Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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 and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

SSC Editorial: Early Adopters

I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as ‘early adopters’. There’s some truth to that, but not all MVP’s are early adopters and not all early adopters are MVP’s. What interested me more was the attitude, that… Read more

0 comments, 74 reads

Posted in SQLAndy on 25 November 2015

Job & Process Documentation Tips

Three big things I look for in documentation:

  • Who to call when it goes wrong
  • Where to find it the code, especially if its in source control – can be hard to find when someone is in a hurry
  • Standard steps for troubleshooting.


Read more

0 comments, 129 reads

Posted in SQLAndy on 19 November 2015

Veterans Day – Thank You for Your Service

If you currently serve or have served in our military, thank you for your service. Please never doubt that your efforts made a difference.

Read more

0 comments, 100 reads

Posted in SQLAndy on 11 November 2015

Did PASS Forget the DBA?

Today I had on my list to finish watching the presentation Gail Shaw did at Summit 2014, one of the free recordings on PASS TV. I don’t remember it from before, but I was prompted to fill out a short demographic form. Ok, I get it. Then I get to… Read more

3 comments, 130 reads

Posted in SQLAndy on 11 November 2015

More Thoughts on the PASS BAC

Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by me):

The PASS BA Conference answers the call to meet the unique needs of business and data analysts, who are asked to do more with data every day.…

Read more

3 comments, 101 reads

Posted in SQLAndy on 10 November 2015

Renewed as MVP

I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for the new MVP year is pretty much the same as last year, I’ll try to out and about serving the Florida community, doing some mentoring, and contributing to… Read more

0 comments, 104 reads

Posted in SQLAndy on 10 November 2015

New FileTable Questions Posted on SQLServerCentral

I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about filetables:

Read more

0 comments, 126 reads

Posted in SQLAndy on 10 November 2015

Notes on the 2015 PASS Summit

I’m still catching up after my 13th PASS Summit and as usual the longer I wait the shorter the notes will be, so I’m going to try to capture the biggest thoughts of my week:

Read more

0 comments, 131 reads

Posted in SQLAndy on 4 November 2015

PASS Summit 2015 Plans

I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day early so I can have a “slow day” and start to sync to local time and it gives me a good buffer in case the flight is delayed or cancelled.… Read more

0 comments, 213 reads

Posted in SQLAndy on 23 October 2015

Notes From the September 16, 2015 Jacksonville SQL User Group Meeting

Forgot to post the next day and now missing details! Notes:

  • Rained the entire drive up (and back)
  • Not a bad drive for me, about 2 hours
  • You know it’s a strange day when you turn left at Wackos to get there
  • Location is a restaurant/bar/grill. Had to look twice,…

Read more

0 comments, 162 reads

Posted in SQLAndy on 30 September 2015

Thoughts on the 2015 PASS Election

We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim Ford – for participating, and congratulations to Jen, Ryan, and Tim for being elected. PASS surely can’t survive without volunteer leaders and it’s great to see that we continue… Read more

2 comments, 217 reads

Posted in SQLAndy on 25 September 2015

SSC Editorial: The Counter Offer – Part 1/Part 2

Counter offers (and the related discussions) are an emotional topic. The comments on two of my editorials for SQLServerCentral (The Counter Offer – Part 1 and The Counter Offer – Part 2) show that.  The takeaway for me is that we are still torn about being loyal employees… Read more

0 comments, 210 reads

Posted in SQLAndy on 23 September 2015

Recommendations, Endorsements, and More on the 2015 PASS Election

We have four good candidates this year, of which two are incumbents. I was asked by Argenis and Tim to provide references for their applications and I was glad to do so – both meet the requirements in my view to be candidates based on their contributions to PASS.

I’m… Read more

4 comments, 232 reads

Posted in SQLAndy on 17 September 2015

Improving Networking at PASS Events–Part 1

This week I’m spending some drive time thinking about how we might improve networking at SQLSaturday and that led to me thinking about the general state of networking within PASS. Some early thoughts on networking in general:

  • It’s not enough to put people in a room and say “network”
  • It’s…

Read more

2 comments, 646 reads

Posted in SQLAndy on 10 September 2015

An Evening of Networking at the 2015 PASS Summit on October 26, 2015 (Monday)

Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new ones? Here’s the registration link for our networking dinner/party. The location should be settled sometime in the next few days. Turns out Monday night is football night in Seattle and… Read more

1 comments, 240 reads

Posted in SQLAndy on 2 September 2015

SSC Editorial: The Problem Solver

The Problem Solver. Ever scoffed at personality types? Surely none of us are just one thing, but often we are mostly one thing, or at least one thing that is easily identified as being a big part of who we are. Writing this I was thinking about two things… Read more

0 comments, 228 reads

Posted in SQLAndy on 31 August 2015

Does SQLSaturday Increase Chapter Attendance?

One of the big goals for SQLSaturday was for it to be a membership drive. It’s worked hugely well in some ways; we’ve added tremendously to the number of PASS members, grown the size of the Chapter mailing lists (for those that held a SQLSat), and introduced a lot of… Read more

10 comments, 209 reads

Posted in SQLAndy on 27 August 2015

SSC Editorial: Annual Security Compliance Training

Compliance training, never a fun topic and I think that is too bad. A combination of companies checking the box, lacking imagination, and being stuck with rules that require doing it annually. Do we really need to review the employee manual if it hasn’t changed since last time? Or… Read more

0 comments, 213 reads

Posted in SQLAndy on 26 August 2015

SQLSaturday & The Speaker Wait List

When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to notifications for the region, basically saying “we hope you’ll speak at our event”. It’s lightweight and useful, and generally the only ‘send to all speakers’ message for that event, but… Read more

0 comments, 218 reads

Posted in SQLAndy on 25 August 2015

Notes From The August 13, 2015 Spacecoast SQL Meeting

  • Meeting is held at Sonny’s BBQ, they have a long room (used to be outside seating) that works pretty well for a small group. Plus the food is good!
  • Presented the basics of avoiding, detecting, and repairing corruption
  • 11 attendees. Was worried for a few minutes, almost everyone came in…

Read more

0 comments, 212 reads

Posted in SQLAndy on 17 August 2015

Older posts