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…
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…
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…
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…
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…
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…
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…
[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…
[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…
[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…
[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…
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…