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.

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

2 comments, 52 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, 85 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, 92 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, 120 reads

Posted in SQLAndy on 17 August 2015

Notes From the August 12, 2015 oPASS and MagicPASS Meeting

  • Meeting held at Nova Southeastern here in Orlando
  • Arrived early to meet David Pless, good thing we were early – couldn’t get the display to duplicate, some kind of problem with the projector set up. Finally had to set things up so he could sit facing the screen for the…

Read more

0 comments, 129 reads

Posted in SQLAndy on 17 August 2015

A Quote from Spock

My mom gave me a book about Leonard Nimoy  recently and we talked later about the impact his life had on others and his role in the rebooted Star Trek. One more reason to love my Mom, she loves Trek! We talked about how having Spock (Spock Prime!) show up… Read more

0 comments, 153 reads

Posted in SQLAndy on 15 August 2015

oPASS & MagicPASS Meeting Tonight

David Pless is presenting:

Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL Database V12. Query Store is designed to help with query performance troubleshooting by making it easier to identify poorly performing statements and finding scenarios where performance regresses. In this… Read more

0 comments, 110 reads

Posted in SQLAndy on 12 August 2015

Farewell Scott McKenzie

Scott McKenzie was the DJ of Mix 105 here in Orlando for an astounding 24 years and that’s been the main station I listen to for about the same amount of time. Curiously I don’t know who was there before Scott. You know how it works, you scan stations until… Read more

0 comments, 109 reads

Posted in SQLAndy on 12 August 2015

Using Kickstarter to Save Neil Armstrongs Spacesuit

Ran across this while visiting the Air & Space Museum over the summer, the Smithsonian launched a Kickstarter campaign to raise funds to conserve and digitize the suit Neil Armstrong wore on the moon. I donated a dollar and I see they’ve already passed the funding goal of $500k.  It… Read more

0 comments, 271 reads

Posted in SQLAndy on 5 August 2015

SSC Editorial: How to Keep Up with SQL Server

How to Keep Up With SQL Server ran as the editorial of the day on July 31st. Modest amount of comments, but in particular I made a note to come back to the topic of early adopters vs being stuck with a late/never adopting employee. Both are interesting scenarios.

Imagine… Read more

0 comments, 136 reads

Posted in SQLAndy on 4 August 2015

SSC Editorial: Would You Pay to Wear Jeans at Work?

Would You Pay to Wear Jeans at Work turned out to be popular piece when posted a couple weeks back. The premise is that some companies allow a relaxed dress code in return for a donation to a specified charity.  I’ve opted in at times and not at others to… Read more

0 comments, 170 reads

Posted in SQLAndy on 28 July 2015

SQLSaturday Orlando 2015–Classes on Thursday and Friday for Even More Learning

We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday. It started way back at #1 when we brought Joe Celko to town! It’s a way to give our local community the chance to do some deeper learning at a… Read more

0 comments, 119 reads

Posted in SQLAndy on 20 July 2015

SSC Editorial: Is the Golden Age of Information Technology Almost Over?

Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential changes without saying the sky is following, but it does make a good opinion piece!

I was discussing it with Steve Jones after it was published and he… Read more

0 comments, 138 reads

Posted in SQLAndy on 16 July 2015

Next oPASS Meeting is July 23, 2015 with David Crook

The next OPASS meeting is July 23, 2015, featuring David Crook from Microsoft doing a presentation on predicting home value using Azure. Should be interesting!


Read more

0 comments, 151 reads

Posted in SQLAndy on 16 July 2015

The End of SQLRally

PASS announced yesterday the end of the SQLRally brand. It was disappointing news for an idea that started with such promise. It’s a minimal impact decision as Rally had long been dead here in the US and I imagine the international users will be able to proceed using the SQLSaturday… Read more

1 comments, 194 reads

Posted in SQLAndy on 14 July 2015

Worth Reading: Microsoft IT migrates mailboxes to Office 365 Exchange Online

Just read Microsoft IT migrates mailboxes to Office 365 Exchange Online, a good overview of their migration from Exchange. Lots of interesting lessons learned and if you generalize just a bit apply to other migration scenarios.



Read more

0 comments, 171 reads

Posted in SQLAndy on 14 July 2015

Be a PASS NomCom Candidate!

Today is the last day to submit your name as a candidate for the NomCom. If you’re a PASS member (surely you are) and you want the org to remain strong volunteering for the NomCom is a great way to help out. It’s also a way to get an… Read more

0 comments, 156 reads

Posted in SQLAndy on 14 July 2015

Thoughts on the PASS BAC

I recently read PASS and Business Analytics: A Winning Combination on the PASS blog and it reminded me that I’ve been wanting to write some thoughts and concerns related to the BAC. I start this acknowledging I’m looking at things from a DBA perspective and that I haven’t attended a… Read more

0 comments, 204 reads

Posted in SQLAndy on 8 July 2015

Moving SQLAndy to Project Nami

I’ve been hosting this blog on Azure for a while, running WordPress on top of MySQL. Works fine, gives me a reason to use Azure here and there to gain experience. No good reason to change. Still, why not?

Last night I loaded Project Nami, a port of WordPress… Read more

0 comments, 146 reads

Posted in SQLAndy on 2 July 2015

Reporting Services Subscriptions in “Pending” Status

Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it had a status of “pending” Not helpful! I tested the report, looked at the datasources, and the subscription, it all looked good. It was only when I stepped through the… Read more

0 comments, 161 reads

Posted in SQLAndy on 1 July 2015

Older posts