Rich Grenwick's Nonsense: April 2011

Tuesday, April 26, 2011

Renumbering Table Rows

For the life of me, I can never remember the syntax for this! Ack!

-- hack to get WITH expression to work
set @user_code = @user_code;

/* renumber now that we have the data massaged how we want */
WITH newPH
AS (SELECT
[rowid]
,ROW_NUMBER() OVER(ORDER BY AUDIT_LOG_DATA_ID DESC) AS [newRowID]
FROM web_sp_AUDIT_LOG_View
WHERE userkey = @userkey)
--SELECT * FROM newPH
UPDATE newPH
SET [rowid] = newRowID

declare @total_records int
SELECT @total_records = COUNT(*) FROM web_sp_AUDIT_LOG_View WHERE userkey = @userkey
UPDATE web_sp_AUDIT_LOG_View SET [total_records] = @total_records where userkey = @userkey

Monday, April 25, 2011

DebugView - view Debug output without opening Visual Studio.

"DebugView is an application that lets you monitor debug output on your local system, or any computer on the network that you can reach via TCP/IP. It is capable of displaying both kernel-mode and Win32 debug output, so you don't need a debugger to catch the debug output your applications or device drivers generate, nor do you need to modify your applications or drivers to use non-standard debug output APIs."

http://technet.microsoft.com/en-us/sysinternals/bb896647

Genius!

Tuesday, April 5, 2011

MSDN Magazine: Natural Algorithms - Use Bee Colony Algorithms to Solve Impossible Problems

MSDN Magazine: Natural Algorithms - Use Bee Colony Algorithms to Solve Impossible Problems: "Volt Information Sciences"

team - How do deal with developers that over complicate projects - Stack Overflow

This thread has some really thought provoking things -- and some good articles referenced. I really want simplicity ...

http://www.codinghorror.com/blog/archives/000933.html

http://www.yafla.com/dennisforbes/Effectively-Integrating-Into-Software-Development-Teams/Effectively-Integrating-Into-Software-Development-Teams.html

http://www.makinggoodsoftware.com/2009/08/11/for-gods-sake-make-it-easy/

http://www.joelonsoftware.com/articles/fog0000000018.html

http://stackoverflow.com/questions/87143/does-k-i-s-s-play-a-role-in-your-development-if-so-do-you-prosper-from-it

HTML5 Boilerplate - A rock-solid default template for HTML5 awesome.

This is awesome indeed!

Conditional stylesheets vs CSS hacks? Answer: Neither! « Paul Irish

Brilliant! Here is an excerpt from this great article:

"Here's my proposed solution:

          <body>

Using the same conditional comments, we're just conditionally adding an extra class onto the body tag. This allows us to keep our browser-specific css in the same file:

 div.foo { color: inherit;} .ie6 div.foo { color: #ff8000; }

Plus it totally validates and works in all browsers.

(Hat tip to Paul Hammond and Adam McIntyre for being s-m-r-t.)"