KEHINDE BOLA-DENNISmodebola.hashnode.dev·Sep 27, 2023Movies Analysis With Sql And Ms ExcelFor my recent project, I made use of SQL, MS Excel and MS PowerPoint. My tutor provided the dataset used. The dataset is about movie companies and movie genres from 1980 to 2020 DATASET https://drive.google.com/file/d/1UtGFdX7jCJTiUW4Mya39KpHJ1kDBwG...Discussdata
Giorgi Anakidzegioanakidze.hashnode.dev·Sep 26, 2023Entity Framework: 5 Rookie TrapsI’m pretty sure that everyone who works with C#/.NET has heard at least once about Entity Framework (EF). Whether it’s good or bad, it’s used widely and it will benefit you to know how to work with it. But what happens when a beginner developer enter...Discuss·69 readsBeginner Developers
Tim Lewistimlewis.hashnode.dev·Sep 25, 2023Seamless Integration: A Comprehensive Guide to Connecting Your Application to SQL ServerThe capacity to effortlessly interface your application with a relational database is essential in the data-driven world of today. The capabilities of your application can be substantially increased by connecting to a powerful database like SQL Serve...DiscussSQL Server
Ishioma Ubahishiomaubah.hashnode.dev·Sep 21, 2023Sql For Data AnalyticsI am now learning SQL for Data Analytics. It is interesting because I am figuring out different ways to solve a problem, getting different results for each applied step, figuring out why and deciding on the required output based on business requireme...DiscussSQL
Josef Richbergjosefrichberg.com·Sep 18, 2023Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# applicationIf you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas. Using this connection string: (Some portions were left out for brevity) "Server=tcp:<servername,port>;Initial Catalog=<database ...DiscussC#
Hemant Singhmemorycrypt.hashnode.dev·Sep 14, 2023A Comprehensive Guide to Using Dapper in C#Introduction Dapper is a lightweight and efficient Object-Relational Mapping (ORM) library for C#. Unlike other ORMs that can be complex and require significant configuration, Dapper is designed to be simple and straightforward. It provides a conveni...Discuss·54 readsC# and .NETDapper
Shreya Srivastavathisisshreya.hashnode.dev·Sep 12, 2023SQL Server vs PostgreSQL vs NoSQL DatabaseThis article covers the concepts, features and differences between the databases, namely SQL Server, PostgreSQL and NoSQL databases. Prerequisites Some knowledge about SQL Server and NoSQL What is a database? A database is an organized collection o...DiscussSQL Server
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·26 readsSQL Server
Stephen David-Williamsstephendavidwilliams.com·Sep 5, 2023An Introduction to SQL in Data EngineeringPreface🚀 Data engineering is a field that deals with turning raw data into useful and valuable information. It involves any activity that manipulates data into a format that can be used or digested by end users or applications to generate real-world...Discuss·36 readsSQL
Tim Hiltontjhilton.hashnode.dev·Aug 31, 2023Using SQL Server to manipulate JSON data structures, including a boolean gotchaThe problem I was solving I recently did some work to update the structure of some JSON stored in a SQL Server database. The JSON started out as a flat list of properties, and I wanted to add some structure by moving the properties into nested JSON o...DiscussCode & technical writingSQL Server