Been doing this so much lately with all of the flavors of Windows 8, I figured I’d write this down for my own benefit, but also for anyone who’s interested in doing the same. Create a new VHD Go to Start, right-click on Computer and choose Manage Under Storage in the left pane, single-click Disk Management In the Actions pane on the right, click More Actions, then choose Create VHD Specify the location you want to store your VHD file (ex:…
This is a quick one…if you ever have multiple web parts on a single SharePoint website, and you want to manage or delete more than one at a time, or even just see which web parts were added to a website beyond the default content of the template, add the following (in bold) after the URL in the active window: http://server/site/page.aspx?contents=1 This is cool! Check the boxes of the ones you want to delete/manage, etc. Enjoy!
I wanted a way to validate that an email address in a SQL query was well-formed, and found a lot of resources suggesting to create a scalar function that invokes sp_OACreate among others, and return a bit indicating if it was valid or not. That works great, but not for those of us in heightened security environments, where granting execute permissions to system stored procs and functions is not permitted. After searching around I came up with the following function:…
(Originally posted September 2, 2009) When I need to know the first (or any) occurrence of a character, I’m used to saying something like InStr() for VB or ASP, or String.IndexOf() in .Net, but when I tried to do something like this in SQL for a substring portion of a query I was creating, those obviously aren’t available. In Oracle InStr is available, but we`re talking about SQL. To get the first occurrence of a character in a TEXT field (emphasis…
While creating a new BI Center at my company we had no trouble building the site in dev, creating dashboards, Excel reports, etc. Everything worked fine. We were rolling the solution out to production (keeping in mind, our dev and prod installations of SharePoint 2010 were created identically), but when we clicked on “Start Using PerformancePoint Services”, we were met with the error page and the message “An error occurred during the processing of /<BI Center>/Pages/ppssample.aspx. Code blocks are not…