SQL Server Always On is a database availability solution that provides automated database replication and failover across standalone servers and SQL Server instances. It allows database administrators and developers to build solutions that guarantee database...

SQL Server on Linux supports a scheduling mechanism for scripts or tasks using SQL Server agent jobs. For example, suppose you want to run full backups daily at 22:00 or a transaction log backup every...

SQL Server On Linux Installation and Configuration The previous articles, Introduction to SQL Server on Linux and Overview of SQL Server on Linux requirements and comparison with Windows SQL Server, begin your journey into SQL...

Back in the day proprietary databases were the only acceptable options.  “No one ever got fired for buying from Oracle/Microsoft/IBM” was the saying.  Huge, monolithic databases used for every single purpose. Paid support - that’s how...

Migrating from proprietary engines into open source engines is a trend that is growing in the industry. However, database migration is not something to be taken lightly. In this blog, let’s see what is needed...

As you may know, Microsoft SQL Server is very popular RDBMS with highly restrictive licencing and high cost of ownership if the database is of significant size, or is used by a significant number of...