Infographic: How to Import and Export Data in SQL Server

I’m pleased to share with you a useful infographic I created for my Online Course “How to Import and Export Data in SQL Server“. This infographic, provides a quick overview of all the available built-in tools and mechanisms in SQL Server, that can be used for import and exporting data.       Cheers, Artemakis … Read more…

Error converting varchar to numeric in SQL Server

While developing data processes in SQL Server, under certain circumstances, you might get the error message: error converting varchar to numeric. This error is similar with the conversion error you might get when you are trying to convert a varchar to float, etc. Read on to find out the reason for getting this error message and … Read more…

Snippets Generator v3.3 is Now Out!

We have some amazing news about Snippets Generator! We are proudly announcing the general availability of Snippets Generator v3.3! With an a brand new, intuitive GUI, Snippets Generator helps you to easily create T-SQL code snippets for use in SQL Server Management Studio (SSMS). Moreover, you can edit existing T-SQL code snippet files. So, what’s … Read more…

SQL Server Row Level Security by Example

SQL Server Row Level Security (RLS) is one of the top new features shipped in SQL Server 2016. With RLS, you can control access to rows in a table based on the characteristics of the user executing a query. The access restriction logic is located in the database tier and access restrictions are always applied, … Read more…

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 file with a single click. … Read more…

Snippets Generator v2.1 is Out!

[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. Our software tool “Snippets Generator” just got new features with its brand new release v2.1! Snippets Generator allows the user to easily create T-SQL snippets for use in SQL Server 2012 SSMS or later! In this new release, the … Read more…

Snippets Generator v2.0 is Out!

[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. We are very happy to announce the general availability of version 2.0 of Snippets Generator. Snippets Generator allows the user to easily create T-SQL snippets for SQL Server 2012 and later! You can create a snippet from scratch or … Read more…

Snippets Generator v1.0 – Stable Version Now Available!

[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. We are very happy to announce that the first stable version of Snippets Generator is now available! Do you need to create T-SQL snippets for your SQL Server 2012 instance? Snippets Generator is the tool for the job! And of … Read more…

Dynamic T-SQL Generator v1.0 is now on CodePlex!

Earlier this year, in one of my blog posts, I presented Dynamic T-SQL Generator: a tool I developed that generates dynamic T-SQL based on a given static T-SQL script and vice versa. Dynamic T-SQL can be used in many cases when you develop SQL Server routines. An example is embedding T-SQL scripts in SQL Server … Read more…

Snippets Generator v1.0 is Now Out!

[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. T-SQL code snippets is a very handy new feature originally shipped in SQL Server 2012. Using code snippets you can save time when you write code and you just need to enter code that does common tasks. Code reuse has … Read more…

String or binary data would be truncated

There are many times where a query may result to the following error: String or binary data would be truncated. The statement has been terminated. We will go through a simple example for explaining this behavior.   Reproducing the “String or binary data would be truncated” error Creating the Sample Table Consider the following table: CREATE TABLE … Read more…