Software

SQLArtBits: Free Online SQL Services

Three years ago, back in 2013, I founded the “SQLArtBits” community initiative. Under the SQLArtBits initiative we develop simple yet powerful data tools for the Microsoft Windows Operating System. The majority of our tools mainly interact with SQL Server, thus providing a richer user experience and enabling the user to…

Why You Need to Secure Your SQL Server Instances

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 assets in your Organization and that’s why you need to…

In-Memory Optimization in SQL Server: Will my Workload Execute Faster?

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). If I was about to describe this technology in two simple sentences I would do so with the below: It eliminates both locks and latches with…

In-Memory OLTP Simulator v1.0 Now Live!

After two years of heavy development, my tool “In-Memory OLTP Simulator” is finally out! In-Memory OLTP Simulator enables the IT Professional and Developer to easily test the powerful In-Memory OLTP Engine of SQL Server 2014® (or later) with different simulations and against different workloads. In the Ultimate Edition of the…

Introducing In-Memory OLTP Simulator

One of the key features 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…