SQL Server Data Masking with DbDefence

Join the Redgate pre-con at PASS Data Community Summit

Take on the challenge of deploying database changes every 30 minutes in Redgate's Summit pre-con 'The Journey from Manual Deployments to Database DevOps' on November 15.

Hosted by Steve Jones, Grant Fritchey and Redgate DevOps experts, you'll start with a manual process and slowly implement changes that allow you to reap the benefits of automation.

The Basics of Inserting Data into a SQL Server Table

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. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement.

Load Data Asynchronously to SQL Server via an API and Python

Learn how to consume multiple API calls to load data to a SQL Server database using Python.

SQL Server Internals: Reading Pages

The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.

Finding the Version of a Flyway-managed Database Using SQL

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

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

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

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

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.

Rethinking SQL Explicit Transactions

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