SQL Shack round-up – October 17th, 2014 – Performance reporting and auditing in SQL Server, Cryptographic features, Continuous integration with SSDT and TFS, and Index strategies

In the latest SQL Shack articles, we wrote about ways to improve performance reporting in SQL Server 2014, SQL Server Auditing, Monitoring and Crypto basics, as well as about interaction between Server Data Tools and Team Foundation Server.

In Using custom reports to improve performance reporting in SQL Server 2014 – the basics we presented SQL Server Management Studio custom reports, explained when they should be used, and gave a stop-by-step guide to create them using SQL Server Data Tools.

In Using custom reports to improve performance reporting in SQL Server 2014 – running and modifying the reports we gave security recommendations and showed how to run and modify custom reports.

In SQL Server Confidential – Part I – Crypto basics and SQL Server Cryptographic Features we described SQL Server cryptographic features that can be used to create a state of the art security and privacy “aware” system.

In Intro to Auditing in SQL Server we explained SQL Server Auditing basics, starting Login auditing, C2 Auditing, Common Criteria Compliance, Adding audit columns, collecting audit information via Triggers, Tracing and Extended events.

In Continuous integration with SQL Server Data Tools and Team Foundation Server we explained interaction between SSDT and TFS. Developing locally and publishing the changes to an on-premises instance of SQL Server – how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution.

In Index Strategies – Part 1 – Choosing the right table structure we explained basics and drawbacks of using Heaps – tables without clustered index.

In Quick and dirty server monitoring with SQL Server Reporting Services we showed how to utilize SQL Server Reporting Services in order to create a dashboard which provides the DBA and developer alike with a quick reaction information system to monitor the server and jobs.

October 17, 2014