From the blog

Articles from our expert staff on a wide range of topics

T-SQL Divide-By-Zero

Divide-by-zero errors are one of the first errors new programmers come across. A reasonable fix is to check the denominator and, if it equals zero, provide some useful result as an alternative to running the division operation. In a table you must think in sets of...

Try Saying Thank You Instead of Sorry

I recently read an article on Bright Site titled Stop saying ‘sorry’ if you want to say thank you: a seriously insightful cartoon, which got me thinking how many times a day I issue the words “I’m Sorry”. I tend to default to using the...

When I was five years old…

When I was five years old, I wanted to be a mathematician. In my circa 1988 mind, being a mathematician was equal parts intelligence and prestige. I had never talked to someone who was a mathematician, or seen one on TV, but I was absolutely certain that this was the...

The Anatomy of a SharePoint Site

A SharePoint site is one of the easiest and most effective ways to share content and coordinate on projects with your co-workers and employees. A SharePoint site page is a customizable canvas in the middle of your interface where you can share links, images, text,...

How to Pull Record Counts for Tables

One way to familiarize one’s self with a very non-production database is to get a list of tables and record counts for each. Table name and count iterator Transact-SQL declare @tbl nvarchar(400); -- internally generated, table name declare @sch nvarchar(400); --...

Character

I was recently given the book “The Road to Character” by David Brooks. Not going lie – it just sounded like an interesting, good book to read. Of course, it reminded me of Mr. Wolf’s line in Pulp Fiction, “Because you are a character, doesn’t mean you have...

Newsletter Signup