MS SQL Server on Linux vs Windows Performance Test to Spot the Difference
Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game....
In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples
What if 1 second of a transaction process is too long? You can tune your queries. But what if it’s not enough, can you still step up...
How to Use Array Functionality in SQL Server
Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to store values in an array in SQL Server....
Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example
Availability Groups are fantastic for High Availability/Disaster Recovery solutions, and I’m sure...
Creation of Pandas DataFrame in Python with Examples
Python is a general-purpose language that can work with various types of data structures and solve data-related problems with the help of...
Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage
Let’s imagine you have a large raw file and need to determine the best way to load it into an Oracle Autonomous Data Warehouse...
SQL Date Format: How to Handle It the Smart Way
Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric...
Successful MySQL/MariaDB Backup and Recovery Strategies
A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential...
Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance
What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
Basics of SQL Server Transaction Log
What is a Transaction Log? There is a requirement in relational database systems that transactions...
