January, 2008

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...