THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL Programming   (RSS)
Showing page 2 of 4 (31 total posts)
  • 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
  • Join Me May 19th for 24 Hours of PASS

    Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May ...
    Posted to Kevin Kline (Weblog) by KKline on April 26, 2010
  • 2009: The Year in List Form

    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 ...
    Posted to Kevin Kline (Weblog) by KKline on January 5, 2010
  • Upcoming Seminar and SQL Saturday in Florida, Oct 13-17

    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 ...
    Posted to Kevin Kline (Weblog) by KKline on October 4, 2009
  • Bitemporal Data

    Any IT pro with more than a year or two of experience will have faced the challenges of version control for an application, but what if you have to implement version control for data? The most common way to tackle this problem is implementing something called ''bitemporal data''. Under this method, each row in a table includes the current ...
    Posted to Kevin Kline (Weblog) by KKline on August 4, 2009
  • Why Do I Keep Seeing This Mistake?

    One of the fundamentals of loop optimization is that you should move stable operations outside of the loop.  What I want to know is - if this is such a fundamental rule, why do so many people break it?!?If you are familiar with other programming languages, then you are probably aware of loop optimization techniques. You should try to put all ...
    Posted to Kevin Kline (Weblog) by KKline on July 10, 2009
  • Looking for Good DMV/Database Admin Queries!

    I like to collect useful database administration queries that leverage the SQL Server 2005 and 2008 DMVs.  Heck, I'm still interested in SQL Server 2000 queries too.  I thought I'd make my search public so that a) you can share your favorite queries here or great reference queries written by others and publicly posted on the ...
    Posted to Kevin Kline (Weblog) by KKline on April 7, 2009
  • An Interview with Denis Gobo

    I had the pleasure of speaking with SQL Server MVP, Denis Gobo, about my newest book, SQL in a Nutshell 3rd Edition.  In the interview, we discuss the state of database industry, ANSI SQL, and other related questions. Check out Denis' interview (and his fine blog) at Thanks, -Kevin
    Posted to Kevin Kline (Weblog) by KKline on February 24, 2009
  • LINQ: Enabling or Entangling?

    There’s been a lot of positive press for LINQ, such as the article about LINQ by Mike Otey at  You can also find lots of glowing reviews and info about LINQ by Troy Magennis at   I've been trying to figure out exactly how I feel ...
    Posted to Kevin Kline (Weblog) by KKline on December 23, 2008
  • Better Ways to Get Transaction Log Information

    If you've been around a while, you tend to do things the way you first learned how to do them.  This can turn you into an ''old timer'' whose oblivious to new and better ways to do things that have appeared in the newer releases of the technology.   Take measuring log space, for example.  If I wanted to find out how much log space ...
    Posted to Kevin Kline (Weblog) by KKline on November 5, 2008
Privacy Statement