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.

The Unusable User–Question Of The Day

My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for an incentive to give it a try? Here are the early stats, it’s definitely a hard question (or badly written? nah):

 

 

I’ll post follow up on… Read more

0 comments, 90 reads

Posted in SQLAndy on 26 March 2014

Notes From the Orlando Code Camp

  • Nice to have a SQL track! Looked like it averaged 20-25 attendance per session.
  • Ran smooth, thanks to Esteban Garcia and the volunteers from ONETUG
  • Had a couple great conversations about PCI and security after my presentation
  • Ran into quite a few people I know on the code side, reminds…

Read more

0 comments, 116 reads

Posted in SQLAndy on 24 March 2014

Notes From the March 2014 oPASS Meeting

  • Rodney Landrum presenting
  • Lots of free form demos, very light on slides – nice change
  • Looked at Power Pivot, Power Query, and Power Map
  • Pivot vs Query is confusing, when to use what? Query seems to support more data sources
  • Nice demo of pulling in SQLSaturday upcoming events from web…

Read more

0 comments, 86 reads

Posted in SQLAndy on 24 March 2014

Speaking At SQLSaturday #298 in Jacksonville on May 10, 2014

Got the email confirmation yesterday that I’m on the schedule – looking forward to being back in Jacksonville.

Read more

0 comments, 85 reads

Posted in SQLAndy on 24 March 2014

More On Alas Snapshot

Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than ran yesterday. Overall the comments on the question were positive, it was interesting (and intuitive I guess) to see that the detailed explanation of all the answers was appreciated. So… Read more

0 comments, 101 reads

Posted in SQLAndy on 21 March 2014

Meetings In Glass Houses

If you’ve followed my writing for a while you’ll know I’m a fan of translucency (transparency) in most things business. Right now I’m working next to a meeting room that has glass walls – talk about transparency! It seems like a good idea, it lets in a lot of light… Read more

0 comments, 100 reads

Posted in SQLAndy on 20 March 2014

Alas, Poor Snapshot, I Knew Him Well (Question Of the Day)

My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve got 5 minutes go give it a try and let me know what you think, with comments on the question or here.

Read more

0 comments, 90 reads

Posted in SQLAndy on 20 March 2014

Submitting PASS Summit Sessions

I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one be about PCI and security because I enjoy the topic and have some experience I’d like to share. Career planning is always interesting to me. As is mentoring, networking, SQLSaturday,… Read more

0 comments, 96 reads

Posted in SQLAndy on 19 March 2014

Why Am I Here? You’re On Retainer

That’s just one of about a hundred great lines from episode 1 of Farmed and Dangerous. A company with the initials of IFIB. The scene where the team is talking about the boss is good (listen for the remark about ticks). It’s free with a couple minutes of commercials… Read more

0 comments, 104 reads

Posted in SQLAndy on 19 March 2014

A Nicely Made Smoke Detector

This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a lot to installing any smoke detector, most have two screws that go into the ceiling and a cover that pops off so you can replace the 9v battery. Sounds easy… Read more

3 comments, 103 reads

Posted in SQLAndy on 19 March 2014

Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!

I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server track. Jason Carter will be speaking, as will Kendal Van Dyke, Max Trinidad, Richie Rump, Robert Biddle, and myself. Thirteen tracks of learning! Even if you… Read more

0 comments, 116 reads

Posted in SQLAndy on 18 March 2014

A Minute About Minute Key

You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let you make your own copies of common key types:

 

 

I tried it out over the weekend. Quick, painless, and if anything not very exciting to watch. I didn’t… Read more

0 comments, 88 reads

Posted in SQLAndy on 18 March 2014

Rodney Landrum Presenting at oPASS on March 20, 2014

Almost time for another meeting! This month Rodney Landrum is presenting Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL Servers:

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now…

Read more

0 comments, 88 reads

Posted in SQLAndy on 17 March 2014

Some Notes On Writing A Question Of The Day

I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest question, Schema Renaming Fun. I’ve got a couple more in the pipeline (The Unusable User,  and Alas Poor Snapshot, I Knew Him Well). Lessons learned/thought of so far:

  • Make…

Read more

0 comments, 100 reads

Posted in SQLAndy on 13 March 2014

You Broke My Tail Light

That’s the first thing I heard when I answered the phone recently. I was working on an change I needed to make, missed a call, called back (thinking it might be related to the change) and no one answered, then they called back again. It went something like this:

Me:…

Read more

0 comments, 101 reads

Posted in SQLAndy on 13 March 2014

Webinar Today at 3pm

I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s a good overview of some of the techniques that can be used for auditing. Much like disaster recovery options, there is quite an assortment of auditing/logging options in… Read more

0 comments, 94 reads

Posted in SQLAndy on 13 March 2014

Schema & Renaming Fun

I wrote the SQLServerCentral question of the day that is live today called Schema & Renaming Fun. Mildly interesting, but looking back at it a couple weeks after writing it not my favorite – feels a bit convoluted. If you read the comments (after trying to answer the question!),… Read more

0 comments, 95 reads

Posted in SQLAndy on 12 March 2014

Call For Speakers for SQLSaturday Houston (Before TechEd)

SQLSaturday returns to Houston this year, this time at San Jacinto College on May 10, 2014. That’s the Saturday just before Teched, so you can make a super week of it. I haven’t decided yet if I’ll attend, it turns out SQLSaturday Jacksonville is on the same day. Jacksonville… Read more

0 comments, 75 reads

Posted in SQLAndy on 11 March 2014

Don’t Park Your Vessel Here

I saw this sign recently, which at first glance is unremarkable, but I couldn’t help be amused at the inclusion of “vessels”. I’m in Florida so I suppose someone parking their boat on a trailer in the parking lot isn’t impossible, but somehow that doesn’t seem big enough… Read more

2 comments, 73 reads

Posted in SQLAndy on 11 March 2014

Look At The SQLSaturday Orlando Home Page

One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It does a lot of good work, but it’s not what I’d call great (and wow, is it better than v1 and v2!), but it does offset that weakness by allowing… Read more

0 comments, 91 reads

Posted in SQLAndy on 10 March 2014

Newer posts

Older posts