• 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

    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

    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

    SQL Server Best Practices: Auto-Shrink Should Be Off

    • 3 Comments
    SQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close, some of them should be left off. The Auto-Shrink setting is another. That might surprise a few people. You might...
  • 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

    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

    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

    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

    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

    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

    Run a SQL Server Command from PowerShell without the SQL Server Provider

    • 3 Comments
    Some folks don't have SQL Server 2008 installed - shame on you! If you're in that sad state, you can still run a query against a SQL Server. You will still need the client connection software installed on your system - you'll have that with any 2005 edition...
  • 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

    Why DBA’s are Recession-Proof

    • 2 Comments
    That’s a bold statement, isn’t it? Is it true? I don’t know that you’ll never lose your job as a DBA – I’ve known folks who have – but it seems to me that the data in a company will be there even after the company shrinks, folds, gets bought out and whatever...
  • Carpe Datum

    Editing Data from SSMS

    • 2 Comments
    Sometimes you want to edit data directly in a table (often a very bad idea!). In Enterprise Manager (SQL2K) and SQL Server Management Studio (SQL2K5) you right-click a table and select "Open Table" from the menu. That brings back ALL of the rows in the...
  • Carpe Datum

    SQL Server Grows Up

    • 2 Comments
    I spoke at the SQL Saturday event in Olympia, Washington, and I noticed that the questions I got were different than those I used to get for SQL Server. In my former life I managed not only SQL Server but other platforms as well. When I would speak to...
  • Carpe Datum

    Opening SQL Server Profiler from SSMS

    • 2 Comments
    The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you'll see a list of processes that you can order, sort and filter. If you right-click any process, you...
  • Carpe Datum

    Mandelbrots and SQL Server

    • 2 Comments
    I was watching Nova last night and they talked to Benoit Mandelbrot, the man who codified some of the math that bears his name. This math branch deals with "rough" or repeating surfaces. You probably already know that Transact-SQL can be used...
Page 7 of 40 (996 items) «56789»