• 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...
  • Carpe Datum

    Transport Systems

    • 5 Comments
    I’ve worked on a couple of SAP systems, both the “R” flavors and the BW product. Although I had my learning challenges with them, there was one construct there I really liked. It was the transport mechanism. Basically what this involved was setting...
  • Carpe Datum

    A Few Links to SQL Server 2008 Resources

    • 5 Comments
    As I was presenting at TechReady yesterday on the new SQL Server 2008 features that will directly affect Microsoft System Center, I was asked a few times about some resources where people could go to learn more about it. I thought I would share that here...
  • Carpe Datum

    Where should the tools be?

    • 5 Comments
    I've got another question for you - where should the tools be? Let me explain. Most of the time when you connect to SQL Server, you open SQL Server Management Studio (SSMS) on a client machine and then type in the name of a server somewhere on the...
  • Carpe Datum

    SQL Injection Attacks

    • 5 Comments
    You might have read recently that there have been ongoing SQL injection attacks against vulnerable web applications occurring over the last few months. These attacks have received recurring attention in the press as they pop up in various geographies...
  • Carpe Datum

    "Hey.....Hey...Hey...Don't be mean. You don't have to be mean."

    • 5 Comments
    Well, I had another post I had planned for today, but after reviewing some customer bugs and some newsgroups where I give out free help (on my own time, mind you) I had to change my mind. I've seen this behavior in grocery stores, online forums, and bug...
  • Carpe Datum

    MOM 2005 Management Pack for SQL Server 2008 is Available

    • 5 Comments
    We've completed the work on the Microsoft Operations Manager (MOM) "Management Pack" for SQL Server 2008. MOM allows you to monitor and manage Microsoft and even other vendor's servers, so if you have this software in your shop you can download...
  • Carpe Datum

    Using Outlook Tasks for a Performance Review

    • 5 Comments
    At Microsoft, we have a performance review twice a year to ensure we're on track towards meeting the goals that we set up at the beginning of the year with our manager. I've been a manager multiple times in my career, so I've been on both sides of the...
  • Carpe Datum

    Windows Azure Data Series: SQL Server Fast-Track Data Warehouse (FTDW)

    • 5 Comments
    Windows Azure provides several options for storing, processing and retrieving data in structured, semi-structured and unstructured layouts. In this series, I'll cover various options for implementing these options. In this entry, I'll cover the SQL...
  • Carpe Datum

    How I work: Standing Desk Update

    • 5 Comments
    <This is a non-technical post, at least mostly> Back in January I wrote a post on switching to a stand-up desk arrangement . Since then folks have asked me if I stuck with it, how it worked out, and will I go back to sitting down to work. I thought...
  • Carpe Datum

    Azure Design Patterns

    • 5 Comments
    I have a lot of learning resources you can find here at my blog, but I wanted to point one out this morning. It's a Silverlight application called "Azure Design Patterns". You can find it at http://azuredesignpatterns.com/, and it's an interesting way...
  • Carpe Datum

    It’s Data Tier Application and Data Application Component

    • 5 Comments
    OK – In SQL Server 2008 R2 we did “re-use” an acronym or two (DAC and DTA), but it’s important to remember there are actually two parts to this new feature. One is the Data Application Component (DAC) and the other is the Data Tier Application (DTA)....
  • Carpe Datum

    TechEd 2010 Day One – How I Travel

    • 5 Comments
    Normally when I blog on the first day of a conference, well, there hasn’t been a first day yet. So I talk about the value of a conference or some other facet. And normally in my (non-conference) blogs, I show you how I have learned to be a data...
  • Carpe Datum

    The Most Effective Learning Methods – The Results

    • 5 Comments
    Yesterday I posted a blank graph and asked where you thought the labels should go for the most effective learning methods, according to a study they read to me and other teachers here at the University of Washington. Here are the labels in the correct...
  • 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...
Page 4 of 40 (999 items) «23456»