• Carpe Datum

    Quickly Locate Text in a Query Window in SSMS

    • 4 Comments
    Wow - long title.   Anyway, my good friend Bill Ramos and I were chatting just the other day. He's a the guy at Microsoft that took my old responsibilities for SQL Server Management Studio (SSMS), and we were swapping tips and tricks. He showed me...
  • Carpe Datum

    Quote of the Day: Aesop On Learning

    • 4 Comments
    It is truly remarkable how many things we learn from the ancients - and how much we don't: "Good judgment comes from experience, and experience--well that comes from poor judgment." - Aesop
  • Carpe Datum

    SQL Server Best Practices: File Layouts (Revisited)

    • 4 Comments
    In a previous "SQL Server Best Practice" post , I made reference to file layouts and where various file types should go. I got a comment there that I felt deserved another post. The question was: "...7 individual drives? If this is correct do...
  • Carpe Datum

    DBA's are from Mars; Developers are from Venus

    • 4 Comments
    They say that DBA's are those who put people into two categories: People who put others into two categories, and people who don't. Perhaps we're not quite THAT bad, but we do tend to see order in our world. But we see it in a particular way. I was...
  • Carpe Datum

    SQL Server R2's Killer Feature

    • 4 Comments
    Donald Farmer and I are headed for a smackdown. If you don't know who Donald Farmer is, you probably haven't been to any technical conferences where BI was discussed. He's simply one of the finest minds on the topic that there is. Hius demos are flawless...
  • 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

    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

    What are the most effective learning methods?

    • 4 Comments
    After I got done speaking at the SQL Server 2008 R2 Launch Event yesterday I came back to the hotel room for a web-meeting with some of the other teachers at the University of Washington. As teachers we are always looking to improve the knowledge transfer...
  • Carpe Datum

    The SQL Server Best Practices Analyzer and Policy Based Management

    • 4 Comments
    The SQL Server Best Practices Analyzer (BPA) came out for SQL Server 2008 R2 recently , and I’ve been asked what the difference is between the BPA and Policy Based Management (PBM) that was introduced in SQL Server 2008. While it’s true both of these...
  • Carpe Datum

    The Windows Page File and SQL Server

    • 4 Comments
    What is the best “Page File” size for a Windows system running SQL Server? I see this question over and over – and I see people answering it incorrectly all the time. Note: I’m talking specifically about 64-bit architectures here. The information is different...
  • Carpe Datum

    Is the Internet Making us Smarter or Not?

    • 4 Comments
    I’ve been reading recently about an exchange among some very bright folks, some who posit that the Internet with its instant-on, sometimes-right, big-statement-wins mentality is making people think in a more shallow way, teaching us to rely on others...
  • Carpe Datum

    Challenge: Learn One New Thing Today

    • 4 Comments
    Most of us know that there's a lot to learn. I'm teaching a class this morning, and even on the subject where I'm the "expert" (that word always makes me nervous!) I still have a lot to learn. To learn, sometimes I take a class, read a book, or carve...
  • Carpe Datum

    Backup Meta-Data

    • 4 Comments
    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled...
  • Carpe Datum

    Spit it out already!

    • 4 Comments
    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I...
  • Carpe Datum

    Session Evaluations

    • 4 Comments
    I do a lot of public speaking. I write, teach, present and communicate at many levels. I love to do those things. And I love to get better at them. And one of the ways you get better at something is to get feedback on how you did. That being said,...
  • Carpe Datum

    Big Data and the Cloud - More Hype or a Real Workload?

    • 4 Comments
    Last week Microsoft announced several new offerings for “Big Data” - and since I’m a stickler for definitions, I wanted to make sure I understood what that really means. What is “Big Data”? What size hard drive is that? After all, my laptop has 1TB of...
  • Carpe Datum

    Team Foundation Server (TFS) in the Cloud - My Experience So Far

    • 4 Comments
    I recently joined a software development project that involves not only myself and other internal Microsoft employees, but a partner and a customer as well. We are building a hybrid solution that uses assets on premises as well as Windows Azure for processing...
  • Carpe Datum

    A combination of crowdsourcing, people helping people, and the best technical community there is

    • 4 Comments
    I talk a lot about “giving back”. It’s a personal issue with me – I grew up quite poor, and from time to time someone would take notice that my mom and I didn’t have enough to eat, and they would help us out. I’ve never...
  • Carpe Datum

    The Power of Goals

    • 4 Comments
    Every year we read blogs, articles, magazines, hear news stories and blurbs on making New Year’s Resolutions. Well, I for one don’t do that. I do something else. Each year, on January 1, my wife, daughter and I get up early - like before 6:00 A.M. - and...
  • Carpe Datum

    Free built-in Steps Recorder in Windows for Training, Demos and Documentation - oh, and Troubleshooting too

    • 4 Comments
    There are a lot of features in Microsoft products that people don't know exist - and one of the most useful for IT pro's is the Problem Steps Recorder or PSR. This tool creates a web page compilation of every click or user action that you can annotate...
  • 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

    Conducting Effective Web Meetings

    • 4 Comments
    There are several forms of corporate communication. From immediate, rich communications like phones and IM messaging to historical transactions like e-mail, there are a lot of ways to get information to one or more people. From time to time, it's even...
  • Carpe Datum

    Declarative Architectures in Infrastructure as a Service (IaaS)

    • 3 Comments
    I deal with computing architectures by first laying out requirements, and then laying in any constraints for it's success. Only then do I bring in computing elements to apply to the system. As an example, a requirement might be "world-side availability...
  • Carpe Datum

    Windows Azure Visio Shapes

    • 3 Comments
    Normally when I diagram a solution for a customer, I use whatever they are comfortable with. I do most of my work these days in OneNote, especially when it’s an Architecture Design Session (ADS), since I can capture notes, handwriting, drawings, web pages...
  • Carpe Datum

    But what can I *do* with Windows Azure? Backups

    • 3 Comments
    If 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…...
Page 5 of 40 (1,000 items) «34567»