Year: 2007

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 a little leather…

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, click the “Standard Reports”, and then select the title at the top of this…

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, click the “Standard Reports”, and then select the title at the top of this…

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/

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 report, navigate from the server object in Object Explorer, move down to the Databases object,…

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 the question, “if…

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, which will soon be offered on DVD, of the SQL Server 2005 Internals. You should also…

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 the size and shape of your tables. You might have a table…

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 able to talk to each other very…

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, and then right-click any database. From the menu that appears, select Reports, then…