• 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

    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

    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

    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

    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

    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

    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

    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

    New Year's Goals

    • 1 Comments
    Happy New Year! Do you make New Year's resolutions? I don't do that. Instead, my family and I always go out first thing New Year's Day (we don't party much on New Year's Eve - I know, I'm kinda weird like that) and find a food joint that is open. We...
  • Carpe Datum

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

    • 2 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 Server Management Studio Standard Reports – Backup and Restore Events: [DatabaseName]

    • 2 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

    Shameless Self-Promotion

    • 1 Comments
    I wrote a two-part article over on SQLServerCentral.com that you may want to check out on "How to become a DBA". Even if you already are a DBA, it's a great resource to point aspiring applicants to: http://www.sqlservercentral.com/articles/Administration...
  • Carpe Datum

    SQL Server Standard Reports – Database: Disk Usage by Partition: [DatabaseName]

    • 2 Comments
    In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the database-level reports. Today I’ll explain another report dealing with space in the database: Disk Usage by Partition: [DatabaseName] . To get to...
  • Carpe Datum

    The Most Important Skill You Can Have

    • 3 Comments
    OK - it's a little light in some of the hallways because of Christmas, so I had a few minutes to actually chat with some friends. We played one of those mental games where you ask "if you could only have one thing for X, what would it be". I was asked...
  • Carpe Datum

    SQL Server Internals Course

    • 1 Comments
    We normally don't recommend one product or vendor over another, but sometimes there is an industry-recognized expert that has something particularly valuable. Kalen Delaney has a course you might be interested in - definitely check it out. It's a course...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables

    • 6 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . I’m covering two reports at once, since they have the same columns and output, but show the data from a different perspective. These two reports will help you find out...
  • Carpe Datum

    Sticking to Standards

    • 1 Comments
    I was working on a Functional Specification today, and I opened a tool to create two UML diagrams. We use UML as a standard, so I normally create fairly detailed use case and sequence diagrams for the developers. I find it's a great tool for us to be...
  • Carpe Datum

    SQL Server Standard Reports – Disk Usage: [Database Name]

    • 2 Comments
    We’re in the first of the database-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . To get to these reports, navigate from the server object in Object Explorer, move down to the Databases object...
  • Carpe Datum

    Puzzle of the Month - this one with prizes!

    • 11 Comments
    OK, it's a shameless giveaway! See if you can fill out this puzzle, made with words you'll find in SQL Server Management Studio. Mail me the answers and I'll send out a small gift to one lucky reader with the right answers, chosen at random at the end...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Transaction Log Shipping Status

    • 4 Comments
    We’re in the final server-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . Don’t worry, there are plenty more reports coming in the database and other objects; but this one is the last of the reports...
  • Carpe Datum

    The Data Saturation Quotient

    • 12 Comments
    I was thinking about something this morning on the ride into work that I’d like to ask your opinion about. It has to do with the amount of data that could be absorbed and acted on by a unit or system in a given period of time. The idea is that there...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Service Broker Statistics

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . Today I'm covering a report on a feature you might not have used yet – the Service Broker. This feature, which you can read more about here , allows you to set up a messaging...
  • Carpe Datum

    Are these really blogs or not?

    • 3 Comments
    Steve Jones, my friend over at SQLServerCentral.com had a podcast the other day (Voice of the DBA) where he commented that blogs should be blogs - not a form of corporate communication. I agree. It's not that you can't have corporate content on an RSS...
  • Carpe Datum

    Do you code or Don'tcha?

    • 1 Comments
    I've met a lot of DBA's that don't do a lot of coding. Sure, they know basic T-SQL, and are probably pretty handy with a scripting language, but they don't write code for a living. In some shops where I've worked (usually larger ones) we had separate...
  • Carpe Datum

    Go get me a switch!

    • 2 Comments
    You probably access SQL Server Management Studio (SSMS) using an icon somewhere in your Start menu or on your desktop. But did you know that there are several command-line switches that you can use to start SSMS and end up right where you want to go?...
Page 36 of 40 (996 items) «3435363738»