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 » Best Practices   (RSS)
Showing page 4 of 11 (108 total posts)
  • Upcoming SQLSaturday Events in Omaha and Atlanta!

    I've had enough time off from traveling after my surgery to finally travel again.  First on the circuit , set for August 27th, is Omaha, Nebraska and SQL Saturday #91.  As a former Crimson Tide alum, I was stoked about going to the University of Nebraska, our once and future rivals on the Grid Iron.  But after a moment's ...
    Posted to Kevin Kline (Weblog) by KKline on August 17, 2011
  • T-SQL Tuesday #21 : Crap Code

    Yes, Adam is right: we've all written crap code (the topic of this month's T-SQL Tuesday Wednesday. Usually we have an excuse: tight deadline, short shelf life of the code, or didn't know any better. I'm sure if I perused my career codebase I'd find tons and tons of examples that I'd write differently today, because back then it fell under ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 10, 2011
  • Microsoft Document Watch for Operational Excellence

    Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins. ...
    Posted to Kevin Kline (Weblog) by KKline on August 8, 2011
  • SQL Server v.Next (Denali) : Breaking change to sys.dm_exec_sessions

    If you're not OCD about prefixing every single column in a query, this is one that might bite you. Today you might have code that assumes that, because database_id is in sys.dm_exec_requests but not in sys.dm_exec_sessions, you don't need to prefix database_id in the following example:SELECT TOP (1)   s.session_id,   ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 19, 2011
  • Pain of the Week/Expert's Perspective: Performance Tuning for Backups and Restores

    First off - the Pain of the Week webcast series has been renamed.  It's now known as The Expert's Perspective.  Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster! The bigger your databases get, the longer backups take. That doesn't really seem like a ...
    Posted to Kevin Kline (Weblog) by KKline on June 27, 2011
  • Available Online - SQL Server Training Videos

    Interested in my various performance tuning and troubleshooting videos about SQL Server?  These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter).  View these insight-packed training videos from our SQL Server training events originally presented on ...
    Posted to Kevin Kline (Weblog) by KKline on June 1, 2011
  • Connect Digest : 2011-05-09

    This week we're going to look at some issues involving tempdb... Provide a tempdb per database #176241 : Eliminating TempDb By Adding Temp Filegroup to Each Database#281202 : multiple tempdb For these two requests, I am hoping that the Contained Databases feature (which I've talked about multiple times) will get to this capability in the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 9, 2011
  • Free Webcast Series: Patterns and Practices in Database Administration

    SSWUG.ORG’s virtual webcasts will prepare the “Accidental DBA” for patterns and practices they will experience in their role as a database administrator. I will provide easy-to-understand insights and realistic examples for professionals who have not had any formal DBA training. By the end of our four-part series, you should have the ...
    Posted to Kevin Kline (Weblog) by KKline on April 27, 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
  • Funny Things You'll Hear at the "Leadership for IT Professionals" at the 2011 SQLRally

      Register now! WWW.SQLRALLY.COM The 2011 PASS SQLRally is just about one month away and it's high time I highlighted some of the important things you'll be hearing about in my precon seminar Leadership and Team Management Skills for the IT Professional. Just to set the context, many of us IT people got to our lofty ...
    Posted to Kevin Kline (Weblog) by KKline on April 18, 2011
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement