T-SQL

Resources

Exploring the New T-SQL Enhancements in SQL Server 2022Oct 31, 2024. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and optimize performance for modern data needs.
BIT Functions New T-SQL Enhancements in SQL ServerOct 30, 2024. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
Windowing Enhancements New T-SQL Enhancement in SQL ServerOct 29, 2024. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, reduce code duplication, and improve readability.
GENERATE_SERIES Function New T-SQL Enhancements in SQL ServerOct 25, 2024. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gaps, and generating test data.
TRIM Function New T-SQL Enhancements in SQL ServerOct 25, 2024. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim from specific positions.
STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL ServerOct 16, 2024. The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of each value's original position in the string.
Least and Greatest New T-SQL Enhancements in SQL ServerOct 15, 2024. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
DATETRUNC New T-SQL Enhancements in SQL ServerOct 09, 2024. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
DATE_BUCKET Function New T-SQL Enhancements in SQL ServerOct 05, 2024. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL functions and provide examples that demonstrate how to use it effectively.
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL ServerOct 04, 2024. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data integrity and performance.
Simple Image or File Import Using T-SQL for SQL ServerApr 03, 2024. The article demonstrates importing image files into SQL Server using T-SQL's OPENROWSET, BULK, and SINGLE_BLOB. It covers basic examples and prerequisites, allowing dynamic file paths and names for flexibility.
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.
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
Intro To T-SQL For Data ScienceMay 12, 2021. In this article, we’ll learn about Database as a whole and use examples and features of T-SQL to learn to find meaning out of raw data.
Top 10 Hottest And Tricky T-SQL Questions For BeginnersMar 08, 2021. Transact-SQL (T-SQL) is an extension to SQL developed by Microsoft and Sybase used to administer SQL Server.
Useful T-SQL For Date CalculationsMay 01, 2014. In this article, we will see some useful T-SQL for date calculation.
SQLCLR vs. T-SQL - Performance ComparisonDec 09, 2010. Before comparing the performance of SQLCLR and TSQL, just have a quick at the definition of SQLCLR.
T-SQL Script for Purging Tables with Foreign Key ReferencesAug 02, 2024. This article provides a comprehensive T-SQL script for purging tables in SQL Server, including those with foreign key references, ensuring data integrity and correct order of operations. Ideal for SQL Developers, Data Engineers, and DBAs seeking efficient data management solutions.
Error handling in Transact-SQL (T-SQL) Jul 13, 2024. Effective error handling in T-SQL (Transact-SQL) is vital for managing unexpected issues in database operations. Using TRY-CATCH blocks, RAISEERROR, and error functions like ERROR_MESSAGE and ERROR_NUMBER, developers can catch and handle errors gracefully.
Difference between SQL and T-SQLMay 09, 2024. In the realm of relational database management systems (RDBMS), SQL (Structured Query Language) and T-SQL (Transact-SQL) are often used interchangeably. In this article, we'll delve into the key differences between SQL and T-SQL, shedding light on their respective features, functionalities, and use cases.
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.
Date and Time Functions in T-SQLJul 25, 2023. This article represents the comprehensive guideline for date and time functions in T-SQL.
Working with Date and Time Formats in T-SQLMay 22, 2023. This article describes how different date styles work with date formats
T-SQL - Pivoting And Unpivoting DataSep 20, 2022. In this article, you will learn about T-SQL - Pivoting And Unpivoting data.
T-SQL Interview Questions On Data Types Jul 30, 2022. In this article, I collected interview questions on data types. I participated in many interview calls and I was asked about (sometimes I asked the interviewee) many times the below interview questions .
T-SQL Subqueries In PracticeJul 21, 2022. This article will demonstrate the two types of subqueries and their practical usage.
XML Shredding In T-SQLJul 19, 2022. In this article, you will learn about XML shredding in T-SQL.
Logical Query Processing In T-SQLJul 19, 2022. This article demonstrates the practical values of knowing Logical query execution in TSQL.
Client-Server WASM-Application In C#, TypeScript And Transact-SQLJul 21, 2020. In this article, we describe a Blazor-WASM sample application. Although the article is associated with Web-development, it is not about the classical web. It is related to general Client-Server programming in conventional languages but in connection with existing Web-reality to which some experimental things are applied.
T-SQL - Display Decimal Numbers As MoneyOct 17, 2017. In this article, we will show how to display decimal numbers as money with and without cents
T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
Error And Exception Handling in T-SQLJan 21, 2015. In this article you will learn about exception handling in T-SQL.
Restore a SQL Server BACKUP Using Transact-SQLJul 22, 2014. This article describes how to restore a SQL Server backup using one of multiple methods using Transact-SQL.
SQL Server DATABASE BACKUP With Multiple Methods Using Transact-SQLJul 17, 2014. This article describes SQL Server database backups and how to take a SQL Server database backup with multiple methods using Transact-SQL.
SQL Server Transact-SQL ProgrammingJul 04, 2014. This article explains Transact-SQL Programming in SQL Server.
Backup and Restore Using Command Prompt - SQLCMD and T-SQLSep 09, 2013. In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt.
T-SQL Query Performance Tuning TipsAug 09, 2013. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
CASE Statement In Transact-SQLJan 04, 2013. In this article, I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement
Insert Master-Detail Data using Transact-SQLJun 24, 2005. This document explains how to utilize SQLXML in SQL Server 2000 for efficient batch operations with XML data. It outlines the process for creating stored procedures to insert, update, and delete records in a database using OpenXML.
Entity Framework Core Interceptors: Real-World Use Cases and ExamplesJun 05, 2026. Learn Entity Framework Core Interceptors with real-world examples. Implement auditing, soft deletes, SQL logging, and performance monitoring in EF Core applications.
SQL Server Performance Tuning Techniques for Modern ApplicationsJun 05, 2026. Learn SQL Server performance tuning techniques including indexing, query optimization, execution plans, statistics management, and database best practices.
SQL Server Performance Tuning Techniques for Modern ApplicationsJun 05, 2026. Learn how to build scalable background services using .NET Worker Services. Process queues, run scheduled jobs, and create reliable cloud-native applications.
Azure Managed Identity Explained with Real-World ExamplesJun 03, 2026. Learn Azure Managed Identity with real-world examples. Discover how to securely access Azure resources without storing passwords, secrets, or connection strings.
SQL Join Optimization: Improve Query Performance on Large TablesJun 03, 2026. Learn SQL Join Optimization techniques to improve query performance on large tables using indexes, execution plans, filtering, and SQL Server best practices.
Database Connection Pooling Explained with ExamplesJun 03, 2026. Learn Database Connection Pooling with practical examples. Understand how connection pools improve performance, scalability, and database efficiency.
Implementing Row-Level Security in SQL ServerJun 03, 2026. Learn how to implement Row-Level Security in SQL Server. Secure data access, restrict rows by user, and simplify multi-tenant application security.
Using the COPY INTO Command to Load Data from Fabric Lakehouse to Fabric WarehouseJun 01, 2026. In this article, I demonstrated how to use the COPY INTO Command to Load Data from Microsoft Fabric Lakehouse to Fabric Warehouse
SQL Injection: Complete Guide with Examples and Proper SolutionsMay 21, 2026. Master SQL Injection: Understand attack types, real-world examples, and robust solutions. Learn to protect your applications with best practices and secure code.
Complete Guide to ASP.NET Core API SecurityMay 21, 2026. Comprehensive guide to ASP.NET Core API security, covering authentication, authorization, encryption, and best practices from beginner to advanced levels. Protect your APIs!
Count of repeating character patterns in a string using MySQLMay 13, 2026. Discover how to count repeating character patterns in strings using MySQL. This tutorial provides a step-by-step guide with code examples for text analysis and pattern recognition.
How to Implement Soft Delete in SQL Server Using Flag ColumnsMay 04, 2026. Implement soft delete in SQL Server using flag columns for data preservation, audit trails, and recovery. Learn best practices, advantages, and real-world use cases.
What is Query Execution Plan in SQL Server and How to Analyze It?May 04, 2026. Unlock SQL Server query performance! Learn to analyze execution plans, identify bottlenecks like table scans, and optimize queries with indexes for faster, scalable databases.
SQL Optimization TechniquesApr 28, 2026. SQL Optimization Techniques
How to Check If a Stored Procedure Exists in SQL ServerApr 29, 2026. A comprehensive guide explaining how to check whether a stored procedure exists in SQL Server using multiple methods such as INFORMATION_SCHEMA, sys.procedures, OBJECT_ID, and SSMS UI. The article also highlights practical use cases, best practices, and common issues developers face while validating stored procedures across different environments like development and production.
How to Connect SQL Server with C# Using Entity Framework CoreApr 23, 2026. Learn how to connect SQL Server to your C# application using Entity Framework Core. This tutorial covers setup, migrations, CRUD operations, and common pitfalls.
How to Fix SQL Server Allocation Errors and Recover Corrupted DatabasesApr 23, 2026. Fix SQL Server allocation errors and recover corrupted databases using DBCC CHECKDB or a professional SQL repair tool. Learn to detect and prevent these errors.
SQL Server Performance Tuning: A Guide for .NET DevelopersApr 21, 2026. SQL Server Performance Tuning: A Guide for .NET Developers
How to implement full-text search in SQL Server with exampleApr 22, 2026. Step-by-Step Implementation with Example
What is database indexing strategy for large-scale applications?Apr 22, 2026. Optimize large-scale apps with database indexing! Boost performance, reduce query time, and improve user experience. Learn strategies for efficient data retrieval.
How to Implement Optimistic Concurrency Control in SQL Server?Apr 21, 2026. Learn how to implement optimistic concurrency control in SQL Server step by step using RowVersion with examples, conflict handling, and best practices.
What is Database Denormalization and When Should You Use It?Apr 21, 2026. Learn what database denormalization is, how it works, and when to use it with real-world examples, advantages, and best practices for performance optimization.
How to Implement Database Triggers in SQL Server with ExampleApr 20, 2026. Learn how to implement SQL Server database triggers step-by-step with real-world examples. Automate tasks like logging, validation, and auditing. Improve data consistency and enforce business rules efficiently. Discover best practices and avoid common pitfalls.
What is Clustered vs Non-Clustered Index in SQL Server?Apr 20, 2026. Unlock SQL Server performance! Master clustered vs. non-clustered indexes. Learn how they work, their differences, and when to use each for optimal database efficiency.
How to Handle Duplicate Records in SQL Queries EfficientlyApr 20, 2026. Master SQL duplicate record handling! Learn to identify, remove, and prevent duplicates for improved data integrity and performance. Essential for robust database management.
How to Design Database Indexes for High Performance QueriesApr 16, 2026. Boost database performance! Learn to design effective indexes for faster queries. Optimize SQL, MySQL, & PostgreSQL. Avoid common mistakes and scale efficiently.
What is Deadlock in SQL Server and How to Prevent It?Apr 16, 2026. Unlock SQL Server deadlock prevention! Learn causes, detection, and step-by-step techniques for optimized database performance and improved user experience.
How to Implement Database Partitioning in SQL Server Step by Step?Apr 17, 2026. Boost SQL Server performance! Learn database partitioning step-by-step: filegroups, functions, schemes, and tables. Handle large datasets efficiently and scale easily.
What is Stored Procedure vs Function in SQL with Examples?Apr 17, 2026. Unlock the power of SQL! Learn the key differences between Stored Procedures and Functions with examples. Optimize database operations and boost performance. Discover when to use each for efficient, scalable applications.
How to Handle NULL Values Efficiently in SQL Queries?Apr 17, 2026. Master SQL NULL handling! Learn to use IS NULL, COALESCE, and more to avoid errors, improve data quality, and ensure accurate query results. Essential techniques for robust databases.
What is Database Indexing and How Does It Improve Query Performance?Apr 13, 2026. Boost database speed! Learn database indexing: types, benefits, and best practices for faster queries in MySQL, SQL Server, and PostgreSQL. Optimize your database now!
How to Handle Concurrency in SQL Server with Locking Mechanisms?Apr 13, 2026. Master SQL Server concurrency! Learn locking, row versioning, isolation levels, and performance tuning to prevent deadlocks and ensure data integrity. Optimize your database!
How to Use Raw SQL Queries Safely in Entity Framework CoreApr 08, 2026. Safely use raw SQL in Entity Framework Core! Learn how to prevent SQL injection with parameterized queries, FromSqlInterpolated, and input validation for secure .NET apps.
How to Connect Power BI to a SQL Server Database and Visualize Data?Apr 07, 2026. Unlock data insights! Learn to connect Power BI to SQL Server, load data, and create interactive dashboards. Visualize sales, trends, and key metrics easily.
How to Use Window Functions in SQL Server With Practical Examples?Apr 06, 2026. Unlock SQL Server's power with window functions! Learn to calculate rankings, running totals, and more without losing row details. Boost your data analysis skills!
What Is a Database Transaction and How to Use It in SQLApr 06, 2026. Master SQL transactions! Learn how to use BEGIN, COMMIT, and ROLLBACK to ensure data consistency and reliability. Understand ACID properties and best practices.
What Is the Difference Between Clustered and Non-Clustered Index in SQL Server?Apr 06, 2026. Unlock SQL Server performance! Learn the key differences between clustered and non-clustered indexes, boosting query speed and database efficiency. Master indexing!
How to Design a One-to-Many Relationship in SQL ServerApr 06, 2026. Master SQL Server one-to-many relationships! Learn to design databases with foreign keys, ensuring data integrity and efficient querying. Includes examples & best practices.
Difference Between Azure SQL Database and SQL Server on Azure VMApr 03, 2026. Understand the key differences between Azure SQL Database (PaaS) and SQL Server on Azure VM (IaaS). Choose the right option for scalability, control, and cost.
How to Use Joins in SQL With Real World ExamplesApr 03, 2026. Master SQL joins! Learn INNER, LEFT, RIGHT, and FULL JOIN with real-world examples. Combine data from multiple tables for powerful insights and reporting.
Difference Between WHERE and HAVING Clause in SQL?Apr 03, 2026. Unlock the power of SQL filtering! Learn the key differences between WHERE and HAVING clauses, when to use each, and how to optimize your queries for peak performance.
What Are Stored Procedures in SQL Server and How to Use ThemApr 03, 2026. Master SQL Server Stored Procedures! Learn to create, execute, and optimize them for improved performance, security, and code maintainability. Step-by-step guide.
How to Handle Transactions in SQL Server with Example?Apr 01, 2026. Master SQL Server transactions! Learn to ensure data integrity with BEGIN, COMMIT, and ROLLBACK. Explore error handling, isolation levels, and best practices for robust database applications.
What is Indexing in SQL Server and How It Improves Performance?Apr 01, 2026. Unlock SQL Server's potential! Learn indexing: boost query speed, understand clustered/non-clustered types, and optimize performance. A must-read for database efficiency!
How to Connect ASP.NET Core Web API to SQL Server Step by StepMar 31, 2026. Learn how to connect your ASP.NET Core Web API to SQL Server step-by-step using Entity Framework Core. Build robust, data-driven applications with ease and efficiency.
What is Normalization in SQL with Real-World Examples?Mar 31, 2026. Learn SQL normalization: a crucial database design technique for eliminating redundancy, ensuring data integrity, and improving scalability. Includes real-world examples!
SQL vs. NoSQL for AI-Native Applications: Choosing the Right Vector DatabaseMar 27, 2026. Explore SQL vs NoSQL for AI-native apps! Learn to choose the right vector database for chatbots, semantic search, and more. Hybrid approach wins!
Vector Search in EF Core 10: From SQL to Semantic QueriesMar 24, 2026. Unlock semantic search in .NET with EF Core 10! Query by meaning, not just keywords, using LINQ and SQL Server's native vector support. Build smarter apps easily.
Difference Between SQL and NoSQL Databases with Examples?Mar 25, 2026. Explore SQL vs NoSQL databases: understand key differences, use cases, and advantages for modern web applications. Choose the right database for scalability!
What are Indexes in SQL and How Do They Improve Query Performance?Mar 25, 2026. Unlock faster SQL queries! Learn how indexes dramatically improve database performance by creating efficient data retrieval paths. Boost your application speed now!
How to Optimize SQL Queries for Better PerformanceMar 25, 2026. Boost database performance! Learn SQL query optimization techniques: indexing, efficient joins, filtering, caching, and execution plans. Speed up your applications!
How to Optimize Slow Queries Using EXPLAIN in PostgreSQLMar 24, 2026. Optimize PostgreSQL query performance using EXPLAIN! Learn to analyze execution plans, identify bottlenecks, and apply indexing for faster, scalable databases.
How to Implement Soft Delete in SQL Without Losing DataMar 24, 2026. Implement soft delete in SQL databases to prevent data loss and enable easy recovery. Learn best practices, improve data safety, and ensure compliance.
How to Validate User Input to Prevent Security VulnerabilitiesMar 24, 2026. Secure your web apps! Learn input validation techniques to prevent SQL Injection, XSS, and other vulnerabilities. Protect user data and ensure application reliability.
How to Fix Database Deadlocks in SQL Server or MySQLMar 23, 2026. Learn how to fix and prevent database deadlocks in SQL Server and MySQL. Discover common causes, detection methods, and practical solutions for high-traffic apps.
How to Prevent SQL Injection in Node.js Applications?Mar 23, 2026. Protect your Node.js apps from SQL Injection! Learn practical techniques like parameterized queries, ORM, and input validation to secure your database and prevent data breaches.
Maintaining Consistency Across Multi-Team SQL Projects Mar 20, 2026. Boost SQL project scalability by enforcing consistency across teams. Automate formatting, naming, and validation to streamline workflows and reduce errors.
How to Prevent SQL Injection Attacks in Modern Web ApplicationsMar 17, 2026. Protect your web applications from SQL Injection! Learn effective techniques like prepared statements, input validation, and ORM frameworks to secure your database.
How to Identify and Fix Slow SQL Queries in Production Systems?Mar 16, 2026. Boost application speed! Learn to identify & fix slow SQL queries in production. Master indexing, query optimization, and monitoring for peak database performance.
How to Prevent SQL Injection Attacks in Modern Web ApplicationsMar 16, 2026. Protect your web applications from SQL injection! Learn how to prevent these dangerous attacks with prepared statements, input validation, and secure ORM frameworks.
Dapper in Depth with ASP.NET Core 10Mar 14, 2026. Master Dapper with ASP.NET Core 10 for high-performance SQL-driven apps. Explore setup, repository patterns, and real-world use cases. Optimize your .NET apps!

Tags