February, 2008

  • Carpe Datum

    Engineering or Manufacturing

    • 7 Comments
    From the metrics on this blog, I see that many of you are either software developers or are database administrators involved with developing software solutions, either for your own company or for sale. I have often seen the process of creating applications...
  • Carpe Datum

    Where should the tools be?

    • 5 Comments
    I've got another question for you - where should the tools be? Let me explain. Most of the time when you connect to SQL Server, you open SQL Server Management Studio (SSMS) on a client machine and then type in the name of a server somewhere on the...
  • Carpe Datum

    A Few Links to SQL Server 2008 Resources

    • 5 Comments
    As I was presenting at TechReady yesterday on the new SQL Server 2008 features that will directly affect Microsoft System Center, I was asked a few times about some resources where people could go to learn more about it. I thought I would share that here...
  • 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...
  • 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

    Do we use the same tools and processes at Microsoft that you do?

    • 3 Comments
    I’ve spoken quite a bit about some of the processes and constraints we have in developing software here at Microsoft. I haven’t explained the actual tools or specific paradigms we follow. When some people come to work here, they are often surprised to...
  • Carpe Datum

    System Center Operations Manager and SQL Server

    • 3 Comments
    If you have multiple systems in your organization, and especially if you use multiple kinds of systems (such as exchange, Forefront and SQL Server, for instance) then you might want to check out Microsoft System Center, and in particular, System Center...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Object Execution 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

    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

    What the Developer needs to Know - About Database Programming

    • 2 Comments
    In a previous post, I discussed a few broad-level topics that DBAs need to know about working with database systems. Today I thought I would describe the topics developers need to know about databases to work with them efficiently. Let's start by...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Index Usage 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

    Making our Software Accessible

    • 2 Comments
    Earlier I spoke a little about some of what we go through to localize and globalize our software, and today I thought I might mention a little about how we make it accessible to different kinds of people. I was thinking about this late last night as I...
  • Carpe Datum

    What the DBA needs to know

    • 2 Comments
    What knowledge is needed to effectively manage a database system? That depends, of course, on what you mean by “manage” and “database system". For this discussion, I’ll define “manage” to include not only pure maintenance tasks but also creation and design...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Index Physical 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

    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

    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

    Tips for (getting ready to deal with) Support

    • 1 Comments
    At one time or another, we all need a little help. When you’re knee-deep in Production and you run into a Problem, a little panic is unavoidable. Having a military background, I’ve been taught that the best way to deal with inevitable panic is preparation...
  • Carpe Datum

    Legal aspects of writing software

    • 1 Comments
    Along with some of the other requirements and challenges we face in developing software for the global marketplace are legal ramifications. Almost everything we write, from the name of the feature to the shape of the icons, is usually subject to some...
  • Carpe Datum

    Working to Get the Field Ready

    • 1 Comments
    In the final days before a release, the Program Managers face pressure on two fronts: on one hand, we are asked to work extra hard to get the features ready for the final release. There’s a lot of testing, re-coding and more testing to do. Sure, we have...
  • Carpe Datum

    Localizing Our Software

    • 1 Comments
    If you want to sell (or give away) your software in multiple countries, you need to think about Localization , which simply means ensuring that the application can be used in other places. At Microsoft, and in SQL Server in particular, we actually break...
  • Carpe Datum

    Sharing the Code

    • 1 Comments
    I’ve worked in several multi-developer/multi-DBA shops in my day, and I’ve also taught a few DBA courses here and there. If you’re in the same situation, you know that it’s often important to be able to show your code to others. I have two tips for SQL...
Page 1 of 1 (22 items)