Background Image
Welcome to SQLArtBits

SQLArtBits is a community-oriented software company 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.



- New Release: DBA Security Advisor v2.0 is Now Out!

- New Release: In-Memory OLTP Simulator v1.1

- Read an interesting article which explains why we build SQL Server software.

Background Image

Product Highlights


DBA Security Advisor
DBA Security Advisor (more info...)

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
In-Memory OLTP Simulator (more info...)

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®.

All Programs
Full Products List (see Products page...)

FULL VERSIONS & EDITIONS
- DBA Security Advisor (Enterprise Edition) [more...]
- In-Memory OLTP Simulator (Ultimate Edition) [more...]

FREE PRODUCTS & EDITIONS
- DBA Security Advisor (Community Edition) [more...]
- In-Memory OLTP Simulator (Community Edition) [more...]
- Snippets Generator [more...]
- Dynamic T-SQL Generator [more...]
- SQL Instance Info Finder [more...]
- SQL Multi-Exporter [more...]
- File Splitter [more...]
- Zero Byte Handler [more...]

Free Online Services Highlights


In-Memory OLTP Simulator
SQL Server Supported Operating Systems

This free online service, takes as user input a version of SQL Server and returns the supported Operating Systems. [use this service...]

In-Memory OLTP Simulator
SQL Server Latest Service Pack Info

This free online service, takes as user input a version of SQL Server and provides info about its latest service pack. [use this service...]

In-Memory OLTP Simulator
All Services (see Services page...)

- SQL Server Supported Operating Systems [more...]
- SQL Server Latest Service Pack Info [more...]
- SQL Server Backward Compatibility Checker [more...]

Selected Publications


DBA Security Advisor Datasheet

DBA Security Advisor's Datasheet provides an executive summary of what the tool can do and how it can help you secure your SQL Server instances based on proven security best-practices.

In-Memory OLTP Simulator Datasheet

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.

Paper: "In-Memory OLTP Simulator: The Experiment"

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.

Webcast: How to Secure Your SQL Server Instances

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.

Journal Article: Top 10 Security Considerations for you SQL Server Instances

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.

Journal Article: Introducing SQL Server In-Memory OLTP

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.