• Carpe Datum

    Using SSMS as a Dashboard

    • 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...
  • Carpe Datum

    Transport Systems

    • 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...
  • Carpe Datum

    Why on earth are you working on that?

    • 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...
  • Carpe Datum

    When the PC becomes the server

    • 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...
  • Carpe Datum

    MSDN and TechNet SQL Server Sites Linked

    • 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...
  • Carpe Datum

    The Very Big and the very small

    • 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...
  • Carpe Datum

    Generalists are just second-class citizens

    • 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...
  • Carpe Datum

    My Favorite CodePlex Projects

    • 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...
  • Carpe Datum

    SQL Server Standard Reports – Top Transactions by Blocked Transactions Count: [DatabaseName]

    • 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...
  • Carpe Datum

    Controlling Just One Part of a Maintenance Plan

    • 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...
  • Carpe Datum

    SQL Server Standard Reports – Top Transactions by Age: [DatabaseName]

    • 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...
  • Carpe Datum

    We Have a Winner!

    • 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 ...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – All Blocking Transactions: [DatabaseName]

    • 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...
  • Carpe Datum

    SQL 2K5 for Performance Reports - You have to download these

    • 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...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Resource Locking Statistics by Object: [DatabaseName]

    • 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...
  • Carpe Datum

    Make it an Application or Make it a Platform?

    • 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...
  • Carpe Datum

    SQL Server Management Studio Standard Reports –Database Consistency History: [DatabaseName]

    • 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...
  • Carpe Datum

    Questions and Suggestions

    • 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...
  • Carpe Datum

    Blogs, Blogs and More Blogs

    • 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...
  • Carpe Datum

    Scripts and more scripts

    • 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...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Top Transactions by Locks Count: [DatabaseName]

    • 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...
Page 1 of 1 (21 items)