In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level. Currently, the elastic jobs are […]
Using AI/ML to help process large amounts of data allows us to tackle problems that we might not otherwise be able to work on.
The insurance landscape is evolving, and customer demands are far from where they used to be, with some of the biggest changes happening in the last year. James Boother from COEO covers how database DevOps can enable the evolving insurance landscape.
In this second part of this article we look at how to move the SQL Server master database files to a different location.
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 […]
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 […]
Steve has a few thoughts on hiring and the way in which you might want to evaluate a DBA candidate.
Azure Databricks has a number of Access Controls and Row Level Security options that we will explore in this article.
How to exploit the branching and merging capabilities of Git for scaling up team-based development, when doing Flyway migrations.
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 […]
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...
By Devin-Knight
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...
We are in the process of converting 500+ reports from our old reporting system...
dbt, or Data Build Tool, is a piece of software that allows analysts to...
Hello! I am trying to create data source to connect to Azure SQL DB...
Ask SSC