Posts Tagged ‘Performance’

Free Training for You, Punishing Workload for Me. Thank You for Enjoying My Misery.

Tuesday, February 9th, 2010

Everybody Needs Training

Everybody enjoys a little free training now and then.  I’ve got mountains of free training in the works.  Some of it is in-person and local while some are in webcast format.  Please join me as you’re able!

Tomorrow – Wednesday!

Wed, Feb 10, 2010 at 12 pm (noon) MST – PASS DBA Virtual Chapter; Top 10 Administration Mistakes on SQL Server

There are a short list of mistakes that, if you know of them in advance and prepare for them, will make your life much easier.  This presentation shows you these mistakes, the “low hanging fruit” of database administration.  Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.  Quest is sponsoring this and raffling off a copy of my book, SQL in a Nutshell, and O-M-G a KINDLE!!!  (Free, but registration required.)  And if you haven’t already done it, join PASS!

Day After Tomorrow – Thursday!

Thu, Feb 11, 2010 at 11 am EST – Quest Software Pain of the Week; Understanding & Preventing SQL Injection Attacks – with Kevin Kline and K. Brian Kelley

SQL Injection attacks is the most common hacker trick used on the Web and yet, one of the easiest to prevent. Learn what they are and why you need to be concerned about them. In this webcast, I and SQL Server MVP K. Brian Kelley (blog | twitter) will demonstrate different types of SQL injection attacks. You’ll learn how to find and block them to keep your databases safe, preventing disruptions to your organization. Quest is sponsoring this as well and raffling off more goodies.  (Free, but registration required.)

Thu, Feb 11, 2010 at 6 pm CST – Nashville .NET User Group; Ten Things DBAs Want .NET Developers to Know

Stereotypes abound for different types of people in the IT world. Developers think DBAs are control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences? If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your competence and credibility. Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration. Techniques include how to analyze a query plan and how to make sure your query is taking advantage of the best available indexes.  Attendance is free although registration is encouraged so we can get a good count for the food, plus there’s free pizza and a raffle at the end.  Drinks afterwards at Chilis.

Coming Soon

Mar 03, 2010 >>>FULL DAY OF FREE TRAINING!<<< – Quest Software SQL Server vConference; Troubleshooting and Performance Tuning with Kevin Kline, Brent Ozar, and Ariel Weil

Join SQL Server MVPs, Kevin Kline and Brent Ozar (blog | twitter), along with Quest Product Manager Ari Weil —all from Quest Software—as they interactively present tips and tricks to help you monitor your SQL Server environment with ease. You’ll learn how to use Dynamic Management Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance. The day consists of eight sessions with live Q&A – a great way to get answers to your questions straight from the source. Chat live with Quest experts. Plus, you can visit the Quest booth to download helpful resources like white papers, watch demos and more.  This virtual training day is free and you can attend the sessions that fit your needs – perfect for tight budgets and busy schedules.

Mar 06, 2010 – PASS SQL Saturday, Charlotte, SC

The SQL Server Community will experience an event like no other in the Southeast region. Renowned speakers from around the world will gather in Charlotte, NC to share their knowledge on Microsoft SQL Server. This is your opportunity to meet, network with and learn from the SQL Community leading experts such as Andrew Kelly, Rick Heiges, John Welch, Brian Knight, Geoff Hiten, Andy Warren, Jessica M. Moss, Rafael Salas, Sergey Pustovit and Tim Ford. Also scheduled to present are current SQL PASS President Rushabh Mehta and former SQL PASS Presidents Wayne Snyder and Kevin Kline.

Mar 24, 2010 – PASS DBA Virtual Chapter; SQL Internals & Architecture

Apr 08, 2010 – Quest Software Pain of the Week; The Admin’s Guide to SQL Server w/ Buck Woody

Apr 12, 2010 – PASS Chapter, Houston; topic TBD

Apr 17, 2010 – PASS SQL Saturday, Chicago; Keynoting w/ Brent Ozar

May 13, 2010 – Quest Software Pain of the Week; SQL Server for the Oracle DBA w/ Buck Woody

May 13, 2010 – PASS Chapter, Louisville; topic TBD

May 15, 2010 – PASS SQL Saturday, Louisville; topic TBD

May 22, 2010 – Indy Tech Fest; SQL Internals & Architecture

2009: The Year in List Form

Tuesday, January 5th, 2010

Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock (blog | twitter), I decided I’d spend a few minutes looking back on both the year 2009. (From a personal standpoint, the 00’s were my most difficult decade yet.  Major problems of every stripe beset me on all sides and with alarming frequency throughout the decade.  I was all “Good Riddance” and “Don’t let the door hit y’ass on the way out, 2009!” as the ball dropped in Times Square.)

