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

SQL

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

Database Deployment with Terraform – Modules
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, […]

10 octobre 2022 dans Sites anglophones étiqueté Automated Deployments / Azure / Azure BLOB Storage / Azure Cosmos DB / Azure Data Lake / Azure SQL / Azure Synapse (formerly Azure SQL Data Warehouse) / Azure Synapse Analytics / azurerm / azuresql / CI/CD / CosmosDB / Database / DevOps / DevOps and Continuous Delivery (CI/CD) / iac / paas / SQL / Synapse / terraform par sqlservercentral.com

Maximize the Business Impact with Quest EMPOWER
You do not want to miss out on signing up with Quest EMPOWER. I will be there […]

19 septembre 2022 dans Sites anglophones étiqueté Quest / SQL par journey to sqlauthority

Database Deployment with Terraform – The Basics
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most […]

26 août 2022 dans Sites anglophones étiqueté Automated Deployments / Azure / Azure SQL / azurerm / azuresql / CI/CD / Database / DevOps / DevOps and Continuous Delivery (CI/CD) / iac / paas / SQL / terraform par sqlservercentral.com

INSERT EXEC statement cannot be nested, the Simple Solution
If you use the tSQLt unit testing framework for long enough, you will eventually run into the “An […]

19 août 2022 dans Sites anglophones étiqueté CLR / Common Language Runtime (CLR) / INSERT EXEC / SQL / SQL CLR / SQLCLR / t-sql / tSQLt / TSQLUnit / Unit Test / Unit Testing par sqlservercentral.com

Accessing Relational Databases in Go at Pluralsight
I just released my 42nd course on the learning platform Pluralsight. It was fun to build this […]

25 juillet 2022 dans Sites anglophones étiqueté Go Lang / Pluralsight / SQL par journey to sqlauthority