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.

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, 186 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, 178 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

4 comments, 267 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

0 comments, 208 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, 235 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

0 comments, 873 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, 298 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

0 comments, 742 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, 195 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,403 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, 241 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

0 comments, 263 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, 248 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, 263 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, 216 reads

Posted in SQLAndy on 22 June 2016

The PASS Speaker Agreement

I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not fueled the fire.

The various posts and discussions and the time writing this (multiple drafts) have definitely caused me to re-examine my own views. I’ve found that some were simplistic… Read more

0 comments, 990 reads

Posted in SQLAndy on 20 June 2016

MS Exams Increasing In Price

Just glanced through the MCP newsletter and see that the price of the exams (or at least the one I looked at) is increasing from $150 to $165. It’s hard not to question whether the exam is worth $165 (or even $150) – it just doesn’t have a lot… Read more

3 comments, 2,394 reads

Posted in SQLAndy on 9 June 2016

The Road to SQLSaturday Orlando – 2016

This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress report.

  • Requesting the event # is much better than the last time I did it (years ago). More of a wizard, lets you set the exact location (though it’s a…

Read more

0 comments, 232 reads

Posted in SQLAndy on 23 May 2016

Events I Wish PASS Organized

I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought or two. I love the PASS Summit – its the great gathering of our craft. But I also long for specialized events to supplement both the Summit and SQLSaturday. Imagine… Read more

0 comments, 932 reads

Posted in SQLAndy on 9 May 2016

Notes From SQLSaturday Jacksonville 2016

  • Everything ran smooth
  • The site reminds me of Orlando – limited space for sponsors, but offset by the other advantages (free venue, great parking, good rooms)
  • Lunch was 4 lines of real food and it looked like the max wait was in the 8 minute range (and less for many).…

Read more

0 comments, 305 reads

Posted in SQLAndy on 9 May 2016

Newer posts

Older posts