Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses compression aggressively to reduce the disk I/O needed to serve the query request. In this article, Arshad Ali talks about the new enhanced columnstore index feature in SQL Server 2014.

Opportunity for Business Intelligence developer

by Press Release

Redgate

Agent jobs

Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.

Sensor Data

by Steve Jones

SQLServerCentral.com

Editorial

The availability of cheap sensors brings with it lots of possibilities and concerns. However there is one certainty: more data.

Variable Default Values to a Stored Procedure (SQL Spackle)

by Dwain Camps

SQLServerCentral.com

Stored Procedures

A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.

New SQL Monitor Custom Metric: Large Transaction Log Files

by Additional Articles

Redgate

SQL Monitor

If the transaction log autogrows rapidly, it can suggest that log backups are not being carried out frequently enough, or another resource may be preventing the log from truncating. This metric measures the number of transaction log files that are greater than 10 GB. The associated alert is raised when the number of files exceeds a specified threshold.

SQL Server Reporting Services Tips and Tricks to Improve the End User Experience

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

In this article we'll take a look at the following Tips and Tricks for SSRS: Display Total Number of Pages while Navigating, Display Everything in a Single Page, Display Report Parameter Selection, Display No Rows Error Message, Page Settings for Optimal Printing.

Common table expressions and circular references

by Geoff Norman

SQLServerCentral.com

Finding circular references that are stopping your CTE from working.

Labor Day 2013

by Steve Jones

SQLServerCentral.com

Editorial

It's the Labor Day holiday in the US today.

What Counts for a DBA: Patience

by drsql@hotmail.com

SQLServerCentral.com

Editorial

Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.

SQL Saturday #251 Paris, France

by Press Release

SQLServerCentral.com

SQL Saturday

SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners.

New Enhanced Column Store Index in SQL Server 2014 – Part 1

Opportunity for Business Intelligence developer

Sensor Data

Variable Default Values to a Stored Procedure (SQL Spackle)

New SQL Monitor Custom Metric: Large Transaction Log Files

SQL Server Reporting Services Tips and Tricks to Improve the End User Experience

Common table expressions and circular references

Labor Day 2013

What Counts for a DBA: Patience

SQL Saturday #251 Paris, France

Blogs

Excellent article on securing msdb

T-SQL Tuesday #201: Temp Tables

When Do You Reach For A #temp Table?

Forums

Return all intermediate members of a recursive CTE?

jdbc auth failing to sql from sap's cloud middleware CPI

Searching for my own posts

Question of the Day

Escaping Strings