Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE...
SQL UNION Cheat Sheet with 10 Easy and Useful Tips
Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into a standstill. Or a report that’s been...
Moving SQL Server Table to Different Filegroup
Introduction A table is a logical structure. When you create a table, you typically would not care which drives it sits on at the storage...
Create a Database in SQL Server Using SQL Server Management Studio (SSMS)
This article briefly explains creating a new database with the New Database wizard of SQL Server...
ASP.NET vs. PHP: the Best Framework for Web Development
The primary goal of web development teams is to deliver web applications with the best user experience, scalability, and sustainability....
Do You Make These Mistakes When Using SQL CURSOR?
For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in the details! You can read all sorts of...
Virtual Columns and Functional Indexes
Much too often, we see poorly written complex SQL queries running against the database tables. Such...
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...
Install Azure CLI 2.0 on Microsoft Windows
Azure CLI is a Microsoft cross-platform tool that allows users to remotely access Azure services via their command line. The current...
Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this...