Additional Articles

All authors

Getting Started with Azure SQL Data Warehouse - Part 2

by Additional Articles

Database Journal

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

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.

2017-03-23

4,160 reads

Follow-up #1 on leading wildcard seeks

by Additional Articles

SQLPerformance.com

Wildcard

Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

2017-03-22

4,058 reads

Core Database Source Control Concepts

by Additional Articles

SimpleTalk

source control

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.

2017-03-21

5,188 reads

Using Power BI in a Hybrid Environment

by Additional Articles

Microsoft MSDN

Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.

2017-03-20

4,239 reads

SQL Server Bulk Insert Row Terminator Issues

by Additional Articles

MSSQLTips.com

bulk insert

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.

2017-03-17

3,572 reads

How to Find Queries Using an Index (and Queries Using Index Hints)

by Additional Articles

SQLServerCentral

Sometimes you know a query is out there, but it’s hard to find the exact query. In this post, Kendra Little gives example code to find queries using a specific index, or using an index hint.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-03-16

5,858 reads

Deployment Automation for SQL Server Integration Services (SSIS)

by Additional Articles

SimpleTalk

Integration Services (SSIS)

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects.

2017-03-15

5,823 reads

Managing Azure SQL Database Recovery

by Additional Articles

Database Journal

Azure SQL database

Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.

2017-03-14

3,555 reads

Introducing DevOps to Farm Credit Services of America

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal,...

2017-03-13

2,937 reads