Monthly Archives: December 2015

The End of 2015

I’m off on vacation, so I won’t be able to respond, but I decided to take a few minutes and look back at 2015 before leaving for the year. This was a year that seems to have been marked by … Continue reading

Posted in Editorial | Tagged , ,

2015 For Me

This was an interesting year for me. Certainly a time of change with one kid starting high school, one entering his last year, and one graduating from college. These events signal a bit of a change for me, and have … Continue reading

Posted in Blog | Tagged

Sharing Code

This editorial was originally published on Jan 25, 2011. It is being re-run as Steve is on vacation. It seems that almost every week I encounter some form of plagiarism it the SQL Server community. Whether its from SQLServerCentral or … Continue reading

Posted in Editorial | Tagged

Why Use the Principle of Least Privilege?

This editorial was originally published on April 12, 2011. It is being re-run as Steve is away on vacation. SQL Injection is not the fault of the SQL Server. Brian Kelley pointed that out, and reminded me that SQL Injection isn’t … Continue reading

Posted in Editorial | Tagged

An Impressive SQL Server

This editorial was originally published on May 6, 2011. It is being re-run for the Christmas holiday. Merry Christmas and Happy Holidays! Recently I heard about one SQL Server with 1TB of RAM and another one that was handling over … Continue reading

Posted in Editorial | Tagged ,

Closing Down for the Year

Today is my last day of work for 2015. I’m actually proud that I’ve managed to take almost all my vacation (3 days left), and will be enjoying myself next week with my family, taking our holiday vacation in the … Continue reading

Posted in Blog | Tagged ,

Correct Old Mistakes

I ran across this piece on the VTech hack that recently occurred. It’s almost a classic example of what not to do in data storage. You can read the piece, and also look at Troy Hunt’s analysis, but clearly we can … Continue reading

Posted in Editorial | Tagged ,

Getting all Yesterday’s Sales, or Finding Midnight Yesterday

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. I see questions like this regularly. How do I get all the sales from yesterday? I tried using DATEADD(day, –1, … Continue reading

Posted in Blog | Tagged , | 2 Comments

The Database is the Cornerstone

I saw a case study video the other day from Redgate Software. It was a look at one of the upper management on Fitness First, a fitness/gym company that has facilities in dozens of countries. It’s a good, short summary … Continue reading

Posted in Blog | Tagged , ,

Hacking Data

This editorial was originally published on Mar 23, 2011. It is being re-run as Steve is away on vacation. I saw a note recently that researchers had successfully hacked a car using only an MP3 file on a CD. They were … Continue reading

Posted in Editorial