RSS

[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools

[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools

Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. This first video describes how to setup a baseline for your system using the PAL tools. It is essential to get a baseline before you start performance tuning so that you can determine how effective the efforts done in trying to tune your SQL Server have been.  The PAL tools at first look a little intimidating but they are really very easy to use and extremely helpful for performance analysis. Enjoy and happy baselining!

A special thanks to Edgardo Valdez for showing me the how to use this tool.

Link to download PAL Tools and Prerequisites: https://pal.codeplex.com/

 

Tags: , , , , , ,

Dear IT Guy, Customer Service is part of your job

Dear IT Guy, Customer Service is part of your job

It may be true that you are one of a kind, a true techie with specialized skills that are hard to find and hire for. One thing that is more true is that customer service is still very much a big part of your job. Which equates to the fact that you need to start working better with your peers internally and your clients on the external side of things.

Technology comes and goes. I believe it was Steve Jobs that said something to the effect of “we are all layers of this large sedimentary rock.” Gordon Moore predicted that computing power would double every 18 months and in a world where we have reached some of the physical limits of CPU clock speeds, that concept is no longer as applicable. If CPU fabricators such as Intel and AMD had seen this as the absolute truth in CPU development, then we may not have gotten the wonderful multi-core chips we have today.  And to that effect, a legend’s theory in the computing world has been superseded by a new technological advancement so what about you and I? One of the most important parts of our career is our own personal brands.

Our brand drives people to approach us to solve problems.  It drives people to want to connect with us and include us on a personal and professional level.  It makes us stand out among our peers and it makes us one of those distinguished people in an organization that everyone has something good to talk about.  That brand, is not just about what you know, but also about how to treat others. Your customer service is what makes your brand shine.  Sure, you could be a brilliant DBA, Sys Admin, or whatever else you aspire to be (note DBAs are awesome!). However, if people don’t like your attitude and how you deal with them on a personal level, they will be reluctant to reach out to you for more work.  They will be reluctant to reach out to your boss with great feedback.  It’s just the nature of how we are as humans.  When was the last time you had a terrible experience at a store or a restaurant and you said to yourself “I’m definitely going back there, I love having a poor experience it makes my day”? The answer is probably never. In reality, this maybe how your colleagues view you at work.

Read the rest of this entry »

 
Leave a comment

Posted by on September 4, 2014 in Other

 

Tags:

Dear IT Guy, Why do you hesitate to attend my meetings?

Dear IT Guy, Why do you hesitate to attend my meetings?

I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT geeky guys and gals don’t like to attend meetings, and deal with people etc.  This was her opinion based on her 20 year career in IT, and even as a technical person who has successfully found her way into great leadership roles. I respected her outlook, and I gave her a little bit of my own outlook based on my experience which I will share with you.

First let me mention what I discussed with my colleague. Personally, I don’t mind attending meetings to much, I’m quite a social butterfly actually (outgoing, extraverted, “i” in the DiSC assessment, etc). So I’m not the stereotypical IT guy that is depicted in movies or that people have grown accustomed to describing to their therapist when talking about people that make them feel bad at work.  Just a side note, I’m totally kidding with these sterotypes, I’ve loved the people I’ve worked with in IT and I don’t think I would pick any other field.  Anyway, back on topic, I don’t like attending meetings with some non-technical folks for a variety of reasons that I will list below:

    Read the rest of this entry »
 
Leave a comment

Posted by on August 28, 2014 in Other

 

Tags:

The Good the Bad and the Ugly of my extended job search

The Good the Bad and the Ugly of my extended job search

Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my interview experience over the last two years starting in the Summer of 2012.  I have left out the company names out purposely because this is not a post to damage any reputations or for me to express my bitterness in.  Rather, this post is to help future job seekers in getting a great position and not falling into a job that they could potentially hate. Also, it is noteworthy to mention that during my own interviewing journey I was also a hiring manager doing interviews to fill a position that reported directly to me. So I will be giving my advice based on both the perspective of a job seeker and hiring manager. The stories are roughly divided up by paragraph and I’ve provided a small summary of points below the stories in case you just want to skip ahead to the advice and not bother with my stories. I won’t be hurt or upset I promise :)

Read the rest of this entry »

 
15 Comments

Posted by on August 25, 2014 in Other, Uncategorized

 

Tags:

SQL Saturday 294 Philadelphia Lessons Learned


Being in Philadelphia this past weekend was fantastic! I got to meet a lot of old friends, spend time with family, and make new friends in the SQL world.  This SQL Saturday was especially important for me since I lived in the Philly area for almost 10 years.  I got to reconnect with my colleagues from Johnson Matthey out in the Wayne PA area and pass by my old desk where it all started.  It is especially hard to get started this morning since I really do miss the great experience I had around this SQL Saturday.

Read the rest of this entry »

 
Leave a comment

Posted by on June 9, 2014 in Presentations

 

Tags:

SQL Saturday 294 Philadelphia, Nostalgic!

SQL Saturday 294 Philadelphia, Nostalgic!

Less than a week left and I’m extremely excited about SQL Saturday in Philly on June 7th, 2014 and the Precon the day before (I signed up for Allan Hirt’s).  I lived in Philadelphia for about 10 years during which I went to college, had my first two full-time jobs, and my first to kids were born in that area. This SQL Saturday is going to be a blast from the past for me.  The actual event takes place in Malvern PA which is off of 202 in the Northwestern Region of the Philadelphia suburbs.  It is part of the “mainline” and close to Valley Forge, King of Prussia and other historic/tourist attractions.  I used to work in the Mainline area for Johnson Matthey in Wayne (and part time in Malvern) so I’m very excited about taking this trip back to visit friends and family.

For those of you that don’t know about SQL Saturday it is a fantastic event. Here are some of the reasons I’ve encouraged people to attend SQL Saturday events:

Read the rest of this entry »

 

Tags: , , , , ,

[SQL Snacks Video] SQL Server Table Partitioning 103

[SQL Snacks Video] SQL Server Table Partitioning 103

Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two videos, I would highly encourage you to do so.

Read the rest of this entry »

 

Tags: , , , , , , , , ,

 
Follow

Get every new post delivered to your Inbox.

Join 911 other followers

%d bloggers like this: