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…

How to Resolve: Bulk load data conversion error (type mismatch or invalid character for the specified codepage)…

This post helps you how to resolve the BULK INSERT-related error in SQL Server: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row… , column …    Reproducing the issue with an example Consider an example where you have a text file which you want to import in … 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…

A connection was successfully established with the server, but then an error occurred during the login process.

When you try to connect to a SQL Server database from a client application, under certain circumstances, you might get the below error message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 – No process is on the other end of the … Read more…

There is insufficient system memory in resource pool ‘internal’ to run this query.

This article discusses how you can resolve the error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to do with memory management. 🙂 … 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…

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…