JStevenson

JStevenson
Name: JStevenson
Score: 80.05
Last Seen: 634 days, 21 hours, 33 minutes ago
Member Since: 18 February, 2011
DotNetShoutout
atom rss
3
Shouts
spam Shout it Mute it

MSSQL - Bulk Deleting rows with backup
published 709 days, 21 hours, 58 minutes ago posted by JStevensonJStevenson 711 days, 1 hour, 15 minutes ago
Thursday, June 16, 2011 8:51:14 PM GMT Wednesday, June 15, 2011 5:34:15 PM GMT
Something that is a common problem in mssql server is deleting a very large number of rows from a table. Normally due to locking the table that the very long delete is running on. There is a few common ways of doing this. Mostly by setting row count and looping though a delete until it runs out of rows to delete. In sql server 2008 it is also possible todo this by moving the data from one table to another using a delete and the output clause. (more)
category: Data | clicked: 0 | comment | | source: www.stev.org
5
Shouts
spam Shout it Mute it

Stev.Org | MSSQL - Who locks what
published 721 days, 3 hours, 21 minutes ago posted by JStevensonJStevenson 723 days, 10 hours, 2 minutes ago
Sunday, June 05, 2011 3:27:33 PM GMT Friday, June 03, 2011 8:47:01 AM GMT
Locks are an important part of mssql server as they are used to protect the same information being changed by multiple clients at the same time when each of the clients don't expect the information to change at all. Sometimes it is important to find out what process or user has locks as long running quries can prevent other tasks from being able to retrive data from the database.   So below are a few quries for producing some basic information about who is locking what and just how many locks have been... (more)
category: Data | clicked: 20 | comment | | source: www.stev.org
2
Shouts
spam Shout it Mute it

ASP.NET Account lockout notify
published 737 days, 13 hours, 47 minutes ago posted by JStevensonJStevenson 737 days, 22 hours, 31 minutes ago
Friday, May 20, 2011 5:02:03 AM GMT Thursday, May 19, 2011 8:17:47 PM GMT
Something that people normally overlook when building a system is logging so here is a little snippet of code that will detect when an account has become locked out making it possible to notify either support staff or the end user that there current account has been locked out.   This following works by taking a reading of the user account before and after the login event. So we read the status of the account on the page postback. Then we test for it during the login error. We can then log this or send... (more)
category: Web Dev | clicked: 0 | 1 comment | | source: www.stev.org
3
Shouts
spam Shout it Mute it

ASP.NET - Blocking By IP Address
published 771 days, 4 hours, 25 minutes ago posted by JStevensonJStevenson 772 days, 19 hours, 53 minutes ago
Saturday, April 16, 2011 2:24:19 PM GMT Thursday, April 14, 2011 10:55:47 PM GMT
Recently I seem to be running into a little bit of a spamming problem with backlink's being submitted to the blog.It looks like the way .net blog engine does post is really easy for the spammer to be able to post lots and lots of comments with bots. This sounds quiet bad but everything is being cought by the spam filters so its really not so bad. So this is a bit of a guide to attempt to protect a website from such action comnig from abusive computers around the internet.   Firstly here is a little ba... (more)
category: Web Dev | clicked: 0 | 1 comment | | source: www.stev.org
3
Shouts
spam Shout it Mute it

Stev.Org | C# / MS SQL Get inserted value of NEWSEQUENTIALID()
posted by JStevensonJStevenson 823 days, 5 minutes ago
Wednesday, February 23, 2011 6:43:45 PM GMT
Here is a quick guide to get the new value of NEWSEQUENTIALID() when inserting a row into a table in ms sql. If you have attempted to use NEWSEQUENTIALID() before you will know that it is only possible to use as a generated value in the table when the row is being inserted. This is a guide to get this value from c# when inserting the row. (more)
category: Data | clicked: 0 | comment | | source: www.stev.org
5
Shouts
spam Shout it Mute it

SQL Injection vs. Lethal Injection / Protection Against SQL Injection
published 825 days, 25 minutes ago posted by http://tugberk-ugurlu.myopenid.com/http://tugberk-ugurlu.myopenid.com/ 828 days, 8 hours, 5 minutes ago
Monday, February 21, 2011 6:24:18 PM GMT Friday, February 18, 2011 10:44:16 AM GMT
SQL Injection and Lethal Injection... They are both dangerous and they can be easily fatal. But how? What is SQL Injection and how it can effect my project? The answers are in this blog post. (more)
category: Data | clicked: 1 | 1 comment | | source: tugberkugurlu.com
tags: SQL Server, Security, SQL, SQL Injection, Database
3
Shouts
spam Shout it Mute it

Decompiling Made Easy
published 825 days, 20 hours, 44 minutes ago posted by KodefuGuruKodefuGuru 828 days, 1 hour, 58 minutes ago
Sunday, February 20, 2011 10:04:43 PM GMT Friday, February 18, 2011 4:51:17 PM GMT
Using the soon to be not-so-free version of .NET Reflector requires one to launch the program, open an assembly, and browse to the appropriate class or method. This is fine when you only want to see how the internals of something are working, and you’re not browsing to it from code. But, it can be extremely annoying when you’ve hit F12 one too many times and you’ve arrived at a class that resides in an external assembly. JustCode will soon make this an easy problem to solve. When you’ve arrived at that ... (more)
category: How To | clicked: 0 | comment | | source: www.kodefuguru.com
tags: JustCode, decompiler, Telerik