Additional Articles

Finding the Version of a Flyway-managed Database Using SQL

by Additional Articles

Redgate

Vendors/3rd-party Products

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

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

Convert Problematic Data in SQL Server

by Additional Articles

MSSQLTips.com

SQLServer

In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE.

2022-10-03

All authors

Additional 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

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

Convert Problematic Data in SQL Server

Blogs

Simple Talks Episode 7

A New Word: the McFly effect

Key mappings in Visual Studio Code

Forums

Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'

SSMS V20 encryption vs SQL Server SSL Encryption

Enable a Disabled Index

Question of the Day

Enable a Disabled Index