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 » DBA   (RSS)
Showing page 2 of 3 (27 total posts)
  • How To Download Free Sessions From PASS

    For all members of the Professional Association for Server (PASS), are you downloading slides and videos from all sorts of great PASS events?  If not, what are you waiting for ... an invitation?Ok, here it is.  I invite you to download like a madman!  (How a madman downloads, an almost entirely virtual activity, is not the ...
    Posted to Kevin Kline (Weblog) by KKline on November 28, 2012
  • 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
  • Recap - SQL Saturday 151 in Orlando

    It's always a feel-good experience for me to return to SQL Saturday in Orlando, the place where SQL Saturdays  were started by Andy Warren (Twitter | Blog).  On this trip, I delivered a full-day, pre-conference seminar on Troubleshooting and Performance Tuning SQL Server.  I also delivered a session on SQL Server ...
    Posted to Kevin Kline (Weblog) by KKline on October 2, 2012
  • Secure Your Spot at the Nashville SQL Saturday!

    PASS SQL Saturdays are free 1-day training events for IT professionals interested in Microsoft SQL Server, providing a variety of high-quality technical sessions, all happen through the efforts of local volunteers.  The leadership team of the local chapter of PASS here in Nashville (Facebook | LinkedIn) have ...
    Posted to Kevin Kline (Weblog) by KKline on August 27, 2012
  • Come See Me. I'll Probably Be Just Down the Street Soon!

    Even though I've recently changed jobs, I'll still be speaking at a lot of SQL events across the country and internationally.  There are still a few trips that I've yet to finalize, in particular with the fine folks in Houston, run by my friend Nancy Hidy (blog | twitter), and my friends in San Francisco and Silicon Valley, run by ...
    Posted to Kevin Kline (Weblog) by KKline on July 31, 2012
  • New White Paper: SQL Server Extended Events and Notifications

    SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred.  There's PerfMon, and Profiler, and loads of Dynamic Management Views to check.  But where to look? As ...
    Posted to Kevin Kline (Weblog) by KKline on April 25, 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
  • Using the @ in SQL Azure Connections

    The other day I was working with a client on an application they were changing to a hybrid architecture – some data on-premise and other data in SQL Azure and Windows Azure Blob storage. I had them make a couple of corrections - the first was that all communications to SQL Azure need to be encrypted. It’s a simple addition to the ...
    Posted to Buck Woody (Weblog) by BuckWoody on June 21, 2011
  • More than one way to skin an Audit

    I get asked quite a bit about auditing in SQL Server. By ''audit'', people mean everything from tracking logins to finding out exactly who ran a particular SELECT statement. In the really early versions of SQL Server, we didn't have a great story for very granular audits, so lots of workarounds were suggested. As time progressed, more and more ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 20, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement