Click here to monitor SSC
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 and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

How O’reilly Picks Sessions

Read this and wanted to share as we head to the PASS Summit next week: This is how we do it: Behind the curtain of the O’Reilly Security Conference CFP


Read more

0 comments, 130 reads

Posted in SQLAndy on 21 October 2016

Notes on Designing an After Hours Event for the PASS Summit

This year we’re trying out two ideas on Thursday night, a networking dinner (of a sort) and game night. I wanted to share some ideas on how and why we put these together.

  • We’ve long tried to encourage more after hours events with limited success. Of course not all events…

Read more

0 comments, 135 reads

Posted in SQLAndy on 20 October 2016

PASS Summit 2016: Dinner, Dinner, Game

Part of making a week long trip to a big event like the PASS Summit successful is finding something to do in the evening that recharges you. PASS has a number of events listed for After Hours this year. Steve Jones and I are organizing three of them:

Read more

0 comments, 114 reads

Posted in SQLAndy on 20 October 2016

Making the Most of PASS Summit and Similar Events

Events like the PASS Summit aren’t just about education. They are a chance to meet new people, get some distance from the day to day problems of work (and life perhaps), and even have some fun. Done well attendees end the week tired and recharged.

How to do… Read more

0 comments, 89 reads

Posted in SQLAndy on 20 October 2016

An Update on My 2012 Mac Air

Typically I want to get 3 years out of a laptop to amortize spending on a premium grade machine. I’m at 4 years on this one and while there is better hardware available now, so far it hasn’t been enough better to drive me to buy something new. I maxed… Read more

0 comments, 121 reads

Posted in SQLAndy on 12 October 2016

SSC Editorial: Does Log Data Belong in a Table or a File?

I think the topic of whether log data belongs in a table or a file would be a great one for a debate format. I think its one of my better editorial efforts because most people will already have an opinion on which is correct/better and will be curious to… Read more

0 comments, 104 reads

Posted in SQLAndy on 10 October 2016

SSC Editorial: A Visit to Microsoft

A Visit to Microsoft was posted back in August and I just re-read it. Here’s a quote that might interest you:

As a working DBA I heard two things that seemed very positive (not counting the new features and improvements of course). One was that Microsoft sees the ability to…

Read more

0 comments, 104 reads

Posted in SQLAndy on 10 October 2016

Networking Dinner at the 2016 PASS Summit

Steve Jones & I are organizing our 7th annual networking dinner on Monday night, October 24th in Seattle. We’re changing the formula just a little this year in an effort to work better with the hosting restaurant – it’s hard to absorb 200 people showing up all at the same… Read more

3 comments, 181 reads

Posted in SQLAndy on 6 October 2016

Notes about Postponing SQLSaturday Orlando Due to the Hurricane

We’ve been monitoring the weather all week, thinking that today was the day we had to decide. We didn’t want to be hyper-cautious and reschedule too early because of the impact on speakers and sponsors traveling to Orlando, nor did we want to want too long and risk them being… Read more

1 comments, 141 reads

Posted in SQLAndy on 5 October 2016

More on Strengthfinders

This past week I attended a one hour facilitated group session that was a continuation of the Strengthfinders assessment.  One part was looking at where our strengths were in regard to four team zones (3 of mine fall into strategic thinking) and the rest was looking at the potential weaknesses… Read more

0 comments, 190 reads

Posted in SQLAndy on 2 August 2016

The ROI of SQLSaturday for PASS & Decreased Event Funding

Returning to the post about Making SQSaturday Sustainable (see also a follow post  about addressing concerns) it mentioned two topics that I wanted to look at more; the ROI for PASS and the decrease in funding to events.

For the past few years the standard has been for PASS… Read more

2 comments, 778 reads

Posted in SQLAndy on 30 July 2016

The End of the BAC–Why?

In a post titled The Future of the BA Community PASS announced that there would be no Business Analytics conference in 2017 and that the new strategy would be multi pronged, focused on local groups and events. I’ve never been a fan of the concept of the BAC so it… Read more

0 comments, 229 reads

Posted in SQLAndy on 30 July 2016

600 Miles, Limits, Fears, and Possibilities for SQLSaturday

Last week PASS published some new guidance for SQLSaturday that sets a 600 mile rule (has since been updated, still keeps the radius) to keep events from being held too close together and another that reduces the funding from PASS for most events. I appreciate the stated goals, find… Read more

2 comments, 609 reads

Posted in SQLAndy on 28 July 2016

SSC Editorial: Should I Stay or Go?

Really late linking to it, Should I Stay or Go is about being more assertive about making the decision to change jobs or projects. It’s easy to decide to leave when things are terrible, much harder when it less than optimum – because most jobs are!

Read more

0 comments, 153 reads

Posted in SQLAndy on 18 July 2016

Karla Set the Standard

Last week Karla Landrum announced that she will be leaving her position as Community Evangelist later this year after five years. That means change for PASS and for us and for Karla, but just the nature and scale of that pending change illustrates how much Karla has done in the… Read more

0 comments, 1,295 reads

Posted in SQLAndy on 17 July 2016

GIT Learning Resources

I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source control than none. Now I’m working with a tam that uses Git, so I’m learning enough to check-in changes and merge and clean and the other basics. I’ve gathered… Read more

2 comments, 210 reads

Posted in SQLAndy on 15 July 2016

Retrieving the SQL Server License Key

Strangely enough its been a long time since I installed SQL in production. It’s almost always done by someone on the server team and that’s fine with me, clicking the wizard (or running the install script) isn’t the interesting part. Today though, I needed to add a named instance (also… Read more

2 comments, 212 reads

Posted in SQLAndy on 27 June 2016

PASS Nominating Committee Update

Today PASS released a bunch of stuff for the upcoming election including the attributes of an “ideal candidate”. We put in quite a bit of time on that description, in part because people often ask “am I ready” and in part because it is the next step in doing a… Read more

2 comments, 211 reads

Posted in SQLAndy on 22 June 2016

Names From the Past

Can you guess what all of these people have in common?

  • Shawn Weisfeld
  • Joe Healy
  • Barry Ralston
  • Trey Johnson
  • Jon Winer
  • Wes Dumey
  • Donnie Reynolds
  • Kevin Jacobs
  • Joseph Memmo
  • Brian Knight
  • Michael Antonovich
  • Declan Link
  • Patrick Thompson
  • Jeff Garbus
  • Jim Blizzard
  • Ken Tucker
  • Jessica Moss
  • Bayer White
  • Joe Celko
  • Judy…

Read more

0 comments, 215 reads

Posted in SQLAndy on 22 June 2016

SQLSaturday Orlando 2016 Call for Speakers Closes July 17, 2016

We’ve advanced the closing date for the SQLSaturday Orlando call for speakers to July 17. That’s to give us time to set the schedule and have it announced around August 1, just a little more than 60 days before the event. We’ll get an email with that information out to… Read more

0 comments, 178 reads

Posted in SQLAndy on 22 June 2016

Older posts