Excel Add-In not displayed in ribbon due to Group Policy setting

Excel Add-In not displayed in ribbon due to Group Policy setting Problem: The Excel Solver Add-in is enabled and appears to load during startup, but is not displayed/visible in the ribbon. Solution: Update the Group Policy setting titled “Disable UI extending from documents and templates” to uncheck/disable “Disallow in Excel”. Details: Today I encountered another…

2

Creating Complex Test Databases - Using Excel to convert a raw list of text into viable T-SQL syntax

As part of my series on creating databases with interesting characteristics for testing purposes, I have covered a few different engine constructs, test strategies, and scripting techniques to build interesting databases.  In this article, I am going to highlight one technique I use fairly often with leveraging Excel’s text concatenation functionality to generate T-SQL script…

4