TedDallas

5 ms·

1. 31.▲
   by TedDallas 5y ago

   If you liked Delphi then Lazarus is a great open source alternative for WYSIWYG Linux and Windows forms based application programming. Recently I used it to create a little SQL editor with syntax highlighting for Maria DB. It only took a fe
2. 32.▲
   by TedDallas 6y ago

   Er ... SQL Server Management Studio is based on Visual Studio shell, and it does a fine job debugging stored procedures. I also code in C# and agree it also works well for that.
3. 33.▲
   by TedDallas 6y ago

   Recursion in SQL is one of the questions I always ask Data Engineers during interviews. The answer in MS T-SQL is to use a recursive CTE. It is not a common problem, but it comes up once in a while. Using a CTE is a better solution than
4. 34.▲
   by TedDallas 6y ago

   Nice documentation. Ada looks a lot like Pascal. It is interesting that SPARK is a subset of subset of Ada.
5. 35.▲
   by TedDallas 8y ago

   --A T-SQL version Select Case When SomeNumber % 3 = 0 and SomeNumber % 5 = 0 Then 'FizzBuzz' When SomeNumber % 3 = 0 Then 'Fizz' When SomeNumber % 5 = 0 Then 'Buzz'
6. 36.▲
   by TedDallas 8y ago

   Data structures - knowing your basic data structures will help you chose the right path for the use case. Even in SQL it is helpful to understand B-Trees.