• Carpe Datum

    Why on earth are you working on that?

    • 3 Comments
    Much of the development work at Microsoft is a mystery to the rest of the world. People ask me all the time why my team is working on X , when clearly what is needed is Y. Of course, everyone's definition of Y seems to be different, but that's another...
  • 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

    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

    SQL Server Management Studio Standard Reports - Top Transactions by Locks Count

    • 3 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering a report that shows more about locking activity, by transaction. Before I begin describing the columns and values in this report, it might make...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Performance - Batch Execution Statistics

    • 3 Comments
    I’m working my way through the Standard Reports you get in SQL Server Management Studio. I’ve gone through several of them already, and today we finally move out of the locking and blocking reports. The next report in the list, and we’re still only on...
  • 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 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

    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

    Windows 2008 Terminal services and SQL SSMS

    • 3 Comments
    One of our Principal Architects, Eddy Bell, shared a great writeup with me that I think is a great way to leverage Windows 2008 and SQL Server 2008. It answers a need that I've seen over and over again - the ability to connect to SQL Server Management...
  • Carpe Datum

    SQL Server 2008 Management Improvements - Introduction

    • 3 Comments
    Well, it’s the first day of the SQL Connections conference in April of 2008 (yes, on a Sunday, although this will post on Monday) and my booth duties are pretty light. There are some great presenters, among them Kimberly Tripp and Paul Randall, who I...
  • Carpe Datum

    SQL Server 2008 Management Improvements – Data Collectors, the Management Data Warehouse, and Performance Reports

    • 3 Comments
    I’m here at the SQL Connections conference in April of 2008 and I’m giving a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one three of the new performance troubleshooting features in...
  • Carpe Datum

    SQL Server 2008 Feature Pack RC0

    • 3 Comments
    The SQL Server 2008 Feature Pack for RC0 is now live - if you haven't downloaded this and played with it yet, shame on you! :) OK - just kidding - it's not like you don't have a day job. However, if you'll take a few moments and look this download over...
  • Carpe Datum

    The Importance of a Test System

    • 3 Comments
    Most of us have three environments in our organizations: Development, Staging, and Production. But I don't count Staging as a test system. Sure, I use it to do an integration test for code before it goes to the users, but that's not the only kind of testing...
  • Carpe Datum

    The Mythical Silver Bullet

    • 3 Comments
    Have you ever sat in a meeting where you either got the distinct impression, or were told directly that you should just use product X or Feature Y to solve a problem?  Sure, we have a lot of features in SQL Server, but I don't think any of them is...
  • Carpe Datum

    Read the SQL Server Error Log with PowerShell

    • 3 Comments
    This script uses a native client call, so you can use it on any machine that has PowerShell installed along with the SQL Server client software. As always, only run this script on a test system until you understand what it does, and of course you'll need...
  • Carpe Datum

    SQL Server Management Studio - Copy With Headers

    • 3 Comments
    I'm writing this on the train to Seattle to visit with a customer this morning - I'm thankful for Wireless! Although setting up a wireless network for a train is a really big thing, sometimes it's the smaller things that make us happy. In SQL Server Management...
  • Carpe Datum

    It Is The Wise Technologist That Makes Complicated Things Simple

    • 3 Comments
    They say that DBA's are people who put other people into two categories: People who put people into two categories, and people who don't.   I think lots of us put people into categories, not just DBA's.   I've run into a couple of "types"...
  • Carpe Datum

    Replacing the Books Online Search Feature

    • 3 Comments
    Some time back, the Books Online team at Microsoft made a very cool macro on Live.com that would search within the on-the-web version of Books Online – a very handy feature indeed, since the search for the installed version of Books Online is, well...
  • Carpe Datum

    SQL Server Best Practices: AutoClose Should be Off

    • 3 Comments
    When SQL Server "opens" a database, resources are assigned to maintaining that state. Memory for locks, buffers, security tokens and so on is assigned, and there is associated CPU and even a little I/O. When connections are made to the database...
  • Carpe Datum

    Getting a Job: The Catch-22

    • 3 Comments
    A "Catch-22" is a term coined from a book about World War Two, and it involves what DBA's would call a "Deadlock" - one thing depends on another, and both must be complete before either will let go. In the case of a job as a DBA, it...
  • Carpe Datum

    Passed 70-432 - Is that Important?

    • 3 Comments
    I don't like to read technical blogs that have a lot of personal info in them. Sure, I'll rant from time to time, or talk about a technical book I've read and so on, but most people really don't care about your new cat or how you're feeling today. Keep...
  • Carpe Datum

    You have a Voice at Microsoft

    • 3 Comments
    When I was on the product team, I was asked by a few of you from time to time to make a change in SQL Server. Now that I'm in the field, I get asked to "chat with the development team" to make one change or another. But you actually have more...
  • Carpe Datum

    Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance - My Notes So Far

    • 3 Comments
    In a previous post , I started the process of my study for the 70-432 exam. I'm working on that (as I have time) and I promised to post my notes here. My notes aren't totally inclusive, they are just things I found interesting as I was doing my reading...
  • Carpe Datum

    Find those rogue SQL Servers in your Enterprise with PowerShell

    • 3 Comments
    I found a great way to check and see if a server has SQL Server installed on it. It uses “WMI”, or Windows Management Instrumentation and PowerShell. It simply interrogates the Services on a system to see if SQL Server is there, whether it...
  • Carpe Datum

    Setting Up a Killer Demo

    • 3 Comments
    I do a lot of presentations, and I’m often asked how I make sure that the demonstrations go off without a hitch. I have a few tricks I use in case you have to do presentations as well. Here is some of the setup I do to make things go smoothly: 1...
Page 7 of 41 (1,023 items) «56789»