Monthly Archives: August 2011

The Special Cloud

It’s not a short yellow bus special cloud, at least I hope not. Amazon is introducing a cloud for the US government, designed to meet their regulatory and compliance requirements. The idea here is that there are different needs for … Continue reading

Posted in Editorial | Tagged ,

Computed Columns and UDFs

I wrote about the basics of computed columns and also using CASE in a computed column recently, but there’s a better way to implement a computation, and reuse the code. You can include a UDF in a computed column. UDFs … Continue reading

Posted in Blog | Tagged , ,

An Investment in Knowledge

“An Investment in Knowledge Pays the Best Interest.” – ~Benjamin Franklin Most of us are working to provide for ourselves and our families. We go to a job every day, earning money that we use to pay our bills and, … Continue reading

Posted in Editorial | Tagged

The Winding Road

This is the text and images from my keynote talk at SQL Saturday #90 in Oklahoma City on August 27, 2011. This is my boss, Neil Davidson. He runs Red Gate Software as one of the two join CEOs for … Continue reading

Posted in Blog | Tagged , , | 2 Comments

SQL Saturday #90–Oklahoma City recap as chauffeur and speaker

I’d never been to Oklahoma City, and when Kristin Ferrier asked me to come to SQL Saturday #90 and do the keynote, I was happy to accept. It’s a short flight from Denver, and not much further from Austin, so … Continue reading

Posted in Blog | Tagged , | 1 Comment

The Basic Security Model in SQL Server – 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. Users and Objects The basic security model diagram that I use is the one below. … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

On the Road Again – SQL Saturday #90

I’m leaving this morning for Oklahoma City for SQL Saturday #90. This is my first time traveling to Oklahoma City and I’m looking forward to it. I’m thinking to check out the National Cowboy Museum, I need to see the … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Create a Log Backup Schedule – #1 Skill You Need

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. You Need Log Backups By default databases in SQL Server are created with the Full … Continue reading

Posted in Blog | Tagged , , , , ,

Keep Data Forever

How long do you expect to keep a piece of data in any of your databases? Chances are if you’re like me, you rarely think about it and expect that you need to store all the data perpetually. As long … Continue reading

Posted in Editorial | Tagged ,

How is this free?

I received this ad in an email: Now I’m a member of the SSWUG mailing list, I get their daily lists and they know that I’m a registered member, but not a paid member. I don’t feel that their service … Continue reading

Posted in Blog | Tagged