SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]

Guest editorial: SQL Code Metrics

by Phil Factor

SQLServerCentral.com

Editorial

In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.

Compressed Microsoft SQL Server Backups by Default

by Additional Articles

Database Journal

Learn how to create default database compression for your SQL Server databases.

Row Pattern Recognition in SQL

by Additional Articles

SQLServerCentral

Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.

Dos and Don'ts of Dynamic SQL

by Thom Andrews

SQLServerCentral.com

Dynamic SQL

A few of my personal Dos and Don'ts when using Dynamic SQL

The History of the VCS

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones looks back at version control systems.

Call SQL Server Stored Procedures with PowerShell using Parameter Objects

by Additional Articles

MSSQLTips.com

In this tip we look at how we can use PowerShell to validate input values into SQL Server stored procedures prior to execution of the stored procedure

Processing Data Using Azure Data Lake, Azure Data Analytics, and Microsoft’s Big Data Language U-SQL

by Additional Articles

SimpleTalk

Data analytics has become one of the powerful domains in the world of data science. An enormous amount of data is being generated by each organization in every sector. Computer science has found solutions to store and process this data in a smart way through a distributed file system. One such example is Azure Data Lake. It uses the Hadoop Distributed File System, and to perform analytics on this data, Azure Data Lake storage is integrated with Azure Data Analytics Service and HDInsight. In this article, Suhas Pande will explain how to store data using Azure Data Lake and how to perform data analysis on it using U-SQL, a big data SQL and C# language.