• Carpe Datum

    Bonus Rant: Conference Speakers and the Golden Rule

    • 20 Comments
    Fair warning: This isn’t a technical post. This is my opinion, and not Microsoft’s. I’ve been a public speaker at events since 1980. Interestingly, even though I’ve done this, it’s never been my paid job. I’ve spoken...
  • Carpe Datum

    Importing SQL Server 2005 Registered Servers to SQL Server 2008

    • 19 Comments
    The team here discovered something that I thought we should share. I'll get a Knowledge Base (KB) article out soon so that you have something more "official", but I wanted to get this out as soon as I could. A user wrote us and said that when...
  • Carpe Datum

    Should it be easy to delete a database?

    • 18 Comments
    We had a discussion yesterday about Management Studio, and we focused on the “ Delete ” command. In SQL Server 2005, you can right-click a database and select “ Delete ”. You get a panel where you can set some options, or you can just click OK and the...
  • Carpe Datum

    SQL Server Books Online

    • 15 Comments
    Most of us have stacks of books on our shelves about SQL Server. But you also have an amazing resource that you get for free with SQL Server, or even on the web: Books Online. Some of you might not know how SQL Server Books Online is put together and...
  • Carpe Datum

    Buck Woody is Changing Jobs

    • 15 Comments
    Recently I read an article ( http://lifehacker.com/is-it-bad-to-stay-at-one-company-for-very-long-1295782130 ) that stated that if you are at the same company for more than a few years, it will harm your career. I don’t agree – consider...
  • Carpe Datum

    Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance

    • 13 Comments
    Microsoft likes for its people to be certified in as many technologies as possible. Personally, I find certifications useful since they help me focus my study, but I don't think that certification = expert. It's just one part of the puzzle. To that end...
  • Carpe Datum

    Code Collapse and Expand Feature in SQL Server Management Studio 2008

    • 12 Comments
    In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath...
  • Carpe Datum

    Script of the day - Remove White Space from a String

    • 12 Comments
    OK - this might be stretching the "Is this Useful" question a bit, but hey, I needed it today and thought I would share it with you - it's free! This construct takes the whitespace out of a string. /* usc_DBA_Remove_White_Space.sql Removes extra...
  • Carpe Datum

    The Data Saturation Quotient

    • 12 Comments
    I was thinking about something this morning on the ride into work that I’d like to ask your opinion about. It has to do with the amount of data that could be absorbed and acted on by a unit or system in a given period of time. The idea is that there...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – The Full List

    • 12 Comments
    I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information...
  • Carpe Datum

    Puzzle of the Month - this one with prizes!

    • 11 Comments
    OK, it's a shameless giveaway! See if you can fill out this puzzle, made with words you'll find in SQL Server Management Studio. Mail me the answers and I'll send out a small gift to one lucky reader with the right answers, chosen at random at the end...
  • Carpe Datum

    Windows Azure Myths

    • 11 Comments
    Windows Azure is part of the Microsoft "stack" - the suite of software and services we offer. Because we have so many products in almost every part of technology, it's hard to know everything about all parts of what we do - even for those of us who work...
  • Carpe Datum

    Cloud Computing In Action: How I work with Live Mesh, SkyDrive, and Office Live Workspace

    • 11 Comments
    Recently I had an tweetversation with a couple of friends on some confusion around two of our products: SkyDrive and Live Mesh . Like most of our software, there’s no single way to do things. That can be a strength or it can cause that confusion. They...
  • Carpe Datum

    How I Work– Working From Home

    • 10 Comments
    I work from home – and I would find it difficult to work any other way. For decades I’ve worked in traditional offices, cubicle-farms, and open-plan work areas. I find them too bright, too loud, too distracting, and in some cases, too depressing to be...
  • Carpe Datum

    Windows Azure Learning Plan

    • 9 Comments
    Note: On June 7th, Microsoft dramatically enhanced the Windows Azure Platform. I'm leaving this resource here, but an updated version is now here: http://blogs.msdn.com/b/buckwoody/archive/2012/06/13/windows-azure-write-run-or-use-software.aspx ...
  • Carpe Datum

    Performance Counters? There’s a script for that.

    • 9 Comments
    It’s not hard to get Performance Monitor counters in PowerShell 1.0, and it’s REALLY easy in 2.0. This is one I used yesterday to monitor network bytes in and out on 2.0 (keep all of the green lines in this post on the same line) : get-counter -Counter...
  • Carpe Datum

    Doing Everything the Graphical Way (Or maybe not)

    • 9 Comments
    One of the things we try to do in SQL Server Management is to allow you to work in whatever way is suited best for your situation and the way you do your job. Some people like to work with graphical tools, since everything you can do with the product...
  • Carpe Datum

    Argh! Bring back Query Analyzer!

    • 8 Comments
    Steve Jones, a friend of mine over at sqlservercentral.com, asked me a question the other day that is brought up quite a bit. In earlier versions of SQL Server, we had at least two management tools: Enterprise Manager (EM) and Query Analyzer (QA). EM...
  • 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

    SQL Server Best Practices: Setting a Default Filegroup

    • 8 Comments
    When you create a database, you should always create Filegroups to store the data on multiple drives. Don't confuse this with just creating multiple files in a database - that is useful, but not the same. Let's take an example to explain what you want...
  • Carpe Datum

    Idera's Job Manager - Trying it Out

    • 8 Comments
    I've downloaded Idera's free Job Manager this morning and I'm going to play with it a little on one of my test systems. Job Management is a difficult thing to visualize, so the Outlook-format this tool has looks interesting to me. Has anyone implemented...
  • Carpe Datum

    Aren’t DBA’s Just System Admins for Databases?

    • 8 Comments
    Last week I ran into an argument I’ve had since I left the mainframe space decades ago. A developer told me “DBA’s don’t design databases.” The inference was that DBA’s (i.e., Database Administrators) only worry about hardware, security, OS, database...
  • Carpe Datum

    PASS 2008 Conference - Day Five

    • 8 Comments
    Today was the final day of the conference, but I had a packed house for our discussion on PowerShell and SQL Server. I wanted to blog about one concept I covered in the demo: Why would I use PowerShell when I have SSIS, stored procs, batch files and other...
  • Carpe Datum

    Help for SQL Server

    • 8 Comments
    Sometimes issues pop up with your system. You need a way to find help, quickly. Here’s a few links that might be useful – feel free to post a reply to this post with other sources you might know, from web sources to your favorite consultant. Note ...
  • Carpe Datum

    Presentation Links: SQL Server Performance Tuning (Quest)

    • 8 Comments
    I worked with a team of folks brought together by Quest software, and we presented multiple sessions on SQL Server Performance Tuning. Here are the links I mentioned during those presentations: Blitz! SQL Server Takeovers (Brent) You're minding...
Page 1 of 40 (1,000 items) 12345»