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 » Administration   (RSS)
Showing page 16 of 16 (160 total posts)
  • What Version of SQL Server Am I Running?

    I frequently see questions like this – ”I am getting different version numbers for my SQL Server 2000 instances. All I'm aware of is 8.00.2039 - which is SP4.  These are these values I am getting, e.g. 8.00.2039, 8.00.2040, and 8.00.2148”?   Here are two great resources to help you out in the ...
    Posted to Kevin Kline (Weblog) by KKline on August 5, 2008
  • New and Useful White Papers

    Be sure to check these out: White Paper: Security Overview for Database Administrators 2008.   http://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-security.aspx SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as ...
    Posted to Kevin Kline (Weblog) by KKline on June 16, 2008
  • Great Giveaways in SQL Server Magazine and at Microsoft TechEd 2008

    I wanted to take a minute to draw some attention to a few things in this month’s SQL Server Magazine.  If you’ve gotten your copy of SQLMag, you’ll notice poster that's a really great reference guide for SQL Server system stored procedures.  This outstanding poster can hang in your cube or office and outlines the function and syntax of ...
    Posted to Kevin Kline (Weblog) by KKline on June 11, 2008
  • MIRRORING THROTTLES BACKLOG

    For some reason, the title of this blog post makes me grin because it evokes a mental image of one guy trying to comically strangle another guy.  But I digress…   Speaking at a user group meeting recently, an attendee asked whether the mirroring process had any capability to speed up or slow down its workload according to the amount of ...
    Posted to Kevin Kline (Weblog) by KKline on May 2, 2008
  • More SQL Server Automation Scripts

    If you've read SQL Server Magazine, then you know that I write a monthly column about free SQL Server tools called Tool Time.  I recently wrote about a set of automation scripts from Microsoft's internal MIS group that automates all sorts of regular tasks they perform on their SQL Server's. Today, I'd like to share some more scripts brought ...
    Posted to Kevin Kline (Weblog) by KKline on March 26, 2008
  • A Gift of Script for 2008: Who's Active, What Are They Doing, and Who is Blocked?

    As with all of the blog posts I keep meaning to write -- I keep a list and given the infrequency with which I've been posting lately, it's getting quite large -- this script has been on the queue for quite some time. So here I find myself with a spare moment right on the cusp of the new year, and figured what better way to end the year than with ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 31, 2007
  • Kevin's Webcast Tomorrow (4/24/07)

    Join me tomorrow for a webcast on SQL Server backup and recovery. Here are the details:  Tuesday, April 24, 2007 2pm Time Zone:Eastern Time (US & Canada)         Seminar Name: LiteSpeed/ SQL Server 2005 Presenter: Kevin Kline/Andrea Schneider  Are you looking for a solution that can help ...
    Posted to Kevin Kline (Weblog) by KKline on April 23, 2007
  • New Windows Live Search Macro for SQL Server

    If you're a fan of the MSDN on-line search tool for the SQL Server 2005 Books On-Line (BOL), you might want to try a new tool.  The new search tool is available at http://search.live.com/macros/sql_server_user_education/booksonline and offers more precise and targeted search results than MSDN.You can investigate creating your own Windows ...
    Posted to Kevin Kline (Weblog) by KKline on April 3, 2007
  • Webcasts on-line

    As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks.  Of course, I'm happy to share those, but I've got one better for you.  As it turns out, you can find five of my most recent webcasts here.  These are recorded webcasts that you can listen to any time.  I believe that ...
    Posted to Kevin Kline (Weblog) by KKline on February 8, 2007
  • Consuming Data from the PerfMon Counters

    SQL Server MVP Kent Tegels recently raise an interesting question. SQL Server publishes a number of performance counters. In the code he's written that publishes performance counter data, he's had to explictly code the counter updates within his code regardless of knowing if any processes were consuming those ...
    Posted to Kevin Kline (Weblog) by KKline on December 15, 2006
Privacy Statement