• Carpe Datum

    Templates

    • 1 Comments
    I’ve run into quite a few DBA’s who aren’t using the Templates feature we provide with SQL Server Management Studio. If you spend a little time becoming familiar with them, I think you’ll find they are a powerful tool. Templates are really just a series...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Performance – Top Queries by *

    • 5 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . Today I'm covering four reports at a time – the performance reports that are broken down by average and total times. The reason I’ll cover all four of them is that they...
  • Carpe Datum

    CTP5 is out! OK, so maybe you already know that...

    • 1 Comments
    I got back from vacation ( more here if you want to read about where we go and what we do every other week) and we released SQL Server 2008 CTP5. If you have been waiting for a bit to install and learn more about it, this is a good release to try. Make...
  • Carpe Datum

    Happy Thanksgiving

    • 2 Comments
    I'll be offline for about a week. For those of you reading this blog outside of the US, we have a holiday called "Thanksgiving" where we are all encouraged to be thankful for the things we have. I think this is a great tradition, and one of the things...
  • Carpe Datum

    More info on those reports

    • 1 Comments
    I spoke with Andrew Fryer yesterday via e-mail when I noticed he was also covering some of the same information we're looking at here on the Standard Reports in SQL Server. I think that's great - I had been wondering if there were many people using these...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Performance - Object Execution Statistics

    • 0 Comments
    We're in the performance section of the series of Standard Reports you get with SQL Server Management Studio . The report we're covering today, located in the "Server" level of reports is another Performance Report, and it is interesting because it brings...
  • Carpe Datum

    It's the little things that count

    • 2 Comments
    As I've mentioned, I've only been in my current role a few months. I've inherited a lot of things from the Program Managers who have gone before me, so I can't take credit or blame for everything I'm now responsible for. But going forward, I want to do...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Performance - Batch Execution Statistics

    • 3 Comments
    I’m working my way through the Standard Reports you get in SQL Server Management Studio. I’ve gone through several of them already, and today we finally move out of the locking and blocking reports. The next report in the list, and we’re still only on...
  • Carpe Datum

    The Importance of Connections

    • 2 Comments
    Since I didn't blog about anything very technical in my last entry, I thought I would post a little something about what we're hearing about the "Connection" dialogs. We have quite a few places in Management Studio that we pop up a place for you to connect...
  • Carpe Datum

    Everything I need to be a good worker I learned in parenting

    • 1 Comments
    (OK – this has almost nothing to do with technology – something I read really irked me) I use the time on the unbelievably long bus ride home (don’t even get me started about the traffic up here. Only California compares to this mess) to clear out...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Top Transactions by Locks Count

    • 3 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering a report that shows more about locking activity, by transaction. Before I begin describing the columns and values in this report, it might make...
  • Carpe Datum

    Are you using what you already have?

    • 2 Comments
    We get a lot of suggestions for our tools here at Microsoft. We get some really good tips about how people are using the tools, and we get some instructions about what we can do to make them better. And we also get requests for features in the tools that...
  • Carpe Datum

    Top Transactions by Blocked Transactions Count

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering a report that shows the transactions on an instance that block others. I’ve described some of this blocking activity here , but this report orders...
  • Carpe Datum

    The Pain of Triage

    • 1 Comments
    The Program Managers here at Microsoft get work from three main buckets. There are things that we have that are broken (bugs), things that we have that people want more/different/other features in (enhancements), and new features (Improvements). As with...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Activity – Top Transactions by Age

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering another "Activity" report. This report shows more information about transactions, which I’ve covered in some of the other reports. This one, however...
  • Carpe Datum

    What does "Writing Good Software" Mean? Good for Who?

    • 2 Comments
    I’ve mentioned before on this blog a little about how we write software here at Microsoft. I think it’s great that we are allowed to talk about it – in fact, we’re encouraged to be open about it. That’s very different from many other software firms I...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Activity – Top Connections

    • 2 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering another "Activity" report. I covered other activity reports, most from the viewpoint of users or sessions. This report shows much of the same information...
  • Carpe Datum

    Should it be easy to delete a database?

    • 18 Comments
    We had a discussion yesterday about Management Studio, and we focused on the “ Delete ” command. In SQL Server 2005, you can right-click a database and select “ Delete ”. You get a panel where you can set some options, or you can just click OK and the...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Activity – Dormant Sessions

    • 0 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering another "Activity" report. The Activity – Dormant Sessions report shows you the sessions you have on SQL Server that are connected, and perhaps...
  • Carpe Datum

    Doing Everything the Graphical Way (Or maybe not)

    • 9 Comments
    One of the things we try to do in SQL Server Management is to allow you to work in whatever way is suited best for your situation and the way you do your job. Some people like to work with graphical tools, since everything you can do with the product...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Activity - All Sessions and Activity - Top Sessions

    • 2 Comments
    I'm continuing my serie s on the Standard Reports in SQL Server Management Studio , and today I'm covering two of them: Activity - All Sessions and Activity - Top Sessions. These are part of the a activity series of reports that provide more detail than...
  • Carpe Datum

    Task-based or object-based?

    • 1 Comments
    Some platform management system designs focus on Task-Based events. You'll see this in programs like the MySQL Admin tool, especially the version for the Mac. I installed this to manage the MySQL system on my Mac at home, and the top row of icons contain...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Activity - All Cursors and Activity - Top Cursors

    • 2 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering two of them: Activity - All Cursors and Activity - Top Cursors. These are part of the activity series of reports that provide more detail than the...
  • Carpe Datum

    Whither the Joy?

    • 1 Comments
    It seems sometimes that the “joy’ of a particular vocation fades. No, I’m not in one of those places today, but I have been from time to time. You’ve probably been there yourself – when the job you have just isn’t as much fun as it once was. This can...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Activity - All Blocking Transactions

    • 2 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). We're now up to the "Activity" reports, which show more information than you'll find in SQL Server Management Studio in the "Activity Monitor" node...
Page 37 of 40 (996 items) «3536373839»