- SQLArtBits Blog -

Announcements   ||   Administration   ||   Development   ||   Security   ||   Troubleshooting   ||   Offers  ||   Weekly SQL Server Tips

Featured Articles


Blog Thumb

DBA Security Advisor v2.0 is Now Out!

Published on April 5th 2017

Dear friends, we are happy to announce the general availability of DBA Security Advisor v2.0!

With today's launch, we've reinvented the way that you interact with DBA Security Advisor and secure your SQL Server instances. With a brand new graphical user interface, the risk assessment process of your SQL Server instances has just became easier and faster... Read The Rest

Blog Thumb

In-Memory OLTP Simulator v1.1 is Now Out!

Published on November 1st 2016

Today we are proudly announcing the release of In-Memory OLTP Simulator v1.1.

With In-Memory OLTP Simulator, you can easily benchmark SQL Server's powerful In-Memory OLTP Engine against your own workload. You can use standard scenarios as well as create and run your own custom scenarios in order to get rich performance analytics, insights and comparisons when processing your workload in with traditional disk-based tables, memory-optimized tables and natively-compiled stored procedures...

Read The Rest
Blog Thumb

Why We Build SQL Server Tools

Published on September 26th 2016

Besides the fact that we build SQL Server tools because we really like SQL Server and enjoy writing cool .NET applications, we build tools in order to help all of us perform our work easier, faster and more efficiently.

Take for example our product DBA Security Advisor. With a single click, you can perform vulnerability assessments against multiple SQL Server instances, detect possible security risks and get recommendations and remediation methods...

Read The Rest

All Articles


Announcements   ||   Administration   ||   Development   ||   Security   ||   Troubleshooting   ||   Offers  ||   Weekly SQL Server Tips

DBA Security Advisor v2.0 is Now Out!

Dear friends, we are happy to announce the general availability of DBA Security Advisor v2.0!

With today's launch, we've reinvented the way that you interact with DBA Security Advisor and secure your SQL Server instances......(read more...)

Published 5th April 2017
7 minutes read

Sneak Peek: DBA Security Advisor v2.0

On Wednesday, April 5 2017, we will be officially releasing DBA Security Advisor v2.0.

DBA Security Advisor is one of our most powerful tools for SQL Server. It features a rich set of security checks that can be used for running comprehensive risk assessments against your SQL Server instances. Every time an assessment is completed, DBA Security Advisor provides recommendations and where applicable, T-SQL scripts that can help you remediate the detected risks...(read more...)

Published 31st March 2017
5 minutes read

SQL Server 2016 SP1: A Pleasant Surprise

The announcement of SQL Server 2016 SP1 surely got us all pleasantly surprised! Many features that were traditionally only availabe in the Enterprise Editions of SQL Server, are now also available in other more "affordable" editions such as Standard and Web. Some of these features are even now available in the Express and Local DB editions of SQL Server 2016 SP1.

Features like: Row-Level Security, Dynamic Data Masking, Database Snapshot, In-Memory OLTP, Columnstore, Always Encrypted, and other, along with the Enterprise Edition, are now available in all editions of SQL server 2016 SP1 (Standard, Web, Express, Local DB)...(read more...)

Published 18th November 2016
3 minutes read

In-Memory OLTP Simulator v1.1 is Now Out!

Today we are proudly announcing the release of In-Memory OLTP Simulator v1.1.

With In-Memory OLTP Simulator, you can easily benchmark SQL Server's powerful In-Memory OLTP Engine against your own workload. You can use standard scenarios as well as create and run your own custom scenarios in order to get rich performance analytics, insights and comparisons when processing your workload in with traditional disk-based tables, memory-optimized tables and natively-compiled stored procedures....(read more...)

Published 1st November 2016
5 minutes read

Weekly SQL Server Tip 10: Securing SQL Server


See Tip ...

Published 25th October 2016
2 minutes read

Weekly SQL Server Tip 9: Password Expiration Option


See Tip ...

Published 18th October 2016
2 minutes read

Weekly SQL Server Tip 8: DBA Security Advisor


See Tip ...

Published 10th October 2016
1 minute read

Weekly SQL Server Tip 7: Query Store (SQL Server 2016)


See Tip ...

Published 3rd October 2016
1 minute read

Weekly SQL Server Tip 6: Always Encrypted (SQL Server 2016)


See Tip ...

Published 27th September 2016
1 minute read

Why We Build SQL Server Tools

Besides the fact that we build SQL Server tools because we really like SQL Server and enjoy writing cool .NET applications, we build tools in order to help all of us perform our work easier, faster and more efficiently.

Take for example our product DBA Security Advisor. With a single click, you can perform vulnerability assessments against multiple SQL Server instances, detect possible security risks and get recommendations and remediation methods...(read more...)

Published 26th September 2016
5 minutes read

Weekly SQL Server Tip 2: JSON Support (SQL Server 2016)


See Tip ...

Published 30th August 2016
1 minute read

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start)

If you are trying to start SQL Server Agent and you get the below error message:

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

...then this is what you can try...(read more)

Published 22nd August 2016
3 minute read

The multi-part identifier could not be found

When you get the below error message, at first you might be puzzled:
"The multi-part identifier [object_name] could not be found"

However, don't worry. It is rather a spelling mistake in your query that caused the above error.

Consider the below example...(read more)

Published 18th August 2016
5 minute read

Error converting data type varchar to float

Under certain conditions, if you try to convert or cast a variable to Float you might get the below error message:
"Error converting data type varchar to float."

Most probably you are getting this error message because the variable you are trying to convert is "not qualified" for the conversion.

In order to better understand, consider the following example...(read more...)

Published 16th August 2016
1 minute read

Free Online SQL Services

Three years ago, back in 2013, Senior SQL Server Architect and Microsoft Data Plaform MVP Artemakis Artemiou, founded the "SQLArtBits (former Artemiou Data Tools)" software startup.

Our startup's mission is to 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 get the most out of the world's more powerful data platform...(read more...)

Published 15th August 2016
5 minutes read

Why 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 keep them as secure as possible during their entire life cycle within your Organization...(read more...)

Published 4th July 2016
5 minutes read

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. I have seen best practices and bad practices. I have seen deep knowledge in administering SQL Server, but I have also seen naivety in administering such a powerful RDBMS and believe me, naivety in database administration is not something good...(read more...)

Published 28th June 2016
5 minutes read