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

Data

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

Cache SQL Server Data in a .NET Web Application

The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.

22 mai 2023 dans Sites anglophones étiqueté .NET / Data / Database Development / SQL Server par sqlservercentral.com

Amazon RDS – Configuring a Connection to a SQL Server ...
Introduction In a previous article, we explored the factors worth considering when deploying a database in the public […]

21 novembre 2022 dans Sites anglophones étiqueté Amazon RDS / amazon rds instance / AWS / cloud / Cloud Computing / cloud database / Data / Database / RDS SQL Server / relational database service par sqlservercentral.com