SQL Server: Using Table-valued Functions

In some cases, I like to use SQL Server Functions to encapsulate some of my SQL Server logic into reusable and maintainable components. Recently, I have found the use of Table-valued Functions to be extremely helpful.  With Table-valued functions, you can return multiple values, which is useful enough in itself, or even entire result sets.…

Secondary Sites and Boundary Groups

Boundary Groups were introduced in ConfigMgr 2012 to combine boundaries together and give them one of two common purposes: Content Location Site Assignment These are the same two things that boundaries were used for in ConfigMgr 2007; however, all boundaries were used for both purposes in 2007 and there was no way to separate them…

ConfigMgr Startup Script Update

After a lot of work, here’s my latest incarnation of the startup script, version 1.54: http://blog.configmgrftw.com/?page_id=349. Lots of new features since 1.03 including: Bug fixes More error checking Better and more error messages Automatic ConfigMgr client agent hotfix installation Startup delay Time stamps WinPE check Local administrator check Calling of an external script to check…