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/
No comments:
Post a Comment