Ligatures are special characters in a font that combine two or more characters into one. For example, if you use a ligatured font, whenever you type != it will become ≠. Aside from the arguments whether using a ligatured font is good or bad thing in your code, here's what you need to do when you want to enable it in Visual Studio Code. For this example, we'll use Cascadia Code (NOT … [Read more...]
Connect New SSRS Server to Old SQL Server with TLS
This was posted just to share an experience of tackling a problem we encountered when we needed to connect an SSRS Server 2016 to an older SQL Server database (Windows Server 2008 R2) and what steps we took to troubleshoot the issue. After all the reports were migrated to the new SSRS server, upon creating a new Data Source, I got an error message something along the line to enter the user id … [Read more...]
How to Quickly Query LDAP in Visual Studio SSIS
At times, you need to do a quick query against LDAP, but if your access is quite restricted, sometimes instead of using SQL Server Management Studio, you can also use SSIS Project within Visual Studio to do it. Steps Launch Visual Studio. Create a new project and double-click on Integration Services Project. Name your Project name (e.g. ITNotaQueryLDAP), then click Create … [Read more...]
How to Fix Failed to Decrypt Protected XML Node Error in SSIS
One morning, you discovered your SSIS package failed to run with the following error message: This is typically caused by a simple setting that is too often overlooked during deployment. In general, you do not want to save any connection ID and password in your package so you can inject the value from variables that you store either in a database or if you use a Package Deployment Model, … [Read more...]
How to Open Visual Studio Code from command line macOS
When you use Visual Studio Code on Windows, one handy feature is you can always call it from the command line by typing "code ." (without the quotes) in the folder where you want to work on. But when you try that on macOS Terminal, this is what you get: zsh: command not found: code Not to worry, the same feature can be had on macOS but it's just not installed by default. In order to … [Read more...]