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.

Standard Sponsor Rates End August 30!

by Additional Articles

PASS

PASS Summit

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.

Archive to the Lake

by Steve Jones

SQLServerCentral

Microsoft Fabric changes the paradigm for how you might store data in your warehouse.

Combine DATE and TIME to DATETIME2 in SQL Server

by Jeff Moden

SQLServerCentral

The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".

7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide

by Additional Articles

Redgate

Vendors/3rd-party Products

Are you looking to modernize and migrate your data but have questions about the complex organizational challenges? We recently hosted the webinar: Overcoming Organizational Challenges in Data Modernization and Cloud Migration: A Guide for Senior IT Leaders. This blog post summarizes the conversation into 7 key points.

Using Power Query to Combine Data from Multiple Sheets in Excel

by Additional Articles

MSSQLTips.com

Power Query

This article employs Power Query features to combine queries and implement requirements in different listed scenarios.

Small Changes, Big Results

by RyanBooz

SQLServerCentral

Last week I was able to attend THAT conference in Wisconsin Dells, Wisconsin. It was my first time in the great state of cheese, and the conference lived up to its reputation. As a developer focused conference (rather than a database conference), I didn't have much expectation that my session about automating database changes would […]

AutomatedLab - A Quickstart for Deploying SQL Server Labs on Windows

by Mikey Bronowski

SQLServerCentral

Learn how you can use AutomatedLab to quickly create new environments.

Flexible Work Policies are Preferred

by Steve Jones

SQLServerCentral

Work environment

New research says that companies with flexible work policies, hybrid or remote, find they are able to hire staff more quickly.

Modifying MySQL data from within Python

by Site Owners

SimpleTalk

MySQL

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.

Ordered Columnstore Indexes in SQL Server 2022

Standard Sponsor Rates End August 30!

Archive to the Lake

Combine DATE and TIME to DATETIME2 in SQL Server

7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide

Using Power Query to Combine Data from Multiple Sheets in Excel

Small Changes, Big Results

AutomatedLab - A Quickstart for Deploying SQL Server Labs on Windows

Flexible Work Policies are Preferred

Modifying MySQL data from within Python

Blogs

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Question of the Day

String Similarity I