I’m going to keep track of installs and changes here, in an effort to prepare for the Windows 8 public release to help others support their installs on their machines. In my case, I’m installing Windows 8 on a VHD on the local HD, then booting to that VHD instead of my core OS. This way I’m allocating 100% of my system hardware exclusively to that VHD as a partition. Machine Specifications HP Pavilion dv7 laptop AMD Phenom II P860…
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…