• 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

    Article on SQL Server Chargeback

    • 2 Comments
    I posted the first part of the article on SQL Server Chargeback strategies over on InformIT: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=311 The big point to make is that you will have to develop this system yourself, since there...
  • Carpe Datum

    Using PowerShell and SMO to list Databases (and other stuff)

    • 2 Comments
    You don't have to use the new PowerShell Provider for SQL Server 2008 to talk to SQL Server, even for versions from 2000 up. To do that, you'll need the Server Management Objects (SMO) libraries. You can install those separately, but you'll already...
  • Carpe Datum

    Which Edition of SQL Server is Right For Me?

    • 2 Comments
    If you're planning an installation or an upgrade of your systems, make sure you think about the right edition while you're in the planning process. This includes planning for something that uses SQL Server, such as Sharepoint. As you're aware, there are...
  • Carpe Datum

    Quote of the Day - On being professional

    • 1 Comments
    Sometimes you have a rough day. Sometimes you have a cold, and some days you feel worn down. This is a great quote that reflects what I've seen out of true professionals: "A professional is someone who can do his best work when he doesn't feel like...
  • Carpe Datum

    The PI is Online

    • 1 Comments
    OK, this post doesn't have a direct link to data, but it does have to do with technology. The Seattle Post-Intelligencer newspaper printed it's last issue on paper today, and went totally on-line. A lot of people are upset about this, but I for one am...
  • Carpe Datum

    Simplified SQL Server Licensing

    • 1 Comments
    I run into people all the time that are confused about SQL Server licensing. Now I'm no licensing expert - not by a long shot - and you SHOULD NOT take this post as authoritative in any way. I don't own the licensing story for Microsoft, not even a little...
  • Carpe Datum

    Microsoft Resources To Help You With Your Career

    • 1 Comments
    Last week I presented at the Pacific Northwest Data Professional's Council, and the topic we selected was "The Data Professional's Career". It was pretty non-technical, and during the presentation I gave out lots and lots of resources from Microsoft...
  • Carpe Datum

    Crowd Power

    • 1 Comments
    I recently e-mailed a bunch of friends with three questions that I have been considering. I want to build a killer demo machine, ditch all my lines to the house except for Internet, and buy a home media PC to replace my very old television. I had researched...
  • Carpe Datum

    Migrations and ROI

    • 1 Comments
    We've had a lot of folks switching to SQL Server from other platforms lately. They start looking at SQL Server because many of the other vendors are prohibitively expensive, and they also charge for things that come with SQL Server out of the box, like...
  • Carpe Datum

    Quote of the Day: Easy Technology?

    • 1 Comments
    "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." - Bjarne Stroustrup
  • Carpe Datum

    Logging in to another SQL Server from a PowerShell session

    • 1 Comments
    Whenever you run the command SQLPS.EXE on a SQL Server 2008 system, or right-click an object and select "Start PowerShell Here" from the menu, you're dropped into the environment on that server. But sometimes you want to connect to a different...
  • Carpe Datum

    Virtual Conferences - plug for SSWUG

    • 1 Comments
    At Microsoft we don't often plug products or services, but I wanted to point out the V-Conference they are conducting over at SSWUG. If your travel budgets have fallen apart (as most people's have), this is a great, inexpensive way to get the same kind...
  • Carpe Datum

    Find those rogue SQL Servers in your Enterprise with PowerShell

    • 1 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

    Finding SQL Servers with PowerShell, Part Deux

    • 1 Comments
    A reader named "Ben" wrote me and said that he looked at my script in PowerShell that finds SQL Server Instances using the WMI provider yesterday and he came up with another method. Here's what he wrote: Hi there, I wasn't able to find a way...
  • Carpe Datum

    ... and yet another way to find SQL Server Instances with PowerShell ...

    • 1 Comments
    I got another great comment today on the last two posts: Good article today on searching out SQL servers with PS. The combination of your and Ben's methods work best though. In Ben's example, you have to pull back all the Win32_Service objects and...
  • Carpe Datum

    The Effect of Hardware on SQL Server Performance

    • 1 Comments
    Many DBAs begin to tune a poorly performing database system at the hardware level. This is not always the best idea - most of the issues I've found in performance are in code, not in hardware components. For instance, if you add a good index, the system...
  • Carpe Datum

    SQL Server Security Links

    • 1 Comments
    I was asked yesterday about sharing my security links for SQL Server, so I thought I would post those here: Microsoft Security Bulletin Summaries and Webcasts SQL Server 2000 security tools Security checklists – SQL Server 2000 (can be used as...
  • Carpe Datum

    Quote of the Day - On What We've Really Learned

    • 1 Comments
    Great Quote: "Everything has been said before, but since nobody listens, we have to keep going back and beginning all over again." Andre Gide
  • Carpe Datum

    Security Patches and the Conficker Worm

    • 1 Comments
    Well, the media has done their usual stellar job on computer technology subjects, so after this weekend you may have gotten some questions about the Conficker worm. Here's a few pointers to hand out to the relatives and associates: Microsoft released...
  • Carpe Datum

    Quote of the Day - on keeping your perspective

    • 0 Comments
    At 20 we worry about what others think of us, at 40, we don’t care what they think of us, and at 60, we find out others haven’t been thinking about us at all. - Bob Hope
  • Carpe Datum

    Real World DBA Episode 20 – Help! I’m a new DBA (part two)

    • 0 Comments
    http://edge.technet.com/Media/Real-World-DBA-Episode-20--Help-Im-a-new-DBA-part-two/ This week: In the news, The SQL Server site has been redesigned. In this week’s feature, I’ll give you the final part of a fast introduction to being a DBA...
  • Carpe Datum

    Best Practices Policy Based Management from PowerShell

    • 0 Comments
    I'm working on my Policies (SQL Server 2008 Policy Based Management) for my environments that I manage. I use them to check the maintenance, show system state, and in some cases, to prevent actions from occurring when I don't want them to. I was asked...
Page 1 of 1 (23 items)