How to Download and Install SQL Server Express Edition?
SQL Server is Microsoft’s premier database management system that we can use to develop...
SQL FOREIGN KEY CONSTRAINT: The Ultimate, Easy Guide for Newbies
Newbie? Then an SQL foreign key may be foreign to you. You may have heard different opinions about SQL foreign keys. If you haven’t, soon...
3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database
There are several methods of how to rebuild all indexes of all tables in SQL Server, among them: Using SQL Server maintenance plans. Using...
SQL Server: Renaming Indexes using the sp_rename Procedure
Not so long ago, I was working on a project where we needed to change the data type of a table. The...
Create and Configure Oracle Linked Server in SQL Server
This article explains the step-by-step process of creating and configuring a linked server between Oracle 19c and SQL Server 2019....
4 Ways to Count Rows in SQL Server Table with Pros and Cons
Recently, I was working on a database performance improvement project. One stored procedure there was causing issues. In its code, a query...
5 No-Hassle Tips to Use SQL UPDATE Statement with JOIN
“Oops! My bad.” How many times did you say this after an SQL UPDATE had gone...
Multicast SSIS: How to Create, Setup and Test
The current article focuses on setting up and testing the necessary environment for multicasting data with SQL Server Integration Services...
MIN and MAX Aggregate Functions in SQL Server
SQL Server Functions In database systems in general and in SQL Server in particular, functions are pieces of code that take zero or one...
22 Different T-SQL Indexes Examples to Warp Speed Your Queries
Indexing the database tables is one of the ways to up your game in tuning queries. How do you do...