• Carpe Datum

    SQL Server Management Studio Standard Reports – Performance – Top Queries by *

    • 6 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . Today I'm covering four reports at a time – the performance reports that are broken down by average and total times. The reason I’ll cover all four of them is that they...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Index Physical Statistics: [DatabaseName]

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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

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

    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

    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

    SQL Server Management Studio Standard Reports – Transaction Log Shipping Status

    • 4 Comments
    We’re in the final server-level reports in this series of the Standard Reports that ship with SQL Server Management Studio (SSMS) . Don’t worry, there are plenty more reports coming in the database and other objects; but this one is the last of the reports...
  • 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

    How I Work– Working From Home

    • 10 Comments
    I work from home – and I would find it difficult to work any other way. For decades I’ve worked in traditional offices, cubicle-farms, and open-plan work areas. I find them too bright, too loud, too distracting, and in some cases, too depressing to be...
Page 4 of 40 (1,000 items) «23456»