RSS

[SQL Snacks Video] Performance Tuning 103 – T-Logs and VLFs


Finally the arrival of Part 3 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. The first video was about performing a baseline using the PAL tool.I would highly recommend you review that video as well as my SQL Snack on Instant File Initialization. Also, if you missed part two from yesterday you can review it here.

If you are still interested in learning more about Performance tuning with SQL Server, I will be giving an hour long presentation with the PASS DBA Fundamentals Virtual Chapter on January 6, 2015 (11 am Central Time/Noon Eastern Time).  For more information please visit http://dbafundamentals.sqlpass.org/ and join PASS for a great way to learn more about SQL Server.

Code from Demo below:

Read the rest of this entry »

 

Tags: , , , , , ,

[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB

[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB

Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. The first video was about performing a baseline using the PAL tool.I would highly recommend you review that video as well as my SQL Snack on Instant File Initialization. This second video discusses the importance of properly sizing Data files, placement, and how the Proportional Fill-Algorithm works for data insertion. I’m hoping you get some last minute Performance tuning in before 2015 and so I will be posting the third video within the next 24 hours.

Code from Demo below:

Read the rest of this entry »

 

Tags: , , , , , ,

PASS Summit 2014 – It’s not you, it’s me

PASS Summit 2014 – It’s not you, it’s me

After an exciting week at the PASS Summit, I’m back home with my family.  This was my first ever PASS Summit and instead of writing about what was good or what was bad, I’ve decided to write about what I did and did not do and what I think I did right and what I can improve for my next Summit.  I’m also talking about my observations in general and some tips for those planning to attend next year. I hope that this serves as an inspiration to other attendees and non-attendees a like, I really did enjoy my time and gained a lot of insight while there.

Read the rest of this entry »

 
7 Comments

Posted by on November 10, 2014 in Other

 

Tags:

Bon Voyage fellow PASS Summit 2014 Attendees!

Bon Voyage fellow PASS Summit 2014 Attendees!

For the first time ever, I will be a PASS Summit Attendee! I’m very excited about going and I’ll be flying out tomorrow afternoon to attend a Pre-Con tomorrow.  If you would like to connect and meet while I’m there please feel free to Tweet out to me @TheSQLPro. That’s the fastest and easiest way to connect while there.  Safe travels to everyone and I hope to meet a lot of people at the PASS Summit this year. If you’re looking for some tips on what to do and take at the Summit watch this informative and entertaining video from Brent Ozar’s team.

See you there!

 
1 Comment

Posted by on November 2, 2014 in Other

 

Tags:

[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:

 
Follow

Get every new post delivered to your Inbox.

Join 1,043 other followers

%d bloggers like this: