Delete multiple web parts at the same time in SharePoint 2010
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!
Validating email string without using sp_OACreate in T-SQL
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:…
Get the first occurrence of a character in SQL
(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…
PerformancePoint error: “Code blocks are not allowed in this file.”
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…
Enabling editing of SQL 2000 DTS in SSMS 2008 R2
We have some old SQL 2000 DTS Packages that we still maintain, and I’m not continuing to install SQL Enterprise Manager on future versions of my OS just to edit these things, I should be able to edit them in SSMS right? Well, yes, but it requires a couple of steps, that so far in my Google research is never complete…it’s always a part of the entire solution. (PINTA) Well, here’s the entire solution: First, go to http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988 and download/install the SQLServer2005_BC.msi…