Writing an Efficient QuerySQL 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 TechnologiesHave 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 2024Before 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 BlockchainBackground 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 QueriesThe 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 – ModulesReusable 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 EMPOWERYou 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 BasicsThis 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 SolutionIf 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 PluralsightI 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
What’s new in T-SQL in SQL Server 2022There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a […] 4 juillet 2022 dans Sites anglophones étiqueté Blogs / SQL / SQL Server 2022 / TSQL par simple-talk.com
Hybrid Cloud MonitoringFor years database server’s were hosted on either on-premises or colocation data centers. It was straightforward to […] 28 juin 2022 dans Sites anglophones étiqueté Idera / MySQL / SQL par journey to sqlauthority