Steve Jones has a new take on what it means to be a DBA.

Free Webinar: Can you Automate your Ops Away?

by Additional Articles

Redgate

Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!

Using a Recursive CTE to Generate a List

by Svetlana Marinova

SQLServerCentral.com

Recursive CTE

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.

Getting Started with Power BI Designer

by Additional Articles

Database Journal

Power BI

The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.

#SQLNewBlogger

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.

Integration Services, MySql and SET FMTONLY ON

by Gerald Britton

SQLServerCentral.com

Integration Services (SSIS)

Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!

Learning SQL Server 2012

by Site Owners

SQLServerCentral.com

SQL Server 2012

A collection of technologies and links that will help you learn more about SQL Server 2012.

Microsoft Azure Stream Analytics

by Additional Articles

SimpleTalk

Azure

Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. It provides a ready-made solution to the business requirement to react very quickly to changes in data and handle large volumes of information. Robert Sheldon explains its significance.

SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once

by Press Release

SQLServerCentral

SQL Monitor

This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.