SQLArtBits is a community-oriented software startup that provides a rich collection of SQL Server tools and free Online Services which can help you get the most out of the world's most powerful data platform. All tools and services are built by a team of Senior SQL Server Architects, Developers and SQL Server MVPs.
DBA Security Advisor is a powerful security tool that can assess SQL Server® instances against a rich set of security checks and detect potential security risks. Furthermore, it provides recommendations as well as remediation methods and scripts. All the security checks and recommendations are based on proven security best practices which can help you secure your SQL Server® instances and thus protect your data more efficiently.
In-Memory OLTP Simulator enables you 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 tool, among other, you can load data from different sources (i.e. from Production DBMS instances using Linked Servers) into the Simulator’s database and simulate real-life scenarios with the use of custom scenarios as well as get in-depth analytics on performance when utilizing Memory-Optimized Tables and Natively-Compiled Stored Procedures in SQL Server®.
In-Memory OLTP Simulator's Datasheet provides an executive summary of what the tool can offer when it comes to benchmarking SQL Server's In-Memory OLTP Engine against your own workload and examine the performance increase patterns.
In this 38-page technical article you can read how with a simple simulation of an UPDATE operation on a 5M record table against SQL Server's In-Memory OLTP Engine, a speedup of 26x was achieved! The entire process was designed and executed from within In-Memory OLTP Simulator against SQL Server 2016.
In this webcast, Microsoft Data Platform MVP and Senior SQL Server Architect Artemakis Artemiou, discusses the proper approach towards securing a SQL Server instance. Besides the different layers that need to be secured, Artemakis presents his brand new software tool: DBA Security Advisor. With DBA Security Advisor, you can easily assess your SQL Server instances against potential security risks based on a rich set of checks. Furthermore, DBA Security Advisor provides recommendations for the detected security risks along with remediation scripts.
In this article published on SQLShack.com journal, Microsoft Data Platform MVP and Senior SQL Server Architect Artemakis Artemiou, talks about the top 10 security considerations you need to keep in mind in order to maintain a healthy and secure SQL Server instance.
In this article published on Simple-Talk journal, Microsoft Data Platform MVP and Senior SQL Server Architect Artemakis Artemiou, introduces SQL Server's In-Memory OLTP Engine and explains the main principles for being able to use it.
More about us
SQLArtBits (former 'Artemiou Data Tools') is a software startup founded by Microsoft Data Platform (SQL Server) MVP and Senior SQL Server Architect Artemakis Artemiou some years ago, aiming at developing simple yet powerful data tools for the Microsoft® Windows™ Operating System. The majority of our tools mainly interact with Microsoft® SQL Server®, thus providing a richer user experience and enabling the user to get the most out of the world's more powerful data platform.
Feel free to browse through our software collection and use our tools and services. Enjoy your dive into the data-driven world!