Monthly Archives: November 2013

Checking Up on Developers

This editorial was originally published on May 8, 2009. It is being re-run as Steve is on vacation. The other day I was reading Brad McGeHee’s post on duplicate indexes, and it struck a chord with me. That same issue … Continue reading

Posted in Editorial | Tagged , , ,

Vendor Value

This editorial was originally published on May 18, 2009. It is being re-run as Steve is on vacation. Software is a very interesting business. Where else can you produce a product that has zero marginal costs for additional units? Where … Continue reading

Posted in Editorial | Tagged

Core T-SQL

Often I find myself wondering about the minimum bar we expect people to clear to be competent in some field. Almost all fields are evolving these days as technology and new ideas are put into practice in medicine, art, construction, … Continue reading

Posted in Editorial | Tagged , ,

Powershell in a Month – Day 3 – Commands

This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones. Day 3, chapter 4. This one is about commands, and getting familiar with what a … Continue reading

Posted in Blog | Tagged , , | 2 Comments

What is SQL Server not good at?

I was reading a post that had this quote: ” The MongoDB docs tell you what it’s good at, without emphasizing what it’s not good at. ” This isn’t to pick on MongoDB, but the post did make me wonder what SQL … Continue reading

Posted in Editorial | Tagged

Backups and Consistency

I wrote about transactional consistency recently. Why do we need this? Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes … Continue reading

Posted in Blog | Tagged , , | 1 Comment

It Starts with Version Control

As a software developer, I learned about the value of version control over time. My first forays into development were as a child, where I made a single backup of my code on a separate floppy disk in the event I had … Continue reading

Posted in Editorial | Tagged , , ,

Testing Skills

This editorial was originally published on May 11, 2009. It is being re-run as Steve is on vacation. How can you measure someone’s skills? Is there a good way to actually assess how well a DBA or developer will do … Continue reading

Posted in Editorial | Tagged

Learn about Database Deployment in DC

SQL in the City is coming to the DC area in a few weeks with a seminar on the Stairway to Database Deployment. Both Grant Fritchey and I are traveling to the Washington DC area to deliver a half day, … Continue reading

Posted in Blog | Tagged , , , ,

More Vacation

As I try to recharge and relax, I’m taking today and tomorrow off. Just a quick note that I’m trying to live up to my advice and get away from work when I can.

Posted in Blog | Tagged | 2 Comments