• Carpe Datum

    Direct Contact with SQL Server's Future

    • 3 Comments
    Many times I'm asked "does Microsoft ever ask the users what they want in SQL Server"? Yes, we do. A lot, actually. And you can be a part of that conversation. For starters, you can hit the http://connect.microsoft.com site, read up on how it works...
  • Carpe Datum

    Databases are the longest-lived component

    • 3 Comments
    Most of you know that I write a technical article each week for the InformIT website - you can see a list of all my articles here . I’ve been writing for that site for – well, a really long time. I have articles all the way back to SQL Server...
  • Carpe Datum

    The New World of Work: Swarms

    • 3 Comments
    I’ve been reading some excerpts from Gartner, Inc. and information from others on the changes they are seeing in the workplace. It’s holding true where I work and in the workplaces of the other data professionals I work with. One of those...
  • Carpe Datum

    The New World of Work: Hyper-Connectivity and Work/Life Blur

    • 3 Comments
    In my last couple of posts I’ve mentioned a new world of work environment put forth by the Gartner Group’s Tom Austin, with a few additions from my own perceptions. I’ve mentioned “swarming” and that we deal with more unique...
  • Carpe Datum

    Which Azure Cloud Storage Model Should I Choose for my Application?

    • 3 Comments
    Most applications have four parts – input, computation, storage and output. I’ll write about all of these over time, but today I want to focus on how to choose the storage part of the equation. This won’t be a full tutorial, full of...
  • Carpe Datum

    Head in the Clouds–Eyes on the Books

    • 3 Comments
    I normally post technical topics here on this blog, but I’m extending this post a bit to include a little professional development. Don’t worry; there’s some tech (and Distributed Computing tech, no less) in this post as well. I recently...
  • Carpe Datum

    You Probably Already Have a “Private Cloud”

    • 3 Comments
    I’ve mentioned before that I’m not a fan of the word “Cloud”. It’s too marketing-oriented, gimmicky and non-specific. A better definition (in many cases) is “Distributed Computing”. That means that some or all of the computing functions are handled somewhere...
  • Carpe Datum

    Should I learn Cloud Computing Next?

    • 3 Comments
    My previous role at Microsoft was in the SQL Server team. I spent quite a bit of time there, and had some really great experiences. I was able to travel and speak as well as doing my “regular” job in the programming team, so I got to meet a lot of people...
  • Carpe Datum

    Quote of the Day–On Determination versus Talent

    • 3 Comments
    A determined soul will do more with a rusty wrench than a talented loafer will accomplish with all the tools in a machine shop. - Robert Hughes
  • Carpe Datum

    Presenting the Cloud in a Different Way

    • 3 Comments
    I had the honor of presenting the Developers at the Portland PASS chapter, and decided to go a different way than just using PowerPoint Slides…. (click on any picture to enlarge) The point is that when you need to get a point across, it’s OK to change...
  • Carpe Datum

    The Database Design Process

    • 3 Comments
    I need your help. I know how I create databases, and I’ve watched a lot of other data professionals follow their own processes for that, but I want to know how YOU do it. I’ve written about the process I follow for a complete database design on...
  • Carpe Datum

    PowerShell – Show a Notification Balloon

    • 3 Comments
    In my presentations for PowerShell I sometimes want to start a process (like a backup) that will take some time. I normally pop up a notification “balloon” at the start, and then do the bulk of the work, and then pop up a balloon at the end to let me...
  • Carpe Datum

    Agile isn’t always Agile

    • 3 Comments
    I want to make a disclaimer before I dive into this topic – At Microsoft we use all kinds of development methodologies, and I’ve worked in lots of other shops using lots of methodologies. This is one of those “religious” topics like which programming...
  • 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

    My Performance Tuning Methodology

    • 3 Comments
    I was speaking with some folks yesterday about tuning a system, and they asked me about my methodology. As time goes on, I find myself doing things differently based on the situation, but there is a general approach I use that I'll explain here. This...
  • 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

    The Importance of a Test System

    • 3 Comments
    Most of us have three environments in our organizations: Development, Staging, and Production. But I don't count Staging as a test system. Sure, I use it to do an integration test for code before it goes to the users, but that's not the only kind of testing...
  • Carpe Datum

    The Mythical Silver Bullet

    • 3 Comments
    Have you ever sat in a meeting where you either got the distinct impression, or were told directly that you should just use product X or Feature Y to solve a problem?  Sure, we have a lot of features in SQL Server, but I don't think any of them is...
  • Carpe Datum

    SQL Server Management Studio - Copy With Headers

    • 3 Comments
    I'm writing this on the train to Seattle to visit with a customer this morning - I'm thankful for Wireless! Although setting up a wireless network for a train is a really big thing, sometimes it's the smaller things that make us happy. In SQL Server Management...
  • Carpe Datum

    It Is The Wise Technologist That Makes Complicated Things Simple

    • 3 Comments
    They say that DBA's are people who put other people into two categories: People who put people into two categories, and people who don't.   I think lots of us put people into categories, not just DBA's.   I've run into a couple of "types"...
  • Carpe Datum

    SQL Server Best Practices: AutoClose Should be Off

    • 3 Comments
    When SQL Server "opens" a database, resources are assigned to maintaining that state. Memory for locks, buffers, security tokens and so on is assigned, and there is associated CPU and even a little I/O. When connections are made to the database...
  • Carpe Datum

    SQL Server Best Practices: Auto-Shrink Should Be Off

    • 3 Comments
    SQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close, some of them should be left off. The Auto-Shrink setting is another. That might surprise a few people. You might...
  • Carpe Datum

    Replacing the Books Online Search Feature

    • 3 Comments
    Some time back, the Books Online team at Microsoft made a very cool macro on Live.com that would search within the on-the-web version of Books Online – a very handy feature indeed, since the search for the installed version of Books Online is, well...
  • Carpe Datum

    Getting a Job: The Catch-22

    • 3 Comments
    A "Catch-22" is a term coined from a book about World War Two, and it involves what DBA's would call a "Deadlock" - one thing depends on another, and both must be complete before either will let go. In the case of a job as a DBA, it...
  • Carpe Datum

    You have a Voice at Microsoft

    • 3 Comments
    When I was on the product team, I was asked by a few of you from time to time to make a change in SQL Server. Now that I'm in the field, I get asked to "chat with the development team" to make one change or another. But you actually have more...
Page 6 of 40 (1,000 items) «45678»