• 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

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