• Carpe Datum

    Cloud Computing Patterns: Using Data Transaction Commitment Models for Design

    • 0 Comments
    There are multiple ways to store data in a cloud provider, specifically around Windows and SQL Azure. As part of a “Data First” architecture design, one decision vector – assuming you’ve already done a data classification of the...
  • 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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    How Does the Cloud Change a Systems Architect’s Job?

    • 1 Comments
    I know - I said I didn't like the "cloud" term, but my better-phrased "Distributed Systems" moniker just never took off like I had hoped. So I'll stick with the "c" word for now, at least until the search engines catch up with my more accurate term. ...
  • 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

    DevOps for Windows Azure

    • 0 Comments
    "DevOps" (Short for Dev eloper Op eration s ) is one of a group of new terms such as "Cloud", "Big Data" and "Data Scientist" - words that are somewhere between marketing and tasks we've actually had around in other forms for years.However, working in...
  • Carpe Datum

    Create Outlook Appointments from PowerShell

    • 1 Comments
    I've been toying around with a script to create a special set of calendar objects in Outlook that show when my SQL Server Agent Jobs are scheduled to run. I haven't finished yet, but I thought I would share the part that creates the Outlook Appointments...
  • 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

    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»