by rlynch
November 01, 2009 07:09
Script to create a UDF (user defined function) that formats a datetime field into a shorttime string.
[More]
Currently rated 4.3 by 3 people
- Currently 4.333333/5 Stars.
- 1
- 2
- 3
- 4
- 5
Tags:
SQL Server
by rlynch
October 24, 2009 16:03
The following script shows the difference between the intersect and except clauses in a hello world type example. Intersect shows the rows in the first query that exist in the second query while the except only shows the rows that don't exist in the second query. The...
[More]
by rlynch
October 24, 2009 07:14
This is a quick and dirty "Hello World" example of how to use savepoints in a SQL Server transaction to Roll back a transaction to a specific point.
create table t3(ids int)
go
truncate table t3
insert into t3 values(0)
begin tran abc wi...
[More]
by rlynch
September 09, 2009 11:48
http://www.ajaymatharu.com/integrating-blogengine-into-an-existing-site/
Great link showing which lines to take from the blogengine web.config to paste into the root if you want to integrated the both sites to a single web app.
Currently rated 4.5 by 2 people
- Currently 4.5/5 Stars.
- 1
- 2
- 3
- 4
- 5
Tags:
asp.net
by rlynch
August 27, 2009 04:04
For anyone who has ever needed to decompile a dotnet exe or dll this utility (and it's addins) offer endless abilities. A few years ago I had a website I developed using a central dll come up for changes. When beginning to make changes, visual studio managed to corrupt all my source code. This...
[More]
by rlynch
August 17, 2009 08:35
Running Vista I was unable to install Visual Studio 2008 from my system via the programs applet in Control Panel.. Fortunatly I found this link at msdn.
http://msdn.microsoft.com/en-us/vstudio/bb968856.aspx
Using the AutoUninstallTool Provided I was able to remove VS 2008 com...
[More]
Currently rated 4.7 by 3 people
- Currently 4.666667/5 Stars.
- 1
- 2
- 3
- 4
- 5
Tags:
by rlynch
August 13, 2009 09:18
Apologies to C# users the code here is VB but it shouldn't be too hard to convert.. If I get time I will do so and post up that version also..
The key methods are "impersonateValidUser" and "undoImpersonation"
impersonateValidUser takes 3 arguments "...
[More]
by rlynch
July 17, 2009 05:33
Remove directory from non authenticated users..
Add inside system.web (The following removes access to the website root to non authenticated users) of a specific directory
<authorization><deny users="?"/></authorization>
The following allows access t...
[More]
by rlynch
July 16, 2009 15:50
Something I needed, so I built it for all to use..
the exe is great if you are sitting at the server, but if you are not...
here is a link to upload the script (you may need to click on the article to get to the link.. the listing view wasn't showing it as a hyperlink for me...)
...
[More]
by rlynch
July 12, 2009 02:59
Avoiding problems running ssis packages in job steps
[More]