This was great. I am actually working with something like this. Got one question about the conversion function (ConvertIP2Num). Why do we need this section CAST((col%@SUBNET_MASK) as...

Loved it. Familiar topic, but very well explained!

I have been using SSIS for a while, but haven't tapped into the power of even handling yet. This is a great and useful introduction!

Great approach. Thank you for the article!

Great idea! Using cluster to simplify hardware upgrades and minimize resulting impact to the end users. Thank you!

Thank you for a useful article. I have a question. In the execution plan example, there are multiple "column" elements listed under "columngroup". Does this mean that...

Great article. I think Microsoft should built in something like this into the next release of SQL Server (and pay royalties to Scott ;-))

Very educational. Thank you! It's interesting that sub-query version sometimes outperforms ROW_NUMBER version in your example when proper indexes are in place. I guess the moral is...

I have been using profiler for a while, but still learned a couple of new tricks by watching these videos. Looking forward to more like this on other topics....

Awesome article. I am saving it! Space management is something to watch out for when this approach is implemented (but then again, we all do it anyway, right?...

Thank you for the article and thank you to Mathew for the trick with Visual Studio shortcut. Very useful!

I can totally see using this for some databases (or even specific tables), for SOX compliance purposes. Looking forward to the next installment.

Excellent series. Profiler is such a valuable tool and so underutlized. Look forward to the rest of the videos.

Excellent series! I especially like that I can build on this type of infrastructure and extend it further (and don't have to pay for expensive 3rd party tools :-)).

Thank you for the article! I have been doing a lot of SSIS work over the last 3-4 years including some pretty advanced stuff, but have never touched Script...