Links

SQL Profiler: Features, functions and setup in SQL Server 2005:

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1159433,00.html

http://msdn.microsoft.com/en-us/library/ms175070.aspx

http://www.developer.com/db/article.php/3482216



========================================================================================

index tunning:

http://databases.about.com/od/sqlserver/a/indextuning.htm

========================================================================================

Create a Trace with SQL Server Profiler:

http://databases.about.com/od/sqlserver/ht/trace.htm

Indexed Views:

http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

SQL Server Query Execution Plan Analysis

http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx

http://msdn.microsoft.com/en-us/library/ms181055.aspx

http://msdn.microsoft.com/en-us/library/ms175913.aspx

http://msdn.microsoft.com/en-us/library/ms178071.aspx



*********************

http://blogs.techrepublic.com.com/datacenter/?p=198

http://www.simple-talk.com/sql/performance/execution-plan-basics/

*********************

Query Analyzer - Sql Server Database Indexes and Execution Plans

http://davidhayden.com/blog/dave/archive/2005/07/24/2403.aspx

trace:

http://blogs.techrepublic.com.com/datacenter/?p=269

SQL Integration Services:

http://www.google.co.in/search?hl=en&q=sql+integration+service&meta=

http://www.microsoft.com/sql/technologies/integration/whitepapers.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx



http://msdn.microsoft.com/en-us/library/ms167031.aspx

http://www.accelebrate.com/sql_training/ssis_tutorial.htm

========================================================================================

Creating stored procedures:

http://msdn.microsoft.com/en-us/library/ms187926.aspx

========================================================================================

Database Tutorials:

http://www.visualbuilder.com/database/tutorial/pageorder/13/

========================================================================================

Free eBooks:

http://www.itquestionbank.com

http://www.free-ebooks-download.org

========================================================================================

SQL Server Locks:

http://mssqlcity.com/Articles/Adm/SQL70Locks.htm

http://www.quest-pipelines.com/newsletter-v3/0202_F.htm

http://www.sqlteam.com/article/introduction-to-locking-in-sql-server

http://msdn.microsoft.com/en-us/library/aa213039(SQL.80).aspx

http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2008/04/08/kinds-of-locks-in-sql-server.aspx

http://www.quest-pipelines.com/newsletter-v3/0202_F.htm

http://www.mssqlcity.com/Articles/General/sql2000_locking.htm

http://www.informit.com/articles/article.aspx?p=26890&seqNum=4

http://support.uptimesoftware.com/article.php?id=194

http://www.zimbio.com/SQL/articles/586/Lock+SQL+Server+3

http://blogs.ittoolbox.com/c/programming/archives/the-net-developer-and-sql-server-know-your-locks-14062

http://www.evanreiser.com/2007/04/locking-in-sql-server-2005.html



========================================================================================

SQL Replication Step by Step:

http://www.codeproject.com/KB/database/MergeReplication.aspx

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

http://www.devx.com/dbzone/Article/35803

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html

============================================================================================================



SQL Server Tips:

http://sql-server-performance.com/tips/gen_tips_p1.aspx

============================================================================================================



All Tutorials:

http://www.java2s.com/Code/SQLServer/Database/Createdatabasefrommdffile.htm

============================================================================================================



SQL server Normalization:

http://www.google.co.in/search?hl=en&q=normalization+in+sql+server&meta=

http://www.sqlservercentral.com/articles/Basic+Querying/normalization/584/

http://www.eggheadcafe.com/articles/20050826.asp

http://databases.about.com/od/specificproducts/a/normalization.htm

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1120129,00.html

============================================================================================================



SQL 2005 Features:

http://www.informit.com/articles/article.aspx?p=327394

http://dotnet.sys-con.com/read/45543.htm

============================================================================================================



SQL Server 2008:

http://www.microsoft.com/learning/syllabi/en-us/6156afinal.mspx#EQD

============================================================================================================



SQL Server Sample databases:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=10901

============================================================================================================



It’s the consolidated list

http://articles.techrepublic.com.com/5100-9592-6143761.html#

======================== pivoting ============================================

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3/

http://www.sqlservercentral.com/articles/Development/2803/ -- link for DLL adding...............

http://www.informit.com/articles/article.aspx?p=327394

http://dotnet.sys-con.com/read/45543.htm

http://technet.microsoft.com/en-us/library/ms143506.aspx

http://www.databasejournal.com/features/mssql/article.php/3112381

http://www.mssqltips.com/tip.asp?tip=1145

