JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

2 entries / SQL Server

Clear filters
Include a carriage return in a column heading
SQL Server 40146

Include a carriage return in a column heading

A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time.

Read note
Connection Strings for SQL Server
SQL Server 61452

Connection Strings for SQL Server

Download Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port Server=myServerAddress;Port=1234;Databa...

Read note
All published notes loaded.

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

25 Years in IT
1990 CRM clients
798 Site articles
24.4m+ Reads / hits