(Marcin Policht) In one our articles recently published on this forum, we described the process of deploying a Windows Server 2012 R2 into an Azure Infrastructure as a Service (IaaS) virtual machine using the latest gallery image.

(Pinal Dave) I am not a big fan of using command line utilities in general. But from time to time I do explore and play around with command line tools that make my life easier.

(Ahmad Yaseen) The SQL Server Business Intelligence team at work wanted a copy of the live Data Warehouse database to be restored to their Development SQL Server by replacing the existing database for testing purposes. Checking the Development SQL Server data drive, there was no free space to fit bo

(Pinal Dave) CONCAT is the new T-SQL function introduced in SQL Server 2012. It is used to concatenate the values. It accepts many parameter values seperated by comma. All parameter values are concatenated to a single string.

(Chris Webb) The video of my SQLBits conference session “Building a reporting solution using Power Query” is now available to view (for free) on the SQLBits website:

(Larry Leonard) This query displays all the index statistics in the current database that are more than ‘n’ days old.

(Ben Snaidero) Over the course of my career as a DBA I’ve read a lot of documentation and articles on database maintenance and more specifically around index maintenance. One of the most consistent topics discussed has always been whether you should rebuild or reorganize your indexes and when to do

(Paul White) The seven SQL Server sort implementation classes are:

(Dennes Torres) Outdated statistics are a major cause of bad query plans in SQL Server’s.

(Kalen Delaney) So still no juicy bits and bytes post, only this short one to tide me over.