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…
DBA Security Advisor is Now Out!
Today is big day. Today, DBA Security Advisor is finally released! It has been a long journey. Two years of research, development, testing, QA, and the list goes on! I work with SQL Server for more than 11 years and I have seen hundreds of SQL Server installations and setups.…
Announcing DBA Security Advisor – A Security Tool for SQL Server
After almost two years of heavy development and extensive testing, in three days, on June 28 2016, I will be releasing my brand new software tool for SQL Server. The name of the tool is ‘DBA Security Advisor‘ and as the name implies, it is a database security tool. DBA…
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…
New Artemiou Data Tools Release: SQL Multi-Exporter
Today I released a brand new data tool via my “Artemiou Data Tools” initiative. The tool is called SQL Multi-Exporter. SQL Multi-Exporter allows the user to connect to a SQL Server instance and by issuing a query against a database, to export the results to an XML, CSV or HTML…