SQL Shack round – up – December 31st, 2014 – 14 new articles including SSRS, auditing, transaction log, Buffer Pool extension, and more

In the latest SQL Shack articles, we wrote about: the Buffer Pool extension, SSRS tips and tricks, SQL Server auditing, transaction log, capacity management, system views tips, DAX, Always on, database deployment with SSDT, and more

Your end user generated queries that seem to run ‘forever’? Here’s a technique you can try – SQL Server 2014 Data Access Layers

Address the most important questions before choosing to implement Availability Groups – Disaster Recovery Planning with Always-On Availability Groups

Improve your effectiveness as a DBA by understanding the Log Structure, number of VLFs we have and WAL – SQL Server Transaction Log – Part 1 – Log Structure and Write-Ahead Logging (WAL) Algorithm

Check out the many factors that can have an effect on your transaction log’s throughput – SQL Server Transaction Log – Part 2 – Top Reasons for Log Performance Problems

Create and deploy DAX queries and ensure that you keep ahead of the curve – What you always wanted to know about DAX but were afraid to ask

A review of what the Buffer Pool Extension can add to systems that use the HEKATON feature – Buffer Pool Extension (BPE) – In-Memory OLTP: The Memory Challenge

Understand the basics of Buffer Pool Extension, how it works, how to implement and troubleshoot – Buffer Pool Extension (BPE) – Implementing another level of cache

Check how the page request works when the Buffer Pool Extension is enabled – Buffer Pool Extension (BPE) – How it works?

Sometimes, it is necessary to move the database from one server to another. The problem is that usually the logins and the database users are mapped. If that is the case, when you backup a Database and restore a database in another server, the logins are lost. In this article, we will show 4 different alternatives to migrate the logins of a database to a different server

Distance yourself from static reports and ensure your reports are more dynamic at run time – Create reports like a champion! Tips and tricks with Reporting Services

A walkthrough of creating a SQL Server Audit and a review of a number of tricky settings – Reviewing the SQL Server Audit

This article talks about the system views/tables/functions and how to solve common DBA questions

Capacity management is one of the most important tasks you have to perform as a DBA. Together we reviewed and deployed a forecast solution which focuses on ‘day to live’ metric – How-to: Proactive capacity management

Sometimes – when doing continuous integration with SQL Server Data Tools – you need to deploy several databases or the same database on several instances. In these cases you will need to tailor your Team Foundation Server Build template in a different way. This post is about how to achieve that using Batch file in your build template

December 31, 2014