January 2008 - Posts

SQL Server Management Studio Standard Reports –Database Consistency History: [DatabaseName]
31 January 08 09:38 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...
Make it an Application or Make it a Platform?
30 January 08 09:16 AM | Buck Woody | 1 Comments   
Most of us are familiar with at least one kind of software development. Nearly every program we interact with has an interface, a processing mechanism or two, and often, a back-end where persisted data is stored. We call these “applications”, because Read More...
SQL Server Management Studio Standard Reports – Resource Locking Statistics by Object: [DatabaseName]
29 January 08 09:20 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...
SQL 2K5 for Performance Reports - You have to download these
28 January 08 08:15 AM | Buck Woody | 1 Comments   
I've been covering lots of reports that ship in the box with SQL Server Management Studio , but there are several others that you can get (if you have Service Pack 2 for SQL Server 2005) that are really amazing. First things first. You can download them Read More...
Why on earth are you working on that?
25 January 08 09:23 AM | Buck Woody | 3 Comments   
Much of the development work at Microsoft is a mystery to the rest of the world. People ask me all the time why my team is working on X , when clearly what is needed is Y. Of course, everyone's definition of Y seems to be different, but that's another Read More...
Scripts and more scripts
24 January 08 07:31 AM | Buck Woody | 1 Comments   
A few posts back I mentioned that I used the "Templates" feature in SQL Server Management Studio to track all of my script librarires. I wanted to expand on that a little bit, and make a correction. Like many DBA's, I have a series of scripts I have collected Read More...
Blogs, Blogs and More Blogs
23 January 08 01:05 PM | Buck Woody | 1 Comments   
I subscribe to a lot of blogs - maybe too many! But I saw a thread the other day where someone was looking for more SQL Server Blogs. I've got a couple of links here that you might find useful: All SQL Server Blogs from Microsoft: http://msdn2.microsoft.com/en-us/sqlserver/bb671054.aspx Read More...
SQL Server Management Studio Standard Reports – Top Transactions by Locks Count: [DatabaseName]
22 January 08 09:17 AM | Buck Woody | 0 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...
Questions and Suggestions
21 January 08 09:58 AM | Buck Woody | 1 Comments   
I’ve covered quite a few of the reports in SQL Server Management Studio , and along the way I’ve gotten some questions about them and a couple of really good suggestions. I’ll cover another report tomorrow, but today I thought I would answer one or two Read More...
Transport Systems
18 January 08 09:05 AM | Buck Woody | 5 Comments   
I’ve worked on a couple of SAP systems, both the “R” flavors and the BW product. Although I had my learning challenges with them, there was one construct there I really liked. It was the transport mechanism. Basically what this involved was setting up Read More...
Controlling Just One Part of a Maintenance Plan
17 January 08 09:47 AM | Buck Woody | 1 Comments   
A few posts back I mentioned that I was speaking with someone that wanted to use the new Resource Governor feature in SQL Server 2008 to “throttle back” only one portion of a Maintenance Plan, using the Wizard to create one. The problem he had was that Read More...
SQL Server Standard Reports – Top Transactions by Blocked Transactions Count: [DatabaseName]
16 January 08 06:49 AM | Buck Woody | 1 Comments   
In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the database-level reports, and we’re in the transaction-level reports at the moment. To get to this report, navigate from the server object in Object Read More...
My Favorite CodePlex Projects
14 January 08 11:04 AM | Buck Woody | 1 Comments   
In case you didn’t know CodePlex is Microsoft’s site for “Open Source” projects. That’s right – source code and binaries you’re free to use, or if you really want to help others, join the projects they belong to. You’ll also notice that all the samples Read More...
Generalists are just second-class citizens
10 January 08 07:24 PM | Buck Woody | 1 Comments   
I was in a meeting with someone the other day who I knew had some input, but didn't give it. They told me that they felt a little overwhelmed because they thought the other people in the room knew more. Now, I agree that if you don't have something to Read More...
Filed under:
MSDN and TechNet SQL Server Sites Linked
09 January 08 02:28 PM | Buck Woody | 2 Comments   
SQL Server can be a strange animal - we have no direct end users, but we do have Developers and DBA's. For years we've have two sites that the two camps have used: MSDN for Developers, and TechNet for DBA's. But of course, there is no such thing as a Read More...
When the PC becomes the server
08 January 08 09:28 AM | Buck Woody | 2 Comments   
I was speaking with a friend yesterday about a requirement he has to separate the maintenance tasks running on his SQL Server from the regular user transactions. In specific, he wanted to throttle the reindexing tasks while users were on, since his shop Read More...
SQL Server Standard Reports – Top Transactions by Age: [DatabaseName]
07 January 08 09:14 AM | Buck Woody | 1 Comments   
In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the database-level reports. To get to this report, navigate from the server object in Object Explorer, move down to the Databases object, and then right-click Read More...
Using SSMS as a Dashboard
04 January 08 09:10 AM | Buck Woody | 6 Comments   
The other day I was asked by a friend about a recommendation on a “Dashboard” for SQL Server 2005. She wanted to be able to see all the pertinent information about her server with just a few clicks. She asked me what I had used in the past, and wanted Read More...
The Very Big and the very small
03 January 08 09:54 AM | Buck Woody | 2 Comments   
We’ve been seeing a renewed interest in two different areas in databases – embedded databases and large-scale enterprise systems. Sure, the core database audience remains in the department-level and higher sized machines, but as developers are working Read More...
SQL Server Management Studio Standard Reports – All Blocking Transactions: [DatabaseName]
02 January 08 01:22 PM | 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...
We Have a Winner!
01 January 08 08:17 AM | Buck Woody | 1 Comments   
You'll recall that I posted a crossword puzzle in December from the Management Studio framework. We have a winner, selected at random from the correct entries: The artist formerly known as ravenbrk. Here are his winning answers: Across 1 TEXT 2 PROPERTIES Read More...
Page view tracker