SQL Server 2025 Quick Reference Guide
Explore the new features of SQL Server 2025, focusing on AI integration and enhanced database performance for modern applications.
Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience.
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure." I can be reached at: Rajendra.gupta16@gmail.com for any consulting help.
- MSSQLTips Awards:
- Author of the Year - 2022 | Author Contender - 2021/2023/2024 | Champion Award (100+ tips) - 2020
AWS Cost Optimization for SQL Server
Unlock the secrets of AWS Cost Optimization with strategies for SQL Server migration and workload management to save expenses.
SQL Concatenate String using Double Pipe (||) Operator in SQL Server 2025
Explore SQL Server 2025's new SQL concatenate string with the double pipe operator for efficient data handling.
SQL Server 2025 Product() Function Examples
Learn about the new SQL Server PRODUCT() function to multiply values in a set to return the product value.
Install SQL Server 2025 Standard Developer Edition for Linux on AWS EC2
Learn how to SQL Server 2025 on Linux and command line tools with this step-by-step guide for AWS EC2 instances.
SSMS Copilot to Boost Productivity and Efficiency
Enhance your SQL Server experience with SSMS copilot. Find out how AI improves query development and database management.
Install SQL Server 2025 Standard Developer Edition
Learn the steps to install SQL Server 2025 Standard Developer Edition in this step by step outline of an installation.
SQL Server 2025 New Features and Enhancements
Learn about the SQL Server 2025 new features such as AI Capabilities, Event Streaming, Security Enhancements, Performance and more.
Alter Table Add Column SQL Server
Learn how to use Alter Table to Add a Column in SQL Server with this article that shows several scenarios of adding a column to an existing table.
![SQL IS [NOT] DISTINCT FROM predicate in SQL Server 2022](https://www.mssqltips.com/wp-content/uploads/8195_s.webp)
SQL IS [NOT] DISTINCT FROM predicate in SQL Server 2022
In this article, we look at a new option in SQL Server 2022, IS DISTINCT FROM and IS [NOT] DISTINCT FROM to further improve working with NULL values.
Date Truncation with DATETRUNC() function in SQL Server
Learn how to use the SQL Server DATETRUNC function to truncate date parts to get the exact date interval needed.
Identify Anti-Patterns in SQL Server Queries
In this article, we look at a new SQL Server Extended Event to help identify anti-patterns in SQL queries and improve performance.
SQL Server Management Studio (SSMS) 21 Changes
Learn about some of the changes and features of SQL Server Management Studio 21 and how you can get started with SSMS 21.
SQL Coalesce Function Examples and Use Cases
This tip explores how to handle NULL values in SQL Server using the COALESCE() function using various queries and reviewing the results.
Overview of Azure Options for SQL Server
Learn about options to run SQL Server on Azure: Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VM.
Python Numpy for Multi-Dimensional Arrays
Learn how to use multi-dimensional arrays when working with Python using the NumPy library.
Data Visualization with Python Matplotlib
Learn about data visualization using Python matplotlib to create a line chart, bar chart, histogram, pie chart, scatter plot, and box plot.
Azure Database for MySQL Flexible Server Administrative Tasks
This tip explores the administrative tasks and operational items required for a MySQL flexible server running on Azure.
Explore Pandas in Python to Analyze and Manipulate Tabular Data
Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
Implement Azure Database for MySQL Step-by-Step
Learn how to implement MySQL on the Azure platform in this step-by-step article using an Azure Database for MySQL flexible server deployment.
Azure Managed Instance Download and Restore SQL Server Backup
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
Microsoft Copilot for Azure SQL Database Management and Development
Learn how to use Microsoft Copilot for your Azure SQL Database to help manage the database and write code for SQL Server.
Download AWS RDS SQL Server Backup
Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.
Get Azure SQL Managed Instance free for 12 months
Learn how to get access to Azure SQL Managed Instance for free for 12 months in this step-by-step article.