• 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

    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

    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...
  • Carpe Datum

    Knowing the Business

    • 3 Comments
    I mentioned the other day that I'm teaching a college course at the University of Washington, and as part of that we're doing a complete database project from requirements gathering to a completed database with all its objects. The students have done...
  • Carpe Datum

    Great new Learning Resource

    • 3 Comments
    We have a lot of content out there - a LOT. But how do you find it all? We have a great new resource that one of our team members put together. It’s a customized Windows Live search, that limits results to Books Online. Check this out, and make sure you...
  • 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

    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

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

    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

    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

    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

    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

    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

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