There are many naming conventions that prescribe things like case, underscores, plural vs. singular, or hungarian notation, but here are some more general guidelines that should apply regardless.

A column should...

Michael L John (4/7/2016)

---

DavidL (4/7/2016)

---

Eric M Russell (4/7/2016)

---

.. The tables in a JD Edwards system were coded with a short alpha sequence and then a 4 or 5 digit number....

Ha!...

By default, a new login has access no databases, and once granted access, they cannot select from anything.

To maximize security, I'd suggest first creating a view that joins the required...

We have open positions for SQL Server DBAs and Database Developers (v2008 - v2016), if anyone is interested in the North Atlanta area, specially Kennesaw/Marietta. Good job market, affordable housing,...

By default, a SQL Server processes will not timeout, unless it is in deadlocked state (an unresolvable locking contention) with another process. In a worst case scenario, a poorly constucted...

🙂

Iwas Bornready (4/5/2016)

---

You just do the job to keep food on the table and a roof over your head. If you are abused get another job. If you can't then...

Rod at work (4/5/2016)

---

Eric M Russell (4/5/2016)

---

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something...

If you have a new project in development and plan to leverage some of the newer features like Clustered ColumnStore or InMemory tables, then definately go for v2016.

However, if...

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something I feel most of us haven't...

.. I was advised by the Sixbit dev's that I should move the listing pictures out of the dB and into their own folder on the C: drive of the...

The following practices are almost always wrong.

1. A table without...

When listening to new coworkers talk about why they left their previous job, a common theme is escaping stress and overtime. They probably won't mention it as a motivation during...

I know what you're wanting to do is simple, but SSMS output grid just isn't designed for it. Instead, consider building a simple SSRS dashboard style report for this.

https://www.mssqltips.com/sqlservertip/1361/building-a-dashboard-in-sql-server-reporting-services/