Sites anglophones

What happens when we drop a column on a SQL Server table? Where's my space?

Publié le 26 avril 2024 sur

Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The record/table size will remain unchanged. A metadata operation Dropping a column is a metadata/logical operation, not a physical one. This me …

[Video] Database Answers in Hong Kong

Publié le 25 avril 2024 sur

As my time in Hong Kong came to an end, I sat inside on a foggy morning and hit your top-voted questions from Here’s what we covered: 00:00 Start 01:32 MyTeaGotCold: Are there any signs of brain drain from SQL Ser …


Working with IAsyncEnumerable in C#

Publié le 24 avril 2024 sur

IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of data asynchronously. It is a great fit for building ETLs that asynchronously stream data to get it ready for transfer. You can think of IAsyncEnumer …


Troubleshooting Mysterious Blocking Caused By sp_getapplock

Publié le 24 avril 2024 sur

I’m kinda weird. I get excited when I’m troubleshooting a SQL Server problem, and I keep hitting walls. I’ll give you an example. A client came to me because they were struggling with sporadic performance problems in Azure SQL DB, and …

It’s almost time for Fundamentals Week! Have you signed up yet?

Publié le 23 avril 2024 sur

The Monday after next, I’ll be getting together with dozens of smart people who are a lot like you. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous ap …


Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3

Publié le 22 avril 2024 sur

The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some o …


Unlocking Power with Updatable Views in SQL Server

Publié le 22 avril 2024 sur

Relational database management systems (RDBMS) rely on Structured Query Language (SQL) as their foundation for data management and manipulation. Views in SQL Server offer a strong way to abstract the underlying intricacy of data structures. While many …

Kubernetes For Complete Beginners

Publié le 22 avril 2024 sur

The post Kubernetes For Complete Beginners appeared first on SQLServerCentral.


Building a Culture of Data: The Technical Aspects

Publié le 19 avril 2024 sur

In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While the lion’s share of the work will be getting people to work together and embrace ever deeper use of data, as a reader of Simpl …


Identifying Customer Buying Pattern in Power BI – Part 1

Publié le 19 avril 2024 sur

This article is part 1 of a retail analytics market-based analysis in Power BI.  In part 1, we will analyze customer purchasing frequency for various products, and the trend across years. Identifying And Analyzing The Data We will be using a sales samp …

[Video] Office Hours: Hong Kong Harbor

Publié le 18 avril 2024 sur

I recently went to Shanghai & Hong Kong, and stopped to take your questions from while sitting next to the Hong Kong harbor. Here’s what we covered: 00:00 Start 01:18 Jason G – RN & Accidental DBA: Wo …


Database Subsetting and Data Extraction

Publié le 17 avril 2024 sur

Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing and releasing of new versions of an existing production database, developers like to use their existing production data. In doing …



Exploration Experience: Saving and Creating Datasets

Publié le 17 avril 2024 sur

I have been talking about Data Exploration in Power BI on many of my sessions, specially the sessions about Data Marts. The new data exploration feature is one more feature on this expanding scenario for data exploration. This one brings some interesti …


How to Have a Conversation About Software Licensing

Publié le 17 avril 2024 sur

As a consultant, I sometimes see SQL Servers with high CPU core counts relative to their workload. For example, the situation that inspired this post was seeing half a dozen SQL Servers with ~50 cores each, hundreds of cores total – yet they cons …

Full vs. Incremental Loads – Data Engineering with Fabric

Publié le 17 avril 2024 sur

The loading of data from a source system to target system has been well documented over the years. My first introduction to an Extract, Transform and Load program was DTS for SQL Server 7.0 in 1998. In a data lake, we have a bronze quality zone that is …

Pages :