The free gedit text editor may be the editor to get you out of a jam without all the bells and whistles getting in the way. Read More
Visual Studio 16.10 Preview 2
Microsoft just released Visual Studio 16.10 Preview 2. We just downloaded a copy onto our machine and will attempt to work with some of the new features. Check out this post by Justin Johnson (April 14, 2021) for more details. There’s always a better way and more than one solution.
SQL Server – MSSQLTIPS
Writing date-based queries with SQL Server are common in our industry. Writing good queries is likely less common. As a subscriber to the MS SQL Tips new letter, I frequently encounter useful information and helpful tips. “Using a calendar table in SQL Server – Part 1” by Aaron Bertrand (2021-04-22) is particularly useful for creating… Read More
How to Connect to SQL Server > TCL 8.6.11 The Magic of Strings
How to connect to SQL Server using TCL It only takes a few lines of TCL code to connect your program to SQL Server. The key to a successful connection is having the right connection string. Visit ConnectionStrings.com – Forgot that connection string? Get it here! Replace the “my_________” entries in the connection string with… Read More
Brackets Adobe
I opened a file using the Brackets code editor today and saw this notice on the bottom of the editor screen: Admittedly, I’m not a frequent user of Brackets. However, there are times when it was just the tool I needed to write a small piece of JavaScript or make minor changes to an HTML… Read More
C#, Excel, and SQL Server
Using Excel to work with SQL Server data sets is often more convenient than having to write a complete solution using C#. A variety of solutions exist to work with Excel from your C# code and Microsoft.Office.Interop.Excel is just one of them. EPPlus is also a popular solution for working with Excel. EPPlus is free… Read More
Total Commander 9.51
Every once in a while I stumble across a very useful utility and Total Commander (ghisler.com) by Christian Ghisler is one of them. I was impressed by the many features this utility includes and will leave it to you to visit their home page to discover them for yourself. To do otherwise would simply be… Read More
Noodling Over EDI Using C#
Years ago, I wrote an application in VBA for Excel to parse an 830 document and format the data into a useable worksheet. The code can process an 830 document (EDI text file) containing upwards of 2500 lines in less than 20 seconds all while creating and formatting the worksheet from scratch. The VBA code… Read More
SQL Server – Dynamic Data Pivot
Creating a pivot table dynamically is not difficult as it may seem. Try it and you’ll see how relatively simple it can be. Read More
Visual Studio 16.9 and 16.10 Preview 1
Visual Studio 16.9 and 16.10 Preview 1 bring many new features to enhance your coding experience. The best IDE is only a few clicks away. Read More