This SQL Saturday was a star-studded cast of speakers and a host of enthusiastic attendees. This was by far one of the biggest SQL Saturdays I’ve been to with over 300 people in attendance. For me things started off right in Tom LaRock’s (blog | twitter) “Performance Made Easy” talk. Between trading verbal jabs with… Read More »
Well, I made it. After a long trek through Nebraska, Iowa, and part of Illinios I arrived early into Warrenville and to the Quest offices for Kevin Kline’s (blog | twitter) pre-conference on Performance Tuning & Troubleshooting. Kevin ran us through his “Rocks, Gravel, and Sand” methodology. This is an approach by which you take… Read More »
We have a vendor right now that periodically requests a backup file FTP’d to their server. Unfortunately we do not run the Enterprise version of SQL Server to be able to compress the backups, and nobody wants to manually take a backup file and compress it on a regular basis. Because of this I created… Read More »
First of all a big thanks to Jes Borland (Twitter | Blog) for hosting this month’s T-SQL Tuesday (#16) topic about aggregate functions. Ok. So it’s not *really* an aggregate function, but it uses them and it does aggregate. Yes, I am talking about the PIVOT function in SQL Server 2005+ that’s near and dear… Read More »
After experiencing another rate increase with DirecTV we had finally have enough. When we really sat down and discussed what channels we watch and what satellite was offering we found that we were basically paying $80 a month for a handful of crappy shows. Going in we knew we wanted Netflix, Amazon VOD, and Hulu.… Read More »
