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

SQL

Managed Instance Gotchas – Error Conditions

I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]

31 mars 2025 dans Sites anglophones étiqueté Azure SQL Managed Instance / Blogs / SQL par simple-talk.com

Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]

21 mars 2025 dans Sites anglophones étiqueté Data Lake / Data Warehouse / elt / ETL / lakehouse / Medallion architecture / Microsoft Fabric / Microsoft Fabric (Azure Synapse, Data Engineering, etc.) / Power BI / SQL par sqlservercentral.com

Azure SQL Serverless: Discover What’s new and Increase Your Savings

Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]

22 janvier 2025 dans Sites anglophones étiqueté Azure / Azure SQL Database / AZURE SQL SERVERLESS / Blogs / Database / Database Administration / SQL / SQL Server par simple-talk.com

Writing an Efficient Query
SQL is easy to start writing. The basic syntax to start returning data is very simple. This […]

19 octobre 2024 dans Sites anglophones étiqueté Back to Basics / Blogs / SQL / T-SQL Programming par simple-talk.com

EsProc SPL and SQL, Complimentary , But Different Technologies
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your […]

26 août 2024 dans Sites anglophones étiqueté development / EsProc SPL / Featured / SQL 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

Will AI end with SQL, Is this the end of ...
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI […]

11 mars 2024 dans Sites anglophones étiqueté Artificial Intelligence / Artificial Intelligence (AI) / Claude / SQL 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

SQL Window Functions Series: RANK() and DENSE_RANK()

Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]

15 novembre 2023 dans Sites anglophones étiqueté Advanced Querying / Advanced SQL / DENSE_RANK() / Performance / query optimization / RANK() / Ranking Functions / SQL / sql commands / SQL Data Exploring / Sql Functions / SQL Query / SQL Script / Window Functions par sqlservercentral.com

How to Use SQL to Analyze the Bitcoin Blockchain

Background The Bitcoin blockchain is a vast and complex database. It contains over 100 million blocks, each of […]

8 septembre 2023 dans Sites anglophones étiqueté bitcoin / blockchain / data analysis / SQL par sqlservercentral.com

SQL WHERE LIKE to Construct More Efficient Queries

The post SQL WHERE LIKE to Construct More Efficient Queries appeared first on SQLServerCentral.

2 juin 2023 dans Sites anglophones étiqueté Developer / queries / SQL / SQL Server par sqlservercentral.com

Unlock the Power of Google Cloud SQL: Setting Up SQL ...

Introduction to Google Cloud SQL Google Cloud SQL is a powerful and easy-to-use managed database service that lets […]

26 mai 2023 dans Sites anglophones étiqueté Cloud Computing / google cloud platform / Google Cloud SQL / MySQL / PostGreSQL / SQL par sqlservercentral.com