(Melissa Coates) Some development aspects of the Cortana Intelligence Suite can occur in the Azure Portal. There are also some additional client tools which are helpful, or potentially required, to fully create solutions.

(Pinal Dave) One of my clients has installed a new instance of SQL Server and then wanted to create maintenance plan. They were complaining about getting some error and we’re looking forward for my help to solve the same. As soon as he did right click on a Maintenance Plan under “Management” node an

(Jack Vamvas) There is an increased focus on DBAs understanding and managing SQL Server licensing .

(Jon Gallant) I rebuilt my dev machine recently and reinstalled the Service Fabric 2.1 SDKs from here: https://azure.microsoft.com/en-us/documentation/articles/service-fabric-get-started/

(Scott Murray) How can I generate a SQL Server Agent status report using SQL Server Reporting Services (SSRS)? Where is the data available and what data is available to help me better manage my SQL Server Agent Jobs?

(musher) One of the key value propositions for the Azure SQL Data Warehouse service is the ability to re-size the compute power of the database very quickly. A common pattern is to re-size the cluster before a data load to decrease load and aggregation time, then re-size again to save costs when run

(Kenneth Fisher) Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! What happened?

(Ajay Jagannathan) A new DMF for retrieving the input buffer for a session/request (sys.dm_exec_input_buffer) is now available in SQL Server 2016 RC0. This is functionally equivalent to DBCC INPUTBUFFER.

(Kris) Common Table Expressions or CTE’s for short are used within SQL Server to simplify complex joins and subqueries, and to provide a means to query hierarchical data such as an organizational chart.

(Jack Vamvas) When a predicate is SARGABLE we mean the sql statement is able to exploit the indexes supporting the sql statement.