Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime, using just SQL. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. No more desultory quests, when dealing with support issues, or when bug fixing, to find which database version was running when the bug happened.

Steps to Quickly Configure an AWS RDS SQL Server instance

by Additional Articles

MSSQLTips.com

Learn how to configure and deploy a new Amazon AWS RDS SQL Server instance with this step-by-step article.

Code Supply Chain Security

by Steve Jones

SQLServerCentral

software development

Building software is becoming harder as new attacks try to inject malicious code into products.

How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop

by Additional Articles

MSSQLTips.com

Database Design

Learn how to build scatter plots in Power BI and use the clustering option to automatically find clusters within the report data for easy visualization.

The Basics of Inserting Data into a SQL Server Table

by Additional Articles

SimpleTalk

insert
T-SQL

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement.

Things I've Learned About the Cloud

by Steve Jones

SQLServerCentral

Cloud Computing

Steve shares a few things he's learned from customers trying to migrate their systems to cloud computing platforms.

Rethinking SQL Explicit Transactions

by Additional Articles

MSSQLTips.com

Explicit Transactions

This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.

Learning New Technology Is Challenging

by Grant Fritchey

SQLServerCentral

Uncategorized

On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]