From the blog

Articles from our expert staff on a wide range of topics

Excel: Copying A Field Without Incrementing

How do you prevent Excel from auto-incrementing when you copy cells? In this blog, I show 2 examples in which I want to copy column data down, however, I do not want the data to increment. There is an easy way to prevent this auto increment, you just have to know...

Quit Trying to be Perfect!

We all make mistakes. It’s a fact of life. It’s part of the human condition. So why do we obsess so much about perfection when we know it’s simply not achievable? How is it that we are always punishing ourselves when we screw up? What causes us so...

Trust Your Gut: If It Feels Wrong, It’s Wrong

In January of last year, a 10-year-old boy was riding home late at night from a hockey game with his father, absently staring out the car window at the cold, snowy Michigan landscape. As they rode past a neighbor’s house, he noticed their garage door was up, and...

SQL Tip – An alternative way to page results

An alternative way to page results using OFFSET AND FETCH. Database used in this example is Adventure Works for SQL Server 2014. You can download the database here. This stored procedure will return paged results from the HumanResources.Employee table. This stored...

Social Stream