• Carpe Datum

    Make it Easy for People to Help You

    • 6 Comments
    OK, there are probably a dozen or more of these kinds of posts, but I’ll dive in anyway. From time to time, people send me e-mails or comments on this blog asking for help. Sometimes it’s on the topic at hand, and other times the topic just jogs their...
  • Carpe Datum

    Book review (Book 6) - Wikinomics

    • 6 Comments
    This is a continuation of the books I challenged myself to read to help my career - one a month, for year. You can read my first book review here . The book I chose for November 2011 was: Wikinomics: How Mass Collaboration Changes Everything, by Don Tapscott...
  • Carpe Datum

    Windows Azure and SQL Azure Use Cases

    • 6 Comments
    The key to effectively leveraging “Cloud Computing” or more accurately, Distributed Computing architectures like Windows and SQL Azure is to implement them where they make the most sense. This is actually good advice for any computing paradigm...
  • Carpe Datum

    Certification Notes: 70-583 Designing and Developing Windows Azure Applications

    • 6 Comments
    Last Updated: 07/04/2011 It’s time for another certification, and we’ve released the 70-583 exam on Windows Azure. I’ve blogged my “study plans” here before on other certifications, so I thought I would do the same for...
  • Carpe Datum

    Quote of the Day: On the Efficiency of Government

    • 6 Comments
    "If you put the federal government in charge of the Sahara Desert, in five years there'd be a shortage of sand." - Milton Friedman
  • Carpe Datum

    Don’t mess with the system databases in SQL Server, or Error: 916

    • 6 Comments
    Note: If you’re reading this more than a few months away from July of 2010, do more research. Never trust an old blog as gospel on anything, including my entries. Always refer to Books Online for the authoritative answer, and if it’s wrong...
  • Carpe Datum

    How Does the Cloud Change a Database Administrator’s Job?

    • 6 Comments
    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization . In a way, the Systems Architect has the easiest transition to a new way of using computing technologies. In fact, that’s actually...
  • Carpe Datum

    Management and Monitoring Tools for Windows Azure

    • 6 Comments
    (Last updated on 01/15/2013) With such a large platform, Windows Azure has a lot of moving parts. We’ve done our best to keep the interface as simple as possible, while giving you the most control and visibility we can. However, as with most...
  • Carpe Datum

    Help Me Help You Fix That

    • 6 Comments
    If you've been redirected here because you posted on a forum, or asked a question in an e-mail, the person wanted you to know how to get help quickly from a group of folks who are willing to do so - but whose time is valuable. You need to put a little...
  • Carpe Datum

    Create your own MCM Program - Learning to Learn

    • 6 Comments
    A lot of electronic ink has been spilled over our recent (and sudden) announcement that we are retiring the highest-level certifications here at Microsoft. At the same time, I'll be teaching a one-day class at the SQL Saturday event in Cambridge, UK on...
  • Carpe Datum

    Using SSMS as a Dashboard

    • 6 Comments
    The other day I was asked by a friend about a recommendation on a “Dashboard” for SQL Server 2005. She wanted to be able to see all the pertinent information about her server with just a few clicks. She asked me what I had used in the past, and wanted...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Disk Usage by Table/Top Tables

    • 6 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio . I’m covering two reports at once, since they have the same columns and output, but show the data from a different perspective. These two reports will help you find out...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Server Dashboard

    • 6 Comments
    I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS). (Note: These reports only work against SQL Server 2005 and higher. They don’t run against the lower versions because those don’t have all the management...
  • Carpe Datum

    Change it! No wait, Leave it Alone!

    • 6 Comments
    We've used two major system management paradigms for SQL Server: The Microsoft Management Console (MMC) and the Visual Studio shared components. In early versions of SQL Server, we had Enterprise Manager for most management tasks from a graphical standpoint...
  • Carpe Datum

    Use PowerShell to Backup All User Databases

    • 6 Comments
    This script will back up all user databases - you need to change the BWOODY1\SQL2K8 part to your server\instance name, and of course, you should only run this on a test system until you completely understand it. Unfortunately, the SQL Server PowerShell...
  • Carpe Datum

    SQL Server Best Practices: Auto-Create and Auto-Update Statistics Should Be On - Most of the Time

    • 6 Comments
    SQL Server uses something called the "Query Optimizer" to find the data you're looking for. To do that, there is another mechanism, called "Statistics", which can be created and maintained on columns in a table - even tables that don't have an Index....
  • Carpe Datum

    SQL Server Best Practices: File Layouts

    • 5 Comments
    In a previous post, I mentioned that you should use Filegroups and I talked a little about those. In this post, the best practice I'll point out is where those files should live. As a general rule of thumb, more "spindles" in a database are better...
  • Carpe Datum

    Quote of the Day: The Unreasonable Man

    • 5 Comments
    "The reasonable man adapts himself to the world; the unreasonable one persists to adapt the world to himself. Therefore all progress depends on the unreasonable man." - George Bernard Shaw
  • Carpe Datum

    Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance - My Notes as of 5/3/09

    • 5 Comments
    Well, here's where I'm at so far: Requirements: 1. Install SQL Server 2008 and related services - file locations; default paths; service accounts http://msdn.microsoft.com/en-us/library/ms143547.aspx NTFS is required for installation, but if you upgrade...
  • Carpe Datum

    SQL Server 2008 Object Search

    • 5 Comments
    At the top of the Object Explorer Details (OED) panel, which you can show by pressing F7 in SQL Server Management Studio, you'll find a "Search" text box. If you want to find an object in a particular database, just click on any database object...
  • Carpe Datum

    ERD Designer

    • 5 Comments
    So what are you using for an Entity Relationship Diagran (ERD) tool? I'm teaching a class at the University of Washington and we're doing that part of the class now. I normally use Visio, but find it a little less than perfect for this. And some of the...
  • Carpe Datum

    Scripts, Blogs, and Learning

    • 5 Comments
    I received an e-mail from a reader asking if I could post a link to a script he's documented in an article. I'm always happy to do that, but there are some things you should know about ANY script you find on the web, and while I'm at it, for how you read...
  • Carpe Datum

    Free T-SQL Beautifier

    • 5 Comments
    I do love me some good-looking code. Sure, the syntax has to be there, and the code has to be correct and all that, but I'm old-school, and I think pretty code is easier to read. I'd love to have a "code beautifier" built right in to SQL Server...
  • Carpe Datum

    Script of the day: Count all objects in a database

    • 5 Comments
    This script counts all of your objects in the database, at least the ones stored in the sysobjects table. Some objects (such as jobs) don't show up there - one day I'll add those: /* usc_DBA_Count_Objects.sql Author: Buck Woody Purpose: Shows a quick...
  • Carpe Datum

    Bring Back the TaskPad!

    • 5 Comments
    I mentioned a few posts back that a lot of people asked us to bring back the Query Analyzer, since many just want to jump into the query tool and start typing. I explained that you can get the same behavior – even better, in mu opinion – by just setting...
Page 3 of 40 (999 items) 12345»