• Carpe Datum

    TechEd 2010 Day Two – No SQL Server in Sight

    • 0 Comments
    Today I worked the booth at TechEd 2010, manning the new “Surface” computer, which is just the coolest object on the planet. After that I didn’t attend a single SQL Server session – instead I’ve been frequenting SharePoint...
  • 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

    Quote of the Day: On Choosing To Succeed

    • 1 Comments
    If you want to do something you will find a way. If you do not want to do something you will find a reason. -Unknown
  • Carpe Datum

    Back up a single table in SQL Server

    • 7 Comments
    SQL Server doesn’t have an easy way to take a table backup, so I often use the bcp (Bulk Copy Program) to accomplish the same goal. I’ve mentioned this before, and someone told me when they tried it they couldn’t restore the table – ah the dangers of...
  • Carpe Datum

    Seek first to understand, then to be understood

    • 1 Comments
    One of the most important (and most difficult) lessons for a technical professional to learn is to not jump to the solution . Perhaps you’ve done this, or had it happen to you. As the person you’re “listening” to is speaking, your mind is performing a...
  • Carpe Datum

    Find Rules and Defaults using the PowerShell for SQL Server 2008 Provider

    • 0 Comments
    I ran into an issue the other day where I couldn't set up some features in SQL Server 2008 because they ddon't support the use of Rules or Defaults. Let me explain a little more about that. In older versions of SQL Server, you could decalre a "Rule" or...
  • Carpe Datum

    You Might Be a DBA

    • 3 Comments
    With all apologies to Jeff Foxworthy, I was up late Friday night on a holiday weekend (which translated into T-SQL becomes “Maintenance Window”) and I got bored in between the two or three minutes I had between clicks. So I started a “Twitter” meme –...
  • Carpe Datum

    Quote of the Day: When You Find that the Ordinary, Isn't

    • 1 Comments
    The wise man is astonished by anything. - Andre Gide
  • Carpe Datum

    I think I’ve finally made it in life. I have a Bobblehead.

    • 7 Comments
    I have no idea why the Marketing group at Microsoft made me into a Bobblehead. Other than this is awesome! I think I’ll call him “Lil Buck”.    
  • 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

    Data-tier Applications in SQL Server 2008 R2

    • 1 Comments
    I had the privilege of presenting to the Adelaide SQL Server User Group in Australia last evening, and I covered the Data Access Component (DAC) and the Utility Control Point (UCP) from SQL Server 2008 R2. Here are some links from that presentation: ...
  • Carpe Datum

    Quote of the day: On backups

    • 1 Comments
    I saw this one yesterday, and it was a slam-dunk for this morning: "Those who do not archive the past are condemned to retype it." - Garfinkel and Spafford
  • Carpe Datum

    Do you have a data roadmap?

    • 0 Comments
    I often visit companies where they asked me “What is SQL Server’s Roadmap?” What they mean is that they want to know where Microsoft is going with our database products. I explain that we’re expanding not only the capacities in SQL Server but the capabilities...
  • Carpe Datum

    What 5 things should SQL Server get rid of?

    • 0 Comments
    I’ve been “tagged” by my friend Paul Randal. It’s a high-tech way of making someone else do what you want, but since it’s Paul, well, I guess I’m OK with that. He’s asked in his recent blog entry “What five things would you get rid of in SQL Server if...
  • Carpe Datum

    Performance-Driven Development

    • 3 Comments
    I was reading a blog yesterday about the evils of SELECT * . The author pointed out that it's almost always a bad idea to use SELECT * for a query, but in the case of SQL Azure (or any cloud database, for that matter) it's especially bad, since you're...
  • Carpe Datum

    SQL Server PowerShell Provider And PowerShell Version 2 Get-Command Issue

    • 0 Comments
    The other day I blogged that the version of the SQL Server PowerShell provider (sqlps) follows the version of PowerShell. That’s all goodness, but it has appeared to cause an issue for PowerShell 2.0. the Get-Command PowerShell command-let returns an...
  • Carpe Datum

    Quote of the day: On Growing Old

    • 0 Comments
    One word: Don't. "Growing old is no more than a bad habit which a busy man has no time to form." - Andre Maurois
  • Carpe Datum

    Book review: Microsoft System Center Enterprise Suite Unleashed

    • 1 Comments
    I know, I know – what’s a database guy doing reading a book on System Center? Well, I need it from time to time. System Center is actually a collection of about 7 different products that you can use to manage and monitor your software and hardware, from...
  • Carpe Datum

    SQL Server PowerShell Provider follows the Version of PowerShell on the Host and other errata

    • 1 Comments
    There may be some misunderstanding on how the PowerShell Provider for SQL Server works. I’ve written an article or two explaining that you can use PowerShell with SQL Server, without having the SQL Server 2008 (or higher) provider around. After all, PowerShell...
  • Carpe Datum

    Testing and Validation – You Really Do Have The Time

    • 0 Comments
    One of the great advantages in my role as a Technical Specialist here at Microsoft is that I get to work with so many great clients. I get to see their environments and how they use them, and the way they work with SQL Server. I’ve been a data professional...
  • Carpe Datum

    But what version is the database now?

    • 0 Comments
    When you upgrade your system to SQL Server 2008 R2, you’ll know that the instance is at that version by using the standard commands like SELECT @@VERSION or EXEC xp_msver. My system came back with this info when I typed those: Microsoft SQL Server 2008...
  • Carpe Datum

    Quote of the Day: Dissenting Opinions

    • 0 Comments
    Seems in our current climate the only thing we can’t tolerate is someone else’s thoughts. The sides of the arguments we hear are those that are the most shrill. In that environment, you’ll notice there are some people in the back that don’t speak up ...
  • Carpe Datum

    Vendors: Partners or Salespeople?

    • 1 Comments
    I got a great e-mail from a friend that asked about how he could foster a better relationship with his vendors. So many times when you work with a vendor it’s more of a used-car sales experience than a partnership – but you can actually make your vendor...
  • Carpe Datum

    SQL Server for the Oracle DBA Links

    • 0 Comments
    I do a presentation (and a class) called "SQL Server for the Oracle DBA". It's a non-marketing overview that gives you the basics of working with SQL Server if you're already familiar wtih how Oracle works. This class and these links DO NOT help you with...
Page 11 of 40 (1,000 items) «910111213»