SQL Server 2014 DML Triggers: Tips & Tricks from the Field

 Editor’s note: The following post was written by SQL Server MVP Sergio Govoni SQL Server 2014 DML Triggers: Tips & Tricks from the Field SQL Server 2014 DML Triggers are often a point of contention between Developers and DBAs, between those who customize a database application and those who provides it. They are often the first…


Updateable Column Store Indexes in SQL Server 2014

Editor’s note: In partnership with Microsoft Press, now celebrating their 30th year, MVPs have been contributing to an ongoing guest series on their official team blog. Today’s article is from SQL Server MVP Sergio Govoni which is the 42nd in the series.  Updateable Column Store Indexes in SQL Server 2014 Introduction Column store indexes had…


SQL Server 2014 Backup Encryption

Editor’s note: The following post was written by SQL Server MVP Nicolas Souquet Introduction With the verly large amounts of data companies store today, databases are very likely to contain critical and confidential data, making database backups encryption an essential database engine feature. It is easily foreseeable that such feature will soon be required to pass…


SQL Server 2014 Performance Enhancements

Editor’s note: In partnership with Microsoft Press, now celebrating their 30th year, MVPs have been contributing to an ongoing guest series on their official team blog. Today’s article is from SQL Server MVP Shehap El Nagar which is the 41stin the series.  SQL Server 2014 Performance Enhancements Database Performance has become an important subject for…