You can just use the property by following the path:

@activity('Lookup1').output.firstRow.TokenGUID

I use a mixture of Visual Studio, vscode, ssms, Azure Data Studio, PyCharm, Jetbrains Rider and IntelliJ 🙂

If you are developing .net code on a windows machine then you can't...

It depends on the project, for new greenfield databases where we can can stop the rot before it sets in then SSDT - older projects that have "issues" i'd probably...

nice!

I hadn't heard't heard "If you're the first person people come to with database problems rather than the last, you might be an exceptional DBA" before but I really like...

Break down those barriers!

I've been on the opposite side where we have had DBA's who always looked busy and were never interested in what we did unless there was a...

Hi sizal 🙂

The logical / physical design is about how you take the data you need to store and create a set of logical entities (customer, order), once you know...

We, as T-SQL developers definitely do need to get better and formalize our testing, I blogged the other day about how to test constraints for example:

http://sqlserverfunctions.wordpress.com/2014/10/05/unit-testing-constraints-in-sql-server/

...