Tag Archives: sql server

The 80/20 Rule – Top Ten SQL Server Skills

Over the years that I’ve worked in technology, I’ve found that the 80/20 rule seems to apply pretty well to all the different areas that one can specialize in. It doesn’t matter whether you build PCs, work on the help … Continue reading

Posted in Blog | Tagged , , | 2 Comments

The Robot DBA

This is the story of Manna, the manager of a fast food restaurant. It’s a great read, and perhaps a little shocking. Manna is a piece of software, reading sensors, reacting, and letting employees know what to do with a synthesized … Continue reading

Posted in Editorial | Tagged , , | Comments Off on The Robot DBA

The Principle of Least Privilege – Skill #3

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. Secure by Default SQL Server doesn’t give logins or users any rights by default. That … Continue reading

Posted in Blog | Tagged , , | 1 Comment

The Growth of Data Types

In the relational databases we have all different types of data that we store. We have the basic types of integers, character data, dates and times, and more. As the RDBMS platforms have evolved, we have also added spatial, XML, … Continue reading

Posted in Editorial | Tagged , | Comments Off on The Growth of Data Types