Rather than spend a lot of time cooking up my own top 10 lists, I reckoned (that’s Southern for “thought”, btw) I’d recap a few others top X lists that are in the ballpark of my own personal opinion.  I couldn’t resist putting together my own list at the end, which I’d love to hear your thoughts on.  In addition, I want to hear about your Top 10 (or 5 or 3) for 2009!

Their Lists

Time Magazine’s list of Top 10 of Everything 2009 was a pretty good recap for the year on big ol’ cultural touch points like movies and music.  I found at least one thing to agree with in each of their pop culture lists:  movies – The Hurt Locker – check;  TV shows – my personal favorite for its brilliant cohesive multiyear storyline and excellent character studies, Lost – check; album – I and Love and You by the Avett Brothers – check; books (sigh – if only I had more time) included the wonderful The Age of Wonders by Richard Holmes.

Lifehacker’s Top 5 Hive Topics of 2009 is a very interesting list covering lots of topics and pointing out a lot of interesting tools that I hadn’t encountered before.  My personal favorite among them was the Top 5 Alternative File Copiers, since the Windows Explorer copy feature reminds me of hungrily awaiting my food in the microwave and just as the counter gets to the T-10 countdown, it goes back up to 30, then down to 8, then back up to 42, then down to 14.

I’m not sure if they meant to be funny but Digg’s Top 10 Most Popular Stories of 2009 is hilarious, much in the same way that Brent Ozar (blog | twitter) and I were when we put on an unintentionally hilarious performance at the PASS 2009 Summit Quiz bowl.  Go ahead – ask Colin Stasiuk (blog | twitter) what he thought of our performance…

Impressed by Our Quiz Bowl Performance?

Impressed by Our Quiz Bowl Performance?

Speaking of unintentionally funny, have you seen Yahoo’s Top 10 Searches of 2009?  Evidently, the median Internet user (at least from their metrics) is hormone-laden, teenage redneck with a thing for fast cars (Nascar), Hollywood hotties (Megan Fox), and an unassailable but secret love for Mormon-influenced Vampires (Twilight).

My List

I usually try to blog at least once per week and, when I can, even more.  I still have this deep down urge to post lots of small blog posts of just a couple paragraphs.  But for some reason, I always seem to come out with these big ol’ epistles.  Despite my verbosity, y’all still read what I write and for that I’m very thankful.  Over the last year, these were my top ten blog posts according to your interest:

  1. Best of the [SQL Server] Blogs and its sister post Great Blogs from the Microsoft SQL Server Teams, also my number one spam generators.  Ever spammer on the planet seems to want their comment appended here.
  2. Microsoft Resources Too Good Not to Share, which I can’t honestly remember if they were any good or not.  But I bet they were.
  3. Are We There Yet, Mom? in which I flashback to my childhood road trip experiences when considering Microsoft’s overall product strategy.
  4. Does the Down Economy Have an Impact on Your Job, cuz it sure punched mine in the mouth.
  5. Why Do I Keep Seeing This Mistake, in which I learn that “Hello World” type applications can lead to massive misunderstandings.
  6. Microsoft [Corporate] Marketing Throws SQL Server Under the Bus.  We can’t get no respect, not even from corporate HQ.
  7. Looking for Good DMV Database Admin Queries, where you can find just about every good DMV query ever written except those other really good ones that are posted here in the comments.
  8. Old Performance Recommendations Die Hard, and when I saw “die hard” I don’t mean like Bruce Willis.
  9. Things You Know Now, a semi-successful meme I started where I asked participants to tells us about stuff they’d do differently if they knew it way back in the day.
  10. Understanding SQLIOSim Output, because no one seems to fully understand this tool, including me.

I excluded a few posts that were numerically in the top ten because, well, they’re my blog posts and I didn’t want them in the top ten.  So there!  But those that I excluded were things like reposting an interview done by another blogger or maybe a product or book that I plugged for some reason or an other.

I hope you’ve enjoyed my blogging and found it valuable.  Tomorrow, I’m jumping on the themeword and goals meme.  In fact, I’m crashin’ the party because none of my peeps called on me.  [pout]

Be well!

-Kevin

Twitter @KEKline

Sequels for SQL: Dec 17, 2009

Thursday, December 17th, 2009

In the Sequels for SQL series, I point you to sites where you can go beyond the nose-to-the-grindstone resources that we see every day as SQL Server professionals.  (My favorite resource for pan-SQL Server pointers is Steve Jone’s Database Weekly email newsletter.)  These are the story that comes after and outside (the sequels) of our daily working lives (the other SQL).  Let’s broaden our horizons together.  If you hit on an interesting but overlooked topic, I’d like to hear from you.

SQL Server: We live it.  We love it.

