We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.
I thought I will share my experience how you can get identity value after insert using SQL Server. I have also written stored procedure that shows how to use one of the methods and return the value using sp argument so it can be used for other purposes.
In this blog article I will give an overview of performance tuning based on common situation that occur on small and medium size BI projects. Later on I hope to add more links that describe the subject in more details.