(Greg Robidoux) SQL Server continues to evolve as new features are added with each release. With these changes database administrators and developers need to rethink the “business as usual” mantra and determine how these new features are a benefit and not a detriment.

(Pinal Dave) Here is a one of the very common question I keep on getting via email.

(Chris Bell) Triggers can be implemented to enforce business rules or referential data integrity in database applications.

(Jason Brimhall) Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is the link so you can read that article first before proceeding here. This article is intended as a first of two part follow-up to that article.

(Kenneth Fisher) I thought of something rather interesting the other day while answering a question asking for help with some table structures.

(William Brewer) This article aims to describe the major scripts, documents and lists that are needed to ensure that changes to a database can be easily tested, deployed, and maintained in service.

(Pinal Dave) Yesterday I wrote a blog post about and it has created quite a lot of interest in the community SQL SERVER – Search Records with Single Quotes. Here are a few other alternatives which I received as a comment.

(Derik Hammer) This week I released a two part blog series on SQLShack.com. The series covers automated testing for your backup files and reporting on the results. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered.

(Dallas Snider) Whether you are an experienced professional or early in your information technology career, starting as a SQL Server business intelligence developer can be a daunting challenge. Besides the technical skills required to be a proficient SQL Server business intelligence developer, there

(Jorge Segarra) In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly to the data you want”. The alternative is doing full table scans to read all the data, which sucks.