• 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

    Create an Excel Graph of your Big Tables – with PowerShell!

    • 4 Comments
    I showed a demo of how to find the top ten tables in the database at the PASS Conference. Here’s that script – you’ll need to fix the server name, instance name, and database name. You can use this to display any numbers – and even more. The mind reels...
  • Carpe Datum

    Store XML Document as Binary, Read as XML

    • 2 Comments
    I had an interesting question the other day, so I thought I would share both the question and the answer. We had an older application that had stored an XML document in a table as a binary data type column. I know, I know – we’ve had an XML data type...
  • Carpe Datum

    Quote of the Day – The Definition of an Expert

    • 2 Comments
    I’ve been at the PASS conference this week, and I’ve been around a lot of really smart Experts – and this definition definitely fits: An expert is someone who knows some of the worst mistakes that can be made in their subject, and how to avoid them. ...
  • Carpe Datum

    Color Me Corrected – Will the REAL sysobjects please stand up?

    • 2 Comments
    A few days ago I posted a way to look at the Dynamic Management Views (DMV’s) using a query, which I then copy and paste into the Help viewer’s Index tab to learn more. Well, my good friend and Colleague, Cliff, pointed out that I was using the older...
  • Carpe Datum

    Using Perfmon with SQL Server – Part Two

    • 1 Comments
    Yesterday I posted a header from a script that shows you some links for how to use “Logman”, a Windows command-line utility that can automate your collection of Windows Performance Monitor counters. Towards the bottom, you can see the logman command I...
  • Carpe Datum

    Learning New Tech on SQL Server Virtualization – From Vendors

    • 1 Comments
    I’m at PASS this year, and one of the things I’ve learned this time is that I can learn from – the vendors!  Most of the “big” names are here, like Idera, Redgate, Quest, and more, but I ran into some folks yesterday I hadn’t spoken with before ...
  • Carpe Datum

    Visio Video (killed the radio star)

    • 1 Comments
    I teach a class at the University of Washington, and in that class I have the students create a few Entity Relationship Diagrams (ERDs). I’m still looking for a decent tool to do that, since the only ones I know that do a good job are WAY too expensive...
  • Carpe Datum

    How Microsoft Does IT - Updated

    • 0 Comments
    I’ve pointed out this link before, and I’ll definitely bring it up again. Microsoft is one of the few companies I know, especially the big ones, that explains how they run their IT. We have a fantastic, I mean really fantastic site that you should definitely...
  • Carpe Datum

    Quote of the Day: Who Is Normal?

    • 0 Comments
    No, this isn’t about third normal form or anything like that: “Everyone seems normal until you get to know them.” - Unknown
  • Carpe Datum

    Win7 – Install SQL Server Native or go Virtual PC?

    • 0 Comments
    I have Windows 7 on my laptop, and I also teach, demo and use SQL Server 2005 and SQL server 2008. Should I install this “native” on my outside operating system or use the Virtual PC (VPC) software that comes with Windows 7? Well, there are arguments...
  • Carpe Datum

    DBA? No – Data Professionals

    • 0 Comments
    I’m here at the Professional Association for SQL Server (PASS) this week, and I’m here in the keynote. A few days ago I ranted about the fact that DBA should be a Data Professional – not an administrator. I’ve heard a lot of response about that blog ...
  • Carpe Datum

    Find and learn DMVs

    • 0 Comments
    This morning I showed how I find DMVs, and find out how to use them. First, I just run this query:   USE MASTER; GO SELECT ‘sys.’ + name FROM sys.sysobjects WHERE name LIKE ‘dm%’   Then I copy and paste a result into the “Index” panel of Books...
  • Carpe Datum

    Quote of the Day – On Having a Purpose

    • 0 Comments
    I try to live by this every day: “No one is useless in this world who lightens the burden of another.” – Charles Dickens
  • Carpe Datum

    Changing the Primary Key Before You Have Data

    • 0 Comments
    In my class this week, the students went through the inserts, updates and deletes that they had created for their database design, and then the moment of truth – creating the queries that answer the questions from the requirements. It’s often at this...
  • Carpe Datum

    Changing the Primary Key After You Have Data

    • 0 Comments
    Yesterday I blogged about changing a Primary Key (PK) during the design phase, and before you have data in the database. Even then, it’s not trivial to change the data type or column(s) that make(s) up the PK. When you have data in that Primary Key and...
  • Carpe Datum

    Code that Writes Code

    • 0 Comments
    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to...
  • Carpe Datum

    The Magical World of SQL Server Licensing

    • 0 Comments
    Licensing. Sometimes it feels like to you need a specialized degree, a black robe and a secret handshake to really understand it – but it’s not quite that bad. There are several licensing “models”, from just buying SQL Server off the shelf to Software...
  • Carpe Datum

    Quote of the Day – On Thankfulness

    • 0 Comments
    Yesterday was Thanksgiving here in the U.S. – a time not just for family, rest and food, but most supremely of giving thanks. We give thanks to God and to each other for the infinite blessings we share. No matter what we think we have need of, that which...
  • Carpe Datum

    Channeling Bruce Lee: Tuning without Tuning

    • 0 Comments
    I’m leading a Performance Tuning workshop here in Portland, Oregon today, and I normally start this kind of workshop with a segment on “pre-tuning” – or, the steps you take so that you don’t have to tune as much later. When we set up a system is the greatest...
  • Carpe Datum

    Using Perfmon with SQL Server – Part One

    • 0 Comments
    I held a workshop on performance tuning in Portland, Oregon yesterday, and as part of that I mentioned a process I follow for automatically collecting Performance Monitor Counters for a system. I use this data to store a baseline and then subsequently...
Page 1 of 1 (21 items)