• 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

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

    • 8 Comments
    I mentioned in another post that we’ve been asked to bring back the “TaskPad” from SQL Server 7’s Enterprise Manager. As I described there, when we plumbed out that question a little further we found that what people really wanted back is the quick access...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Server Dashboard

    • 6 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). (Note: These reports only work against SQL Server 2005 and higher. They don’t run against the lower versions because those don’t have all the management...
  • Carpe Datum

    Bring Back the TaskPad!

    • 5 Comments
    I mentioned a few posts back that a lot of people asked us to bring back the Query Analyzer, since many just want to jump into the query tool and start typing. I explained that you can get the same behavior – even better, in mu opinion – by just setting...
  • Carpe Datum

    Oh no -3D again

    • 3 Comments
    I spoke with a colleague yesterday and he wants to set up a meeting to talk about 3D interfaces. Inwardly I groaned, but the scientist in me says to go in to the discussion with an open mind. Don’t get me wrong – I’m one of the biggest geeks around...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Configuration Changes History

    • 3 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). (Note: These reports only work against SQL Server 2005 and higher. They don’t run against the lower versions because those don’t have all the management...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Schema Changes History

    • 2 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). The Schema Changes History report shows the changes you’ve made using Data Definition Language statements, similar to the Configuration Changes History...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Scheduler Health

    • 2 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). The Scheduler Health report shows information about each scheduled process that the Instance of SQL Server runs on the processor(s) on your system...
  • Carpe Datum

    Designing Women (and Men)

    • 2 Comments
    I understand some people are having an issue with the last few posts on the standard reports in Management Studio. I’ll look into that – but if you click into them, they seem to work fine. Anyway, I thought I would break from those for one post to...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Memory Consumption

    • 2 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). The Memory Consumption report shows information about how the Instance of SQL Server has partitioned out the memory on your system. Memory is probably...
  • Carpe Datum

    Management by GUI or by Scripts?

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

    It’s two helps in one!

    • 2 Comments
    Did you know that you can show help in two different ways from SQL Server Management Studio? Most of us like the full client of Books Online, which is actually a program called the “DExplorer”. This tool has multiple windows, a URL bar, a search feature...
  • 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

    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

    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

    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

    I need to script with all options. Where are all the options?

    • 1 Comments
    In older versions of SQL Server, when you scripted an object you got a rather large panel that allowed you to set various options such items as DROP’s, users, and more. In SQL Server 2005+, when you right-click and object and select “Script” you don’t...
  • Carpe Datum

    How much do you have to care about the operating system?

    • 1 Comments
    I started with databases a really long time ago, on a mainframe, then moved on to a VAX cluster, and then to UNIX machines. On those platforms, in sort of a descending order, I wasn’t aware of a lot of the lower-level constructs in the operating system...
  • Carpe Datum

    Out Out, Darn Database!

    • 1 Comments
    Have you ever really needed to drop a database and you couldn’t? You’ve tried using the management tools, but you forgot you can’t drop a database when you’re in it, or you’re just fighting a process that just won’t seem to die? Fear not – the following...
  • 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 – 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...
Page 1 of 1 (23 items)