Articles

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.

2022-10-14

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.

2022-10-14

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.

2022-10-12

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.

2022-10-12

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.

2022-10-10

Data Masking: Static vs Dynamic

by maxtardiveau

SQLServerCentral

data masking

Learn about how static data masking differs from dynamic masking and learn which one might be best for your organization.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2022-10-07

3,499 reads

Discuss

Build Conditional Logic - SQL IF, BEGIN, END, ELSE, ELSEIF

by Additional Articles

MSSQLTips.com

tSQLt

Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.

2022-10-07

Improving the Quality of Data Governance: Where to Start?

by Additional Articles

Redgate

Vendors/3rd-party Products

How do we set about improving the quality of data governance within an organization? What are the priorities? Data Governance is generally considered to mean providing clear roles, responsibilities, policies, principles, and organizational structures that can ensure that data is managed well, in a way that benefits the whole organization. Where do you start?

2022-10-07

Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance - Part 6

by Additional Articles

MSSQLTips.com

cloud

This article covers tips on establishing, enhancing, and empowering collaboration, communication, and governance on Cloud Transformation projects.

2022-10-05

Transaction locking and row versioning guide

by Additional Articles

SQLServerCentral

In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2022-10-05

Articles

Finding the Version of a Flyway-managed Database Using SQL

Steps to Quickly Configure an AWS RDS SQL Server instance

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

The Basics of Inserting Data into a SQL Server Table

Rethinking SQL Explicit Transactions

Data Masking: Static vs Dynamic

Build Conditional Logic - SQL IF, BEGIN, END, ELSE, ELSEIF

Improving the Quality of Data Governance: Where to Start?

Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance - Part 6

Transaction locking and row versioning guide

Blogs

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

What is CPU Usage?

Limiting Checkpoints

Question of the Day

Limiting Checkpoints