Git Tips & Best Practices for Beginners
Without a version control system, it’s next to impossible to manage the source code. ...
Basics of SQL Server Management Studio (SSMS). Part 2
This article further explains the basics of SQL Server Management Studio (SSMS) – one of the most widely used database development and...
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 statements. Moreover, it is one of the...
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...
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 Management Studio (SSMS). The 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...
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 queries may take a very short or a very...
How AI Will Change Software Development and Testing
Artificial intelligence is the fuel for what we know as the fifth industrial revolution. Its...
