L'actualité technique MS SQL Server en France (et ailleurs)

Data

Incrementally Loading Data into Parquet with Python
Parquet is a column-oriented open-source storage format increasingly used for “big data” analytics. Yet despite its growing […]

17 juillet 2025 dans Sites anglophones étiqueté Data / Database / Database Administration / Databases / Parquet / Programming / Python / SQL / SQL Server par simple-talk.com

Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]

24 mai 2024 dans Sites anglophones étiqueté 2024 / bar / barisopen / baropen / beer / Conference / Conferences, Classes, Events, and Webinars / crowd / Data / datagrillen / DBA / Events / grillen / lingen / SQL / SQLFamily par sqlservercentral.com

Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […]

12 avril 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Azure SQL / BI / Data / Database / SQL Script / Uncategorized par sqlservercentral.com

SQL Window Functions Series: NTILE()

Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]

3 janvier 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced Querying / Advanced SQL / Data / ntile / Performance / SQL / SQL Script / SQL Server / Window Functions par sqlservercentral.com

SQL Window Functions Series: LAG() and LEAD()

In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]

11 décembre 2023 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Data / Database / Date Calculations / Date computation / DATEDIFF / LAG / LAG function / LEAD / OVER() / Performance / Performance and Tuning / Performance Tuning / Programming Language / SQL / SQL Compare / sql monitor / SQL Performance / SQL Prompt / SQL Script / SQL Server / t-sql / time series / TSQL / Window Functions par sqlservercentral.com

The difference between libraries and frameworks

The post The difference between libraries and frameworks appeared first on SQLServerCentral.

5 juillet 2023 dans Sites anglophones étiqueté Data / development / Framework par sqlservercentral.com

Data Transfer from Snowflake to Azure Blob using Synapse Analytics

The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.

9 juin 2023 dans Sites anglophones étiqueté Azure / Azure BLOB Storage / Azure Synapse (formerly Azure SQL Data Warehouse) / Data / snowflake par sqlservercentral.com