THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tips » Best Practices   (RSS)
Showing page 1 of 2 (13 total posts)
  • Writing and Delivering a Successful Full-Day Technology Seminar

    I was recently chatting with the current President of PASS, Thomas LaRock (Twitter | Blog), and Pieter Vanhove (Twitter | Blog), a prominent SQL Server consultant and expert in Belgium, about how I go about building and presenting a full-day technical seminar. In the SQL Server world, we tend to call these ...
    Posted to Kevin Kline (Weblog) by KKline on May 6, 2014
  • My Advice About Growing as an IT and Data Professional

    First off, I should apologize for not blogging in quite a while. I've been traveling extensively and, because traveling can be so exhausting, I usually have to queue up blog posts to hit while I'm traveling in order to remain active while on the road.  I didn't do that for these most recent trips.  And, as you can see, there's quite a ...
    Posted to Kevin Kline (Weblog) by KKline on July 15, 2013
  • Quick Tip - Speed a Slow Restore from the Transaction Log

    Here's a quick tip for you:During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time.  Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. ...
    Posted to Kevin Kline (Weblog) by KKline on November 14, 2012
  • The Zombie PerfMon Counter That Never Dies! Quick Tip

    The PerfMon Counters That Just Won't DieOne of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away.  (Some day, politicians will realize this.  We can easily fact check their consistency).  Because of longevity of content posted to ...
    Posted to Kevin Kline (Weblog) by KKline on October 8, 2012
  • Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

    Here's an evergreen question. It's a question that never completely goes away. But lately, I've been getting it a few times per week. So I thought it's time to readdress the question, which usually takes some form of the following:I can't really do effective development on my little dev laptop because our production SQL Server database is 15 ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2012
  • Must-Have Resources - SQL Server Backup & Recovery

    One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like ''I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that ...
    Posted to Kevin Kline (Weblog) by KKline on December 8, 2011
  • New on SQLMag.Com: Update to SP_WHOISACTIVE

    I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time.  Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
    Posted to Kevin Kline (Weblog) by KKline on April 21, 2011
  • Database Maintenance Scripting Done Right

    I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2011
  • Visual Studio 2010 - Special Edition

    I wanted to pass along this great info from Microsoft.  There are literally oodles of free resources for Visual Studio programmers. In their own words... Take Visual Studio for a Test Drive Take this powerful tool and its features for a spin by downloading a full Visual Studio 2010 trial version. Discover how Visual Studio 2010 ...
    Posted to Kevin Kline (Weblog) by KKline on September 10, 2010
  • It's the Atlanta Attendance Contest!

    I'm speaking tonight on Top 10 Mistakes DBAs Make at the Atlanta SQL Server User Group meeting in Alpharetta, GA.  You can find all of the details here.The Best Dang Design Book for SQL Server Professionals - EVER!I thought I'd liven things up a bit with a little contest.  The rules are simple: A. If you don't follow me on ...
    Posted to Kevin Kline (Weblog) by KKline on July 12, 2010
1 2 Next >
Privacy Statement