A Strange AI Achievement

• by Steve Jones

• SQLServerCentral

• Artificial Intelligence (AI)

What happens when an AI achieves something we didn't think was possible?

Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI

• by Erin Stellato

• SQLServerCentral.com

In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data.

Tracking SQL Server Configuration Across All Your Servers Using SQL Monitor

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

The Estate Configuration reports SQL Server configuration across all your servers, so you can quickly investigate ad-hoc or unauthorized changes to any settings that might affect their performance, stability, or security.

Using Power Apps Patch Function with SQL Server

• by Additional Articles

• MSSQLTips.com

• SQL Server

In this article we look at how to create a basic Power App that allows saving data to a database table.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

• by Jeff Moden

• SQLServerCentral.com

• T-SQL

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.

A Comparison of Database Drivers for MySQL

• by JerodJ

• SQLServerCentral

MySQL is "The world's most popular open source database" and it is widely-used to store and access your data. In fact, there are many cloud and on-premise databases (like MemSQL and Google Cloud SQL) that use the MySQL interface. Several native, open-source drivers are available for connecting to your MySQL data from other applications. In […]

The Complexity of Modern Systems

• by Steve Jones

• SQLServerCentral

• software development

Building software is hard, and our systems are very complex these days.

Working with an Azure Data Factory Meta-data Driven Pipeline

• by Arindam

• SQLServerCentral

This article shows how to create a data driven ADF pipeline.

Learn how to use Flyway for Automated Database Migrations

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Here's your one-stop-shop for Flyway learning resources, curated by Tony Davis. Check out this handy learning pathway for managing and automating database deployments, from version control, using Flyway.

Ransomware: A world under threat

• by Additional Articles

• SimpleTalk

• Security

Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware and what needs to be done to protect against it.