T-SQL Resources

Share

Related resources for T-SQL

Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. 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 opt
BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. 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 Server10/29/2024 6:29:27 AM. 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, redu
TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. 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 fro
GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. 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 gap
STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server10/16/2024 9:01:22 AM. 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 ea
Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. 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 Server10/9/2024 6:48:59 AM. 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 Server10/5/2024 6:28:43 AM. 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 fun
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. 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 int
Insert Master-Detail Data using Transact-SQL10/1/2024 4:54:39 AM. 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 recor
Database Backup With Compression in SQL Server9/20/2024 9:18:22 AM. This article explains how to perform database backup compression in SQL Server 2012 using SQL Server Management Studio or a Transact-SQL statement. It provides a step-by-step guide to visually create
Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
Learn to Shrink a Microsoft SQL Server Database Programatically 8/20/2024 4:59:45 AM. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause
T-SQL Script for Purging Tables with Foreign Key References8/2/2024 8:42:15 AM. 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
How To Connect On-Premise SQL Server From Microsoft Flow Using Azure On-Premise Data Gateway7/30/2024 4:34:24 AM. This guide covers step-by-step instructions to set up the gateway, configure data connections, and integrate your SQL Server with Flow for seamless automation and data management.
Error handling in Transact-SQL (T-SQL) 7/13/2024 10:59:58 AM. 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_NU
Check and Detect T SQL Code Analysis7/8/2024 7:38:43 AM. In this session, we’ll review the SqlCheck, ScriptDOM, and SQL projects code analysis options such that you can confidently add code analysis to the SQL components of your applications.
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed7/4/2024 7:36:25 AM. Learn how to detect the current Cumulative Update or Service Pack installed on SQL Server using various methods like ServerProperty in T-SQL, SQL Server Management Studio, Configuration Manager, and P
Query to Find SQL Server Version7/2/2024 7:11:42 AM. To identify the version of SQL Server running, use the query SELECT @@VERSION AS 'SQL Server Version';. This returns detailed information including version number, edition (like Developer Edit
Backing Up and Restoring a SQL Database6/19/2024 7:31:50 AM. In database management, ensuring data integrity and availability is paramount. Regularly backing up your database is crucial to mitigate risks such as hardware failures, software issues, or accidental
SqlTransaction In C#6/13/2024 10:53:14 AM. Transactions in databases ensure data integrity using ACID properties: Atomicity ensures all steps complete successfully or rollback completely, Consistency ensures transitions maintain data rules, Is
SQL Query Execution Understanding Process and Performance6/11/2024 11:37:51 AM. Understanding the SQL query execution order—from FROM and JOIN to WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT/OFFSET—is crucial for optimizing queries. Key techniques include indexing, optimi
Understanding Different Types of SQL Triggers in SQL Server6/11/2024 9:14:12 AM. SQL Server triggers are powerful tools that allow the automatic execution of SQL code in response to specific events on a table or view. They play a crucial role in maintaining data integrity, enforci
Using GO and Semi-Colon in SQL Server 20125/30/2024 12:12:09 PM. Learn about the usage of the GO command and semicolon in SQL Server. Understand how to use GO as a batch separator and change it in SQL Server Management Studio. Semicolon (;) terminates SQL statement
Difference between SQL and T-SQL5/9/2024 10:35:19 AM. 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 d
Convert Rows to CSV & Eliminate Duplicates in SQL Server5/6/2024 4:17:43 AM. Using SQL Server's string aggregate function, efficiently transform row data into a comma-separated format, while simultaneously removing any duplicate entries, ensuring data integrity and optimiz
SQL Server Fundamentals: Design, Queries & Optimization4/29/2024 10:52:37 AM. This article serves as a comprehensive guide to SQL Server fundamentals, database design principles, querying with Transact-SQL, stored procedures, and optimization techniques. Through real-time examp
Zero To Hero In MS SQL Server - Part Four4/19/2024 10:31:37 AM. In this article, Part Four of 'Zero To Hero In MS SQL Server' delves into advanced topics like query optimization, stored procedures, and indexing strategies. Master database management, T-SQL
Temporary Table in SQL Server4/3/2024 9:41:55 AM. In this article, we will learn about temporary tables in SQL Server, a powerful feature for temporary data storage and manipulation. Master T-SQL techniques for creating and managing temporary tables,
Simple Image or File Import Using T-SQL for SQL Server4/3/2024 8:47:23 AM. 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 fo
How To Get Started With Always Encrypted For Beginners - Part One3/28/2024 6:27:34 AM. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Se
How To Get Started With Always Encrypted For Beginners - Part Three3/28/2024 6:26:32 AM. Discover advanced techniques in data security with Always Encrypted in Microsoft SQL Server. Part Three of our beginner's guide delves deeper into encryption keys, transparent data encryption, and
Analysis of T-SQL and PL/SQL2/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
Mastering T-SQL Rank Functions2/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
JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQL1/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
Identifying the Root Cause of SQL Server Problems1/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
Learn to Avoid Query Governor Cost Limit Error in SQL Server11/13/2023 7:08:56 AM. Learn to solve "The query has been canceled because the estimated cost of this query... "
What is SQL Server Management Studio (SSMS)11/7/2023 4:14:32 AM. SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database ob
Know The History Of Your SQL Server Database10/16/2023 9:00:14 AM. Understand your SQL Server database history for effective management. Learn to identify the internal version number using SQL Server Management Studio and various T-SQL statements, ensuring accurate d
Auditing Data Changes In Microsoft SQL Server8/25/2023 10:16:21 AM. Tracking changes in data over time is a common problem, and deciding on your approach relies on answering questions such as “Do I want to track every field or just some fields?”, “Does it need to be ‘
Oracle database 11g and Microsoft SQL Server 20087/31/2023 4:34:50 AM. In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment o
Date and Time Functions in T-SQL7/25/2023 10:24:37 AM. This article represents the comprehensive guideline for date and time functions in T-SQL.
How to Create Azure SQL Server Database in the Microsoft Azure Portal?6/22/2023 10:40:30 AM. Step by step details to create azure sql database server in the Microsoft Azure Portal
Working with Date and Time Formats in T-SQL5/22/2023 9:36:23 AM. This article describes how different date styles work with date formats
How To Call Stored Procedure With MuleSoft4/29/2023 12:25:23 PM. In this article, we will learn how to call Azure SQL Server Stored Procedure with MuleSoft.
Working with Big Data in SQL Server4/27/2023 8:54:36 AM. Working with Big Data in SQL Server
Backup and Restore Using Command Prompt - SQLCMD and T-SQL3/7/2023 6:46:06 AM. In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt.
Put SQL Server’s Query Execution Engine on Hold3/3/2023 6:58:02 AM. Here you will see how to put your SQL Server’s Query Execution Engine on hold for a while.
Search For Missing Values Within a Numerical Sequence3/3/2023 5:26:01 AM. The purpose of this short article is to show a method for identifying, within a SQL Server table, gaps in a numerical sequence, to quickly locate absences of consequence within given data.
Examples Of DATE/DATETIME Conversion2/28/2023 4:11:34 AM. Basic considerations and examples of DATETIME, DATE and TIME data types.
Implementing and Using Fishhook Relation in Transact SQL2/22/2023 8:27:07 AM. Here the use of fishhook relation to represent tree structures is explained through a detailed example in T-SQL.
Convert SQL Server Data to JSON2/22/2023 6:32:15 AM. Learn how to Convert SQL Server Data to JSON using JSON PATH clause.
Replace Nulls With Specified Values in SQL Server2/21/2023 12:44:01 AM. In this article we will see the various ways to replace null values in a table. ISNULL() function, CASE statement, COALESCE() function can be used to replace null values in a SQL Server table.
Creating an OLAP Cube (SSAS)2/20/2023 5:56:49 AM. Here you will see how to create an OLAP Cube (SSAS).
How to Generate a CREATE TABLE Script For an Existing Table: Part 12/14/2023 3:19:00 PM. In this article, we learn how to generate a CREATE TABLE Script For an Existing Table.
T-SQL - Retrieve Task Hierarchy In Project Server2/13/2023 9:31:09 AM. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
SQLCLR vs. T-SQL - Performance Comparison2/3/2023 8:44:05 AM. Before comparing the performance of SQLCLR and TSQL, just have a quick at the definition of SQLCLR.
CASE Statement In Transact-SQL2/1/2023 10:07:12 AM. In this article, I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement
XML Data Type in Microsoft SQL Server 1/30/2023 6:58:35 AM. In this article, we will see about XML data type in Microsoft SQL Server 2005.
SQL Server Merge Statement1/20/2023 9:14:11 AM. In this article, you will learn about the SQL SERVER MERGE statement.
CLR Function in SQL Server 1/14/2023 12:35:44 PM. In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.
Table Valued CLR Function in SQL Server1/14/2023 11:52:35 AM. In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.
Simulating Autonomous Transactions in Microsoft SQL Server1/14/2023 11:41:25 AM. In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.
T-SQL Query Performance Tuning Tips1/10/2023 8:52:11 AM. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
Insight.Database .NET Micro ORM - Executing And Carrying Out SELECT SQL Commands1/10/2023 8:17:02 AM. Insight. The database micro-format for.NET is quick, light, and, dare we say it, fantastic. SQL commands are simple to run using Insight. SqlCommand class and parameters are no longer used. AddWithVal
SQL Server Functions and Oracle Equivalent1/9/2023 11:15:39 AM. This article looks at SQL Server string, numeric and date functions and their Oracle equivalents.
The Most Important SQL Queries For Beginners12/17/2022 6:20:46 PM. How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.
Export Microsoft SQL Data To CSV Using Python11/1/2022 5:40:41 AM. In this article, you will learn how to create REST API to read Microsoft SQL table and export the result to CSV file using Python. I have created a simple Microsoft SQL table for this demo named as Em
Read Microsoft SQL Table And Send The Results As Rest API JSON Response Using Python10/31/2022 5:46:08 AM. In this article, you will learn how to read Microsoft SQL table and send the results as REST API JSON response using Python.
T-SQL - Pivoting And Unpivoting Data9/20/2022 10:55:00 AM. In this article, you will learn about T-SQL - Pivoting And Unpivoting data.
T-SQL Interview Questions On Data Types 7/31/2022 10:42:38 PM. 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 question
T-SQL Subqueries In Practice7/21/2022 8:17:52 PM. This article will demonstrate the two types of subqueries and their practical usage.
XML Shredding In T-SQL7/19/2022 9:32:17 PM. In this article, you will learn about XML shredding in T-SQL.
Logical Query Processing In T-SQL7/19/2022 8:03:35 PM. This article demonstrates the practical values of knowing Logical query execution in TSQL.
Data Fetching From Microsoft SQL To C#6/1/2022 12:26:11 PM. In this article, you will learn about data fetching from microsoft sql to c#.
Build A ToDo List Application Using .NET 5.0 Web API And Microsoft SQL Server9/17/2021 2:06:03 PM. The article shows how to build a ToDo list application using .Net 5 Web API, Jwt authentication and AspNetCore Identity.
T-SQL Window Function Performance - Women Data Summit 20216/27/2021 10:48:10 AM. This session in Women Data Summit 2021 is about T-SQL Window Function Performance
Exists And Not Exists In SQL Server5/22/2021 2:54:51 PM. In this article we will explore the usage of Exists and Not Exists in SQL Server
T-SQL in Practice - AI42 Ep. 105/20/2021 8:28:56 AM. Welcome to the 10th episode of the AI42 series! This time we will learn about T-SQL.
Full And Differential Backup Using SSMS5/19/2021 12:34:27 PM. In this article, we will see how to create a SQL Server Database backup. Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will di
Intro To T-SQL For Data Science5/14/2021 11:51:22 AM. 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.
Create An App Using Angular 10, .NET Core Web API And SQL Server4/21/2021 4:26:47 PM. In this article, you will learn how to create an App using Angular 10, .NET Core Web API and SQL Server.
T-SQL for Data Science - AI42 Ep. 63/25/2021 6:10:25 PM. Welcome to the 6th session of the AI42 series! This time we will learn about T-SQL.
Top 10 Hottest And Tricky T-SQL Questions For Beginners3/8/2021 6:47:04 PM. Transact-SQL (T-SQL) is an extension to SQL developed by Microsoft and Sybase used to administer SQL Server.
How To Link A SQL Server To An Oracle Database2/26/2021 6:18:45 PM. This article describes what is Linked servers and how to link MS SQL Server to Oracle from SSMS
Synapse Serverless for T-SQL Ninjas - AMA ft. Nikola Ilic2/12/2021 1:32:24 PM. Join us with our guest speaker Nikola Ilic on live AMA for a Crash course on Synapse Serverless for T-SQL Ninjas.
Modern T-SQL for Better Performance - SQL Server Virtual Conference 20212/1/2021 4:31:38 PM. This session is about “ Modern T-SQL for Better Performance ”in SQL Server Virtual Conference 2021.
Storage What SQL Server DBAs Need To Know1/20/2021 5:54:20 AM. In this article, you will learn about storage what sql server DBAs need to know.
Real Life SQL And .NET - Part One12/6/2020 10:41:53 PM. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be req
Export SQL Data to Excel Using ASP.Net11/24/2020 4:12:39 AM. This article explains how to export SQL Data to Excel using ASP.NET.
Execute Long Running SQL Query Or Stored Procedure From .NET11/3/2020 12:47:34 AM. This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
Client-Server WASM-Application In C#, TypeScript And Transact-SQL9/29/2020 11:07:57 PM. 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 progra
Compare And Update SQL Server Database Project With Visual Studio8/24/2020 2:54:59 AM. In this article, you will learn how to create a SQL Server Database project using Visual Studio 2019 and how to compare and update the SQL Server Database Project from the remote SQL Server Database a
SQL Comments Statement 7/6/2020 7:42:12 AM. In this article you will learn how to make SQL Comments statement in SQL
SQL Server JSON and ASP.NET Web API Scaffolder Generator Source Code5/6/2020 4:13:54 PM. This article demonstrates how to create an ASP.Net web API scaffolder generator based on SQL Server JSON store procedures.
SQL Server REST Scaffolding Simple High Performance SQL JSON Usage5/3/2020 6:38:38 PM. This project is a code generation framework for ASP.NET Web API based on SQL Server JSON result and C# repository pattern manager.
How To Import And Export SQLite Database2/20/2020 5:37:21 AM. In this article, we will learn how to import/export Android SQLite Database directly from an application. We can use an SQLiteImporterExporter library to perform these functionalities.
Oracle Database Server To SQL Server Migration 2/11/2020 11:01:56 PM. In this article, you will learn about Oracle Database Server to Microsoft SQL Database Server Migration.
How to Generate Alter Script of Table Design Mode - Sql Server Management Studio11/13/2019 7:11:26 AM. How to generate the alter table SQL script in using SSMS.

Topics