Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

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.

SSC Editorial: Is Powershell Intimidating?

Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too. I think we forget that sometimes, that learning something new can be scary, painful (and fun, and exhilarating).

And of course today MS announced Bash is coming to… Read more

0 comments, 276 reads

Posted in SQLAndy on 4 April 2016

If SQL Server Runs on Linux What’s Left for April Fools Day and A Journey Journey

It’s still a bit hard to believe that SQL Server will soon run on Linux. If you think back to the early days of SQL 7, 2000, even 2005, who would have bet any money on it ever happening?  It was a topic worthy of an April 1 post back… Read more

3 comments, 320 reads

Posted in SQLAndy on 1 April 2016

2016 PASS Nominating Committee Announced

I was pleased to hear today that I was selected for the 2016 NomCom, along with Joaquin Romero, Erin Stellato, and Thomas LeBlanc. We’ll be working with the Nominations Committee (NomCom) Chair, Thomas LaRock, and Board representative, Tim Ford. It is a solid team and I’m eager to get… Read more

1 comments, 334 reads

Posted in SQLAndy on 31 March 2016

Notes from the March 2016 oPASS Meeting

Quick notes:

  • Chinese food instead of pizza (thanks Shawn!)
  • The wine bar is doing some remodeling to make better use of the space we (and presumably others) use by adding a pass through window to the bar area. That’s good, but the downside is the route to the restrooms appears…

Read more

0 comments, 317 reads

Posted in SQLAndy on 28 March 2016

SSC Editorial: On Time, or Not

Is being on time important? I think that might be a revealing interview question. The answer might or might not be a deal breaker depending on the hiring manager or the culture, but just hearing how they answer offers some interesting insight into how they see the world.

The comments… Read more

0 comments, 282 reads

Posted in SQLAndy on 24 March 2016

Last Day to Submit Your Letter of Interest for the 2016 PASS Nominating Committee

I submitted my letter just a few minutes ago. It’s a template, doesn’t take more than 5 minutes to fill out and send in. I’m curious to see if we have more volunteers this year than in previous years with the streamlined requirements.

 

Read more

0 comments, 278 reads

Posted in SQLAndy on 23 March 2016

Thoughts on the March 17, 2015 PASS Town Hall

I listened to most of the town hall today. The main topic was the just voted on changes to the NomCom selection process, with some related questions and conversation about why someone should serve, requirements, etc. I like the town halls – not as good as in person, but reasonable.… Read more

0 comments, 300 reads

Posted in SQLAndy on 18 March 2016

Notes from SQLSaturday Tampa 2016

Quick notes:

  • Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is hard to find!
  • Signs were up and looked good, though I heard a few people still weren’t quite clear to park (it’s a big parking lot). One or two…

Read more

0 comments, 320 reads

Posted in SQLAndy on 9 March 2016

Notes From the February 2016 OPASS Meeting

I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do it). Title still needs work, maybe the abstract too, but once we get started it seems to engage people. The biggest thing I’ve noticed from doing this presentation is the…unease?…when… Read more

0 comments, 301 reads

Posted in SQLAndy on 9 March 2016

SSC Editorial: Lessons From Little Green Army Men

This one is about spending time with my daughter – she bought some army men as a toy after a visit to the doctor. It’s also a little bit about diversity because the package of army men was all male.

Writing about father/daughter time is easy compared to writing about… Read more

0 comments, 299 reads

Posted in SQLAndy on 9 March 2016

SSC Editorial: Spousal Surcharges

I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is health insurance and the growing trend of employers charging employees a fee if their spouse has the option to get insurance via a different employer and opts out. Read more

0 comments, 242 reads

Posted in SQLAndy on 9 March 2016

Comments on Proposed Changes to the NomCom Process

On Friday Thomas LaRock posted Changes to the NomCom Process on the PASS blog for comment prior to the Board voting on the changes at the March meeting. If you haven’t read it yet, I encourage you to do so before reading my comments.

First, some quick background and disclosures.… Read more

2 comments, 324 reads

Posted in SQLAndy on 1 March 2016

Building With Iron Pipe

For a while I’ve been wanting to do a project that used black iron pipe for the main structure. Kind of a Lego’ish appeal for grown ups, if such a thing is possible. It’s strong and not hard to work with as long as you can stick to the stock… Read more

2 comments, 323 reads

Posted in SQLAndy on 16 February 2016

Moving to Open Live Writer

I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well enough and I’ve liked having an offline editor. It moved to open source after years of stagnating (though it still worked well enough!) and I’ve finally moved to that version Read more

0 comments, 401 reads

Posted in SQLAndy on 11 February 2016

Speaking at OPASS on February 25, 2016

Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database restores. It’s a still evolving presentation, but one that I think engages attendees. They know how to restore, they know why, so it’s just layering some ideas on top of… Read more

0 comments, 357 reads

Posted in SQLAndy on 2 February 2016

Pausing PASSWatch & What’s Next

I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard to call it a success, based both on stopping it and not accomplishing as much as I hoped, yet I don’t see it as a failure either. I learned a… Read more

0 comments, 350 reads

Posted in SQLAndy on 2 February 2016

SSC Question of the Day: DBCC Error 6

My latest question of the day on SQLServerCentral is DBCC Error 6. Text of the question below:

As the on-call DBA, you received calls of timeouts and errors on a SQL 2012 SP3 instance used for testing. You track the issue to IO requests that are taking longer than…

Read more

0 comments, 362 reads

Posted in SQLAndy on 2 February 2016

SSC Editorial: Design a Better SQL Server Pricing Model

Design a Better SQL Server Pricing Model ran on January 21, 2016 and as you can guess from the title is about the challenges we have with the current pricing model…and how we might improve it. Nothing simple about that, from our perspective or from that of Microsoft. Ultimately it… Read more

0 comments, 363 reads

Posted in SQLAndy on 1 February 2016

Call for Speakers for Orlando Code Camp 2016 Ends February 6, 2016

Quick reminder that the call for speakers for Orlando Code Camp is open through Feb 6 (next week!).

Read more

0 comments, 428 reads

Posted in SQLAndy on 29 January 2016

SSC Editorial: Turn Out the Lights

This ran a couple weeks ago (Turn Out The Lights) to see if I could spark a discussion about how/when/why we might think more about costs incurred by the way we provide solutions. Based on the follow-on discussion I didn’t quite achieve that. It reminds me that there… Read more

0 comments, 376 reads

Posted in SQLAndy on 29 January 2016

Newer posts

Older posts