Here I get past the basics of using the Script() method and take you to how to recreate some of the scripts you can create in SSMS by instantiating a scriptingOptions object and passing it to the method. Here’s the vid.
Category: Uncategorized
Cool New SSMS Features for DBAs
I give MS a hard time sometimes so I like to give them props when I find something really worth it. And here I discuss 3 new features in Katmai that are mainly for DBAs. They’re really cool so pay attention and enjoy. Here’s the vid.
Creating Files with ForEach Loop
Here I take the intro one step further and show you how to create multiple txt files based off of a looping variable in the ForEach loop container. This is a very common task and I see this question quite a bit in the forums, so I documented it. Here’s the vid.