SQL Server, Power BI, and other Business Intelligence and data technologies

Tag: SQL Server (Page 4 of 4)

The Road to SQL Server Certification – Part 1: Introduction

The Road to SQL Server Certification – Part 1: Introduction

Having been a part of the IT industry for a good 12 years now, I’m no stranger to certifications.  There are countless debates on the Internet over the value of certifications.  My stance tends to be that as long as you actually earn them, getting them is better than not getting them.  As such, over the years, I’ve taken, passed, and failed a number of certification exams from various vendors.

To me, certification is an excuse to learn a topic.  You may say to yourself “you know, I really enjoyed restoring that corrupt database last week, I want to learn more about SQL Server” or “I really enjoyed troubleshooting that mail delivery issue yesterday.  I’d love to learn more about Exchange server!”  Even if you don’t place a lot of value in the piece of paper you receive from completing a certification track, the exam prep materials provide a great structure for learning a topic from end-to-end and the exam itself provides the motivation to do so in a structured and timely manner.

Over the course of my career so far I’d estimate I’ve sat close to 30 unique proctored certification exams (many certifications require multiple exams to attain).  I make a distinction between proctored and non-proctored exams as you typically have to pay an exam fee to take a proctored exam at a testing center whereas a non-proctored exam may or may not be free and is typically taken in the comfort of your own home where you are free to Google answers or phone a friend.

In the beginning of my career, these exams tended to be for entry level certifications (such as CompTIA’s A+ or Cisco’s CCNA (which was their entry level certification at the time)) and over time I progressed on to higher tier certifications.  These days, most of the exams I sit tend to be of an upgrade nature to upgrade technologies, example upgrading my Microsoft MCSE 2003 to the 2008 equivalent or upgrading VMware VCP4 to VMware VCP5.

Around July of 2012, I decided to start a new certification journey:  MCSA: SQL Server 2012.  While this journey shouldn’t be an insanely long one (like the old MCSE 2003: Security which was a total of 7 exams!), it was a fairly new concept for me as previously all of my certification had been around operating systems and networking devices — this three-exam series would be my first single application/development themed series.  A new challenge indeed!

One great motivator on embarking upon this journey was a promotion Microsoft was running at the time:  Second Shot.  As it turns out, they’ve just started re-running the promotion again with new expiration dates.  The promotion is pretty simple.  You sign up for a free voucher code and register for your exam with that code.  Should you fail the exam, you get to retake it (within the promotion period, which is usually about a year) once at no additional cost.  Additionally, they offer a second deal (which is the one that I took advantage of) if you’re willing to pay for an entire exam series up front, such as the 3-exam MCSA SQL 2012 series.  By making this commitment, you receive:  a second-shot for each of the three exams in the series, 15% off each exam fee, and an extra 6 months in the promotion period to get it done (bringing it up to about a year and a half).  A great deal!

In my next post, I’ll give an update as to where I am so far along this latest certification journey (I’m not done yet, but time is running out and I’m close!) as well as some thoughts on the individual exams and experiences themselves, and finally I’ll cover some of the preparation tools and strategies which have worked well for me along the journey.  Stay tuned!

[ Go forward to Part 2 ]

PASS Summit 2013 Roundup — The Adventures of a First Timer

PASS Summit 2013 Roundup — The Adventures of a First Timer

Wow, what a ride.  For the past year, attending various SQL Saturday and other events, I’ve heard the whisperings of PASS Summit in sessions and hallways.  This past week, it finally arrived and at last I had the opportunity to attend my first PASS Summit.

The whispers couldn’t possibly prepare me for what a truly amazing and motivational experience it was!  Summit was a non-stop week of connecting, learning, and sharing combined with a lot of fun and #sqlfamily that can only be rivaled by future summits (since all of my fellow first timers which I spoke to are now also completely hooked on the event)

I registered for PASS Summit 2013 all the way back in December of 2012.  It’s a bit of a gamble that something won’t come up when you register nearly a year in advance, but by registering that early, you can get some pretty deep discounts on Early Bird registration.  Plus, since you’re now invested, you can build anticipation and look forward to the event for almost an entire year!  Early Bird Registration for 2014 goes until December 6th this year, so I’ll probably do the same again.

Monday– Prep!  I took the day off from work to get things done before heading out of town for the week.  I’d heard from multiple people that you don’t sleep during Summit, so I planned to head to bed early so I’d start the week well rested.  I finished packing and went to bed a little after 1 am.  Whoops, so much for that.

Tuesday – I got up bright and early to begin my drive from Duluth, GA to Charlotte.  My goal was to arrive in Charlotte just early enough to get parked and checked in in time for the First Timer’s “Get to Know Your Community” meeting.  I planned to hit a couple of notable geocaches along the way, making for a longer but leisurely drive.

Ultimately, I took a bit too long on the drive up and I missed the First Timers “Get to Know Your Community” session, but I made it just in time for the First Timers Orientation session.  The orientation session was great and I was very happy to see so many well-known vets (sporting their stylish propeller beanies) in the crowd supporting us first timers.

Continue reading

Preparing for PASS Summit 2013 — My First Time!

Preparing for PASS Summit 2013 — My First Time!

Being a regular attendee of SQL Saturday events in the Southeast, I frequently hear murmurs of PASS Summit and what a great thing it is.

With a little bit of luck it turns out that this year, for the first time in years its being held outside its usual home in Seattle, WA in the not-too-distant city of Charlotte, NC.  Seems like a sign to me!

PASS Summit is a BIG conference!  As such, there are a lot of moving parts in order to get prepared.  The PASS Connect page offers a great “one-stop” link resource for many of the major items:

Continue reading

T-SQL Date Dimensions with ConnectWise

T-SQL Date Dimensions with ConnectWise PSA

ConnectWise PSA is a Microsoft SQL Server OLTP-based application commonly used by IT Managed Services Providers for managing their businesses.  ConnectWise provides a mechanism for entering and storing service tickets, time worked by technicians on service tickets, sales items, client billing, and other finance information.  For any Managed Services Provider, it tends to be the heart of the business.

A Date Dimension is a concept typically used in a Data Warehouse for implementing Time Intelligence which allows for querying on say “year to date” or for the quarter.  A Date Dimension is created through the creation of a Date Table.  A Date Table is a table which contains every date for a time period (with no gaps within) and numerous properties for each date.  Some of the most common properties are:

  • The Date, as a DATE or DATETIME
  • The DateKey, which is an INT that shows the date in YYYYMMDD form
  • Whether or not the date is a work day or not
  • Numerous date parts of the date, such as the month number, month name, day of the week, week number, quarter, year, and many more.
While the exact fields which make up the date table will vary based on the needs of the business, the above items tend to be some of the most common.

Continue reading

Newer posts »

© 2026 Jeff Pries

Theme by Anders NorenUp ↑