Monday, October 31, 2005
SQL Server 2005 Articles
A Big collection of SQL Server 2005 related article links are posted at the SQL.RU site.
Here is the link
Here is the link
Sunday, October 30, 2005
T-SQL Coding Challenge
Do you know what quine is?
If yes, there is an interesting challenge on Ken Henderson's blog for self replicating T-SQL code.
As always, Steve Kass came up with the smartest one.
Here are the links
T-SQL Coding Challenge
More about self-reproducing T-SQL
The New Generation of Microsoft Certifications
The Microsoft Certifications are getting more specific, and is going to be available by early 2006.
Here is an overview
Monday, October 10, 2005
Good News!
I am committed that I will be posting only things that are 'SQL', not anything personal, here.
But what will I do when I have some great news to tell you guys?
Hmmm.. I will tell that in an SQL (read crazy) way.
So here you go.
SELECT
CHAR(LEFT(P.m,2)) +
CHAR(SUBSTRING(P.m,3,2^1)) +
CHAR(SUBSTRING(P.m,6,~2 * -1)) +
CHAR(RIGHT(P.m,(-3 & 4 -1))) +
SPACE(1)+
STUFF(REPLACE(STUFF(OBJECT_NAME(1), 1, 4, ''),'j',''),4,1,REVERSE('emo'))+
SPACE(1)+ CHAR(ASCII('`')+1)+ SPACE(1)+
LEFT(@@VERSION,20)+
SPACE(1)+ UPPER(LEFT(DB_NAME(1),1))+
CHAR(CAST(LEFT(P.m,2) AS INT)+4)+
CONVERT(CHAR(2), 0x5021) AS [Good News]
FROM
(SELECT REVERSE(V.hugo+V.adam+V.david+V.louis)
FROM
(SELECT
CAST(M.a AS VARCHAR) AS thanksto_JCelko,
CAST(M.a + POWER(8^2,DB_ID('tempdb')) AS VARCHAR) AS thanksto_Sommarskog,
REPLICATE(DB_ID('master'),3) As thanksto_ItzikBenGan,
CAST(M.s AS VARCHAR) As thanksto_Tibor
FROM
(SELECT
(DB_ID('msdb') + 1) * POWER(10,DB_ID('tempdb')) + 1 AS thanksto_ASen,
DATEDIFF(yy, '19760509','20051007')-1 AS thanksto_SKass) As M(a,s)
)AS V(hugo, adam, david, louis)) P(m)
UNION ALL
SELECT CONVERT(VARCHAR, 0x5468616E6B7320746F20796F7520616C6C21)
-- :)
