The Facebook Fiasco

About ten years ago, my friends and family were abandoning their Myspace accounts and heading to Facebook. I fought it for a while but eventually assimilated and ended up with over 650 Facebook “friends” at last count. Even my mother embraced the platform, very happy that she could see frequently updated photos of her many … Read more

Working from Home

I’ve been fortunate enough to work from my home office for the past six years. My commute is about twelve steps, or, occasionally, a 45-minute drive to the nearest airport. It may not be for everyone, but I think that more employers should let their workers take advantage of an arrangement like this. Since I … Read more

Time Off

Time is a precious commodity, and so much of our time is dedicated to working. IT professionals often have jobs with good benefits, including generous paid time off. It’s very important to get away from work to relax and recharge, but, sometimes, it’s difficult to take those days that belong to us. Even when we … Read more

Self-improvement: Uniquely Human

There are many things that separate humans from other animals. One of those things is our interest in improving ourselves. Many of us are motivated, especially this time of year, to learn languages, better our health, develop leadership qualities, or increase wealth. There is an entire genre of literature dedicated to self-improvement, also known as … Read more

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor's SQL Speed Phreak challenge produced some memorable code, but can SQL features introduced since then help to produce code that performs as well and is also easy to understand? Aunty Kathi investigates.… Read more

SQL Server Reporting Services Basics: Deploying Reports

Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.… Read more