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 Server 2008 » Database Administration   (RSS)
Showing page 2 of 3 (25 total posts)
  • Speaking at SQLSaturday #33 in Charlotte

    I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell. The event takes place at the Microsoft Charlotte Offices on 8050 Microsoft Way, Charlotte, NC 28273. For more information please visit or email us ...
    Posted to Allen White (Weblog) by AllenMWhite on March 4, 2010
  • Service Broker Basics - Part Deux

    Last week I introduced the Service Broker Basics. Today I'd like to cover some of the ''plumbing'' - the components that allow communication between different servers running Service Broker. Endpoints. There needs to be a channel for the communications coming in and out of the server, and in the IP world that channel exists in the form of a ...
    Posted to Allen White (Weblog) by AllenMWhite on January 12, 2010
  • Service Broker Basics

    I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not a lot of information out there to help guide you through the process. Here I'd like to walk you through the basics. Message Types. Service Broker sends messages asynchronously from one database to another. You can ...
    Posted to Allen White (Weblog) by AllenMWhite on January 6, 2010
  • Updates to the Wait Type Repository – PSS Blog

    At PASS Summit earlier this year, Bob Ward an Escalation Engineer in Microsoft Product Support, vowed to create a Wait Type Repository over on the PSS Blog that does a better job of documenting SQL Server Wait Types to assist the community.  He create a blog post that he is updating over time to document the wait types in SQL Server. The SQL ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on December 18, 2009
  • Ola Hallengren Releases New Version of Backup, Integrity Check and Index Optimization Scripts

    Ola Hallengren’s Backup, Integrity Check and Index Optimization scripts are pretty famous.  They have been covered by SQL Server Magazine and they have been reviewed on the following blogs: Aaron Bertrand's Blog Chad Boyd's Blog Greg Low's Blog Kevin Kline's Blog Kimberly Trip's Blog Paul Randal's Blog Satya SK ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on August 26, 2009
  • Building a SQL Server Cluster for Testing - Part2

    Its been a few days since the first post in this series, and I have learned a lot about clustering in Windows Server 2008 with SQL Server 2008.  The first thing I learned over the last few days is that there are some significant changes in Windows 2008 Clustering that affect how you will roll out a cluster for testing purposes.  A lot of ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on June 7, 2009
  • Building a SQL Server Cluster for Testing - Intro

    At some point as a SQL Server DBA, you have to learn how to install and configure a SQL Server Cluster.  I personally haven't dealt with a SQL cluster since SQL Server 2000, and I've never had to install one from scratch, so I've decided to jump in feet first and put the time in to learn how to do this.  There are already a few great ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on June 3, 2009
  • Changing Server Default Collation

    An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the Czech Republic, I have to reset our lab systems server default collation to Czech_CI_AS, and I found it difficult to find out how to do this via Books Online. Since we have systems running SQL 2000, SQL 2005 and ...
    Posted to Allen White (Weblog) by AllenMWhite on May 29, 2009
  • Tracking Deprecated Features

    This week I'm in Brno, Czech Republic leading an App Compat seminar for Microsoft clients here, and one of the things we need to look for in their applications is the use of deprecated features. I was poking around the sys.os_performance_counters DMV and discovered the [sqlinstance]:Deprecated Features object and found that if your application ...
    Posted to Allen White (Weblog) by AllenMWhite on May 26, 2009
  • SQL Server 2005 and 2008 receive Guest Failover Clustering Support from Microsoft

    Bob Ward blogged about this on the Customer Support Services blog this morning: SQL Server Support Policy for Failover Clustering and Virtualization gets an update… Essentially you can now run SQL Server 2005 and 2008 in a Virtualized Failover Cluster as long as the Guest OS is Windows Server 2008 or higher, the selected virtualization ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on May 19, 2009
Privacy Statement