http://evansdonnell.blogspot.com/2008/02/green-lantern-is-superdelegate.html
Might remember these guys from the Yahoo debates. Worth a look!
Red State Update from AthensSouth
Posted by JackDonnell
on March 1, 2008
Comments Off on Red State Update from AthensSouth
Iron is King – Video
Posted by JackDonnell
on February 29, 2008
Comments Off on Iron is King – Video
The blacksmith is a son of a friend of my mother’s. Great How it is made video . I love the music in the background.
http://www.youtube.com/watch?v=HSV8vLGgnh8
Andrew Crawford, a blacksmith in Atlanta, shows us how to make a sunflower in this episode of “Iron is King.”
Javascript Libraries
Posted by JackDonnell
on February 28, 2008
Comments Off on Javascript Libraries
Nowhere near a complete list, but some good links to start seeing what is possible and available without re-creating the wheel:
ThickBox 3.1 built on top of JQUERY
http://jquery.com/demo/thickbox/
Open,Commercial and Reseller Versions library Used by Some Big Folks:
http://extjs.com/
Nice listing of useful scripts:
http://www.howtocreate.co.uk/jslibs/
Two of my favorite sites that have been around for years :
http://www.hotscripts.com/
Linked Server Example from Original Site
Posted by JackDonnell
on February 28, 2008
Comments Off on Linked Server Example from Original Site
Older article/post on Linked Server functionality in SQL Server 200-2005 and 2K8.
https://jackdonnell.com/articles/linked_Serv.htm
I mostly use the OpenQuery() select statments to get to MySQL and other platforms. Watch your security Model!
Group By and Case Statements or Other SQL Functions
Posted by JackDonnell
on February 28, 2008
Comments Off on Group By and Case Statements or Other SQL Functions
One thing I forget to do often is to include the actual item I’m returning in the Select Statement in the Group By. Meaning , if I use a case statement of some function to change the value that I’m returning, then I should include that and not the base column name in the Group By part of the select statement
/*
If you write something like this and the Col2 has multiple 'Unique' Values
then you will get a row for each value distinct Col2 value that says 'Other'
*/SELECT [Col1]
,Case When [Col2] = 10 then 'Ten'
Else 'Other' End as [LameExample]
,Count(*) as CNT
FROM [dbo].[lameTableExample]
GROUP BY [Col1], [Col2]
-- This Example will return Only two rows
SELECT [Col1]
,Case When [Col2] = 10 then 'Ten'
Else 'Other' End as [LameExample]
,Count(*) as CNT
FROM [dbo].[lameTableExample]
GROUP BY [Col1]
, Case When [Col2] = 10 then 'Ten'
Else 'Other' End
Select Case has a simple overview of using CASE in a SQL Query with the SUM() function.
Improv Everywhere Mobile Desktop Computers
Posted by JackDonnell
on February 27, 2008
Comments Off on Improv Everywhere Mobile Desktop Computers
Improv Everywhere causes scenes of chaos and joy in public places. Created in August of 2001 by Charlie Todd, Improv Everywhere has executed over 70 missions involving thousands of undercover agents. The group is based in New York City
WordPress – Adsense Plugins Review
Posted by JackDonnell
on February 27, 2008
Comments Off on WordPress – Adsense Plugins Review
Looking for Adsense plugins and a how-to :
I found these links thought I would share them you:
Rating of 10 Plugins :
http://www.quickonlinetips.com/archives/2006/11/10-best-wordpress-plugins-for-google-adsense/
Edit the simple.php file :
http://www.tamba2.org.uk/wordpress/adsense/
Google Search Used – Has some good automation:
For Each … SQL System Stored Procedures
Posted by JackDonnell
on February 25, 2008
Comments Off on For Each … SQL System Stored Procedures
Sql server has some great built-in commands procs that can help you script server or database wide commands. sp_MSForEachTable and Sp_MSForEachDb
When first looking at a database , I sometimes like to run the following:
execute sp_MSforEachTable @command1=‘Print ”?”; Select Count(*) as [? – (count)] from ?;Select Top 10 * from ? ‘
I used the sp_MSforeachDB just the other day to set all the non-system
databases on a test server to Simple Recovery mode.Just made a quick stored procedure that I passed the ? value and filter out the system databases ( Master, Model, Tempdb and MSDB).
For More Information Checkout :
November 30, 2004
SQL Server Undocumented Stored Procedures sp_MSforeachtable and sp_MSforeachdb
By Gregory A. Larsen
http://www.databasejournal.com/features/mssql/article.php/3441031
Got To Get a Plug-in for Adsense
Posted by JackDonnell
on February 23, 2008
Comments Off on Got To Get a Plug-in for Adsense
Link to Old Articles and Scripts
Posted by JackDonnell
on February 23, 2008
Comments Off on Link to Old Articles and Scripts
https://jackdonnell.com/articles/index.htm is still available and has the old links to javascript s, T-SQL scripts, etc.