• Carpe Datum

    The Enterprise DBA

    • 1 Comments
    In a couple of other posts, I’ve covered some of the challenges and strategies for dealing with those challenges that DBAs face. I mentioned that in my experience, the answers depend on the “kind” of DBA you are. I've covered the “single-seat” DBA and...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Notification Services - General

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that...
  • Carpe Datum

    Real World DBA: Episode 4 - Prepping for Install

    • 1 Comments
    http://edge.technet.com/Media/Episode-4-Prepping-for-Install/ This week: In the news, Microsoft has updated the community links for SQL Server. In this week’s feature, I’ll explain the “big deal” about preparing for an installation, the web link...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Number of Errors

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that...
  • Carpe Datum

    "Hey.....Hey...Hey...Don't be mean. You don't have to be mean."

    • 5 Comments
    Well, I had another post I had planned for today, but after reviewing some customer bugs and some newsgroups where I give out free help (on my own time, mind you) I had to change my mind. I've seen this behavior in grocery stores, online forums, and bug...
  • Carpe Datum

    Theory or Practice?

    • 2 Comments
    As most of you know, I'm big on practical advice. My Podcast is even called the "Real World DBA" . I think until something becomes concrete, it's tough to buy off on it. On the other hand... I work in theoretical settings all day long. I deal with...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Tasks

    • 3 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that...
  • Carpe Datum

    Real World DBA Episode 3 – Does Join Order Matter?

    • 0 Comments
    http://edge.technet.com/Media/Real-World-DBA-Episode-3--Does-Join-Order-Matter/ This Week In the news, Microsoft releases a web-based database service. In this week’s feature I’m joined by Joe Webb, who answers the question “Does Join Order Matter...
  • Carpe Datum

    Time-based Optimization

    • 1 Comments
    One of the primary jobs of both developers and DBAs is optimization, or its more common name, performance tuning. Lots of the management tools improvements for SQL Server 2008 are aimed at performance, such as the new activity Monitor. Using the...
  • Carpe Datum

    The Organizational DBA

    • 4 Comments
    I posted another entry about a question I received as to the most effective management processes are for a DBA, and in that post I mentioned that the answer was "it depends". There are a lot of ways to slice and dice the information, but I think a convenient...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Resource Locking Statistics by Logins

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security...
  • Carpe Datum

    The Small Shop DBA/Developer

    • 2 Comments
    I’ve been asked what the most effective management processes are, and of course the answer is (as always) “it depends”. It depends because the size of the shop often dictates how much time you have to devote to your systems, how big those systems are...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Login Failures

    • 2 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security...
  • Carpe Datum

    Real World DBA Episode 2 - Using the Right Identity

    • 1 Comments
    http://edge.technet.com/Media/Real-World-DBA-Episode-2-Using-the-Right-Identity/ (Note - there was one section in the podcast where I was not clear about the intent of a statement. Please see the "Addendum" section below for more on that!) This...
  • Carpe Datum

    Do You UML?

    • 2 Comments
    As part of my job I model quite a few things. I'm familiar with serveral modeling languages, and the two I use most often are Business Process Model Notation (BPMN) and the Unified Modeling Language (UML). I find that a picture is worth a thousand specs...
  • Carpe Datum

    Excited about the Improvements

    • 1 Comments
    I started working in this team last August, so I really came in near the end of the new work on SQL Server 2008. Thankfully I was still able to get quite a few improvements and changes into a few of the management tools in the last few months. I am compiling...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Login Statistics

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security...
  • Carpe Datum

    Customer Meeting on Accessibility

    • 3 Comments
    Yesterday I had the privilege of meeting with a DBA who was visiting us from Australia. He is an amazing fellow. He originally set out to be a doctor, but found that he was losing his sight. He switched to studying law, but found that he enjoyed technology...
  • Carpe Datum

    SQL Server Management Studio Standard Reports –Active Full Text Catalogs: [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

    Real-World DBA Podcast Show Notes – Episode 1: SQL Server Editions

    • 3 Comments
    http://edge.technet.com/Media/Real-World-DBA-Episode-1-SQL-Server-Editions/ The Zune(OK, iPod works too) link for subscription is here: http://edge.technet.com/Tags/Real+World+DBA/feed/ipod/ And the general RSS feed is here: http://edge.technet.com...
  • Carpe Datum

    SQL Server Management Studio Standard Reports –Service Broker Statistics: [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

    Introducing the Real World DBA

    • 2 Comments
    On the bus-ride to work, I listen to some music while I work on the laptop, and each morning I listen to a Podcast or two. Some are very good - others are just passable - so I thought I would toss my hat in the ring. In the next couple of weeks I'll...
  • Carpe Datum

    Setting up a Testing System

    • 1 Comments
    I build a new SQL Server just about every other day. As we write new software or fix bugs on old software, we create a new installation of SQL Server. Those of us who are testing the fixes, creating new features and so on have to install these new versions...
  • Carpe Datum

    SQL Server Management Studio Standard Reports –User Statistics: [DatabaseName]

    • 3 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 – Schema Changes History: [DatabaseName]

    • 4 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...
Page 34 of 40 (1,000 items) «3233343536»