• Carpe Datum

    Attaching a Database

    • 0 Comments
    I had someone ask me yesterday how they could get to a database used by a product that they owned, but that was installed using SQL Server Express. They didn’t have access to the database, and they didn’t know the password for the service that started...
  • Carpe Datum

    Transparent Data Encryption and the Latest Data Breach

    • 0 Comments
    Well, It’s happened again. Hundreds of thousands of private records were stolen from a database . This one, however, was different. No one stole any passwords, no one did any social engineering, nothing was captured in-line. No, this one was accomplished...
  • Carpe Datum

    Data Design

    • 0 Comments
    I give series of classes and presentations on Data Design. I say “data” design instead of “database” design because we should consider more than just the database. Data might actually be stored in non-relational stores, such as Excel or XML files, and...
  • Carpe Datum

    How Does Microsoft Do IT?

    • 0 Comments
    Microsoft is a big company – and of course we have a lot of IT infrastructure that we have to manage. It might surprise you to learn that we have an IT group, just like at your company. We have a networking team, a server hardware team, software teams...
  • Carpe Datum

    Quote of the Day: On Finding It Out

    • 0 Comments
    Whenever you are asked if you can do a job, tell 'em, "Certainly I can!" Then get busy and find out how to do it. Theodore Roosevelt
  • Carpe Datum

    How to get Microsoft to speak at your event

    • 0 Comments
    If you’re holding a special event, such as a SQL Saturday or a user group, one of the challenges is to get speakers for the event. Now, the best speakers come from the community – people who use the product day-in, day-out. They have a wealth of expertise...
  • Carpe Datum

    Lessons from Volunteering

    • 0 Comments
    Saturday I volunteered at a work-day at our church. Our building is one of the first buildings built in this area of Washington, so it’s a beautiful old structure, which of course means there’s lots of maintenance. I’m fairly decent with tools, I’ve done...
  • Carpe Datum

    Weekly Challenge – Tools for Thought Site

    • 0 Comments
    A good friend of mine years ago showed me this web site: http://www.rheingold.com/texts/tft/ . I took my lunch hour each day for a week or so and read each “page” on this site. It deals with computer technology history in a way that I had never read before...
  • Carpe Datum

    PowerShell Version Two – Get Continuous Perf Counters

    • 0 Comments
    In version 2.0 of PowerShell, you can now use a direct command-let (get-Counter) to get at the Performance Monitor counters. For instance, to show the current value of the Processor Percent Time, use this command:   Get-Counter '\Processor(*)\% Processor...
  • Carpe Datum

    Quote of the Day – On Change

    • 0 Comments
    They say that time changes things, but you actually have to change them yourself. - Andy Warhol
  • Carpe Datum

    Have you backed up your keys lately?

    • 0 Comments
    Did you know that you already have a Server Master Key (SMK) generated for your system? That’s right – while a Database Master Key (DMK) is generated when you encrypt a certificate or Asymmetric Key with code, the Server Master Key is generated automatically...
  • Carpe Datum

    Did that change really fix the problem?

    • 0 Comments
    When we’re heads-down on a problem, it’s sometimes far too easy to relax the method we should follow for troubleshooting. We’re supposed to gather as much information as possible, freeze the system as much as possible, and then develop the plan for the...
  • Carpe Datum

    No Certainties, Including That One

    • 0 Comments
    The older I get, the more I realize that there are few certainties in life. No, this isn’t one of those philosophical posts where I relate some newfound wisdom as if I’m the first one to discover it – I’m going somewhere practical with this. I deal not...
  • Carpe Datum

    ROI and the DBA

    • 0 Comments
    I love them three-letter acronyms! An “ROI” is a Return On Investment – it’s a basic financial calculation that places investments in a standard number so that they can be compared. If the number is positive, then it has a “good” return on investment...
  • Carpe Datum

    Quote of the Day – On Reputation

    • 0 Comments
    “Character is like a tree, and reputation is like its shadow.” Abraham Lincoln
  • Carpe Datum

    It’s OK to take a Shortcut Sometimes

    • 0 Comments
    I was working this weekend with a fairly simple Excel spreadsheet, and I had to decompose one cell in it out to three columns in a SQL Server table. There are tools within SQL Server Integration Services (SSIS) that should be able to do that, but I just...
  • Carpe Datum

    Consolidation Strategy References

    • 0 Comments
    I have a presentation that I give on SQL Server Consolidation Strategies, and in that presentation I talk about a few links that are useful. Here are some that I’ve found – feel free to comment on more, or if these links go stale:   Consolidation...
  • Carpe Datum

    System Variables, Stored Procedures or Functions for Meta Data

    • 0 Comments
    Whenever you want to know something about SQL Server’s configuration, whether that’s the Instance itself or a database, you have a few options. If you want to know “dynamic” data, such as how much memory or CPU is consumed or what a particular query is...
  • Carpe Datum

    Quote of the Day – On the Importance of Truth

    • 0 Comments
    “Whoever is careless with the truth in small matters cannot be trusted with important matters.” - Albert Einstein
  • Carpe Datum

    What to leave when you're leaving

    • 0 Comments
    There's already a post on this topic - sort of. I read this entry, where the author did a good job on a few steps , but I found that a few other tips might be useful, so if you want to check that one out and then this post, you might be able to put together...
  • Carpe Datum

    Using linked servers, OPENROWSET and OPENQUERY

    • 0 Comments
    SQL Server has a few mechanisms to reach out to another server (even another server type) and query data from within a Transact-SQL statement. Among them are a set of stored credentials and information (called a Linked Server ), a statement that uses...
  • Carpe Datum

    Today I talk about you

    • 0 Comments
    Some time back I posted a blog entry (mirrored here and here ) asking you how you design databases. Out of those responses, my own experience, studies I read, and interviews I conducted, I collected a wealth of data. Thanks for your responses. So what...
  • Carpe Datum

    Cluster Nodes as RAID Drives

    • 0 Comments
    I'm unable to sleep tonight so I thought I would push this post out VERY early. When you don't sleep your mind takes interesting turns, which can be a good thing. I was watching a briefing today by a couple of friends as they were talking about various...
  • Carpe Datum

    Quote of the day – on when NOT to say something

    • 0 Comments
    I think many of us can say something right at the right time. But there’s a deeper skill: “Remember not only to say the right thing in the right place, but far more difficult still, to leave unsaid the wrong thing at the tempting moment.” - Benjamin Franklin
  • Carpe Datum

    Quote of the Day: On Predestination

    • 0 Comments
    I have noticed even people who claim everything is predestined, and that we can do nothing to change it, look before they cross the road. - Stephen Hawking
Page 36 of 40 (1,000 items) «3435363738»