Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies which are part of the Azure SQL Database feature set.

Internal Controls

by Steve Jones

SQLServerCentral.com

Editorial

Steve wonders if there are good internal controls for data access.

Linear barcodes in SSRS using the Barcode Image Generation Library

by Stan Kulp

SQLServerCentral.com

SSRS

The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.

November Data Platform Releases

by Steve Jones

SQLServerCentral.com

Editorial

At the PASS Summit, there are a few announcements of changes to the data platform.

Testing PowerShell Modules with Pester

by Additional Articles

SimpleTalk

Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.

Data Breach Danger

by Steve Jones

SQLServerCentral.com

Editorial

Is a data breach a danger to those identified in the data. A court says no, but Steve Jones wonders if this is a bad decision.

Unused Indexes - Are they really unused or have they just not been used YET?

by Additional Articles

Brent Ozar Blog

Indexing

Tara explains when index DMVs gets reset by telling a story from her dark past.

The Cost of Switching

by Steve Jones

SQLServerCentral.com

Editorial

With so many companies looking at other platforms, when should an organization consider changing their database? Steve Jones has a few thoughts.

T-SQL Decommenter Part I

by Toby Ovod-Everett

SQLServerCentral.com

T-SQL

Introduction to a T-SQL query that remove comments from T-SQL code

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

by Additional Articles

SimpleTalk

Azure

With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.

Overview of In-Memory Technologies of Azure SQL Database

Internal Controls

Linear barcodes in SSRS using the Barcode Image Generation Library

November Data Platform Releases

Testing PowerShell Modules with Pester

Data Breach Danger

Unused Indexes - Are they really unused or have they just not been used YET?

The Cost of Switching

T-SQL Decommenter Part I

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

Blogs

Optimizing Redshift Performance by Configuring WLM Queues

PowerShell Strikes Back: Return of the Loop

Breaking Rules in Rome

Forums

Merge Replication failing with Error converting data type nvarchar to numeric

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Distance Metric Algorithms

Question of the Day

Distance Metric Algorithms