Monthly Archives: December 2015

An Impressive SQL Server

Posted on December 25, 2015 by way0utwest

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 , | Comments Off on An Impressive SQL Server

Closing Down for the Year

Posted on December 24, 2015 by way0utwest

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 , | Comments Off on Closing Down for the Year

Correct Old Mistakes

Posted on December 24, 2015 by way0utwest

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 , | Comments Off on Correct Old Mistakes

Getting all Yesterday’s Sales, or Finding Midnight Yesterday

Posted on December 23, 2015 by way0utwest

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