• Carpe Datum

    Microsoft Windows Azure Disaster Recovery Options for On-Premises SQL Server

    • 1 Comments
    One of the use-cases for a cloud solution is to serve as a Disaster Recovery option for your on-premises servers. I’ll explain one particular use-case in this entry, specifically using Windows Azure “IaaS” or Virtual Machines as a Recovery...
  • 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

    Create an Excel Graph of your Big Tables – with PowerShell!

    • 4 Comments
    I showed a demo of how to find the top ten tables in the database at the PASS Conference. Here’s that script – you’ll need to fix the server name, instance name, and database name. You can use this to display any numbers – and even more. The mind reels...
  • Carpe Datum

    Real World DBA Episode 5 – The DBA Checklist

    • 1 Comments
    http://edge.technet.com/Media/Real-World-DBA-Episode-5--The-DBA-Checklist/ This week: In the news, learn how you could win an Xbox, just for finding a bug. In this week’s feature, you’ll learn how to create your own DBA checklist. The web link shows...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Memory Consumption

    • 2 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). The Memory Consumption report shows information about how the Instance of SQL Server has partitioned out the memory on your system. Memory is probably...
  • Carpe Datum

    You probably have enough

    • 7 Comments
    This a decidedly non-technical post, and even a little preachy. I post it here because you, the technical professional, are the perfect audience for it. I have enough stuff. I never think so, of course, but I do. I don’t consider myself rich...
  • Carpe Datum

    Script of the day: Count all objects in a database

    • 5 Comments
    This script counts all of your objects in the database, at least the ones stored in the sysobjects table. Some objects (such as jobs) don't show up there - one day I'll add those: /* usc_DBA_Count_Objects.sql Author: Buck Woody Purpose: Shows a quick...
  • Carpe Datum

    SQL Server 2008 Object Search

    • 5 Comments
    At the top of the Object Explorer Details (OED) panel, which you can show by pressing F7 in SQL Server Management Studio, you'll find a "Search" text box. If you want to find an object in a particular database, just click on any database object...
  • Carpe Datum

    SQL Server Best Practices: Set a Fixed Memory Size

    • 0 Comments
    SQL Server allows you to set a “bottom” and “top” range for memory that the Instance will use. The memory will dynamically expand and contract based on Instance need and system pressure. But this flexibility and ease of configuration can (not always,...
  • Carpe Datum

    How Does the Cloud Change a Systems Administrator's Job?

    • 2 Comments
    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization , and another on how the cloud changes a database administrator's job . This time I'll cover a few of the changes the cloud brings...
  • Carpe Datum

    Data Design

    • 0 Comments
    I give series of classes and presentations on Data Design. I say “data” design instead of “database” design because we should consider more than just the database. Data might actually be stored in non-relational stores, such as Excel or XML files, and...
  • Carpe Datum

    Big Data - A Microsoft Tools Approach

    • 2 Comments
    (As with all of these types of posts, check the date of the latest update I’ve made here. Anything older than 6 months is probably out of date, given the speed with which we release new features into Windows and SQL Azure) I don’t normally...
  • Carpe Datum

    SQL Server Management Studio Standard Reports - Overview

    • 8 Comments
    I mentioned in another post that we’ve been asked to bring back the “TaskPad” from SQL Server 7’s Enterprise Manager. As I described there, when we plumbed out that question a little further we found that what people really wanted back is the quick access...
  • Carpe Datum

    PowerShell PowerPack Download

    • 1 Comments
    I read Jeffery Hicks’ article in this month’s Redmond Magazine on a new add-in for Windows PowerShell 2.0. It’s called the PowerShell Pack and it has a some great new features that I plan to put into place on my production systems as soon as I finished...
  • Carpe Datum

    Windows Azure Learning Plan - Architecture

    • 0 Comments
    This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here . This one deals with what an Architect needs to know about Windows Azure. General Architectural Guidance Overview and...
  • 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

    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 Standard Reports – Object Execution Statistics: [DatabaseName]

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

    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

    But what can I *do* with Windows Azure? Create (Free) Websites and Applications

    • 8 Comments
    f you want to know more about Windows Azure, how it works, the components, or more about the entire platform, I’ve written about that here: http://blogs.msdn.com/b/buckwoody/archive/2012/06/13/windows-azure-write-run-or-use-software.aspx But…...
  • 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

    How Does the Cloud Change a Database Administrator’s Job?

    • 6 Comments
    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization . In a way, the Systems Architect has the easiest transition to a new way of using computing technologies. In fact, that’s actually...
  • 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

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

    • 5 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...
Page 3 of 40 (1,000 items) 12345»