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 2005   (RSS)
Showing page 2 of 3 (24 total posts)
  • T-SQL Tuesday: Easy Extended Properties

    Ahhh, attention to detail. I misread Adam's T-SQL Tuesday rules and posted early. So here I go again :) This time the puzzle is how to add and update metadata via extended properties in the database with minimal headaches. SQL Server supports a great feature for storing database object metadata in the database in the form ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 12, 2010
  • Long time SQL Cluster issue resurfaced

    It is interesting as time goes on, what things are found by others that have already been reported, but seem to be ignored.  SQL 2005 Clustering issue with lower case servernames is the topic of this post.  I attended a Clustering Class by Russ Kaufmann and during the class I illustrated to him a problem that we had in installing a ...
    Posted to Ben Miller (Weblog) by dbaduck on January 11, 2010
  • Please Vote: Windowing Enhancements in SQL Server

    Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 19, 2009
  • SQL Server 2000 Still Strong, but Diminishing

    I presented a webcast on Wednesday on SQL Server Consolidation.  As with many of my sessions (both physical and virtual), I like to ask several questions.  This is NOT scientific, but it is anecdotal. Poll Question #1:  Do you have SQL Server 2000 STILL running in production in your organization today?  YES = 70%, NO = 27%, ...
    Posted to Rick Heiges (Weblog) by RickHeiges on April 24, 2009
  • Turning the corner on Upgrading from SQL Server 2000

    Last month, I spoke at a SQL Server Firestarter event in Charlotte.  With just about every session that I speak at or webcast that I do since 2006, I always ask for a show of hands on two questions.  The first is ''How many people here are running SQL Server 2000 in production?'', and the follow-up question that I ask is ''How many ...
    Posted to Rick Heiges (Weblog) by RickHeiges on February 12, 2009
  • SQL 2005 Encryption with Certificates

    OK, I found out that my age is creeping up on me.  I have implemented some encryption using Certificates in SQL Server and had some interesting experiences I thought I would share. I have a Database Master key and planned out my encryption strategy at least for the near future as follows: DATABASE MASTER ...
    Posted to Ben Miller (Weblog) by dbaduck on February 2, 2009
  • Updated Support Policy for SQL Server on VMs

    As virtualization grows stronger in the marketplace, the question of SQL Server performance and support on Virtual Machines appears more often.  Bob Ward has a great post here.  Enjoy!
    Posted to Rick Heiges (Weblog) by RickHeiges on October 8, 2008
  • IMTC Presentation Posted

    Earlier this year, I was fortunate to visit Dublin, Ireland to speak at the Irish Microsoft Technical Conference (IMTC).  Chuck Boyce from was there recording and streaming sessions.  He was unable to stream my session live, but he did get it recorded.  Chuck has just posted my session on SQL Server Express 2005 ...
    Posted to Rick Heiges (Weblog) by RickHeiges on August 26, 2008
  • Recent Mags

    I get several more ''generic'' IT mags sent to my home.  I usually get them in an attempt to keep up with what is going on in the outside world.  Typically, I look at the lead story and find a nugget or two in the rest. In my recent issue of TechNet magazine, the cover story is on how to Tune up your database by Paul Randall.  He ...
    Posted to Rick Heiges (Weblog) by RickHeiges on July 28, 2008
  • Risky Business

    Whenever I do a webcast or presentation, I always ask the audience to indicate where their organization is in relation to running SQL Server 2000 or running SQL 2005.  Recently, in an audience of about 40 people, more than half of the audience still had more than 50% of their production servers running SQL Server 2000.  One of the ...
    Posted to Rick Heiges (Weblog) by RickHeiges on June 24, 2008
Privacy Statement