In this short article I will introduce the possibility to run a sql script outside of SQL management studio using SQL server command line utility (sqlcmd for short). This...
I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience when unboxing, everything tuned to...
Correct table indexing in SQL Server is a base for good database performance during querying. You need to understand how SQL Server stores data into tables/indexes if you want...
While installing SQL Server, one of the parameters that is needed to be set during installation is Server collation. It is a parameter influencing the way in which SQL...
I described plus and cons of SQL Server Express edition in the article SQL Server Express for Beginners. If you decided to try Express and you wonder how to...
A trigger is a database object (procedure) that works as a watchdog for certain event. Using database triggers we can catch this event and initiate some additional action –...