Release SSIS using Azure DevOps
Steps on how to create a working pipeline to release SSIS packages using Azure DevOps from the creation of the…
Split SQL script tool
I have created a simple C# console application as a tool to split big SQL scripts. For example, I had…
How do I extract text that lies between two strings?
My initial problem was to extract from a SQL string generated by MySql, all fields....
Migrate SQLite to MySQL
I’m developing a huge app made with Xamarin Forms in my company. A problem was...
How to use REPLACE() within NTEXT columns in SQL Server
SQL has an incredibly useful function, REPLACE(), which replaces all occurrences of a specified string...
How can I know when SQL Full Text Index Population is finished?
When you execute some queries on your SQL Server, are you sure the catalog is...
How to remove HTML tags from data with SQL
The purpose of this article is to provide a way of cleaning up of HTML...
SQL SERVER – Find Current Location of Data and Log File of All the Database
As I am doing lots of experiments on my SQL Server test box, I sometime...
How to truncate log file in SQL Server
In SQL Server data is stored using two physical files: (.mdf) extension which contains the...