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 » Database Administration   (RSS)
Showing page 5 of 8 (76 total posts)
  • Don't Do This

    In working on applications at client sites you tend to come across code that makes you think ''what were they thinking''? This week I found one that just made me do the ''facepalm'': select top 1 @_StateTrueKey = OverEngineeredKey from OverEngineered where Value = 'true' select top 1 @_StateFalseKey = OverEngineeredKey from ...
    Posted to Allen White (Weblog) by AllenMWhite on June 25, 2010
  • PowerShell Script to Remove Old Backups

    A Twitter user asked for a script to remove old backups, and I had one I built back in February, so here it is (use at your own risk): #rmbackup.ps1 # Removes database and transaction log backups # # Change log: # February 2, 2010: Allen White # Initial Version # Get the SQL Server instance name from the command line param( ...
    Posted to Allen White (Weblog) by AllenMWhite on June 24, 2010
  • Lots of Speaking Engagements Coming Up

    SQL Saturday - Columbus, OH, June 26, 2010 I'll be presenting two sessions this Saturday (June 26, 2010) in Columbus, OH - XQuery Basics and Gather SQL Server Performance Data with PowerShell. The event takes place at Goodwill Columbus, 1331 Edgehill Rd, Columbus, OH. In the XQuery session I'll give an introduction to XQuery and show how easy ...
    Posted to Allen White (Weblog) by AllenMWhite on June 23, 2010
  • TechEd 2010 Followup

    Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience, even though my demos didn't always work out as planned. Here are the sessions I presented: DAT01-INT Administrative Demo-Fest for SQL Server 2008 SQL Server 2008 provides a wealth of features aimed at the DBA. In this demofest of features we'll ...
    Posted to Allen White (Weblog) by AllenMWhite on June 13, 2010
  • Service Broker Solutions - Don't Forget the Basics

    After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it can be to implement and get it really working as expected. First, understand the technology. There are some great resources out there to help you get started. The first place to go is Klaus ...
    Posted to Allen White (Weblog) by AllenMWhite on April 3, 2010
  • Document, Document, Document

    A while back I blogged about using Checklists, but there's another task you want to incorporate into your workflow - documentation. Now, I'm not just talking about documenting the logic, system flow and data and structure changes, I'm also talking about documenting your daily activities (commonly referred to as a journal.) It's amazing how ...
    Posted to Allen White (Weblog) by AllenMWhite on March 13, 2010
  • Keep Your Data Clean

    In working with client data you start to notice trends that raise flags in your mind. In my case I'm looking at data and seeing a lot of columns that have NULL in the column where a NULL doesn't mean ''I don't know'', it means ''I was too lazy to put something here''. In the stored procedures to process the data and produce management level ...
    Posted to Allen White (Weblog) by AllenMWhite on March 5, 2010
  • 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
  • Bookstores and Databases

    My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at dinner celebrating my wife's birthday she was telling me about setting up the shelves in the new bookstore they're opening this week in our local community of Brunswick. A majority of the books they receive as donations are fiction, ...
    Posted to Allen White (Weblog) by AllenMWhite on March 3, 2010
  • T-SQL Tuesday #3: Database Relationships

    In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with relational databases. At the basic level, a database table is really a relation. You can have a truly relational database with just a single table. The relationship is that between each of the attributes (or columns) with the ...
    Posted to Allen White (Weblog) by AllenMWhite on February 9, 2010
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement