In the fast-paced world of computer science, it is easy to get caught up in the latest trends and technologies. Data science, data engineering, and data analysis are just a few recently popular skills. However, it is essential to remember that specific fundamental skills are the building blocks for any…

It is not easy to extract object names from an SQL command since they may be written in different ways (with/without schema, databases name included …). Still, there are many option to extract objects from an SQL query that you can try. This quick tip illustrates different approaches to parse…

When executing the SSIS package the Script Task throws the following exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.InvokeMember(String name…

This article explains how implicit conversion affects SQL query performance and causes the query optimizer to perform an index scan instead of index seek while searching for a specific value. Implicit conversion… A quick reminder In SQL, implicit conversion is an automatic data type conversion done by the compiler within an operation where different data…

Tech Blog is a Medium publication that tends to publish technical articles, ideas, and tutorials. If you are interested in sharing your knowledge with us, please read the article writing guidelines and submission rules before submitting your first article. Submission rules Before submitting your article, you need to know a few essential…

Leading database technologies are providing certification exams for free! — Professional certification recognizes your knowledge and experience and enhances your professional credibility. Many students and developers cannot get certified since they cannot pay the certifications exams fees. After a little research on the internet, I found several database certification exams available for free by leading database providers in the market.

This post mentions some SQL Server experts you need to know during your SQL Server journey. Those experts are Microsoft Most Valuable Professionals that highly contributed to SQL Server the community. I am sure there are many more experts in the SQL Server community, but I will be mentioning the…

Even after the rise of Big Data technologies, Microsoft SQL Server Integration Services still one of the most popular data integration tools. Mainly, SSIS developers use Visual Studio to develop their data integration packages. One of the main challenges that face the SSIS developers is that they design tens of…

SchemaMapper SchemaMapper is a data integration class library that facilitates data import process from external sources having…munchy-bytes.github.io As in the first release (1.0.0), SchemaMapper was developed to merge data from different file types (flat file, Excel, Access …) into one SQL table. SchemaMapper 1.1.0 was released after being improved to support reading from relational databases and writing data into more data formats. Also, SchemaMapper 1.1.0 …