SQL Server Management Studio Standard Reports – Activity – Top Connections

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, but from the viewpoint of a connection. This is useful in large organizations or…

2

Should it be easy to delete a database?

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 database is gone. Unless, that is, there are people connected…

18

SQL Server Management Studio Standard Reports – Activity – Dormant Sessions

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 at one time even ran some query, but aren’t doing anything right now. There’s a…

0

Doing Everything the Graphical Way (Or maybe not)

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 is “discoverable” from the interface,…

9

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

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 the “Activity Monitor” panel. Activity – All Sessions I’ll start…

2

Task-based or object-based?

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 what are basically a task list based on things you…

1

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

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 “Activity Monitor” panel. One thing that I haven’t mentioned yet is…

2

Whither the Joy?

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 happen for a lot of…

1

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

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. That view is more immediate; these reports show more detail. This particular report…

2

Management by GUI or by Scripts?

I work in the part of SQL Server that is all about SQL Server Management. I handle the graphical tools, and another person handles the command-line stuff. Which is kind of interesting, since in my career I’ve mostly used scripting to manage my systems. But I see a place for both. I think graphical tools…

2