Additional Articles


External Article

Data Transfer from Azure Blob Storage to Snowflake Using Pipelines

One of the premises of a modern warehouse is to be able to interconnect cloud services and process and analyze data from any provider with ease. Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data from/to those services, it is important to know how to interconnect them and be able to transfer data between services.

2023-08-11

External Article

PostgreSQL 101: The ten PostgreSQL extensions you need to know about

Extensions are a unique and powerful capability in PostgreSQL, a feature that other relational databases do not provide. Taking advantage of the extension framework in PostgreSQL is a true advantage to using the platform.

In this webinar, find out how PostgreSQL extensions can help you find solutions to some of your common problems.

Register now and to join on August 22nd

2023-08-11

External Article

Ordered Columnstore Indexes in SQL Server 2022

One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is not enforced by any SQL Server process. This leaves managing data order to us, which may or may not be an easy task.

2023-08-09

Technical Article

Standard Sponsor Rates End August 30!

Secure your Sponsorship package before the rates go up. PASS Data Community Summit 2023 is where the database community meets every year to make life-long connections with peers, network with industry leaders, and advance their careers. With over 170 technical sessions, and a great line-up of sponsors, this is your time to secure your space before August 30 and get a preferred booth location.

2023-08-09

External Article

Modifying MySQL data from within Python

In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.

2023-08-02

Blogs

Learning Database Design and Power BI Performance

By

I spend my days working on and managing SQL Server instances—working days at least,...

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Monday Monitor Tips: CIS Compliant

By

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...

Read the latest Blogs

Forums

Generative AI Services and the Future of Content Moderation Jobs

By inbathiru

Introduction to Generative AI Services Welcome to the cutting-edge world of Generative AI Services,...

need help with assigning a value to a variable

By water490

Hi I am trying to assign the value of the  variable using the output...

Merry Christmas 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Merry Christmas 2025

Visit the forum

Question of the Day

The Reindeer Count

How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.

See possible answers