For me, the benefit of using Roles is the layer of abstraction. Roles are contained within the database (vs. a user which is tied to a login which is...

The table should be named Contact, not Contacts. (IMO) That's another can o' worms. 😉

Reliance on spell check is a big part of the problem. When I cast stones, I judge an editorial differently than its comments section. This problem is much...

I'd worked for over 10 years before I took more than a week vacation. After 12 days of my 2 week vac, I literally felt stress leave my body....

I learn things by not being constrained by what I know. At the moment, I have never used Powershell. If I needed something done and I thought Powershell...

Use the INSENSITIVE keyword in your declare statement and the cursor is essentially just like using a temp table, since insensitive cursors don't keep track of changes that are occurring...

We transitioned to a more secure system a few years ago. During normal business hours, there are security people at the entrance and a photo employee badge is required...

I've worked with a few non-profits and the smallers ones always have volunteer technical assistance for building and running websites. Data management is almost always the most manual and...

That's what the education system is supposed to do... it doesn't give you all the answers, it equips you with the tools to find the answers to the questions you...

I search to get a direction moreso than an answer. Thinking about it, you do the exact same thing within your own team of coworkers. Someone gives you...

He's just saying that if you include an identity column in a PK then whatever you insert into the table will always be unique because an identity column always increments....

I thought this was a great article, for two reasons. The first is because I've seen databases full of bad design as described in the article and it explains...

Unfortunately, a production database administrator isn't necessarily for the design of the database or for writing the SQL. Identifying performance issues is much more important and over half the...

I had at one time asked someone to fix a report that ran in 2 hours. They refused, until later that year when it was taking longer than 26...

I'm one of the crazy people who will use a GUID for a PK, because I don't care that much about random inserts. I would never use a fill...