“Special midwifery service, Pat is on his way” “what’s it going to be today”
Category Archives: Uncategorized
Change MSSQL database owner / schema
Looking to change the schema/owner on a stored procedure that you’ve restored from a different MSSQL database server. The following took me a while to work out based on all the different options. sp_changedbowner did not work for me, I had to change the schema rather than the actual owner.
ALTER SCHEMA [new schema name] TRANSFER [old schema].[stored procedure/object]
example:
ALTER SCHEMA dbo TRANSFER databdev.sp_ASPBannner_DBinfo
This was annoying to find especially as I was initially getting ‘Cannot find the object ‘sp_ASPBannner_DBinfo’, because it does not exist or you do not have permission’ and similar errors.
Jay Greig
DCOM Config Security options greyed out
If you come across a similar issue to myself with Windows 2008 within Component Services that all of the security options in the majority of the DCOM Config entries are greyed out and you cannot change them you may need to do the following on the particular CLSID entry in regedit
1. Open regedit to 'HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\
{61738644-F196-11D0-9953-00C04FD919C1}' <- this is the CLSID of the app you wish to
amend
2. Right click the {61738644-F196-11D0-9953-00C04FD919C1} key and select
permission.
3. Next click Advanced and change the ownership from Trusted Installed to the
administrator account that you're using.
4. Re-open the component services/dcom config screen and you should now be
able to amend security on the CLSID.
The particular error I had was the following:
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{61738644-F196-11D0-9953-00C04FD919C1}
and APPID
{61738644-F196-11D0-9953-00C04FD919C1}
to the user DOMAIN\sharepointwa SID (S-1-5-21-3696552686-295401563-3087639421-4121)
from address LocalHost (Using LRPC) running in the application container Unavailable
SID (Unavailable). This security permission can be modified using the
Component Services administrative tool.
This actually turned out to be the IIS WAM Admin Component
IIS Rewrite Redirect Non HTTPS to HTTPS
A quick and simple method for forcing people to use HTTPS on a site. The code uses Microsofts IIS Rewrite which is an additional feature in IIS 7 and IIS 7.5. You can easily place the following code into the applications web.config and adjust accordingly, it maintains the subfolder/path string and won’t strip it out.
<configuration>
<system.webServer>
<httpErrors errorMode="DetailedLocalOnly" defaultPath="./error/404.html" defaultResponseMode="ExecuteURL">
<remove statusCode="404" subStatusCode="-1" />
<error statusCode="404" prefixLanguageFilePath="" path="./error/404.html" responseMode="ExecuteURL" />
</httpErrors>
<rewrite>
<rules>
<rule name="HTTP to HTTPS redirect" stopProcessing="true">
<match url="(.*)" />
<conditions>
<add input="{HTTPS}" pattern="off" />
</conditions>
<action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Found" />
</rule>
</rules>
</rewrite>
</system.webServer>
</configuration>
There’s a few examples out there that don’t seem to work to great, but the above is tested and works just file.
Hope this helps people!
Jay Greig
RedBull Stratos
Brilliant achievement:
Megane off road
Just another image I took yesterday of the megane in a field after an interesting drive to work
Interesting Morning
If you start your day on a healthy note, chances are it’s probably going to benefit you for the rest of the day.
“Your mornings set the tone for the day,” Andy De Santis, a Toronto-based registered dietitian, tells Global News. “When kids and adults eat breakfast they tend to focus better at school and work and it may also help reduce cravings that come from unaddressed hunger.”
And while there are many things you can do in the morning to have a healthy routine, experts agree eating well is the first step. A well-fed body is a well-fuelled mind, De Santis adds. If you are trying to lose weight check these leptoconnect reviews.
“When you are properly nourished and fed, you are much more resilient to the ups, downs and stresses of daily life. Imagine how much harder it is to deal with a stressful situation in the office if you’re starving.”
Take a cold shower
Expert: Andy De Santis, Toronto-based registered dietitian
“I start my day with a cold shower, or at least I start it cold. It wakes you up and energizes you like nothing else, and when you finally turn the water warm, you appreciate it 1,000 times more. I can honestly not enjoy a purely warm shower anymore because of how much better it feels when you suck it up and face the cold first.”
Get into child’s pose
Expert: Inderjot Sandhar, a yoga instructor based in Mississauga, Ont.
“Do a child’s pose or bring in the knees into your chest before even getting out of bed,” she says. “[This helps] to stretch out your lower to upper back, and release any tension from the hips.”
“Do a child’s pose or bring in the knees into your chest before even getting out of bed,” she says. “[This helps] to stretch out your lower to upper back, and release any tension from the hips.”
Lemon water is key
Expert: Anna He, a wellness expert based in Toronto
“It’s always a great idea to go to bed with a glass of lemon water or supplements beside you,” she says. “Your body has been dehydrated for eight hours and in general, people don’t drink enough water. Start your day with a glass of lemon water. Get the best dietary benefits with blood balance formula.
Tesco Scan as you Shop
So, last night went to my local Tesco superstore in Wellingborough to find that they had added a ‘Tesco Scan as you Shop’ service. Trust-based shopping at it’s (Tesco) finest. I wonder how much they’ve weighed the benefits of reducing staff, speed of checkout processing against a drop in profits from customers ‘accidentally’ not paying for things:)
Time will tell.
Jay Greig
- Tesco Scan As You Shop
Let’s go fly a kite
A song that’s constantly whirring around in my head at the minute!
Enjoy!
Hello
Hello all,
I’ve no idea why really but i’ve decided to setup wordpress on this site. The original content and open source projects will be here again soon, the server we had was flakey at the best of times so bare with me on that.
What i’m aiming to do is open this site for technical posting really. I work for an ISP and over the past 6 years I often come across challenges and as a natural born problem solver I wish to share some of what I’ve come to appreciate when building a reliable service.
I’ve a lot of work to do on the site especially as I have no idea about wordpress. In my line of work the only things I seem to ever hear are that someone’s wordpress has been hacked so maybe this isn’t the best choice, but, lets face it I’m even less motivated to build a new site from scratch at the moment:)
Check in again soon:)…. Now, how do I publish this….
J Greig