Languages & Coding Archives - {coding}Sight https://codingsight.com/category/languages-coding/ Blog for SQL Server DBAs and Developers Mon, 04 Sep 2023 08:08:01 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Languages & Coding Archives - {coding}Sight https://codingsight.com/category/languages-coding/ 32 32 Different types of LINQ queries: Query Syntax and Method Syntax https://codingsight.com/different-flavors-of-linq-query-operations/ Sun, 02 Oct 2022 07:56:00 +0000 http://codingsight.com/?p=14513 The current article continues the series about LINQ. The previous part introduced the LINQ technologies and demonstrated its usage on some basic examples and a couple of more advanced coding challenges. The current article will further expose different ways to write LINQ query operations. LINQ queries can be written in two syntax types, a Query …

The post Different types of LINQ queries: Query Syntax and Method Syntax appeared first on {coding}Sight.

]]> Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer https://codingsight.com/spark-sql-the-most-important-tool-for-a-big-data-engineer/ Thu, 22 Sep 2022 08:44:00 +0000 http://codingsight.com/?p=19145 Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what exactly is Spark SQL? What are spark data frames? How can you learn using it? Let’s take a look at its functions, capabilities, and, more importantly, the results it can provide for you. Table of …

The post Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer appeared first on {coding}Sight.

]]> PgAdmin GUI client for PostgreSQL: Comprehensive Overview https://codingsight.com/an-overview-of-pgadmin-tool-for-postgres/ Sat, 20 Aug 2022 07:57:00 +0000 http://codingsight.com/?p=16283 The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides various graphical user interfaces for managing the Postgres relational database. It simplifies database management activities such as database creation, maintenance, database objects export\import, query tool, backup\restores, managing cluster objects. PgAdmin Features How to Download PgAdmin Tool The current PgAdmin …

The post PgAdmin GUI client for PostgreSQL: Comprehensive Overview appeared first on {coding}Sight.

]]> LINQ to Entities – Tutorial with Examples https://codingsight.com/introducing-linq-to-entities/ Wed, 03 Aug 2022 07:54:00 +0000 http://codingsight.com/?p=14805 When we think about querying databases, the first thing that pops to mind is usually some SQL query. Then other questions arise in regards to the database type, connection, query design, etc. LINQ to Entities combined with Entity Framework allows the developers to skip a big portion of these questions and worries. Entity Framework handles …

The post LINQ to Entities – Tutorial with Examples appeared first on {coding}Sight.

]]> An Overview of the SQL Variables Usage https://codingsight.com/an-overview-of-the-sql-variables-usage/ Fri, 25 Mar 2022 17:55:56 +0000 http://codingsight.com/?p=20041 The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle starts with declaration and ends with the batch. Similarly, if you use the local variable in a stored procedure, its scope is within the SP execution. The few typical usages of the SQL variables are as below. Single …

The post An Overview of the SQL Variables Usage appeared first on {coding}Sight.

]]> Getting Started with the SQL Server T-SQL CASE Expression Statement https://codingsight.com/getting-started-with-the-sql-server-t-sql-case-expression-statement/ Tue, 15 Mar 2022 15:44:46 +0000 http://codingsight.com/?p=19931 SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple conditions in the CASE..WHEN expression and get the associated output defined in the THEN or ELSE statement. CASE expression offers two approaches to compare and return a condition-based result. As per MSDN, the Simple …

The post Getting Started with the SQL Server T-SQL CASE Expression Statement appeared first on {coding}Sight.

]]> JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation https://codingsight.com/json-for-sql-server/ Mon, 26 Jul 2021 12:25:10 +0000 http://codingsight.com/?p=15741 In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used. In the SQL Server 2016, Microsoft implemented JSON support directly in the database engine, and the capabilities of data manipulation are increasing in each following version. The word comes as an abbreviation …

The post JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation appeared first on {coding}Sight.

]]> LINQ to XML: Easy Work in C# https://codingsight.com/xml-made-easy-linq-to-xml/ Fri, 23 Jul 2021 08:35:18 +0000 http://codingsight.com/?p=15718 LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the more traditional Document Object Model (DOM), LINQ to XML brings XML documents into memory and lets you query and modify them before saving the results to a file or data stream. What is different from the DOM is the …

The post LINQ to XML: Easy Work in C# appeared first on {coding}Sight.

]]> Query JSON Data with SQL/JSON Functions & Autonomous Database https://codingsight.com/json-query-data-with-sql-json-functions-autonomous-database/ Fri, 02 Jul 2021 10:07:43 +0000 http://codingsight.com/?p=14629 In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database. However, SQL Developer Web has its limitations. It only allows you to parse the first level of the JSON data. Thus, it won’t support parsing complicated JSON structures. So, does it mean …

The post Query JSON Data with SQL/JSON Functions & Autonomous Database appeared first on {coding}Sight.

]]> An Overview of Analytic Functions in PostgreSQL https://codingsight.com/an-overview-of-analytic-functions-in-postgresql/ Fri, 11 Jun 2021 09:57:16 +0000 http://codingsight.com/?p=14462 Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default. They allow you to execute a variety of analytical workloads on your datasets and prepare results. In the world of cloud computing, where we need to provide insights to customers in a swift and meaningful way, understanding these analytical functions solves …

The post An Overview of Analytic Functions in PostgreSQL appeared first on {coding}Sight.

]]>