TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About SQL
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Pratik Somaiya (4)
Abiola David (4)
Ajay Kumar (4)
C# Corner Live (3)
Sarathlal Saseendran (3)
Alpesh Maniya (3)
Kuppu Swami (3)
Sardar Mudassar Ali Khan (3)
Keyur (3)
Anandu G Nath (3)
Vithal Wadje (2)
Nitesh Jha (2)
Raj Kumar (2)
Rohatash Kumar (2)
Dinesh Gabhane (2)
Ankit Sharma (2)
Nandan Hegde (2)
Manikandan Murugesan (2)
Jitendra Maurya (2)
Sivaruban Narayanapillai (2)
Aradhana Tripathi (2)
Jithu Thomas (2)
Subarta Ray (2)
Shaily Dubey (1)
Rohini Parade (1)
Srihari Chinna (1)
Humza Tufail (1)
Sai Sherlekar (1)
Nisarg Upadhyay (1)
Naveen Kumar (1)
Rohit Kainth (1)
Ravi Patel (1)
Jignesh Kumar (1)
Amit Mohanty (1)
Nipun Tomar (1)
Pankaj Kumar Choudhary (1)
Samir Behara (1)
Jaydeep Patil (1)
Mithilesh Tata (1)
Vijai Anand Ramalingam (1)
Farhan Ahmed (1)
Mahesh Chand (1)
Virendra Gour (1)
Mohamed Shifan Salideen (1)
Anupam Maiti (1)
Lakshmi V (1)
Hadshana Kamalanathan (1)
Mrunali Sawant (1)
Bala S (1)
Deepak Solanki (1)
Nitin Pandit (1)
Sharad Gupta (1)
Kisorjan Jakathiswaran (1)
Kiran B S (1)
Harunraseed Basheer (1)
Sanjeev Vishwakarma (1)
Arun Ramaswamy (1)
Rahul Singh (1)
George (1)
Ankit Sahu (1)
Dmytro Hubernatorov (1)
Satyaprakash Samantaray (1)
Najath Risni (1)
Jefferson S. Motta (1)
Related resources for SQL
No resource found
Vector Similarity Search in Azure Cosmos DB for PostgreSQL with pgvector & Azure AI Vision
3/14/2024 4:31:40 AM.
In this session, we will discuss about vector search with Azure AI Vision and Azure Cosmos DB for PostgreSQL.
Querying Azure SQL Databases In Databricks Spark Cluster
3/13/2024 8:44:48 AM.
We will see the entire steps for creating an Azure Databricks Spark Cluster and querying data from Azure SQL DB using JDBC driver. Later we will save one table data from SQL to a CSV file.
Inserting List of Records into Single SQL Column As XML File In ASP.NET MVC
3/13/2024 8:39:38 AM.
This tutorial guides you through the process of converting a list of records into XML and inserting it into a single SQL column, streamlining data storage and retrieval in your application.
How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQL
3/12/2024 10:59:03 AM.
In SQL, fetching data based on specific time intervals like day, week, month, and year is essential for meaningful analysis.
Basics of Azure Databricks: Data Analytics in the Cloud
3/11/2024 10:31:10 AM.
Azure Databricks stands at the forefront of cloud-based data analytics platforms, revolutionizing the way organizations manage, process, and derive insights from massive datasets. Azure Databricks, ex
Benefits of Temporary Tables over Table Variables in SQL Server
3/10/2024 8:15:37 AM.
The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handl
Code Only Design using ADO.NET Entity Framework 4.0
3/7/2024 8:43:43 AM.
This code snippet implements Code Only Design in ADO.NET Entity Framework 4.0, connecting to a SQL Server database, configuring entities, and binding data to a GridView with exception handling.
Remote Access Of The Database Using SQL Server
3/7/2024 8:36:49 AM.
Remote access to SQL Server databases enables users to connect to and manage databases from a location outside the physical server. It involves configuring network settings, security measures like aut
How To Secure PII Data In SQL Server Using .NET Assembly
3/6/2024 10:46:18 AM.
In this article, we will learn PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number, etc. When you are working with financial
How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)
3/6/2024 10:45:53 AM.
PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario
Display SQL Data Using Knockout in ASP.Net
3/6/2024 10:41:07 AM.
In this article, we will learn how to fetch SQL data in ASP.NET and display it dynamically using Knockout.js. Utilize AJAX to retrieve data as JSON and bind it to HTML elements, creating an interactiv
Practical Introduction To Entity Framework: Day 2
3/6/2024 10:30:54 AM.
This article provides a comprehensive guide on executing stored procedures using Entity Framework. It covers creating stored procedures in SQL Server, adding entity models to projects, and calling aut
Renaming the Column in SQL Server
3/6/2024 10:28:46 AM.
Renaming columns in SQL Server is a fundamental task in database management. This comprehensive guide provides step-by-step instructions, syntax examples, and best practices to effectively rename colu
Understanding FORMATMESSAGE() Function in SQL Server
3/6/2024 4:58:24 AM.
In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
Importing Access Database into SQL Server 2012
3/5/2024 10:40:07 AM.
Destructuring simplifies value extraction from objects/arrays. React's event handling enables dynamic responses to user interactions, crucial for interactive UIs. Components manage state/props, fa
How to Enable Remote Connections in SQL Server 2005
3/5/2024 10:39:30 AM.
This article provides guidance on enabling remote connections in SQL Server 2005, addressing the common error message encountered when attempting a remote connection. It outlines the security precauti
Covering Indexes And Filtered Indexes In SQL
3/5/2024 10:36:56 AM.
Hello Learners. I hope you all are doing great. This article describes the Covering Indexes and Filtered Indexes. I would like to tell you that these type of Indexes can only be created as NONCLUSTERE
SQL Server Error Logging From A Stored Procedure
3/5/2024 10:28:44 AM.
In this article, we will learn effective error handling in SQL Server stored procedures. Utilize RAISERROR to log errors, manage exceptions, and maintain robust error reporting mechanisms for enhanced
Enhance SQL Server Stored Procedure Performance – Tuning Tips
3/5/2024 9:26:01 AM.
Covering indexes and filtered indexes in SQL optimize database performance by efficiently retrieving data for queries. Covering indexes include all needed columns, while filtered indexes target specif
SQL CTE to Rank Sales by Products using Fabric Data Warehouse
3/5/2024 5:03:37 AM.
This video shows how to author Common Table Expressions in Fabric Data Warehouse to Rank Sales by Products.
Securing Remote Access to SQL Server
3/5/2024 4:16:02 AM.
Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
SQL Server Effective Database Tune up and Maintenance
3/4/2024 11:31:33 AM.
This document provides essential tips for effectively maintaining a production database, aimed particularly at developers who may not be professional database administrators. It covers topics such as
SQL Server Performance Tuning: Data Compression
3/4/2024 11:30:53 AM.
In this article, you will learn about Data Compression in SQL Server. Learn SQL Server Performance Tuning, Types of Data Compression like Row Compression, Page Compression, Dictionary Compression.
Improving SQL Performance Using Covering Indexes
3/4/2024 11:29:49 AM.
In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
SQL Tuning - Effective Strategies with Practical Examples
3/3/2024 5:01:15 AM.
SQL Tuning — Effective Strategies with Practical Examples
Product Management Application using .NET Core and React JS with CRUD Operations
3/2/2024 9:31:29 AM.
In this article, learn to create a product management web API with CRUD operations using .NET Core 6 and React JS. Utilize SQL Server for the backend and Axios for API consumption.
An Instant API using Data API Builder
2/29/2024 11:34:05 AM.
In the session, you will learn how to create an applications API layer from a single configuration file.
How to Open, Read or View MS SQL Error Log File
2/29/2024 10:47:38 AM.
Explore methods to open, read, or view SQL Server Error Log File. Get the best solution to open or view the SQL Server Log File of MS SQL Server in easy steps.
How to search the data from the associated external content type in SharePoint 2010
2/29/2024 10:36:46 AM.
In this article, we will be seeing how to search the data from the associated external content type. Searching data from associated external content types in SharePoint 2010. Learn to create ECTs, and
SQL Server Data Types for Performance, Memory Efficiency
2/28/2024 6:49:09 AM.
"Embark on a journey to unlock SQL Server's full potential through savvy data type selection. Enhance performance and streamline operations with optimal choices.
Quick SQL Refresher
2/28/2024 4:39:54 AM.
The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, excep
CRUP Operation with Dapper Using ASP.NET Core
2/27/2024 10:41:54 AM.
Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
How To Install SQLite On Windows 11
2/23/2024 6:55:34 AM.
Learn how to easily install SQLite on your Windows 11 system. Download the setup, configure environment variables, and use the command prompt to set up the SQLite shell for efficient database manageme
Azure Document DB CRUD Operation
2/21/2024 11:38:53 AM.
This article explains how to create documents into SQL (DocumentDB) API. Before starting, we need to understand what is documentDb and how it works. SQL (DocumentDb) API is one of API comes under Azur
Blazor - Create SPA With Azure Database For MariaDB Server
2/21/2024 8:27:24 AM.
We will create a MariaDB database service in Azure and connect MariaDB in a Single Page Blazor application. Azure Database for MariaDB is a relational database service in the Microsoft cloud. Azure Da
Blazor - CRUD Using PostgreSQL And Entity Framework Core
2/20/2024 3:13:20 PM.
We will see the CRUD actions in Blazor framework with PostgreSQL database and Entity Framework Core. We will create a sample Patient app with all CRUD actions.
Tips to Launch Your SQL Mission
2/20/2024 11:34:01 AM.
This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep i
ASP.NET Core - Expense Manager Using EF Core And Highcharts
2/20/2024 7:31:47 AM.
We will create a personal expense manager using Asp.NET Core 2.1 and Entity Framework core Code first approach with the help of Highcharts to show the expense summary chart and a modal dialog to handl
Installing and Configuring XAMPP on Windows 11
2/20/2024 6:51:27 AM.
This article provides a comprehensive guide on installing XAMPP, the popular PHP development environment, on Windows 10/11. XAMPP includes Apache, MySQL, PHP, and Perl, making it a convenient solution
Deploying A Blazor Application On Azure
2/19/2024 10:00:19 AM.
This comprehensive guide walks through the process of deploying an ASP.NET Core-hosted Blazor application on Azure, covering steps from creating an SQL database server to publishing the application.
Cloud Security: Secure Access from your Applications to Azure SQL
2/19/2024 4:47:28 AM.
In this session, you will discover the differences between authentication on-premises and in the cloud and learn how to go way beyond the basic user/password for authentication.
SQL Server Migration Strategy into Azure SQL PaaS Database
2/16/2024 3:47:43 AM.
This article outlines a strategic approach to migrating SQL database workloads from on-premises to Azure cloud services. It covers the high-level migration roadmap, choosing the right migration path,
Difference Between UNION and UNION All (SQL Server)?
2/12/2024 11:55:50 AM.
UNION merges and filters out duplicates from various SELECT queries, whereas UNION ALL combines them without eliminating duplicates, providing quicker results but retaining all rows, including duplica
Analysis of T-SQL and PL/SQL
2/12/2024 4:03:24 AM.
This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for effici
New Modifications and Improvements to the Azure Stream Analytics No-Code Editor
2/11/2024 8:22:36 AM.
Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations,
The Amazing Adventure of MongoDB Queries
2/9/2024 9:21:46 AM.
This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, executi
How to Find Blocked Deadlocks in SQL?
2/9/2024 8:42:19 AM.
The SQL query utilizes dynamic management views (DMVs) like sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_connections, and sys.dm_exec_sql_text to monitor and manage active sessions, connect
Difference Between Raw SQL and Dapper
2/8/2024 8:55:42 AM.
Explore the trade-offs between using raw SQL queries and leveraging Dapper, a micro-ORM for database access in C# development. Delve into performance, code maintainability, and efficiency to make info
Create ASP.NET Web App With SQL Database In Azure
2/7/2024 4:50:27 AM.
In this article, you will learn to create an ASP.NET web app with SQL Database on Azure! Prerequisites include a Microsoft Azure Account and Visual Studio 2013/2015. Follow the steps to create a SQL D
Mastering T-SQL Rank Functions
2/6/2024 9:28:41 AM.
SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential nu
Top 10 Most Used SQL Queries
2/6/2024 6:39:43 AM.
In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
Requirements to Install SQL Server 2014
2/6/2024 6:28:59 AM.
In this article I explain what are requirements to install SQL Server 2014
DATEPART Function in SQL Server
2/6/2024 6:26:51 AM.
This SQL Server tutorial explores the Datepart function, a built-in function for extracting portions of a DateTime field, demonstrated through practical examples for various date and time components.
Automated Deployment of SQL Server Database through Azure Devops
2/6/2024 4:04:30 AM.
Explore an automated deployment solution for SQL Server databases using Azure DevOps. This guide details the setup of a self-hosted agent, granting necessary server access, and configuring a release p
Data Vault Design in Azure SQL - Read PII with Customer Keys
2/5/2024 11:00:54 AM.
Data Vault design in Azure SQL - Utilizing Customer keys to read PII information in databases. Ensuring data security in the cloud era is crucial, especially with the rise in data attacks. Protecting
🖥️ How to Create an Web App in Microsoft Azure?
2/5/2024 9:42:03 AM.
In this article, we will see how to create a web app in Microsoft Azure in step by step. Azure Web App, a fully managed PaaS from Microsoft Azure, simplifies web app deployment. Learn how to create an
SQL Joins for Efficient Database Queries
2/5/2024 5:54:13 AM.
Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data
Optimize SQL Database Performance
2/1/2024 8:40:21 AM.
"Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases
Full-Stack Web Development in ASP.NET Core 8 MVC
1/30/2024 4:10:26 AM.
Full-stack web development refers to the practice of designing, developing, and deploying both the client-side (front-end) and server-side (back-end) components of a web application. In this, develope
Implement CRUD Operations in .NET Core 8 with Dockerized MSSQL Server
1/25/2024 5:31:16 AM.
In this article, I'm going to implement the basic CRUD Operations using .Net Core Web API & the Dockerized MSSQL Server. This article guides you through implementing CRUD operations in ASP.NET
Run MS SQL Server on Docker 📦
1/24/2024 6:27:51 AM.
In this article, I'm going to show how to install Docker on Windows 11 and run the MS SQL server on it.
Lazy Loading In ASP.NET Core 7 Web API
1/22/2024 9:09:14 AM.
ASP.NET Core 7 Web API. Lazy loading is a technique where related data is only loaded from the database when it is explicitly requested. In Entity Framework Core, lazy loading can be achieved by marki
Working with SQL Lite Database in Asp.NET Core Web API
1/21/2024 1:32:23 PM.
SQLite is a self-contained, serverless, and zero-configuration relational database management system (RDBMS). It is a lightweight, open-source, and embedded database engine that does not require a sep
🖥️ A Guide to Web Attack Incident Handling
1/17/2024 9:02:52 AM.
In this article, we will explore various types of web attacks, including Denial of Service (DoS) and Distributed Denial of Service (DDoS), SQL Injection, Cross-Site Scripting (XSS), Command Injection,
Building a Secure PHP MySQL Signup/Login Website with Email Verification
1/15/2024 8:48:49 AM.
Creating a secure signup/login system is essential for any web application that involves user authentication. In this article, I'll guide you through building a PHP MySQL login/signup website with
OPENJSON in SQL Server
1/15/2024 5:50:12 AM.
SQL Server's OPENJSON function is a powerful tool for working with JSON data in relational database systems. It allows users to parse and transform JSON-formatted strings into tabular data, making
Partitioning in PostgreSQL: What, Why, and How
1/11/2024 4:44:32 AM.
PostgreSQL partitioning enhances database management by dividing large tables into smaller, manageable partitions. Learn the benefits and types (range, list, hash, composite) for efficient data organi
JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQL
1/10/2024 10:39:54 AM.
In this series of articles, we'll focus on a hands-on, practical implementation of JWT authentication with refresh tokens in .NET Core 6.0 using ADO.NET and SQL, emphasizing real-world scenarios a
Union and Union All
1/10/2024 6:55:52 AM.
This article will tell you the use of union and union all and difference between them and some key points that are important to follow in union and union all syntax.
Interface Segregation Principle
1/10/2024 6:15:27 AM.
The Interface Segregation Principle advocates breaking down a large interface into smaller, client-specific interfaces. This ensures that no class is compelled to depend on methods it doesn't use,
SQL Functions and Examples.
1/10/2024 6:08:41 AM.
This article provides you with many built-in SQL functions including aggregate functions, date functions, string functions, control flow functions, window functions, and math functions.
Identifying the Root Cause of SQL Server Problems
1/10/2024 5:17:17 AM.
Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Manag
Deleting Duplicate Records Using CTE
1/9/2024 7:00:44 AM.
In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
Understanding the One-Way Nature of HASHBYTES in SQL
1/5/2024 10:48:17 AM.
This article delves into the cryptographic world of hashing algorithms, emphasizing the irreversible nature of these functions. Learn why HASHBYTES, a widely-used function for creating hash values in
What is WebSQL?
1/4/2024 11:55:46 AM.
Explore the fundamentals of WebSQL, a deprecated but once widely used client-side storage solution for web applications. Learn its basics, from setting up a database to CRUD operations with SQL.
Create a Powerful RESTful API for SQL Server CRUD Operations
1/4/2024 7:57:08 AM.
Discover the world of building simple and effective APIs that talk to SQL Server databases. Learn how to safely handle data, improve performance, and get hands-on with coding examples for each CRUD op
Safely Changing the Instance Name of SQL Server
1/4/2024 5:24:47 AM.
Changing the instance name of a SQL Server involves several steps and should be done with caution. Secure process for changing the instance name of SQL Server. This guide ensures a smooth transition,
Query to Find and Drop User-Defined Stored Procedure
1/3/2024 9:53:53 AM.
In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run
Connecting Postgres Database to Mobile App with Flutter and Dart
1/3/2024 9:18:11 AM.
Postgres Database to connect with your mobile app using Flutter and Dart
Connecting MySQL Database to Mobile App with Flutter and Dart
1/3/2024 7:20:56 AM.
MySQL Database to connect with your mobile app using Flutter and Dart
Truncate All Table Data in MSSQL
1/2/2024 10:49:45 AM.
In this article we will learn about how to truncate all tables in a SQL Server database using dynamic SQL. Exercise caution, as this operation deletes all data without the possibility of rollback. Lea
Azure Cosmos DB Interaction through Python
1/2/2024 9:01:56 AM.
This article speaks about the techniques to interact with Cosmos DB using Python. Azure Cosmos DB, a fully managed NoSQL and relational database for modern app development. Learn how to build a Python
Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET
1/1/2024 7:47:53 AM.
Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET: Best Practices and Code Examples
Consistency Levels in Azure Cosmos DB with an Example
12/27/2023 8:15:56 AM.
In this article, we will learn about the Azure Cosmos DB multiple consistency levels, including strong, boundless, session, consistent prefix, and eventual, with an example and scenario.
How To Create a WCF Service
12/26/2023 8:48:44 AM.
How can I create a WCF service that manages employee details while interacting with an SQL database, including the necessary SQL table script for employee information storage?
Table(s): Temp Table, Table Variable and CTE (Common Table Expression)
12/26/2023 7:51:55 AM.
This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
Cross Tab Report in Fabric Data Warehouse using PIVOT Operator
12/26/2023 5:02:06 AM.
The Pivot operator allows transforming rows into columns and performing aggregation on data. It improves the readability and clarity of the query. This video shows how to create cross-tab report in Fa
Creating Dynamic PIVOT Query in SQL Server
12/23/2023 11:50:26 AM.
In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
Inner Join SQL Query in Fabric Notebook using PySpark
12/22/2023 5:15:40 AM.
This video shows how to write inner join SQL Query in Microsoft Fabric Notebook using Spark.
Schemas in PostgreSQL
12/20/2023 5:56:28 AM.
Understanding Schemas in PostgreSQL. Explore the power of PostgreSQL's schemas—logical groupings of database objects. Learn how to create, manage, and leverage schemas for effective data organizat
MySQL: Unveiling its Versatility and Robustness for Diverse Use Cases
12/20/2023 4:10:36 AM.
Explore MySQL's diverse use cases in web applications, e-commerce, CMS, data warehousing, telecommunications, and finance. Dive into its key features, architecture, and crucial queries for efficie
Implement Entity Framework A Code First Approach in .Net 8 API
12/18/2023 11:14:53 AM.
In this article, we are going to discuss. How to implement Entity Framework a code first approach in .Net 8 API. In this approach, model classes and their relation are created first using the ORM des
Optimizing SQL Queries: CTE vs Temporary Tables for Speed
12/17/2023 7:22:44 AM.
In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
Data Pipeline to Copy Data from Azure SQL Database to Fabric Data Warehouse
12/13/2023 5:03:20 AM.
Moving data in-between and across different technologies is one of the jobs of data engineers. In this new video, I demoed how to create data pipeline to copy data from Azure SQL Database to Fabric Da
Row Constructors in PostgreSQL
12/13/2023 4:27:10 AM.
Explore the power of row constructors in PostgreSQL, enabling efficient row-wise data manipulation. This guide covers syntax, applications in SELECT, INSERT, UPDATE, DELETE statements, and common use
CrateDB: Powering the Internet of Things
12/11/2023 6:06:56 AM.
CrateDB, an open-source distributed SQL database, is spotlighted for its efficacy in handling IoT complexities. This article explores use cases, including time-series data, analytics, and scalability,
Reduction Consumed Storage in SQL DB
12/11/2023 5:10:53 AM.
The simple way to reduce consumed DB storage on production app, with data migration and without dramatic changes in DAL (no additional services are required)
Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server
12/7/2023 9:19:11 AM.
In this article, you will learn how to bind the data in WebGrid control, using stored procedure in ASP.NET MVC 4.0 & SQL Server 2012.
How Configure User’s Profile in Server 2019
12/7/2023 6:22:57 AM.
This article guides you through configuring user profiles on Windows Server 2019 for effective access control and privilege enforcement. Learn step-by-step procedures, including logon hours, log-on to
Getting Started with SQL Server 2022 SSDT 17.8
12/7/2023 6:12:21 AM.
It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.