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.

A Note on Configuring HP SSD’s

Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage guy noted that the following has to be done to get best performance.

This command disables SSD Smart Path. You must disable the SSD Smart Path before enabling Controller caching.…

Read more

0 comments, 217 reads

Posted in SQLAndy on 24 March 2017

Configuring KDIFF With GitHub

Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and useful, but you have to get all the switches set up if you want full functionality (three way merge). I found the answer on this blog post (a reminder to… Read more

2 comments, 642 reads

Posted in SQLAndy on 23 March 2017

The PASS Executive Committee

I was just reading The PASS Board Guidance Policy . Overall a reasonable document and absolutely worth reading if you’re thinking about running for the Board. It is missing what I consider a key point about the Executive Committee, so I wanted to write a quick note on that.

The… Read more

2 comments, 212 reads

Posted in SQLAndy on 22 March 2017

Thinking about Chapters (aka Groups)

I think it was 2003 or 2004 when someone from PASS came to Orlando and helped start what became OPASS. They stressed the need to find speakers each month and the need to have multiple people involved so that the group wouldn’t die if someone moved on. The formula was… Read more

2 comments, 370 reads

Posted in SQLAndy on 11 March 2017

The Ebb & Flow of Community Participation

It’s an interesting moment when you discover the SQL community (or any other I suppose). It’s the moment of finding the door in a dark room that leads to the next level of the career game. Easy to find once you know it’s there, but until you find it not… Read more

4 comments, 230 reads

Posted in SQLAndy on 5 March 2017

Would You Still Love Linux If Windows Was Free?

How often is cost the deciding factor in the case of Windows vs Linux? And what if cost wasn’t a factor (noting that Linux isn’t “free” if you’re paying a support agreement)? If you look at cloud offerings Linux has an advantage in pricing because its, if not free, considerably… Read more

0 comments, 270 reads

Posted in SQLAndy on 7 February 2017

Worth Reading – Something I learned while unemployed by Rod Falanga

SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to stay current and the difference between knowing concepts and implementing them.


Read more

0 comments, 488 reads

Posted in SQLAndy on 28 January 2017

Notes from the January 2017 oPASS/MagicPASS Meeting

This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to see Grant and Denny speak. Grant did an hour, then we had a 30 minute demo/pitch from ScaleArc, then an  hour by Denny. That feels like a better investment of… Read more

4 comments, 220 reads

Posted in SQLAndy on 23 January 2017

Joint OPASS/MagicPASS Meeting Tomorrow Night (January 18, 2017)

Grant Fritchey will be presenting Faster Provisioning with SQL Clone and Denny Cherry is presenting Optimizing SQL Server Performance in a Virtual Environment. The event is being held at Nova Southeastern in Orlando. Register (Free) at https://www.eventbrite.com/e/sql-sons-of-beaches-tour-tickets-30043366518. Hope to see you there!


Read more

0 comments, 337 reads

Posted in SQLAndy on 17 January 2017

Should We Allow Paid Sponsor Presentations at PASS Summit?

For many years the PASS Summit program committee has enforced a bright line rule – no sponsor content in the educational tracks. I always thought it was a good rule because it was easy to enforce and it made sure that sessions were educational (that is, not a veiled or… Read more

2 comments, 349 reads

Posted in SQLAndy on 9 January 2017

Moving to WordPress.com

For years I’ve hosted WordPress somewhere, most recently in Azure using Project Nami so that I could store all the posts in SQL Azure. It’s been a good learning experience. It takes some effort to set up, but once done it’s fairly painless, you can even have security updates applied… Read more

0 comments, 271 reads

Posted in SQLAndy on 8 January 2017

Reflecting on Ten Years of SQLSaturday

It’s hard to believe it’s been more than 10 years since we started the planning for the first event in Orlando. The success of the idea seems obvious now – surely the time was right for something to happen in our space. Back then though it was far from obvious.… Read more

8 comments, 805 reads

Posted in SQLAndy on 30 November 2016

Notes from our 3rd Student to IT Pro Seminar

Concurrent with SQLSaturday Orlando we ran our third student seminar. This is our way of giving back to the college that so kindly gives us free space for the event and of encouraging students to see IT as a great career choice.

  • Attendance was down last year, not good. This…

Read more

0 comments, 343 reads

Posted in SQLAndy on 29 November 2016

Notes From SQLSaturday Orlando 2016

This year we held our 10th SQLSaturday, a very nice milestone to hit. I’ll reflect in a separate post on the growth and future of the overall franchise – there’s a lot to think about – but I’ll mostly keep this post specific to the event itself.

This turned out… Read more

0 comments, 371 reads

Posted in SQLAndy on 28 November 2016

Why we need a PASS Sponsor Portal

Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all interesting and potentially valuable invitations, but the sheer volume can be overwhelming. Beyond that, sponsors struggle to find the ROI, from picking the swag that draws people to the table… Read more

0 comments, 261 reads

Posted in SQLAndy on 11 November 2016

The PASS Global Alliance Program (GAP)

One of the topics I forgot to mention from the Roundtable was a swell of dissatisfaction with the GAP. Not all understood it, and it’s clearly not “global” from the perspective of the non North American events. I don’t know if GAP is a good idea or not, but it… Read more

2 comments, 253 reads

Posted in SQLAndy on 10 November 2016

The ROI of SQLSaturday

Following up on my notes about the 2016 SQLSaturday Roundtable I wanted to write more about the ROI of SQLSaturday. I suppose there are many ways to measure it, but I think it boils down to two views:

  • How many people did we train/hours we deliver to our members? That’s…

Read more

10 comments, 332 reads

Posted in SQLAndy on 9 November 2016

Notes from the 2016 SQLSaturday Roundtable Meeting

Each year PASS holds a meeting for SQLSaturday event leaders and key players on Tuesday morning. It’s a valuable meeting, though I have some criticisms about both format and content this year, more on that in a minute. Watching and listening, I appreciate more than ever that while it’s useful… Read more

1 comments, 343 reads

Posted in SQLAndy on 8 November 2016

Thoughts on the 2016 PASS Summit

I’ll have several more posts this week on specific activities at the Summit, but wanted to start with how the trip went personally:

  • I flew out Monday instead of Sunday. Whether it just that or my pacing for the week, I wasn’t wiped out on Friday afternoon
  • I didn’t take…

Read more

0 comments, 238 reads

Posted in SQLAndy on 7 November 2016

MVP No More

Back in September I received a call from my MVP lead that I wasn’t being renewed. Not a big surprise, though still a disappointment. The program has changed a lot since I joined in 2008 and today has much more focus on “data platform” than just SQL Server (where I… Read more

0 comments, 257 reads

Posted in SQLAndy on 7 November 2016

Newer posts

Older posts