Resources  
  • Temporary Tables vs Common Table Expressions in SQL ServerMar 29, 2024. In this article, we will learn what is Differences Between Temporary Tables and Common Table Expressions in SQL Server. Temporary tables and Common Table Expressions (CTEs) are SQL Server tools for data manipulation.
  • Mastering DevOps: History, Benefits, and Real-World ApplicationsMar 26, 2024. This article delves into the fundamentals and advantages of DevOps through real-world examples. It covers DevOps history, its principles, workflow, continuous integration, and continuous deployment in detail.
  • Configuring Git in Azure Data Studio for SQL & Synapse PoolsMar 21, 2024. In this article, we'll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio.
  • Change Data Capture - CDC with SQL serverMar 21, 2024. Learn how CDC facilitates seamless data integration, enables efficient data replication, and ensures accurate data synchronization, providing businesses with timely insights and streamlined operations.
  • TINYINT Data Type in SQL and Its C# EquivalentMar 16, 2024. Understanding data types is crucial for effective data manipulation and storage. In this article, we will learn about TINYINT in SQL efficient storage for small integers. In C#, use byte or sbyte for representation. Optimization is crucial.
  • What is DateTime Manipulation in C#?Mar 12, 2024. Master DateTime manipulation in C# with this comprehensive guide. Explore methods like 'Add' and properties for modification, extract components, and learn about rounding and truncating DateTime values for robust applications.
  • How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQLMar 12, 2024. 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 CloudMar 11, 2024. 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, exploring its components, features, and capabilities to empower data-driven decision-making in the digital age.
  • Benefits of Temporary Tables over Table Variables in SQL ServerMar 10, 2024. 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 handling large datasets and complex data manipulation tasks.
  • A Comprehensive Guide to Nullable Reference Types in C# 10Mar 07, 2024. Explore a comprehensive guide to leveraging nullable reference types in C# 10 by Ziggy Rafiq, providing detailed explanations, code examples, and best practices for improving code safety and robustness. Learn how nullable reference types enable developers to catch null-related bugs at compile time, reducing the likelihood of runtime errors and enhancing code quality.
  • Implementing Broadcasting in BlazorMar 07, 2024. Blazor inherently doesn't have a broadcasting model. To address this limitation, we need to implement a broadcasting model within Blazor. Broadcasting allows components to exchange information regardless of their hierarchical or structural relationships within the application
  • What is Change Data Capture(CDC)Mar 07, 2024. Change Data Capture (CDC) is a method used in databases to track and capture changes in data. It enables real-time updates by identifying and recording modifications made to the database, facilitating efficient data integration, replication, and synchronization across systems.
  • Understanding FORMATMESSAGE() Function in SQL ServerMar 06, 2024. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • Renaming the Column in SQL ServerMar 06, 2024. 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 columns, ensuring data integrity and maintaining database structures.
  • Securing Remote Access to SQL ServerMar 05, 2024. 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 protection against cyber threats.
  • SQL Tuning - Effective Strategies with Practical ExamplesMar 03, 2024. SQL Tuning — Effective Strategies with Practical Examples
  • Product Management Application using .NET Core and React JS with CRUD OperationsMar 02, 2024. 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.
  • How to Open, Read or View MS SQL Error Log FileFeb 29, 2024. 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.
  • SQL Server Data Types for Performance, Memory EfficiencyFeb 28, 2024. "Embark on a journey to unlock SQL Server's full potential through savvy data type selection. Enhance performance and streamline operations with optimal choices.
  • Vue.js HTTP Handling: Dynamic Interactions, State, Uploads, Real-Time DataFeb 28, 2024. Vue.js, with its reactive framework and extensive ecosystem, provides developers with powerful tools to handle HTTP requests seamlessly. In this guide, we will explore advanced examples, extending beyond the basics, to showcase the versatility and capabilities of Vue.js in dealing with data fetching, error handling, and utilizing external libraries like Axios.
  • Quick SQL Refresher Feb 28, 2024. 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, exception handling, indexes, views, stored procedures, transaction control, triggers, and cursors.
  • Programming in Practice DisciplineFeb 27, 2024. Programming in Practice is a discipline that systematically applies engineering principles to the program design, development, and implementation of algorithms, program text editions, and testing. It is a part of the software engineering discipline, which also involves project management, software distribution, maintenance, and evolution of software systems. Programming in Practice can be deployed tanks to widely accepted best practice rules and design patterns for well-defined subdomains as follows: sequential programming, concurrent programming, real-time programming, parallel programming, and distributed programming.
  • Tips to Launch Your SQL MissionFeb 20, 2024. 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 into actionable strategies and invaluable tips to help you kickstart your SQL learning journey and unleash the transformative power of data manipulation and insight extraction.
  • Securing Your .NET Projects: Simple Strategies and Real ExamplesFeb 18, 2024. In today's digital world, keeping our software safe from cyber threats is super important. For developers working with .NET projects, it's not just a good idea but really necessary to make sure our apps are strong against potential attacks. Luckily, there are lots of tools and tricks within the .NET world to help us do this.
  • Date and Time Column Behavior in SharePoint List/LibraryFeb 12, 2024. In this article, we will learn how managing date and time column conversions in applications becomes challenging when your organization spans multiple offices across different time zones.
  • Difference Between UNION and UNION All (SQL Server)?Feb 12, 2024. 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 duplicates.
  • Polymorphism Concept in Object-Oriented ProgrammingFeb 12, 2024. What do you mean by polymorphism? Polymorphism is explained with C# examples, Polymorphism, a concept extending beyond programming, is illustrated in everyday scenarios. Electrical outlets serve as an analogy, supporting diverse devices—an example of polymorphism manifesting in real life.
  • Analysis of T-SQL and PL/SQLFeb 12, 2024. 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 efficient database application development.
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor Feb 11, 2024. 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, and recent user experience enhancements for streamlined stream processing logic.
  • How to Find Blocked Deadlocks in SQL?Feb 09, 2024. 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, connections, and SQL statements on a SQL Server instance.
  • The Amazing Adventure of MongoDB QueriesFeb 09, 2024. 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, execution as detective work, utilizing the Aggregation Framework for complex queries.
  • Difference Between Raw SQL and Dapper Feb 08, 2024. 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 informed decisions in your data retrieval strategies.
  • Apache Kafka with Dapr Bindings in .NETFeb 07, 2024. This content provides an in-depth overview of integrating Apache Kafka with Dapr Bindings for building distributed event-driven applications. It explains the key concepts of Apache Kafka, Dapr, and Dapr Bindings, along with step-by-step
  • Mastering T-SQL Rank FunctionsFeb 06, 2024. 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 numbers, RANK assigns unique ranks allowing ties
  • Automated Deployment of SQL Server Database through Azure DevopsFeb 06, 2024. 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 pipeline for deployment.
  • Data Vault Design in Azure SQL - Read PII with Customer KeysFeb 05, 2024. 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 Personally Identifiable Information (PII) is paramount during cloud migration.
  • 🖥️ How to Create an Web App in Microsoft Azure?Feb 05, 2024. 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 and deploy via FTP, enhancing efficiency in web development and hosting.
  • SQL Joins for Efficient Database QueriesFeb 05, 2024. 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 retrieval.
  • Building a Real-Time Chat App with Node.js and Socket.io 🚀Feb 04, 2024. Embark on a magical journey to build a real-time chat app using Node.js and socket.io. Follow simple steps to set up the server, create a chat UI, and handle real-time communication.
  • Optimize SQL Database PerformanceFeb 01, 2024. "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. for optimize SQL database performance, ensuring faster queries, reduced resource consumption, and improved overall database responsiveness.
  • SQL Server Migration Strategy into Azure SQL PaaS DatabaseJan 30, 2024. 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, and tools.
  • Implement CRUD Operations in .NET Core 8 with Dockerized MSSQL ServerJan 25, 2024. 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 Core Web API using .NET Core 8 and saving data in a Dockerized MS SQL Server. Follow the steps for setup and coding.
  • Run MS SQL Server on Docker 📦Jan 24, 2024. In this article, I'm going to show how to install Docker on Windows 11 and run the MS SQL server on it.
  • Working with SQL Lite Database in Asp.NET Core Web API Jan 21, 2024. 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 separate server process and operates directly on the client's device
  • 🖥️ A Guide to Web Attack Incident HandlingJan 17, 2024. 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, Local File Inclusion (LFI).
  • OPENJSON in SQL ServerJan 15, 2024. 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 it easier to integrate JSON data with traditional relational data. In this article, we'll explore the functionality, syntax, and use cases of OPENJSON in SQL Server
  • Building a Secure PHP MySQL Signup/Login Website with Email VerificationJan 15, 2024. 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 email verification. I'll focus on security best practices, including password encryption using PHP's built-in functions.
  • Working with Noda Time, .Net and Entity Framework (EF core)Jan 15, 2024. Working with NodaTime with EF core which is a alternative DateTime framework for .net applications.
  • Partitioning in PostgreSQL: What, Why, and HowJan 11, 2024. 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 organization and querying.
  • SQL Functions and Examples.Jan 10, 2024. 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.
  • Union and Union AllJan 10, 2024. 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.
  • Identifying the Root Cause of SQL Server ProblemsJan 10, 2024. 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 Management Studio for queries and execution plans, employ Profiler Traces, analyze Dynamic Management Views, monitor disk space, and review application code for optimization.
  • Interface Segregation PrincipleJan 10, 2024. 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, promoting cleaner design.
  • JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQLJan 10, 2024. 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 and code examples for a deeper understanding of the underlying concepts.
  • Deleting Duplicate Records Using CTEJan 09, 2024. In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
  • Real-Time Paris Metro Crowdedness Forecast: A Proof of Concept with Azure and C#Jan 08, 2024. In this article, we will learn about navigating you through crafting a prototype for forecasting crowd levels in Paris Métros using Azure and C#. It covers Azure setup, machine learning, model deployment, streaming pipeline creation, and user application integration.
  • Understanding the One-Way Nature of HASHBYTES in SQLJan 05, 2024. 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 SQL Server, isn't designed for decryption but serves as a vital tool for data integrity, password security, and more.
  • What is WebSQL?Jan 04, 2024. 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.
  • Safely Changing the Instance Name of SQL ServerJan 04, 2024. 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, covering essential steps and precautions to safeguard your SQL Server configuration.
  • Create a Powerful RESTful API for SQL Server CRUD OperationsJan 04, 2024. 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 operation (Create, Read, Update, Delete).
  • Connecting Postgres Database to Mobile App with Flutter and DartJan 03, 2024. Postgres Database to connect with your mobile app using Flutter and Dart
  • Truncate All Table Data in MSSQLJan 02, 2024. 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. Learn essential precautions.
  • Table(s): Temp Table, Table Variable and CTE (Common Table Expression)Dec 26, 2023. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
  • How To Create a WCF ServiceDec 26, 2023. 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?
  • Creating Dynamic PIVOT Query in SQL ServerDec 23, 2023. In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
  • Schemas in PostgreSQLDec 20, 2023. 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 organization, security, and improved database design.
  • Query to Find and Drop User-Defined Stored ProcedureDec 20, 2023. 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 in production environments; it poses serious risks.
  • MySQL: Unveiling its Versatility and Robustness for Diverse Use CasesDec 20, 2023. 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 efficient database management.
  • Implement Entity Framework A Code First Approach in .Net 8 APIDec 18, 2023. 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 designer, and the physical database will be generated using this model. The Model First approach means we create a diagram of the entity and relation that will be converted automatically into a code model.
  • Optimizing SQL Queries: CTE vs Temporary Tables for SpeedDec 17, 2023. In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
  • Row Constructors in PostgreSQLDec 13, 2023. 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 cases for optimization.
  • Reduction Consumed Storage in SQL DBDec 11, 2023. 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)
  • CrateDB: Powering the Internet of ThingsDec 11, 2023. 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, and demonstrates CrateDB integration through code snippets.
  • Getting Started With NodaTimeDec 08, 2023. Noda Time is an alternative date and time API for .NET. It helps you to think about your data more clearly, and express operations on that data more precisely.
  • Getting Started with SQL Server 2022 SSDT 17.8Dec 07, 2023. It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.
  • How Configure User’s Profile in Server 2019Dec 07, 2023. 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 restrictions, and more.
  • Join vs. Except and Intersect in SQLDec 06, 2023. SQL Improvement Performance Tips & Tricks. Explore SQL data retrieval methods with JOIN, EXCEPT, and INTERSECT keywords. JOIN combines rows from multiple tables based on a related column, while EXCEPT and INTERSECT compare and combine SELECT statement results.
  • Array Constructors in PostgreSQLDec 06, 2023. Explore the robust array feature in PostgreSQL, a powerful tool for storing and managing multiple values in a single column. Learn declaration, input, access, and manipulation techniques.
  • How to Get All SQL Server Agent Jobs in SQL Server?Dec 05, 2023. Retrieving a list of SQL Server Agent jobs in SQL Server Management Studio is a straightforward process. You can use the GUI provided by SSMS or run a T-SQL query to gather the necessary information.
  • Understanding LIKE vs ILIKE in PostgreSQLDec 05, 2023. In this article, we will focus on the differences between the LIKE and ILIKE operators, and how to use them effectively.
  • Efficient Data Fetching Techniques in SQL ServerDec 05, 2023. This article combines theory and hands-on SQL examples to showcase efficient data retrieval techniques in SQL Server. From indexing strategies to query optimization, it offers actionable insights for maximizing SQL Server performance.
  • PIVOT AND UNPIVOT Operators in SQL ServerDec 05, 2023. In this article, we are going to learn PIVOT and UNPIVOT Operators in SQL Server with some examples.
  • How to create a Microsoft Azure SQL Database in serverless compute tier from the Azure PortalDec 03, 2023. This article focuses on the swift creation of a serverless Azure SQL Database via the Azure Portal.
  • String Constants in PostgreSQLDec 01, 2023. Delve into PostgreSQL's handling of string constants, which is essential for managing text data. Explore their syntax, handling of special characters, and their versatile use in variable assignment, function arguments, comparisons, and more. Examples demonstrate their significance in tasks like substring replacement, regular expression matching, and date conversion. Elevate your PostgreSQL proficiency in manipulating and storing text data with these insights.
  • Dealing with Date and Time in Humanizer in C#Dec 01, 2023. Learn how to handle date and time in a user-friendly way in C# projects using Humanizer. Covering DateTime and TimeSpan humanization with customization options and real-world use cases for improved user experience.
  • Understanding Window Functions in PostgreSQLNov 30, 2023. In this article, we will learn how to use window functions in PostgreSQL, what are the different types of window functions, and how to write window function queries with examples.
  • How to Use Inheritance in PostgreSQL?Nov 29, 2023. PostgreSQL, a robust database system, introduces the concept of inheritance, enriching data organization. This article delves into utilizing PostgreSQL's inheritance for modeling hierarchical data, exemplified through products and categories. Explore the advantages, disadvantages, and querying nuances of this powerful feature.
  • How to Convert a Month Number to Month Name in PostgreSQLNov 28, 2023. Learn how to convert a month number to a month name in PostgreSQL using the versatile to_char function. Explore format strings like 'Month' and 'Mon' for full and abbreviated names.
  • Time Series Databases: Understanding, Using, and ImplementingNov 28, 2023. In our era of data dominance, managing and analyzing time-sensitive information is pivotal, especially in finance, IoT, and healthcare. Traditional databases grapple with time-stamped data, paving the way for Time Series Databases (TSDBs).
  • Manually Install MySQL on Windows Without MySQL InstallerNov 27, 2023. The article details manual installation steps for MySQL on Windows, emphasizing configuration options via option files, service installation methods, and password management, offering insights into customizing and managing MySQL instances beyond the ease of a wizard-based installer.
  • Date and Time Formatting in C#Nov 27, 2023. This guide provides a concise overview of working with DateTime in C#. It covers the basics of the DateTime structure, including obtaining the current date and time, representing specific dates, and manipulating dates.
  • Ranking Function in SQL ServerNov 23, 2023. This SQL Server tutorial explores ranking functions, including RANK(), ROW_NUMBER(), DENSE_RANK(), and NTILE(). With detailed examples, learn how these functions assign ranks, sequential row numbers, dense ranks, and group distribution in result sets.
  • Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data WarehouseNov 18, 2023. This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse.
  • .NET Core: Understanding of Scopes and Lifetime ManagementNov 17, 2023. Scopes and Lifetime Management in .NET Core: A Comprehensive Guide to Dependency Injection and Object Lifespan
  • Inserting 1 Million Dummy Product Data into SQL Server Using Bogus PackageNov 17, 2023. When working with databases, populating them with substantial amounts of data for testing or demonstration purposes is crucial. The Bogus package in C# provides a convenient way to generate fake data, making it an excellent choice for creating large sets of dummy records. This guide will walk you through inserting 1 million dummy product records into a SQL Server database using Bogus.
  • Learn to Avoid Query Governor Cost Limit Error in SQL ServerNov 13, 2023. Learn to solve "The query has been canceled because the estimated cost of this query... "
  • Mastering Database Management with Azure SQL DatabaseNov 02, 2023. Mastering Database Management with Azure SQL Database.
  • Improving SQL Table Data PerformanceNov 01, 2023. This article discusses strategies and best practices for optimizing SQL table data performance. Topics covered include indexing, normalization, partitioning, data types, query design, monitoring, hardware, caching, sharding, and maintenance. These practices aim to improve database efficiency and, in turn, enhance application performance and user satisfaction. Regular maintenance is stressed for sustained success.
  • Use Transaction Log to Recover the Deleted or Modified DataOct 31, 2023. This article is to use of Transaction Log to Recover the Deleted or Modified Data. The SQL Server Transaction Log plays an important role in recovering deleted or modified data if you mistakenly perform a DELETE or UPDATE operation with the wrong condition or badly without filtration condition. This can be achieved by listening to the records stored inside the SQL Server Transaction Log file.
  • Recover Deleted Table Data "without Backup" in SQL ServerOct 27, 2023. This article will discuss Recover Deleted Table Data "without Backup" in SQL Server.

About SignalR-Real-time-SQL-Broadcast

NA

OUR TRAINING