Blog

(Articles with tag:Optimize my database) - Remove Filter

Mar 14/2021

How to Insert Carriage Return or Line Break Or Tab into a string in MS SQL Server

From some reason when I first ran MS SQL 2016 I realized when I run some code with Carriage Return Return and Line Break it stays in one line after coping that into a note pad or below the SQL code in Microsoft SQL Server Studio. So, what happened here? After digging deep into it I found out that this feature that worked as default from MS SQL 2014 and below is not working as a default feature anymore. You need to set it up in order to make that work.

Mar 16/2019

Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

While working with different software developers, I noticed that some of them still using spreadsheets or MS Word to keep track of the database design. Other developers use the MS SQL Database Diagrams in MS SQL. Visual Studio provides some basic capabilities on the database design. But is that the most productive tool to use?