Monthly Archives: December 2015

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