December 2007 - Posts

New Year's Goals
31 December 07 08:37 AM | Buck Woody | 1 Comments   
Happy New Year! Do you make New Year's resolutions? I don't do that. Instead, my family and I always go out first thing New Year's Day (we don't party much on New Year's Eve - I know, I'm kinda weird like that) and find a food joint that is open. We have Read More...
Filed under:
SQL Server Management Studio Standard Reports – All Transactions: [DatabaseName]
27 December 07 06:51 AM | Buck Woody | 2 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
SQL Server Management Studio Standard Reports – Backup and Restore Events: [DatabaseName]
24 December 07 08:18 AM | Buck Woody | 1 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, Read More...
Shameless Self-Promotion
20 December 07 08:51 AM | Buck Woody | 1 Comments   
I wrote a two-part article over on SQLServerCentral.com that you may want to check out on "How to become a DBA". Even if you already are a DBA, it's a great resource to point aspiring applicants to: http://www.sqlservercentral.com/articles/Administration/61680 Read More...
Filed under:
SQL Server Standard Reports – Database: Disk Usage by Partition: [DatabaseName]
19 December 07 10:51 AM | Buck Woody | 2 Comments   
In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the database-level reports. Today I’ll explain another report dealing with space in the database: Disk Usage by Partition: [DatabaseName] . To get to this Read More...
The Most Important Skill You Can Have
18 December 07 02:26 PM | Buck Woody | 3 Comments   
OK - it's a little light in some of the hallways because of Christmas, so I had a few minutes to actually chat with some friends. We played one of those mental games where you ask "if you could only have one thing for X, what would it be". I was asked Read More...
Filed under:
SQL Server Internals Course
17 December 07 12:51 PM | Buck Woody | 1 Comments   
We normally don't recommend one product or vendor over another, but sometimes there is an industry-recognized expert that has something particularly valuable. Kalen Delaney has a course you might be interested in - definitely check it out. It's a course, Read More...
Filed under: , ,
SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables
14 December 07 07:54 AM | Buck Woody | 0 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio . I’m covering two reports at once, since they have the same columns and output, but show the data from a different perspective. These two reports will help you find out Read More...
Sticking to Standards
13 December 07 06:27 PM | Buck Woody | 1 Comments   
I was working on a Functional Specification today, and I opened a tool to create two UML diagrams. We use UML as a standard, so I normally create fairly detailed use case and sequence diagrams for the developers. I find it's a great tool for us to be Read More...
SQL Server Standard Reports – Disk Usage: [Database Name]
11 December 07 09:16 AM | Buck Woody | 1 Comments   
We’re in the first of the database-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . To get to these reports, navigate from the server object in Object Explorer, move down to the Databases object, Read More...
Puzzle of the Month - this one with prizes!
10 December 07 03:28 PM | Buck Woody | 11 Comments   
OK, it's a shameless giveaway! See if you can fill out this puzzle, made with words you'll find in SQL Server Management Studio. Mail me the answers and I'll send out a small gift to one lucky reader with the right answers, chosen at random at the end Read More...
SQL Server Management Studio Standard Reports – Transaction Log Shipping Status
07 December 07 05:54 PM | Buck Woody | 1 Comments   
We’re in the final server-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . Don’t worry, there are plenty more reports coming in the database and other objects; but this one is the last of the reports Read More...
The Data Saturation Quotient
06 December 07 08:57 AM | Buck Woody | 12 Comments   
I was thinking about something this morning on the ride into work that I’d like to ask your opinion about. It has to do with the amount of data that could be absorbed and acted on by a unit or system in a given period of time. The idea is that there is Read More...
SQL Server Management Studio Standard Reports – Service Broker Statistics
04 December 07 06:45 AM | Buck Woody | 1 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio . Today I'm covering a report on a feature you might not have used yet – the Service Broker. This feature, which you can read more about here , allows you to set up a messaging Read More...
Are these really blogs or not?
03 December 07 07:37 AM | Buck Woody | 3 Comments   
Steve Jones, my friend over at SQLServerCentral.com had a podcast the other day (Voice of the DBA) where he commented that blogs should be blogs - not a form of corporate communication. I agree. It's not that you can't have corporate content on an RSS Read More...
Filed under: ,
Page view tracker