http://www.sql-server-helper.com/tips/date-formats.aspx

============================================================================================================



URLs for SSRS 2005

http://www.sqlservercentral.com/articles/Development/2803/

https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=85378&SiteID=17

http://msdn.microsoft.com/msdnmag/issues/06/07/DataPoints/default.aspx

http://en.csharp-online.net/Microsoft_SQL_Server_2005_Reporting_Services,_Sams

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3-the-chart-control/

============================================================================================================



Reporting Services Programming:

http://technet.microsoft.com/en-us/library/ms155076.aspx

http://msdn.microsoft.com/en-us/library/aa237738(SQL.80).aspx



============================================================================================================



SSRS :

http://www.informit.com/articles/article.aspx?p=327394

http://dotnet.sys-con.com/read/45543.htm

http://technet.microsoft.com/en-us/library/ms143506.aspx

http://www.databasejournal.com/features/mssql/article.php/3112381

http://www.mssqltips.com/tip.asp?tip=1145

http://www.sql-server-helper.com/tips/date-formats.aspx

http://www.sqlservercentral.com



Rules for SSRS:

http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx



============================================================================================================

SQL Serer Locks:

http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm

============================================================================================================

Microsoft SQL Server 2005 Service Pack 2 :

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

http://www.toggle.com/lv/group/view/kl39928/Microsoft_SQL_Server_2005_Service_Pack.htm

============================================================================================================http://trec-step.info/

============================================================================================================



DotNet Spider:

http://www.dotnetspider.com/forum/ViewForum.aspx?ForumId=64019

============================================================================================================



MCP:

http://www.microsoft.com/learning/mcp/mcsd/requirementsdotnet.mspx

============================================================================================================



SQL Server Magazine:

http://www.sqlmag.com/

============================================================================================================



All Forums:

http://www.eggheadcafe.com/default.aspx

============================================================================================================



COE:

http://hcssrums01/sites/COE/Shared%20Documents/Forms/AllItems.aspx

============================================================================================================



============================================================================================================SQL Server Performance.com:

http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx

============================================================================================================Exchange Server Name : hcsmsg001/002

============================================================================================================

Interview Questions:

http://www.allinterview.com/showanswers/28431.html



============================================================================================================Microsoft® Visual Studio® 2005 Team Suite Service Pack 1:

http://www.microsoft.com/downloads/details.aspx?FamilyId=BB4A75AB-E2D4-4C96-B39D-37BAF6B5B1DC&displaylang=en



============================================================================================================

ASP.NET Quick Start:

http://quickstarts.asp.net/QuickStartv20/aspnet/doc/default.aspx

http://207.46.248.104/quickstart/aspplus/

http://www.15seconds.com/

Enjoy this

UNIX is simple. But It just needs a genius to understand its simplicity.
--Dennis Ritchie


Before software can be reusable, it first has to be usable.
--Ralph Johnson


Good judgment comes from experience, and experience comes from bad judgment.



--Fred Brooks




It's hard enough to find an error in your code when you're looking for it;
It's even harder when you've assumed your code is error-free.


-- Steve McConnell Code Complete




The trouble with the world is that the stupid are sure and the intelligent are full of doubt.


--Bertrand Russell



This is the best 1.....
If debugging is the process of removing bugs,
Then programming must be the process of putting them in.
--Edsger Dijkstra


You can either have software quality or you can have pointer arithmetic;
You cannot have both at the same time.
--Bertrand Meyer


There are two ways to write error-free programs; only the third works.
--Alan J. Perlis


Measuring programming progress by lines of code is like measuring aircraft building progress by weight.


--Bill Gates




The first 90% of the code accounts for the first 90% of the development time.
The remaining 10% of the code accounts for the other 90% of the development time.


--Tom Cargill




Programmers are in a race with the Universe to create bigger and better idiot-proof programs.
The Universe is trying to create bigger and better idiots.
So far the Universe is winning.
--Anon

Theory is when you know something, but it doesn't work.
Practice is when something works, but you don't know why it works.
Programmers combine Theory and Practice: Nothing works and they don't know why.

The Six Phases of a Project:
· Enthusiasm
· Disillusionment
· Panic
· Search for the Guilty
· Punishment of the Innocent
· Praise for non-participants



Last but not least ! ....
No matter how slick (efficient) the demo is in rehearsal,
When you do it in front of a live audience
The probability of a flawless presentation
Is inversely proportional to the number of people watching,
Raised to the power of the amount of money involved