Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

Archives: June 2014

SSC Editorial: The Product Centric Career

The Product Centric Career is my latest editorial for SQLServerCentral, this one from the perspective of my own career and how I sort of made decisions that led me to focus on SQL Server.

Read more

0 comments, 179 reads

Posted in SQLAndy on 30 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 21

Been busy the past week, not as much time on this as I’d have liked:

  • Received the “retro” flyer with the minor revisions we requested
  • Decided flyers are final in design, just need to get them all into PDF
  • Had our first weekly call and talked about the tempo for…

Read more

0 comments, 225 reads

Posted in SQLAndy on 27 June 2014

What is 268435456?

What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for all that. Better than 50% getting it right, not bad for a Friday question!

 

Read more

0 comments, 254 reads

Posted in SQLAndy on 27 June 2014

The Great Escape-Question of The Day

The Great Escape is the question today, one I think you will like because…it’s about LIKE! It’s a head scratcher. The comments on this one so far have been really good and that’s good, I need to look for more arcane topics (LIKE is common, the ESCAPE part is not).… Read more

0 comments, 116 reads

Posted in SQLAndy on 25 June 2014

Speaking at the 2014 PASS Summit

Finally the email we’d all been waiting for arrived yesterday, the results of session selection for the 2014 PASS Summit. Good news for me, one session of mine was accepted, so I’ll be presenting “Turbocharge Your Career With A Learning Plan” this year. It’s a good topic and one I’m… Read more

2 comments, 138 reads

Posted in SQLAndy on 25 June 2014

Finding Checked Out Files in TFS

There may be an easier way, but this was a quick way to find ALL the checked out files in TFS, something I needed so I could make sure no one from the data team had anything checked out prior to some consolidation/maintenance. The “Developer Command Prompt for VS2012” resolves… Read more

0 comments, 163 reads

Posted in SQLAndy on 24 June 2014

No Files For You

No Files For You is another Question Of The Day. I ended up making this one just a little more ambiguous than I meant to, interesting to see the different takes on it in the comments. I’ll say again, reading that stuff, what a great way to learn about writing…

Read more

0 comments, 156 reads

Posted in SQLAndy on 24 June 2014

SSC Editorial: Bad Meetings or Meeting Badly

Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had done a better job on the title, because my intent (and execution) is to get attendees to see the other side of the coin on meeting requests. Take a look… Read more

0 comments, 148 reads

Posted in SQLAndy on 23 June 2014

Reading, Writing, and Riskmetic-Question of the Day

Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance while giving not giving them more access than needed. Great conversation that followed it, in particular read the comment here by Gail Shaw.

Read more

0 comments, 148 reads

Posted in SQLAndy on 23 June 2014

Poecilonym Madness-Question of the Day

Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part – there are six correct answers to this one, that should be enough to challenge you on a Friday!

Read more

0 comments, 181 reads

Posted in SQLAndy on 20 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 20

Next week will begin our weekly planning call, so ahead of that (and perhaps a bit later than I should have) I sent out my draft calendar and marketing plan. It was hard to let go, I really yearn for the detail of a full project plan, but that’s just… Read more

0 comments, 148 reads

Posted in SQLAndy on 19 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 19

Below is the chart Kendal Van Dyke maintains for us in Orlando showing year over year registration counts. Don’t I wish this was baked in to the admin tools! You can see the trend has been remarkably consistent over the years (and we see the same with PASS Summit registrations,… Read more

0 comments, 125 reads

Posted in SQLAndy on 19 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 18

I’m on vacation this week, but enjoying some quiet time during the day to think a little, going back through my first 17 posts and wishing I had them printed – sometimes marking up a document is good for thinking!

First, a recap of key items on the task list… Read more

0 comments, 172 reads

Posted in SQLAndy on 17 June 2014

SSC Editorial: Kitchen Duty

I try to find good stories for editorials at SQLServerCentral and the one this week about Kitchen Duty seems to have resonated more than most. Take a look when you have a minute.

Read more

0 comments, 161 reads

Posted in SQLAndy on 17 June 2014

Notes From SQLSaturday South Florida

Notes from the trip:

  • Four hour drive between traffic and rain, about an hour longer than I would have liked. The new service plaza at Fort Drum on the Turnpike is nice, but I thought the old model had better/easier parking. Ah well.
  • Speaker dinner was at Carrabas. Not a…

Read more

0 comments, 111 reads

Posted in SQLAndy on 16 June 2014

I Gotta See the Code–Question of the Day

I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if you get figure out all the correct answers! So far it’s working out to be a hard question, only 17% getting all of them.

 

Read more

0 comments, 180 reads

Posted in SQLAndy on 16 June 2014

Reflections On Fathers Day

Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to think a little on being a father. Thinking about the gleeful giggle of my oldest daughter when you she sees through my tricks and the devious and delightful cackle of… Read more

0 comments, 119 reads

Posted in SQLAndy on 16 June 2014

SQL Saturday South Florida And Then Vacation

I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed the last two years due to scheduling conflicts with my vacation, this year I made things easier and scheduled my vacation to coincide! I’m on vacation all of the following… Read more

0 comments, 163 reads

Posted in SQLAndy on 13 June 2014

SSIS Lessons Learned, Or Not, And Mistakes Beginners Make

It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since I went through the SSIS class that Brian Knight taught back when we were in the training business together. Recently I had a chance to take on a small project… Read more

0 comments, 258 reads

Posted in SQLAndy on 12 June 2014

Giving Away Woodworking Magazines

I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a de-clutter kick and part of that is a trimming down a big stack of wood working magazines. I sent some to a friend, and was thinking to drop the rest… Read more

4 comments, 227 reads

Posted in SQLAndy on 12 June 2014

Older posts