An Introduction to Azure Data Explorer

Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past are not capable of processing and storing all this data in an efficient way. We need […]

Looking Forward to SQL Server vNext

Releases of on-premises SQL Server arrived quite rapidly for a few years with seven releases during the years spanning 2008 and 2019. While it has technically been less than two years since SQL Server 2019 reached general availability in November 2019, it feels like ages since we have heard any news about what’s coming next. […]

Blogs

Daily Coping 17 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Running a SQL Server container from scratch

By

I’ve been interested (obsessed?) with running SQL Server in containers for a while now,...

Encryption in SQL Server #1 – Column Level Encryption

By

For one reason or another data security and encryption has been coming up quite...

Read the latest Blogs

Forums

How to find a user and a spid that holds database in single_user mode?

By SQL Guy 1

I am recreating a scenario when somebody or a process set database to single_user...

SSIS Import only new values from a CSV without using a staging table

By datsun

Hello, How can I import a CSV file in SSIS (2016) at the same...

Query store index rebuilds

By Rasmus Remmer Bielidt

Recently we experienced a sudden surge in disk I/O every twenty minutes or so....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers