Yesterday, we proudly announced the release of our brand new software tool “My Remote Connections Manager“. In this short post, we are introducing My Remote Connections Manager by describing its main features and explaining how it can help you in your daily IT tasks. What is My Remote Connections Manager? My Remote Connections Manager, … Read more…
This article, discusses about the necessity of securing your SQL Server instances and databases. Introduction Database Management Systems (DBMSs) store data. They sure have added functionality and a huge set of significant features but again, in the end of the day, they store data. Your data. This makes your DBMSs one of the most valuable … Read more…
In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory Optimization in SQL Server, has certain characteristics and can help increasing performance in a great number of scenarios. A Short Description of the SQL Server In-Memory OLTP Technology If I … Read more…
One of the key features originally shipped with SQL Server 2014 was the long-awaited In-Memory OLTP, codenamed as project “Hekaton”. In-Memory OLTP introduced new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored procedures, they can offer a huge performance boost when … Read more…