Articles

New release: SQL Monitor 10
SQL Monitor 10 has landed! You can now integrate SQL Monitor alerts with your ticket management system, so chosen alerts are automatically raised as tickets. New suppression options give you granular control over what alerts are raised during specific times, such as maintenance windows. And, you can now annotate the server activity graph with specific events, so you can measure their impact on your servers.
Discover the new features

2020-03-23

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2

by Nikolai Basov

SQLServerCentral.com

SQL Server 2016

In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-03-20 (first published: 2018-08-27)

6,581 reads

Discuss

Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins

by Additional Articles

Brent Ozar Blog

Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.

2020-03-20

What’s New in SQL Monitor 10?

by Tony Davis

SimpleTalk

SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.

2020-03-20

Restore SQL Server database using data management provider REST API

by Pablo Echeverria

SQLServerCentral

Learn how to restore sql server database using data management provider Rubrik REST API

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2020-03-19

2,936 reads

Discuss

Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

by Phil Factor

SQLServerCentral

Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-03-19

437 reads

Verifying Object Exists and Dropping Object with One Statement

by Additional Articles

Database Journal

For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.

2020-03-19

Never Create Columns with ANSI_PADDING set to OFF

by Site Owners

SQLServerCentral

There is no good reason for having ANSI_PADDING set to OFF when you create tables in SQL Server. It was provided purely for legacy databases that had code that assumed the old CHAR behavior for dealing with padding, and its use has now been deprecated.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-03-18

Securely Manage Database Credentials Using Visual Studio Manage User Secrets

by Additional Articles

MSSQLTips.com

In this tip we cover how to manage application secrets in a development environment to securely store database credentials.

2020-03-18

Fetch Web Data in Power BI

by sayand

SQLServerCentral

Power BI

Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-03-17

5,443 reads

Discuss

Articles

What’s New in SQL Monitor 10?

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2

Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins

What’s New in SQL Monitor 10?

Restore SQL Server database using data management provider REST API

Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

Verifying Object Exists and Dropping Object with One Statement

Never Create Columns with ANSI_PADDING set to OFF

Securely Manage Database Credentials Using Visual Studio Manage User Secrets

Fetch Web Data in Power BI

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