It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it.

Array Element by Agonizing Array Element

by Phil Factor

SQLServerCentral.com

Editorial

Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.

Cardinality Estimation for a Predicate on a COUNT Expression

by Additional Articles

SQLServerCentral

Cardinality Estimates

Paul White takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.

Fixing an SSRS Password Error while Changing Credentials

by Muhammad Bilal Ayub Khokhar

SQLServerCentral.com

Reporting Services (SSRS)

SSRS Password error while changing credentials

SQL Database Analysis

by Phil Factor

SQLServerCentral.com

Editorial

Static code analysis is immature for SQL code. Today Phil has a few thoughts.

Encrypting SQL Server: Dynamic Data Masking

by Additional Articles

SimpleTalk

Encryption

Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.

Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#

by Daniel Calbimonte

SQLServerCentral.com

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

In this new article, we will learn how to access to our Azure DWH tables using C#.

Cracking the SQL Code

by Phil Factor

SQLServerCentral.com

Editorial

Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.

The Human Impact of a Capable AI

by Steve Jones

SQLServerCentral.com

Editorial

Computing systems and algorithms continue to improve, especially in the machine learning and AI spaces. What does that mean for us humans?

Backing Up SQL Server Databases Hosted on Azure VMs

by Additional Articles

SQLServerCentral

Azure VM

Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.

Using the DbFit Framework for Data Warehouse Regression Testing

Array Element by Agonizing Array Element

Cardinality Estimation for a Predicate on a COUNT Expression

Fixing an SSRS Password Error while Changing Credentials

SQL Database Analysis

Encrypting SQL Server: Dynamic Data Masking

Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#

Cracking the SQL Code

The Human Impact of a Capable AI

Backing Up SQL Server Databases Hosted on Azure VMs

Blogs

The Book of Redgate: Hours

How to Check TDE Progress and Elapsed Time in SQL Server

PostgreSQL Support in the Data API Builder

Forums

Squared Values

I Don't Want To Do XX

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

Question of the Day

Squared Values