When Jimmy May talks, I listen.  Not just because he’s a personal friend, but also because he knows what’s what, if you’ll pardon the expression.  So when Jimmy says “I believe xPerf will fundamentally change the way I do my job”, then I want to know what the heck this free xPerf management tool is and how I can best leverage it.  Check out Jimmy’s blog entry on xPerf here.

Devices & Gadgets: Usually making our lives better, sometimes not so much.

Ever wonder what’s inside one of those tiny USB hard drives?  No?  Not even a little bit?!?  When I started in IT, hard drives where as big as washing machines and cost $60,000 running at speeds in the 100’s of RPMs.  My how times have changed.  Here’s a fun hack of a USB hard drive – http://www.dansworkshop.com/electricity-and-electronics/usb-hard-drive-hack.htm.

Futurewatch: Important issues just over the horizon.

There are a lot of standard elements of society being rebranded as the “2.0″ version of itself.  The 2.0 moniker was first put forward by visionary Tim O’Reilly (blog | twitter), of the eponymous media company. Whenever you see the 2.0 moniker added to the end of something, most famously Web 2.0, then you know that it will include the characteristics of collaboration, interoperability, and user-centered designs.  So, whereas the first go at the web in the mid- to late-1990’s was about enabling information retrieval such as transforming printed catalogs into on-line catalogs, Web 2.0 enables all of its participants to comment on, review, rate, and otherwise participating with each other in the use of such a catalog.  In the last FutureWatch blurb, I pointed out work on Grid 2.0, centered on efforts to update the USA’s electricity grid.  I’m going to do a much more detailed post in the near future about emerging 2.0 efforts, but one to point out now is Gov 2.0.  Under this broad set of initiatives, governments from the lowest to highest levels of responsibility are opening up their public databases for consumption by the public.  An example of Gov 2.0 in action comes with the President’s SAVE Award, in which the public is invited to vote on their pick for the best money saving tip put forward by federal government workers.  Read all about this year’s SAVE Award here.

Humor: I haz da funny.

Weird products in Japan have their own name – chindogu.  Most of these are crackpot inventions that everyone knows will never see the light of day, such as these these featured here.  However, some of these products DO get marketed and, more amazingly, purchased.  Check out the product reviews of this totally bizarro chindogu here at Overstock.com.

Professional Development: Because there are two words in “database professional”.

There are mountains of great websites with tips on how to be a better speaker.  Some day, I’ll write a long blog post about my favorite sites for learning how to improve your oration.  But if you’re in a hurry, and who isn’t these days, then this blog post at TechRepublic succinctly sums up the advice you’ll find from many other web sites, articles, and blogs.

Society: Important issues to discuss with your friends and family.

One of the most remarkable things about the USA, as a rather biased citizen, is our ability to suck up our pride, admit a mistake, and try to prevent it from happening again.  One way that the USA tries to prevent future occurrences is to convene a commission of some kind.  I found this analysis by David Leinweber, a Haas Fellow in Finance and Founding Director of the Center for Innovative Financial Technology at UC Berkeley, on the commission studying banking market reform in the USA to be quite intriguing and, frankly, upsetting.

WorldView: If James Bond knows that the world is not enough, then so should I.

I’m always on the lookout for issues related to safe and clean water.  If you think people can be grumpy when oil is in short supply, imagine what it’s like when there’s not enough drinking water for everyone.  See how India is dealing with enormous water issues in this revealing article from the Economist.  And I’d be interested to hear what our Indian blogger friends thoughts are on this topic, folks like Rushabh Mehta, Jacob Sebastian, and Pinal Dave.  (Water issues have remained one of my passions ever since my years working for NASA developing the water recycling systems for the International Space Station, in which we made water of the H20 that passes through the human body re-drinkable.  And it tastes good.  Incidentally, all of the technology we developed for this project, as with all non-classified government projects, became public domain.  ECLSS technology is now used in hundreds of commercial products ranging from household detergents to commercial solvents to filtration systems.)

Thanks!

-Kevin

Twitter @KEKline

The Sequels for SQL Server: The Week of November 27, 2009

Wednesday, November 25th, 2009

Just as an FYI, I’ve added one new slide deck and webcast to http://KevinEKline.com/Slides/, as well as quite a few upcoming user group events where I’m speaking in http://KevinEKline/Upcoming-Events/.

I’m starting a new series called Sequels for SQL Server.  In this series, I point you to sites where you can go beyond the nose-to-the-grindstone resources that we see every day as SQL Server professionals.  These are the story that comes after and outside (the sequels) of our daily working lives (the other SQL).  Let’s broaden our horizons together.  If you hit on an interesting but overlooked topic, I’d like to hear from you.

SQL Server: We live it.  We love it.

An amazing example of explosive growth in SQL Server performance using SSDs from one of the most popular on-line gaming systems, Eve On-Line by CCP Games.

