(Steve Endow) Christina Phillips and I have done a SQL presentation at several Dynamics GP conferences, and one of the items I always like to mention is INFORMATION_SCHEMA. It seems that many people don’t know about this fantastic set of views, and are still suffering by using sysobjects.

(Pinal Dave) ApexSQL Audit is a tool which is used to audit SQL Server events for the purpose of general auditing as well as to meet strict SQL Server compliance standards.

(Marcin Policht) In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises

(Pinal Dave) My exploration with SQL Server 2016 features are just continuing and I am delighted every other day to figure out something new been added to the capabilities which in the opinion were of limited capacity in the prior versions of SQL Server.

(Denny Cherry) You may have heard that there’s a bug in SQL Server 2016 related to the query store in non-Enterprise editions. This is a less than dangerous bug, in that in editions of SQL Server 2016 other than Enterprise Edition when the space allocated to the query store fills it stops collectin

(Thomas LaRock) A database disaster is going to happen to everyone at some point. If you haven’t had one yet, just give it time.

(Grant Fritchey) If your number one wait type, by far, is io_latch, if you find yourself relying on table variables, if you’re collecting massive amounts of data in SQL Server through inserts, the chances are that you’ve already been considering the use of In-Memory OLTP tables and indexes.

(Rajendra Gupta) It is very important for organizations to protect sensitive information such as customer details, credit card numbers, social security numbers, etc. Only authorized users should be able to see this data. SQL Server 2016 helps limit data exposure to only authorized personnel with Dyn

(Kenneth Fisher) That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing SSIS package. You opened up a new project, imported the package, and made your changes.

(Michael J. Swart) “One thing at a time / And that done well / Is a very good thing / As any can tell”