DevOps will have the greatest impact on the IT organization now and in the next ten years. Join us on 10/19 as we dive into this topic and more during our live Virtual Event!
Last week I provided a challenge that required you to come up with a solution for fast clearing of a table that has an indexed view defined on it, without dropping the indexed view. You can find the puzzle details here. Thanks to all those who...
Last week I provided a T-SQL challenge involving a table called DailyVisits that holds information about daily visits to a website. Your task was to identify, for each day, certain statistics compared to the previous day, like how many visits...
This is a nice little puzzle that I got some time ago from a friend and colleague, Eladio Rincón. It’s not a very difficult challenge, but I find it to be a fun one to work on, so I hope you will enjoy it too.
Suppose that you record data ab...
For some of us a laptop is so tightly integrated in our daily lives that it almost feels like an organ. I probably spend a good two-digit number of hours on most days with a laptop for both work-related and personal purposes. So these days I see...
