Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Documentation
Monday, November 16, 2009 7:19 AM

Color Me Corrected – Will the REAL sysobjects please stand up?

A few days ago I posted a way to look at the Dynamic Management Views (DMV’s) using a query, which I then copy and paste into the Help viewer’s Index tab to learn more. Well, my good friend and Colleague, Cliff, pointed out that I was using the older
Posted by Buck Woody | 1 Comments
Wednesday, November 11, 2009 7:49 AM

How Microsoft Does IT - Updated

I’ve pointed out this link before, and I’ll definitely bring it up again. Microsoft is one of the few companies I know, especially the big ones, that explains how they run their IT. We have a fantastic, I mean really fantastic site that you should definitely
Posted by Buck Woody | 0 Comments
Wednesday, November 04, 2009 8:04 AM

Find and learn DMVs

This morning I showed how I find DMVs, and find out how to use them. First, I just run this query:   USE MASTER; GO SELECT ‘sys.’ + name FROM sys.sysobjects WHERE name LIKE ‘dm%’   Then I copy and paste a result into the “Index” panel of Books
Posted by Buck Woody | 0 Comments
Wednesday, July 29, 2009 8:06 AM

Commenting your Code

You should always add descriptive comments to any code that will live longer than a single event. It's useful not only for the other unfortunate souls blessed with your code, but for yourself, years later, when you say "what was I thinking here?"
Posted by Buck Woody | 7 Comments
Tuesday, July 21, 2009 7:51 AM

Replacing the Books Online Search Feature

Some time back, the Books Online team at Microsoft made a very cool macro on Live.com that would search within the on-the-web version of Books Online – a very handy feature indeed, since the search for the installed version of Books Online is, well,
Posted by Buck Woody | 3 Comments
Tuesday, July 07, 2009 8:12 AM

SQL Server 2008 Books Online Update is Released

I try not to post things that others have already discussed, but I make a few exceptions. I'll (re)tell you about security issues and service packs, and I'll also mention when Books Online is updated. I run into so many issues that are already covered
Posted by Buck Woody | 0 Comments
Monday, June 22, 2009 7:53 AM

Help Me Help You

Before I start this post, let me say that it is not pointed at any one person - if you've asked me for help recently, this isn't about you! The programming and administration computer disciplines are fairly unique, in my mind, in one interesting way:
Posted by Buck Woody | 1 Comments
Monday, April 06, 2009 7:50 AM

A Web Based Search for Books Online

As many of you know, I used to work on documentation like whitepapers and Books Online for SQL Server. One of the main problems I've found with our documentation isn't that there is not enough content - we have over 65,000 pages in BOL alone - but that
Posted by Buck Woody | 1 Comments
Tuesday, February 10, 2009 8:01 AM

Of Patterns and Practices

Does the data professional need to know about Patterns and Practices? Well, if you're on the development side of things, you're more than likely already familiar with this term. At the bottom it's a list of "best practices" that you use to solve
Posted by Buck Woody | 1 Comments
Wednesday, February 04, 2009 7:29 AM

Server Consolidation Done Right

Consolidating your servers is all the rage, especially since you can save money by doing it. You can save not only on the hardware, but the licenses. To do that properly, you need a strategy. You start by detailing what you have, and then lay out the
Posted by Buck Woody | 1 Comments
Tuesday, February 03, 2009 9:12 AM

Service Broker and the Need for Planning

I mentioned yesterday about the database I was using implemented Service Broker. I wanted to mention (again) the incredible need for planning when you're setting up a project. Whenever you're working on something as distributed as Service Broker, you
Posted by Buck Woody | 1 Comments
Monday, February 02, 2009 9:50 AM

Check that database before you restore it...

I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as
Posted by Buck Woody | 1 Comments
Tuesday, January 27, 2009 9:13 AM

Versioning the Database

If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire
Posted by Buck Woody | 1 Comments
Monday, January 26, 2009 8:40 AM

Which Edition is Right for Me?

I had a discussion the other day with someone who had some questions about Enterprise Edition of SQL Server 2008. In many cases, I've seen someone not using the "right size" of SQL Server. Many installations really call for Enterprise Edition
Posted by Buck Woody | 1 Comments
Thursday, December 04, 2008 9:33 AM

SQL Server 2008 Whitepaper Access Point

A special site is available to get at the whitepapers for SQL Server 2008. You can find that here: http://www.microsoft.com/sql/2008/learning/whitepapers.mspx . And here are a few of my personal favorites: Performance and Scale http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_perfandscale.mspx
Posted by Buck Woody | 1 Comments
More Posts Next page »
 
Page view tracker