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 » dba » Best Practices   (RSS)
Showing page 1 of 2 (19 total posts)
  • Third Party Applications and Other Acts of Violence Against Your SQL Server

    I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ...
    Posted to Kevin Kline (Weblog) by KKline on August 12, 2014
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

     Join me for a day ofReal World Database Configuration and Tuning for Microsoft SQL ServerSQL Saturday Silicon Valley 2014Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT)Mountain View, CAClick HERE to register Now! Seating is very limited! This full-day training event combines a thorough overview of fundamental architectural concepts ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2014
  • One Preparation that makes SSMS Crash Dumps Easy to Survive

     Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
    Posted to Kevin Kline (Weblog) by KKline on February 10, 2014
  • Now Playing on SSWUG TV!

    Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the ...
    Posted to Kevin Kline (Weblog) by KKline on September 10, 2013
  • Database Trends & Applications column: Database Benchmarking from A to Z

    Have you heard of the monthly print and web magazine Database Trends & Applications (DBTA)? Did you know I'm the regular columnist covering SQL Server?  For the past six months, I've been writing a series of articles about database benchmarking culminating in the latest article discussing my three favorite database ...
    Posted to Kevin Kline (Weblog) by KKline on July 24, 2013
  • Use TPC Database Benchmarks to Save Money

    Last month, I began a series of articles describing database application benchmarking. In the first article, I told you about different ways that you can construct your own database application benchmark. However, you don’t have to reinvent the wheel. The Transaction Processing Council (www.tpc.org) has already created a large number of ...
    Posted to Kevin Kline (Weblog) by KKline on April 29, 2013
  • Read the New TPC Database Benchmarking Series

    Let's talk about database application benchmarking.This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database Trends & Applications magazine, I'll give you a brief introduction to TPC benchmarks and, ...
    Posted to Kevin Kline (Weblog) by KKline on April 22, 2013
  • The Year That Was - 2012

    2012 was, simply stated, a year that kicked my butt.  When I wasn't struggling professionally, I was struggling personally.  Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles.  I apologize to those of you who are normally on my Christmas ...
    Posted to Kevin Kline (Weblog) by KKline on December 31, 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement