Category Archives: Editorial

Testing Coders

Interviewing someone is hard. In fact, I’m not sure many of us really know how to do it well. Looking at the past hires in most companies I’ve known, I find that all too often the success of hires in … Continue reading

Posted in Editorial | Tagged | Leave a comment

First Class Jobs

I was looking through the forums the other day and noticed that someone wanted to track changes to the Agent jobs on their instance. However, they couldn’t find a DDL trigger to capture the changes to a job. That’s because … Continue reading

Posted in Editorial | 2 Comments

Learn to Earn

Could you double or triple your salary by learning more technology skills? Sure, and here’s a great story about someone learning PowerShell and dramatically increasing their earnings. This is a good read, looking at the journey of someone through their … Continue reading

Posted in Editorial | Tagged | Leave a comment

The Pressure to Compromise Ethics

There have always been those that seek to defraud, deceive or mislead their customers. In order to do this, someone inside an organization has always been willing to pressure employees to compromise their ethics and morals. Construction companies may use … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Finally, Create or Alter

There are lots of reasons to upgrade to SQL Server 2016, but this is the one for me. We finally get a CREATE OR ALTER statement in T-SQL. This not only makes lots of code easier to write, it means … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Hire the Right People

I’ve seen this list of why projects fail going around the Internet for awhile (recently from Brent Ozar Unlimited).  There are a number of items in here, and if you substitute some other field for the data scientist part, you … Continue reading

Posted in Editorial | Tagged | Leave a comment

Monitor All the Changes

Can you monitor every configuration change and setting on all your SQL Server instances? Can you get an alert every time code changes, or even if an option for an object changes, such as the changing of an EXECUTE AS … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Wow. Just Wow

Wow. Just Wow. Yes, I meant to use a capital letter there. The Red Cross’ Blood Service in Australia had database backups on a website that anyone could access. That means that anyone could download the backup, which contained PII … Continue reading

Posted in Editorial | Tagged , | Leave a comment

A Joke Come True

Yesterday was the opening of Microsoft Connect 2016. If you didn’t have the chance to watch the opening keynote, I’d recommend you do so. Mostly because one of my jokes, or perhaps a dream, has come true. SQL Server runs … Continue reading

Posted in Editorial | Tagged | Leave a comment

Held Hostage by the Database

Your database platform will constrain and limit the flexibility you have in evolving your software. It doesn’t matter which platform you choose, which type of database, or even the format for your data. At some point, you will be dealing … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment