What do you want to be when you grow up?

SQL Tips

Alan Underwood shares valuable tips for managing databases using SQL Server Management Studio. He highlights a lesser-known feature where you can highlight a table name, hold down 'alt', and press 'F1' to bring up a list of columns and descriptive information about the table 1. Another tip involves dragging the columns folder into your editor to automatically generate a comma-delimited list of all columns, simplifying tasks like 'SELECT' or 'INSERT INTO' operations 1.

Autocomplete sometimes works because there's no describe function. Yes, this is actually the kind of trick for describe.

--- Alan Underwood

These tips enhance efficiency and streamline database management tasks 2 3.

   

Unit Testing

Michael Outlaw introduces Specflow, a tool that bridges the gap between business requirements and unit testing. Specflow allows business owners to define application criteria in a 'given-when-then' format, which can be translated into unit tests 4. This approach not only streamlines the testing process but also ensures that tests are aligned with business needs.

It was pseudo readable English type business cases that got turned into unit tests. It was really neat.

--- Alan Underwood

Additionally, Specflow can generate test structures for both JavaScript and C#, making it a versatile tool for developers 5.