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

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

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

    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

    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

    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

    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

    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

    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

    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

    Argh! Bring back Query Analyzer!

    • 8 Comments
    Steve Jones, a friend of mine over at sqlservercentral.com, asked me a question the other day that is brought up quite a bit. In earlier versions of SQL Server, we had at least two management tools: Enterprise Manager (EM) and Query Analyzer (QA). EM...
  • Carpe Datum

    TCO is dead. Long Live TTS!

    • 1 Comments
    It seems that life is all about shortening concepts into three-letter acronyms (TLAs). Every place I've ever worked, from the military to NASA, just loves to create short, catchy names for technical terms. Ah well. The current TLA in vogue is "TCO...
  • Carpe Datum

    What do games have to do with Database Management?

    • 1 Comments
    Plenty. With the release of Halo 3 this week, lots of buzz has been given to the stunning graphics and gameplay. But games like Halo have a lot more to do with Management Tools than you might think. In a game situation, especially mulit-player versions...
  • Carpe Datum

    Elements of Design

    • 1 Comments
    What is the "best" solution for a management tool for SQL Server? If you ask a pure DBa (those technical professionals concerned primarily only with system administration from a database standpoint) you'll get a different answer than you will from a data...
  • Carpe Datum

    Script of the day: Count all objects in a database

    • 5 Comments
    This script counts all of your objects in the database, at least the ones stored in the sysobjects table. Some objects (such as jobs) don't show up there - one day I'll add those: /* usc_DBA_Count_Objects.sql Author: Buck Woody Purpose: Shows a quick...
  • Carpe Datum

    PASS Day Four

    • 0 Comments
    Well, it's the final day of the conference. I have had a fantasitc time, learned a ton of new things, and got to present to one of best group of technical professionals I've ever met. Let me tell you some of the takeaways I got by talking to people...
  • Carpe Datum

    Captain's Log: Supplemental. T-SQL Beautifier

    • 2 Comments
    I love these things - and my friends over at SimpleTalk have a free one: http://www.simple-talk.com/prettifier/
  • Carpe Datum

    PASS Day Three

    • 1 Comments
    Yesterday Ted Kummert (who is the VP in charge of SQL Server for Microsoft) made a bunch of really key announcements about SQL Server 2008 at the keynote: - There will be no price increase for SQL Server 2008 - Dell and Microsoft are working together...
Page 38 of 40 (999 items) «3637383940