Articles

Node.JS and SQL Server are a good match for creating non-blocking, event-driven database applications. Though you can use ODBC or JDBC to communicate between the two, it is possible to run such applications on platforms such as Azure, Linux, OSX and iOS by using Node together with the JavaScript TDS library called 'Tedious'. 'Tedious' is a mature product but it is still possible to get things wrong in converting SQL Server datatypes such as BigInt to native Javascript data.

2017-04-19

3,491 reads

Working with Tables in Azure SQL Data Warehouse

by Chris Testa-O'Neil

SQLServerCentral.com

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

In this next installment of our series on Azure SQL Data Warehouse, we'll look at tables and the options for how we decide to create them for optimum performance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-04-18

2,117 reads

Discuss

Moving from application automation to true DevOps by including the database

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

Tom Austin talks about the challenges that arise from trying to include the database in your DevOps process.

2017-04-18

3,224 reads

Scaling out SSRS on SQL Server Standard Edition

by Additional Articles

SimpleTalk

Reporting Services (SSRS)

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.

2017-04-18

3,892 reads

Performance Myths : Clustered vs. Non-Clustered Indexes

by Additional Articles

SQLPerformance.com

clustered index

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

2017-04-17

5,314 reads

Creating Azure SQL Data Warehouse Databases

by Chris Testa-O'Neil

SQLServerCentral.com

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Learn how you can create an Azure SQL Warehouse database quickly and easily.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-04-14

945 reads

Discuss

Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services

by Additional Articles

Database Journal

dacpac

One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.

2017-04-14

2,268 reads