Deceptive Visualizations

I'm sure there are plenty of examples, but I've seen deceptive data visualizations far too often in mass media. I don't often watch the news, but at times I've been at the gym, saw a graph on a television, and been a little surprised. The issue that bothered me is similar to what's discussed in […]

Conditional DELETE and INSERT in PostgreSQL

Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, called ALL_EMPLOYEES, which contains all employees' information who are working or had ever worked for […]

Handling Row-level Errors in ADF Data Flows

If you are working with ADF (Azure Data Factory) data flows, then you may have noticed there was a new feature released in November 2020, which is useful to capture any error while inserting/updating the records in a SQL database. This article will describe how to setup the error row handling feature and why it's […]

Blogs

Daily Coping 22 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Suggested Topics in Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

Read the latest Blogs

Forums

Migrating Folder Structure in Report Manager from one SSRS server to another

By rsiem

We are in the process of converting 500+ reports from our old reporting system...

Setting up and using dbt (Data Build Tool) with SQL Server

By David Fundakowski

dbt, or Data Build Tool, is a piece of software that allows analysts to...

SSRS 2016 data source - Azure SQL DB not working

By PJ_SQL

Hello! I am trying to create data source to connect to Azure SQL DB...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers