Joubin Najmaiedatafragments.com·Jun 21, 2024Week of June 17 2024 - Mindmap RecapJune 17, 2024: Databricks - Issues with Excel Library in Clusters An issue was encountered with the crealytics:spark-excel library in Databricks. This Spark plugin is essential for reading and writing Excel files within Databricks. However, we observ...DiscussDatabricks
Joubin Najmaiedatafragments.com·Jun 9, 2024Week of June 3 2024 - Mindmap RecapThe importance of abstraction, reusability, error handling, efficient data manipulation, robust string handling, and performance optimization. Adopting these principles leads to cleaner, more maintainable, and high-performance code that becomes cruci...DiscussT-SQL
Shashidharreddyshashidharreddydakuri.hashnode.dev·Jun 1, 2024Difference Between SQL Server and PostgreSQL for .Net Application(My Research)How SQL Server is better than PostgreSQL for .Net core Project. While both SQL Server and PostgreSQL are great choices for .NET Core applications, SQL Server does have some advantages in specific areas: Deep Integration with Microsoft Services: If y...DiscussT-SQL
Data SenseiforSihan's Code Repocode-repo.hashnode.dev·Feb 20, 2024Nested IF in TSQL--nesting example DECLARE @Var1 INT = 15 IF @Var1 % 5 = 0 BEGIN IF @Var1 % 3 = 0 BEGIN print 'the number is divisible by 3 and 5' END ELSE BEGIN print 'the number is divisible by 5' END END ELSE BEGIN IF @Var1 %...DiscussSQL
Sadat Arefin Rafatdevrafat.hashnode.dev·Dec 18, 2023Detailed overview of Query Hints in T-SQLI needed to learn SQL Server Query Hints as part of my work. So I wrote a documentation outlining the query hints with examples. First I put summary. Then the detailed discussion. I took help from BARD in some cases, especially to summarize the descr...Discuss·50 readsSQL Hints
Josef Richbergjosefrichberg.com·Sep 6, 2023How to curb aggressive parallelism in Microsoft SQL ServerMicrosoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular programming paradigm (think Hadoop). This is done by the optimi...Discuss·77 readsSQL Server
Josef Richbergjosefrichberg.com·Jul 10, 2023Efficient calculation of an ISBN-13 check digitI thought I might pass along, what I have found to be, the most efficient way to validate the check digit within Azure SQL Server. I was looking to go down the path of a CLR, but it turns out that seems to be frowned upon. The function returns Y/N. F...Discuss·78 readsSQL Server
Sarang S Babusstechie.hashnode.dev·Nov 18, 2022SQL vs T-SQL vs PL/SQLOverview SQL (Structured Query Language) is an ANSI standard adopted in 1986. Many RDBMS (relational database management system) vendors have used it as a foundation. At the same time, PL/ SQL stands for Procedural Language Extensions SQL, an Oracle...Discuss·1 like·40 readsSQL
Massimiliano Figinimassyfigini.hashnode.dev·Jan 6, 2022Temporal Tables in SQL Server and Azure SQL DatabaseTemporal table: to provide information about data in a table at any point in time.On SQL Server from the 2016 version. -- This statement creates a Temporal Table CREATE TABLE dbo.ExampleTemporal ( Id INT NOT NULL PRIMARY KEY CLUSTERED, Col1 I...DiscussSQL
Emmanuel Tisseraemmti.com·Oct 14, 2015T-SQL for restoring a databaseBits and pieces of SQL code were gathered for my own use when restoring a database. Best used when back-porting data. Posted as a helper for myself - But feel free to modify and use it. -- INSTRUCTIONS: -- 1. Replace custom_database with the actual...Discuss·44 readsSQL