Devices & Gadgets: Usually making our lives better, sometimes not so much.

Everyone I know wants the newest best smartphone, InfoWorld gives us a good test run of them all. Ultimate mobile deathmatch: iPhone vs. BlackBerry vs. Droid vs. Pre.

Futurewatch: Important issues just over the horizon.

The reshaping of our national power grid will provide profound benefits to consumers, but it will also bring enormous liabilities that could equal—or even outweigh—the very problems we hope to solve.   And this webcast from O’Reilly on Grid 2.0 is also quite good.

Humor: I haz da funny.

Witness firsthand a mind-boggling worst practice by a DBA insisting that he’s implementing a best practice.

Professional Development: Because there are two words in “database professional”.

Peter Drucker, one of the greats in management thought-leadership, would’ve turned 100 last week were he alive today.  Check out these top 20 quotes from the man who revolutionized management theory.

Society: Important issues to discuss with your friends and family.

Quoting the Motley Fool, “We spent the latter half of 2008 feeling the wrath of “too big to fail.” Today, banks are bigger than ever. We need to end that. Now.”  It’s Time to End “Too Big to Fail”.  Read this thought-provoking article soon.

WorldView: If James Bond knows that the world is not enough, then so should I.

The smartest analyst on international issues out there, Fareed Zakari, discusses US and Indian relations in this insightful article from Newsweek.

Thanks!

-Kevin

Twitter @KEKline

SQL Server 5-Minute Health Check

Wednesday, November 11th, 2009

Quest Software Pain of the Week Webcast: The 5-Minute SQL Server Healthcheck


Join me and Christian Bolton, UK SQL Server MVP and blogger,as we discuss how to quickly evaluate the basic health of your SQL Server environment. You’ll learn about several quick checks you can perform in minutes to determine if critical thresholds are being met—and where you need to resolve issues.

Date: Thursday, November 12, 2009

Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe

Duration: 45-60 minutes

Cost: FREE

Presenters: Christian Bolton, SQL Server MVP & Kevin Kline, SQL Server Expert, Quest Software

One lucky attendee will win SQL Server expert Kevin Kline’s new essential reference book, SQL in a Nutshell. The drawing will be held at the end of the webcast, and the winner will be notified by e-mail.

Register for the event here.

Upcoming Seminar and SQL Saturday in Florida, Oct 13-17

Sunday, October 4th, 2009

Please join me for SQL Saturday #21 coming up on Saturday, October 17th.  There are over 50 sessions on tap with great speakers from the area and across the nation.  Some of the notable speakers include:

  • Andy Leonard (blog here)
  • Andy Warren (blog here)
  • Brian Knight (blog here)
  • Buck Woody (blog here)
  • Chad Miller (blog here)
  • Joe Celco (blog here)
  • Joe Webb (blog here)
  • Jonathan Kehayias (blog here)
  • Kendal Van Dyke (blog here)
  • Ken Simmons (blog here)

Not only do we have SQL Saturday coming up, but Andy & company put together five world class seminars the week leading up to it! Use code “KKLINE” to get a 20% discount if you register for two or more seminars!

Seminars will be held at the Embassy Suites in Altamonte Springs, FL. Each seminar is $149 and includes a full lunch. Seating is limited, register today!

Attendees of my seminar will get a free copy of my book, Database Benchmarking: A Practical Approach for Oracle and SQL Server, plus other free goodies from my employer, Quest Software. As an added note of explanation, Buck’s excellent seminar centers around detecting and troubleshooting performance problems, while my seminar focuses on writing high-performance and highly scalable SQL and Transact-SQL code.  Why not sign up for both of them to get comprehensive education on the entire process of writing great code, deploying it, and monitoring it for continued excellent performance?

Finally, I’ll be speaking at user groups in the area leading up to SQL Saturday.  If you can join me at my seminar or at SQL Saturday, maybe one of these other events better fits your schedule:

  • Tuesday, Oct 13, Tampa SQL Server User Group (http://www.tampasql.com)
  • Wednesday, Oct 14, Orlando SQL Server User Group (http://www.opass.org)
  • Friday, Oct 15, Jacksonville SQL Server User Group (http://jacksonville.sqlpass.org)

I hope to see you there!

-Kevin

Twitter @KEKline

More content at http://KevinEKline.com

New Post on my SQLMag Blog – Free DMV Monitoring Tools

Monday, September 21st, 2009

I’ve posted a new entry on my SQL Server Magazine blog about two free DMV monitoring tools available on CodePlex.

Read the article here:

http://www.sqlmag.com/Articles/ArticleID/102837/102837.html?Ad=1

Take a look at the two tools and let me know which you like better and why.  Inquiring minds want to know!

Cheers,

-Kev