-
SET Vs SELECT
-
I have seen multiple post on this very topic. And most importantly its a blanket statement that dont use SELECT and use only SET while assigning. Here is some more perspectives to the whole thing from Tony. Read it here.
PS: I still wonder why MS always tries to give two-three or more methods for the same function yet not documenting most of them from a usage perspective.
Nevertheless, we always get to read from the fabulous fellow MVP's on them ;) ...
-
Cross Tab in SQL Server 2000
-
Today, I got a note from one of the blog readers on this very topic and thought it is worth making a mention over the blog rather than sending replies everytime to different people. I am sure this will be useful to someone googling over the internet :) ...
MSDN - Cross-Tab Reports
SQL Magazine Article - Dynamic Crosstab Queries
from Fellow MVP, Itzik Ben
From the SQLTeam site - Dynamic Cross-Tabs/Pivot Tables
Some third party tools that specialize on this requirement and if you have the extra $$$ you can also think on these lines.
GeckoWare Australia - SQL Crosstab Builder for Microsoft SQL Server
http://www.ag-software.com/Content.aspx?Doc_id=1002
Very famous and quite a lot of times refered on the Newsgroups is:
RAC - http://www.rac4sql.net/
-
TechEd 2006 India: My sessions
-
Same time next week I must be on my way to attend/present at the biggest techno event TechEd from Microsoft in India. So I plan to talk on couple of topics and the same can be got from: TechEd Site.
So I am talking on:
- SQL Server Monitoring Tools: The Key to Running 24x7 SQL Deployments
- SQL Mobile 2005 Performance Tuning
I will be presenting at all the cities this time too and would enjoy meeting you all over my sessions. I have some really exciting demo centric sessions and these have really taking very good shape.
Even though I dont want to give away the specifics, for my blog readers well the first session on monitoring has hardly any slides but talks more on how you would monitor SQL Server 2005 using demo :). I would talk on tools and techniques introduced with SQL Server 2005. So dont miss it ... Meet you all soon ...
-
Presence Controls for Microsoft Office Communicator 2005
-
I have been using Communicator inside our organization and it surely looks cool. Was amazed to see this go a step further in implementing this on windows apps? Cool !!! Check out this download on MSDN.
-
SP1 and RS
-
SP1 extends SQL Server 2005 Reporting Services with a new .NET Data provider and a new MDX Query Designer that directly support enterprise reporting against SAP NetWeaver Business Intelligence. You can get a whitepaper about this new feature here.
-
TechEd India 2006
-
Will you be there ??? Dont forget to meet me ...
Registration...
-
Hindi Global Support Site
-
Did you know that??? Abhisek (MVP Lead) did give us the link but surely a big step forward. There is a lot to be done to make it loaded with articles.
India Hindi site: http://support.microsoft.com/?LN=hi-in