Category Archives: SQL Saturday
Back In the Saddle Again
After spending a week at Paul Randal’s Immersion Event training, a week dedicated to standing up our new clusters, and then SQL Saturday this past weekend in Tampa, I am glad to get back to my SQL Servers. I missed them. Does anyone else ever feel like Gollum from Lord of the Rings, me neither. Now to get caught up on my various administrative duties that have queued up in the meantime. I am back in the saddle again!
I am going to be working on some blog posts for Best Practices this week after getting my new clusters all best practiced up! I am also working on some write ups for things I learned at SQL Saturday #110 in Tampa. I hope you enjoy!
Today is SQL Saturday Letdown Day!
SQL Saturday #110 in Tampa is in the books. Done. Finito. Over. The Sunday after SQL Saturday is the proverbial sugar crash for the weekend. What comes up must come down.
The build up for months of anticipation meets the pre-cons and then comes the big day SQL SATURDAY! Meeting all of the #SQLFamily, meeting local user group friends, meeting new peers and SQL rock stars makes for an excellent day, and oh yeah there was some amazing FREE training thrown in there, too.
Now we must face the reality: we have one year to wait until the next Tampa SQL Saturday! Well not really, as we are one of the lucky ones that has two events, our second one is for business intelligence held in the fall. And I won’t mention that we have one in Orlando in the late summer, early fall. Ok, I’ll admit that we are spoiled here, but I never get enough of these events.
I had planned this year to attend the events in Jacksonville and Atlanta, however I have exams on both of those weekends for one of my college courses. What a bummer! I may then have to expand out to South Florida or Pensacola to make up for the loss! See you there!
Enjoy!
We Interrupt This Regularly Scheduled Blog
We interrupt our regularly schedule blog, the SQL Saturday Schoolhouse, to bring you a blog live from SQL Saturday #110 from KForce in beautiful, historic Ybor City (aka Tampa). With around 350 registered attendees and several big name speakers flying in to our beautiful state, the excitement level was through the roof.
I have attended several great sessions today, learned a few new things, goofed off on twitter hoping to catch speakers with their twitter feed on, took my picture with a Lamborghini Countach, met a bunch of twitter friends in real life, remotely fixed a production systems administration problem, got some new laptop stickers, got some new pens, talked to some vendors about things that pain me in my daily world, ate some great Cuban food, saw SQLChicken rap like Vanilla Ice, created the blog world’s longest and most annoying string of disjointed phrases, and once again had a wonderful #SQLFamily day! I hope you too are taking advantage of this wonderful, FREE resource.
Enjoy!
SQL Saturday #110 Countdown
SQL Saturday #110 in Tampa is only a few days away…have you registered yet? Check out the schedule of speakers, especially if you have already setup your Guidebook app as there has been some minor shuffling over the last few days. There will be 35 great sessions and lunch is provided thanks to our great sponsors.
If you are interested in volunteering, please sign up now as your help is always appreciated. I look forward to seeing you there on Friday, if you are volunteering, and Saturday for some great #SQLAwesomeness!!
Enjoy!
SQL Saturday #110 – Tampa
We interrupt this episode on Sunday Funday to remind everyone that next Saturday, March 10th, is SQL Saturday #110 in Tampa. Over the last year, I have become a passionate proponent of attending SQL Saturdays working diligently to attend ones that are close to me. How can you pass up free training?
If you have not signed up to attend this SQL Saturday, then what are waiting for? Check out the schedule of sessions, as we have some pretty top-notch speakers. My biggest problem is that there are too many good sessions and inevitably, I miss a great one. That is a good problem to have! If you want to help out with this SQL Saturday, be sure to fill out the volunteer section of your registration. If you see me at SQL Saturday, feel free to say howdy!
Enjoy!
Personal Development Plan Part Dos….
Having posted yesterday about my Personal Development Plan, I read a blog post from Neil Hambly regarding his 2012 goals. Now, I realize that my goals were somewhat vague and easy to worm out of. Here are the goals that I had mentioned yesterday:
- I want to dedicate time everyday to this blog and giving back to the SQL community that has helped me so much over the years.
- I want to continue to dedicate time to the SQL community in social media.
- I want to attend at least ten events this year consisting of SQL Saturdays, training, code camps, and possible SQL Rally and/or SQL PASS.
Let’s revise those goals to the following:
- I will post daily to this blog in order to give back to the SQL community that has helped me so much over the years.
- I will spend time daily helping people on twitter, SQL blogs, and various SQL-related websites such as SQL Server Central.
- I am setting a goal of 300 followers on Twitter which would double my existing followers for 2011.
- I will attend at least ten of the twelve Tampa Bay SQL Server User Group meetings.
- I will atend three to five other SQL User group meetings, such as the Tampa BI group or Orlando’s MagicPASS.
- I will attend every Tampa VMWare User Group meetings which occur quarterly.
- I will attend other events that interface with SQL Server or VMWare such as the Orlando IT Pro Camp scheduled for January 21, 2012.
- I will attend one Microsoft SQL training course this year, but I cannot say at this time what that course will be as that will depend upon my employer ;-). I would like to attend Course 2778a (Writing Queries Using Microsoft SQL Server 2008 Transact-SQL) and Course 6234 (Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services.
- I will attend every SQL Saturday offered in the Orlando, Tampa, and Jacksonville areas. I would also like to attend some others, if possible, within driving distance. I am already registered for SQL Saturday #110 in Tampa on March 10, 2012.
- I will volunteer to help with at least one SQL Saturday this year.
- I would like to attend SQL Rally in Dallas this year and I would definitely like to attend the SQL PASS Summit, but with one child in college this year and two more entering over the next two years, I may have to pass on this one for a couple of years until they are situated and my bank account returns to normal.
- I will continue to take at least one to two classes a semester online in order to complete my degree in Business Administration. All those Engineering and Computer Science classes I took 20 years ago are not relevant today and I would like to possibly return to consulting in five or ten years and that degree would be more beneficial in that long term goal.
- I will continue SQLAndy’s recommendation to meet at least three people at every SQL event. This is a great recommendation for networking. It is hard sometimes to break out of our introverted ways.
- I will attain my VMWare Certified Professional 4 certificate this year for VMWare.
- I would like to speak somewhere this year, my local SSUG, VMUG, or even a training session at work. I need to get over my fear of public speaking. 2012 is the year to step it up and take it to another level.
I think this is an adequate list on my second day of contemplation, but I will review this over the next week or so to decide if it is exhaustive. Stay tuned and enjoy!
And so it begins…..
After attending SQLAndy’s SQL Saturday session on “Building a Professional Development Plan” a couple of months ago, I have been determined to develop my own Professional Development Plan. Over the next week or so, I will be formulating this plan here on this blog. At this point, I have a few goals for 2012 to begin the discussion.
- I want to dedicate time everyday to this blog and giving back to the SQL community that has helped me so much over the years.
- I want to continue to dedicate time to the SQL community in social media.
- I want to attend at least ten events this year consisting of SQL Saturdays, training, code camps, and possible SQL Rally and/or SQL PASS.
Stay tuned as we formulate this plan….
SQLSat86 Session Review: Andy Warren’s ‘Building a Professional Development Plan’
Before we begin, I must first admit that when I saw ‘Building a Professional Development Plan’ in the SQL Saturday 85 Schedule in Orlando back in September, I was not enthusiastic about attending this session as I thought it was more for consultants or for those looking to start their own business. Quite simply, I was thinking business plan and not individual plan. In hindsight, I wish I had attended this session back then, but I digress.
As most everyone knows, Andy Warren is the father of SQL Saturday and his status in the SQL community is legendary. With that being said I will now list the things that I learned from this session.
- Generally we do not like setting goals as there is an inherit risk of failure.
- The professional development plan, or PDP, is essentially your business plan as you are essentially a business with a plan.
- The PDP should be a pretty good mixture of growth items as well as technical items, such as:
- Formal Education
- Training
- Projects
- The PDP should have goals, milestones, as well as tasks necessary to accomplish these items.
- Questions you should ask yourself when developing the PDP include the following:
- Am I learning skills that only apply to my current job?
- What will be the next job that I search for?
- Will it be within my company?
- Am I being siloed into a narrow skill set in order to accomplish my existing responsibilities?
- If you are not being paid enough for your existing skill set then you are leaving money on the table.
- Where are you going and what do you want should be reflected in your PDP. What is the balance of the following items:
- More Money
- Stability
- Challenges
- Responsibility
- The following is a breakdown of the amount of time needed to reach different levels of success, how much are you willing to spend?
| 0-20 hours | No goal, no plan–Just work |
| 21-50 hours | Standard Maintenance |
| 51-100 hours | Slow growth, adding one skill |
| 101-200 hours | Serious investment |
| 200+ hours | Different focus / Hyper Growth |
- A Personal Development Plan should include the following:
- Networking, you should always try to meet three new people at each event or training.
- Writing / Communication skills
- Leadership / Management training
- Formal Education (or degree)
- Teaching / Presenting
- Professional Organizations / Events
- Blogging is important to your PDP for the following reasons:
- Networking
- It gives you practice writing
- It shows your level of consistency and follow through to future employers
- It shows that you participate in your profession
- You should keep up with new features for SQL Server. It is not possible to master all of the features but knowing what they are or do can be beneficial to your career.
I thoroughly enjoyed this session and will be developing my own Professional Development Plan before the end of the year. Thanks, Andy.
SQLSat86 Session Review: Adam Jorgensen’s “0 to SSAS”
The first session of the morning for me was Adam Jorgensen’s “0 to SSAS” presentation. Before this event, I had never had the privilege of attending one of Adam’s sessions and I do not work directly with SSAS, but his reputation as a good speaker enticed me to attend. Needless to say that I was not disappointed. Below are some random things that I learned from Adam:
- AS is the most powerful engine in the SQL Server line (designed to do table scans which would kill the DB engine)
- The Standard Edition for SQL Server is missing some of the AS functionality.
- AS uses BIDS aka Visual Studio with different project types
- AS works best with the STAR schema but might get the job done if your snowflake schema is not too diluted and you do not mind manually adding the dimensions.
- “Add related tables” will only find one level of relations which makes the STAR schema optimized for this.
- It was not said but I am guessing that the constellation schema would kill the engine 😉
SQLSat86 Session Review: Adam Jorgensen’s “0 to SSAS”
The first session of the morning for me was Adam Jorgensen’s “0 to SSAS” presentation. Before this event, I had never had the privilege of attending one of Adam’s sessions and I do not work directly with SSAS, but his reputation as a good speaker enticed me to attend. Needless to say that I was not disappointed. Below are some random things that I learned from Adam:
- AS is the most powerful engine in the SQL Server line (designed to do table scans which would kill the DB engine)
- The Standard Edition for SQL Server is missing some of the AS functionality.
- AS uses BIDS aka Visual Studio with different project types
- AS works best with the STAR schema but might get the job done if your snowflake schema is not too diluted and you do not mind manually adding the dimensions.
- “Add related tables” will only find one level of relations which makes the STAR schema optimized for this.
- It was not said but I am guessing that the constellation schema would kill the engine 😉
SQL Swampland 