• 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 Standard Reports – Database: Disk Usage by Partition: [DatabaseName]

    • 2 Comments
    In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the database-level reports. Today I’ll explain another report dealing with space in the database: Disk Usage by Partition: [DatabaseName] . To get to...
  • Carpe Datum

    Windows Azure Use Case: High-Performance Computing (HPC)

    • 0 Comments
    This is one in a series of posts on when and where to use a distributed architecture design in your organization's computing needs. You can find the main post here: http://blogs.msdn.com/b/buckwoody/archive/2011/01/18/windows-azure-and-sql-azure-use-cases...
  • Carpe Datum

    SQL Server Desktop Screen Background

    • 0 Comments
    I was doing a presentation recently and was asked about the image I use as my background on my desktop. I’m happy to share it! Click below for the full size:
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Resource Locking Statistics by Object: [DatabaseName]

    • 1 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears...
  • Carpe Datum

    PowerShell to the clipboard

    • 1 Comments
    In PowerShell 2.0, there's a command to get things to the clipboard. I haven't deployed 2.0 yet, though, since I'm a DBA and naturally paranoid about anything beta on my systems. So I searched for other ways to do that, and there are a few, but then I...
  • Carpe Datum

    Windows 2008 and Replication

    • 2 Comments
    I mentioned in a previous post that I would point out where SQL Server 2008 takes advantage of improvments in Windows 2008 (Check out the "Windows 2008" tag below for that). I just had to share something I got today from the replication team in an e-mail...
  • Carpe Datum

    Slipstreaming SQL Server Installations and the SP1 Controversy

    • 2 Comments
    Yesterday, along with several hundred other folks, I told you that SQL Server 2008 Service Pack 1 was out, and where to download it. I also mentioned that one of the big advantages in it was that you could now do "slipstream" installations....
  • Carpe Datum

    How Does the Cloud Change a Developer's Job?

    • 0 Comments
    I've recently posted a blog on how cloud computing would change the Systems Architect’s role in an organization , another on how the cloud changes a Database Administrator's job , and the last post dealt with the Systems Administrator . In this...
  • Carpe Datum

    List SQL Server Instances using the Registry

    • 0 Comments
    I read this interesting article on using PowerShell and the registry , and thought I would modify his information a bit to list the SQL Server Instances on a box. The interesting thing about listing instances this was is that you can touch remote machines...
  • Carpe Datum

    The Top-Five Most Valuable Development Team Positions

    • 7 Comments
    In many organizations, there’s a push to save cost. “Cost” is an integral part of a profit-and-loss statement in the organization. Even if you work in a non-profit organization, cost control is central. Of course, you can take cost-control...
  • 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

    SQL Server 2008 Improvements Practicals - Connection Dialogs, Central Management Servers, and Multi-Server Queries

    • 1 Comments
    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's what I showed for 8:00am - "Good Morning Sunshine": The first enhancement is the new options for strings that you can add in the connection...
  • Carpe Datum

    Read the SQL Server Error Log with PowerShell

    • 3 Comments
    This script uses a native client call, so you can use it on any machine that has PowerShell installed along with the SQL Server client software. As always, only run this script on a test system until you understand what it does, and of course you'll need...
  • Carpe Datum

    Windows Azure Database (SQL Azure) Development Tip

    • 0 Comments
    When you create something in the cloud, it's real, and you're charged for it. There are free offerings, and you even get free resources with your Microsoft Developer Network (MSDN) subscription, but there are limits within those. Creating a 1 GB database...
  • Carpe Datum

    SQL Server Management Studio Standard Reports – Schema Changes History: [DatabaseName]

    • 4 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears...
  • Carpe Datum

    Windows Azure Learning Plan - SQL Azure

    • 0 Comments
    This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here . This one deals with SQL Azure. There are a series of videos here you can use for a complete overview: Getting Started: SQL Azure at a Glance...
  • Carpe Datum

    Why Use PowerShell with SQL Server?

    • 1 Comments
    If you've never read the "scripting guys" at Microsoft, they are a hoot. Ed Wilson and Craig Liebendorfer do a fantastic job of writing each week and helping with scripting of all kinds, including PowerShell. Well, this week they appointed me...
  • Carpe Datum

    T-SQL to Find Physical and Logical Processors

    • 1 Comments
    I ran into a licensing question the other day on Physical versus Logical Processors. Happily, Microsoft only charges you for Physical sockets - which you can find with this query: SELECT cpu_count / hyperthread_ratio AS PhysicalCPUs FROM sys.dm_os_sys_info...
  • Carpe Datum

    Windows Azure Learning Plan - Other Features

    • 0 Comments
    This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here . This one deals with the Application Fabric for Windows Azure. It serves three main purposes - Access Control, Caching, and as a Service Bus. ...
  • 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

    Windows Azure Use Case: Elastic Scale

    • 1 Comments
    This is one in a series of posts on when and where to use a distributed architecture design in your organization's computing needs. You can find the main post here: http://blogs.msdn.com/b/buckwoody/archive/2011/01/18/windows-azure-and-sql-azure-use-cases...
  • Carpe Datum

    SQL Server 2008 CTP4 Virtual Machine Available

    • 1 Comments
    You can find the latest release of SQL Server 2008 in a convenient Microsoft Virtual Machine format here: · Microsoft Connect SQL Server · Microsoft Download Center Enjoy!
  • Carpe Datum

    Passed 70-432 - Is that Important?

    • 3 Comments
    I don't like to read technical blogs that have a lot of personal info in them. Sure, I'll rant from time to time, or talk about a technical book I've read and so on, but most people really don't care about your new cat or how you're feeling today. Keep...
  • Carpe Datum

    SQL Server Management Studio Standard Reports –User Statistics: [DatabaseName]

    • 3 Comments
    I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears...
Page 5 of 40 (1,000 items) «34567»