-->
SQL Clone
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.

The Future of the SQLSaturday Tools

Every year when many of the SQLSaturday event leaders meet at the Summit the topic of improvements to the tools comes up. Certainly the site has seen changes  and improvements over the years,  plus at least two new coats of paint (on the public site), but it’s never enough (with… Read more

0 comments, 160 reads

Posted in SQLAndy on 8 November 2017

Notes on the 2017 PASS Summit

Just a few notes:

  • Weather on Wed was great, ok on Thurs, cold on Fri. Have had worse years!
  • Felt like I saw fewer people this year (that I knew), in part due to arriving Wed after lunch and in part to many of them skipping the event due to…

Read more

0 comments, 149 reads

Posted in SQLAndy on 8 November 2017

Monday Night Networking Dinner 2017

It’s on! Free registration at EventBrite.

I wrote last month about not being able to make it to Seattle on Monday to help organize the annual Networking Dinner. Good news though, Lisa Bohm has volunteered to organize the event this year. It will be held at Yard House,… Read more

0 comments, 154 reads

Posted in SQLAndy on 29 October 2017

SQLSaturday Orlando 2017 Notes – Part 3

This year we held our fourth Student to IT Pro Seminar for the students at Seminole State College. It runs from 9 am to 1130, concurrent with SQLSaturday but in a different building. Here is the schedule from this year:

Time Description
 8:30 to 9:00  Check-in & Informal Networking
 9:00…

Read more

0 comments, 169 reads

Posted in SQLAndy on 22 October 2017

SQLSaturday Orlando 2017 Notes – Part 2

SQLSaturday is really three sites. The public facing one (www) plus one for event admins and one for HQ to do overall admin. Most of the notes in this post apply to the site for event admins. These are all from my perspective which is biased in a few ways;… Read more

0 comments, 151 reads

Posted in SQLAndy on 22 October 2017

SQLSaturday Orlando 2017 Notes – Part 1

Part 1 will be about things we did (or didn’t) do and some lessons learned. In Part 2 I will share some thoughts on the SQLSaturday tools/web site. Part 3 isn’t really about SQLSaturday, rather our student seminar that we run concurrently. I’ll get to Part 2 and 3 as… Read more

0 comments, 167 reads

Posted in SQLAndy on 19 October 2017

Non Profit Umbrella Org – Good Idea?

Note: Published too soon, so lots of edits from the first version. Sorry for any confusion.

I had a question from my earlier post about SQLOrlando with regards to setting up an umbrella organization, basically asking “instead of each Chapter doing all this work, why not have one org?”. Great… Read more

2 comments, 932 reads

Posted in SQLAndy on 14 October 2017

More Notes on Non Profit Status

Following up on my post about forming a non profit here in Orlando, here are some notes that might help you get through the process a little faster:

  1. In the corporate filing for the state, use the IRS recommended language: Said corporation is organized exclusively for charitable, religious, educational, and…

Read more

0 comments, 198 reads

Posted in SQLAndy on 14 October 2017

SpeedPASS Download Naming Convention

This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was surprised/dismayed to see that when I unzipped the download the filenames were all named with a less than helpful format; b9d73479-5a04-42a3-9f11-a56af7b56beb.pdf. The goal was to be able to quickly find… Read more

2 comments, 1,229 reads

Posted in SQLAndy on 9 October 2017

SQLOrlando

We’ve haven’t had a good solution for managing money for SQLSaturday and our groups here in Orlando. In the early days I’d put the money in my business account, keep the receipts, figure out what was left to accrue for the next year, and let the accountant do the rest.… Read more

3 comments, 160 reads

Posted in SQLAndy on 12 September 2017

PASS Travel Plans, Halloween, Networking Dinner, SQL Dinner & Game Night

Normally I fly out Monday to spend the week at PASS. It’s good to get there early to adjust to the time change, I like to attend the meetings on Tuesday, and of course Monday night is the networking party that Steve Jones & I have organized the last few… Read more

2 comments, 278 reads

Posted in SQLAndy on 10 September 2017

SQLSaturday Orlando 2017 Goes Live

Today we’re starting on our 11th SQLSaturday here in Orlando. Normally we rotate the leadership between oPASS and MagicPASS, but this year is a bit of change – I’ll be leading this year instead of just contributing. It’s a chance for Shawn and Kendal to take a year breather and… Read more

0 comments, 274 reads

Posted in SQLAndy on 5 June 2017

Changing the SQLSaturday Logo?

I read with interest the post from Bob Pusateri that discusses what seems to be the next iteration of the SQLSaturday logo. Informative, calm, and I thought had quite a few valid points. I don’t know that I can be as logical or as calm!

Logically, I’d add to the… Read more

0 comments, 234 reads

Posted in SQLAndy on 17 April 2017

Reviewing the 2016 PASS Audited Financials

Notes on items I found interesting in the financial statement, recommend you download and read the entire document.

  • Global Alliance Partner (GAP) dues decreased from $103k to $65k. This doesn’t seem like a lot of money either way, is this program successful?
  • It looks like we lost $40k in…

Read more

0 comments, 220 reads

Posted in SQLAndy on 10 April 2017

Murder Data

The Murder Accountability Project is worth a look. It’s a reminder that gathering good data is hard, but once you have the data you can do interesting things – like identify serial killings. The site says 220,000 unsolved homicides in the US since 1980. A big number, but not big… Read more

0 comments, 307 reads

Posted in SQLAndy on 6 April 2017

ADO Connection Resiliency

It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection string to enable retries on connections that were established (in the connection pool) but have since failed. I suspect many apps will cover this in the code that handles… Read more

0 comments, 279 reads

Posted in SQLAndy on 5 April 2017

Only as Good as Your Auditor

I wrote Only as Good as Your Auditor for SQLServerCentral because its something I’ve explained to people over and over again. For most of us in IT audits are something we tolerate and try to get done as quickly as we can, a test to pass, and because of that… Read more

0 comments, 332 reads

Posted in SQLAndy on 4 April 2017

How to Become a SQL Server Database Administrator

I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project for Idera, one that I still point people to when they show an interest in the career path. I wish there more of these out there. It would… Read more

4 comments, 307 reads

Posted in SQLAndy on 3 April 2017

April Fools 2017

Each year I try to something fun for April 1st, though it’s hard to do well. Trying to be funny without crossing any of the many lines we should respect isn’t the easiest thing. Probably the easy target is self – least likely to complain! Still, sometimes there are general… Read more

0 comments, 315 reads

Posted in SQLAndy on 1 April 2017

Why I’m Changing to MySQLAndy

From time to time we all have to examine our path and decide if we need to make adjustments. Looking at the market, I found a lot of reasons why now is the right time to switch to mySQL. Here’s the top five:

5. I’m going to have to learn… Read more

0 comments, 260 reads

Posted in SQLAndy on 1 April 2017

Older posts