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 Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
hi, now and then i want one connection in my ssis pkgs to use...
Comments posted to this topic are about the item AlwaysON health check alerts
Comments posted to this topic are about the item Bat and SQL script to...