• Carpe Datum

    It’s nice to be important, but it’s more important to be nice

    • 6 Comments
    I’ve been a little “preachy” lately, telling you that you should let people finish their sentences, and always check a problem out before you tell a user that their issue is “impossible”. Well, I’ll round that out with one more tip today. Keep in mind...
  • Carpe Datum

    Performance Counters? There’s a script for that.

    • 9 Comments
    It’s not hard to get Performance Monitor counters in PowerShell 1.0, and it’s REALLY easy in 2.0. This is one I used yesterday to monitor network bytes in and out on 2.0 (keep all of the green lines in this post on the same line) : get-counter -Counter...
  • Carpe Datum

    SQL Server Management Studio Tips and Tricks

    • 0 Comments
    Are you getting everything out of your SQL Server tools that you can? I’ve given you lots of tricks and tips here on my blog, but nothing beats an on-screen demonstration. My good friend and former teammate Bill Ramos did a session on SQL Server...
  • Carpe Datum

    SQL Server Background Picture

    • 1 Comments
    I use a particular background in my presentations that I've been asked about a lot. I thought I would share that here: http://blogs.msdn.com/photos/buck_woody_-_msft/images/9286756/original.aspx
  • Carpe Datum

    Application Lifecycle Management Overview for Windows Azure

    • 1 Comments
    Developing in Windows Azure is at once not that much different from what you’re familiar with in on-premises systems, and different in significant ways. Because of these differences, developers often ask about the specific process to develop and deploy...
  • Carpe Datum

    PowerShell – Show a Notification Balloon

    • 3 Comments
    In my presentations for PowerShell I sometimes want to start a process (like a backup) that will take some time. I normally pop up a notification “balloon” at the start, and then do the bulk of the work, and then pop up a balloon at the end to let me...
  • Carpe Datum

    Templates for New Query Window

    • 4 Comments
    When I’m in SQL Server Management Studio and I click the “New Query” button, my Query Window comes up like this: /* <ScriptFileName, SYSNAME, ScriptFileName>.sql Purpose: <Purpose, SYSNAME, Purpose> Author: <Author, SYSNAME, Buck Woody>...
  • Carpe Datum

    SQL Server Management Studio Projects and Solutions

    • 0 Comments
    Inside SQL Server Management Studio (SSMS), there's a feature I don't see used a great deal. It's called a "Project" and in effect it's just a way to bundle files, connections and scripts into a single package that you can navigate within SSMS...
  • Carpe Datum

    ODBC Drivers Are Updated in Windows 7

    • 1 Comments
    One of the first exposures I had to an ODBC driver was NOT a good one - the particular behavior for ANSI NULLS ended up causing some issues in a database application that I had inherited, so I tend to keep my eye on these things. Mind you, it was back...
  • Carpe Datum

    Bonus Rant: Conference Speakers and the Golden Rule

    • 20 Comments
    Fair warning: This isn’t a technical post. This is my opinion, and not Microsoft’s. I’ve been a public speaker at events since 1980. Interestingly, even though I’ve done this, it’s never been my paid job. I’ve spoken...
  • Carpe Datum

    Cloud Computing and the Code-Based Infrastructure

    • 2 Comments
    In an on-premise system, most of us start fulfilling business computing requirements by making decisions around buy or build. If there is a software package that fills the need of the business, depending on the price of the software and other factors...
  • Carpe Datum

    Start a SQL Server Agent Job using the SQL Server PowerShell Provider

    • 2 Comments
    Whew!  That’s a mouthfull. Anyway, I thought I would share part of a script I wrote today to help automate (more) from PowerShell. This assumes a few things: that you’re doing this from the SQL Server 2008 PowerShell provider (not just good old regular...
  • 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

    Object Search - Search Only What You Need

    • 1 Comments
    At the top of the Object Explorer Details (OED) pane in SQL Server Management Studio 2008 there is a box to type in a search term for database objects. You can use the exact name, or use standard T-SQL wildcards to find an object such as a table or a...
  • Carpe Datum

    Real World DBA Episode 3 – Does Join Order Matter?

    • 0 Comments
    http://edge.technet.com/Media/Real-World-DBA-Episode-3--Does-Join-Order-Matter/ This Week In the news, Microsoft releases a web-based database service. In this week’s feature I’m joined by Joe Webb, who answers the question “Does Join Order Matter...
  • Carpe Datum

    Code that Writes Code - A Good Idea or Not?

    • 1 Comments
    I’m a big fan of code that writes code – most of the time. For instance, whenever you use the “templates” feature in SQL Server Management Studio (SSMS) or the Maintenance Wizard, you’re using code that writes other code. There’s even a trick of writing...
  • Carpe Datum

    Windows Azure Security Review

    • 0 Comments
    Current as of 08/01/2011 - Check the Resources listed below for more up-to-date information on this topic Background: Security for any computing platform involves three primary areas: Principals (users or programmatic access to an asset or other program...
  • Carpe Datum

    How I Work: A Cloud Developer's Workstation

    • 4 Comments
    I've written here a little about how I work during the day, including things like using a stand-up desk (still doing that, by the way). Inspired by a Twitter conversation yesterday, I thought I might explain how I set up my computing environment. First...
  • Carpe Datum

    Using Perfmon with SQL Server – Part One

    • 0 Comments
    I held a workshop on performance tuning in Portland, Oregon yesterday, and as part of that I mentioned a process I follow for automatically collecting Performance Monitor Counters for a system. I use this data to store a baseline and then subsequently...
  • Carpe Datum

    Using Hadooop (HDInsight) with Microsoft - Two (OK, Three) Options

    • 0 Comments
    Microsoft has many tools for “Big Data”. In fact, you need many tools – there’s no product called “Big Data Solution” in a shrink-wrapped box – if you find one, you probably shouldn’t buy it. It’s...
  • Carpe Datum

    SQL Server Standard Reports – Disk Usage: [Database Name]

    • 2 Comments
    We’re in the first of the database-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . To get to these reports, navigate from the server object in Object Explorer, move down to the Databases object...
  • Carpe Datum

    Create your own MCM Program - Learning to Learn

    • 6 Comments
    A lot of electronic ink has been spilled over our recent (and sudden) announcement that we are retiring the highest-level certifications here at Microsoft. At the same time, I'll be teaching a one-day class at the SQL Saturday event in Cambridge, UK on...
  • Carpe Datum

    Windows Azure and SQL Azure Use Cases

    • 6 Comments
    The key to effectively leveraging “Cloud Computing” or more accurately, Distributed Computing architectures like Windows and SQL Azure is to implement them where they make the most sense. This is actually good advice for any computing paradigm...
  • Carpe Datum

    The Top 20 Questions in Database Design

    • 2 Comments
    I'm still re-reading the "Fourth Paradigm" book by Microsoft Research, and one section continues to intrigues me. There's a part where the book explains database design, and puts forth that the most important thing when you're designing large data sets...
  • Carpe Datum

    Help Me Help You Fix That

    • 6 Comments
    If you've been redirected here because you posted on a forum, or asked a question in an e-mail, the person wanted you to know how to get help quickly from a group of folks who are willing to do so - but whose time is valuable. You need to put a little...
Page 4 of 40 (1,000 items) «23456»