SQL Server BIT Datatype – Ultimate Guide
Introduction to Bit Data Type The data type represents an attribute that stores integer, character,...
9 Best Practices for Writing SQL Queries
If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many...
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 it? Today’s post will give you 22 SQL...
Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function
Today’s code editors and word processors come with a search and replace feature. It is...
SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios
The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
How AI Will Change Software Development and Testing
Artificial intelligence is the fuel for what we know as the fifth industrial revolution. Its capacities to impact and disrupt numerous...
Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database...
Manage MDF Files in SQL Server 2019
An SQL Server database contains primary data files, secondary data files (optional), and transaction log files. The primary and secondary...
Make Awesome Lists Yourself, or GitHub as Notebook
This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps,...
Deploy SQL Server AlwaysOn Availability Groups on Linux
In the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the...
