Interesting SQL Server Articles

Right click and open the links in a new window/tab:

S. No	Topics	Links
1	sys.fn_my_permissions	http://msdn.microsoft.com/en-us/library/ms176097.aspx
2	SQL Server D&D Blog	http://sqlserverdownanddirty.blogspot.com/2011/02/sql-server-schedulers.html
3	How to update or slipstream an installation of SQL Server 2008	http://support.microsoft.com/kb/955392
4	SQL Server 2008 failover cluster rolling patch and service pack process	http://support.microsoft.com/kb/958734
5	SQL Server 2008 failover cluster rolling patch and service pack process	http://blogs.technet.com/b/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx
6	How to: Revert a Database to a Database Snapshot	http://msdn.microsoft.com/en-us/library/ms189281.aspx
7	Limitations and Requirements of Database Snapshots	http://msdn.microsoft.com/en-us/library/ms189940.aspx
8	DBCC CHECKDB WITH DATA_PURITY	http://msdn.microsoft.com/en-us/library/ms176064.aspx
9	Trace Flags	http://msdn.microsoft.com/en-us/library/ms188396.aspx
10	Analysis Services Links	http://www.mssqltips.com/sql-server-tip-category/28/analysis-services/
11	Backup concepts : MSSAS	http://www.sqlmag.com/article/backup-recovery/backup-basics-for-sql-server-analysis-services
12	OPENDATASOURCE	http://msdn.microsoft.com/en-us/library/ms179856.aspx
13	The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statement	http://blogs.technet.com/b/wardpond/archive/2005/08/01/the-openrowset-trick-accessing-stored-procedure-output-in-a-select-statement.aspx
14	OPENQUERY	http://msdn.microsoft.com/en-us/library/ms190312.aspx
15	UCP : Utility Control Point	http://msdn.microsoft.com/en-us/library/ee210548.aspx
16	UCP : Configuration Demo	http://www.mssqltips.com/sqlservertip/2114/introduction-to-utility-control-points-in-sql-server-2008-r2/
17	Using sp_executesql	http://msdn.microsoft.com/en-us/library/ms175170.aspx
18	Using Multiple Active Result Sets (MARS)	http://msdn.microsoft.com/en-us/library/ms131686.aspx
19	SQL Injections	http://msdn.microsoft.com/en-us/library/ms161953.aspx
20	QUOTENAME	http://msdn.microsoft.com/en-us/library/ms176114.aspx
21	Using Session Context Information	http://msdn.microsoft.com/en-us/library/ms189252.aspx
22	Managing Long-Running Transactions	http://msdn.microsoft.com/en-us/library/ms366331.aspx
23	Moving System Databases	http://msdn.microsoft.com/en-us/library/ms345408.aspx
24	Rollbacks and Commits in Stored Procedures and Triggers	http://msdn.microsoft.com/en-us/library/ms187844.aspx
25	Factors That Can Delay Log Truncation	http://msdn.microsoft.com/en-us/library/ms345414.aspx
26	Checkpoints and the Active Portion of the Log	http://msdn.microsoft.com/en-us/library/ms189573.aspx
27	Deferred Transactions	http://msdn.microsoft.com/en-us/library/ms188290.aspx
28	How to Rebuild System Databases in SQL Server 2008	http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx
29	Resource Governor and MAXDOP, Parallel plan generation	http://blogs.msdn.com/b/psssql/archive/2011/02/03/resource-governor-and-maxdop-parallel-plan-generation.aspx
30	SQL Server Service is not starting – what do I do?	http://blogs.msdn.com/b/sqlserverfaq/archive/2011/05/11/inf-hey-my-sql-server-service-is-not-starting-what-do-i-do.aspx
31	An Overview of Troubleshooting Memory Issues	http://blogs.technet.com/b/askperf/archive/2008/01/25/an-overview-of-troubleshooting-memory-issues.aspx
32	How to Rebuild System Databases in SQL Server 2008	http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx
33	Troubleshooting stored procedure recompilation	http://support.microsoft.com/kb/243586
34	How to identify the cause of recompilation in an SP:Recompile event	http://support.microsoft.com/kb/308737/EN-US
35	Tracking database recovery progress using information from DMV	http://blogs.msdn.com/b/psssql/archive/2010/12/29/tracking-database-recovery-progress-using-information-from-dmv.aspx
36	Case of using filtered statistics	http://blogs.msdn.com/b/psssql/archive/2010/09/28/case-of-using-filtered-statistics.aspx
37	Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)…	http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx
38	Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates…..	http://blogs.msdn.com/b/psssql/archive/2010/08/24/why-use-sql-server-2008-r2-bpa-case-1-missing-updates.aspx
39	Internals of SQL Cluster Setup and Troubleshooting Tips	http://www.serverwatch.com/tutorials/article.php/3784191/Internals-of-SQL-Cluster-Setup-and-Troubleshooting-Tips.htm
40	Installing SQL Integration Services after SQL Cluster Setup has Completed	http://blogs.msdn.com/b/psssql/archive/2010/07/29/installing-sql-integration-services-after-sql-cluster-setup-has-completed.aspx
41	Why is my SQL Clustered Instance changing authentication modes?	http://blogs.msdn.com/b/psssql/archive/2010/07/09/why-is-my-sql-clustered-instance-changing-authentication-modes.aspx
42	Failover Cluster Step-by-Step Guide: Configuring the Quorum in a Failover Cluster	http://technet.microsoft.com/en-us/library/cc770620(WS.10).aspx
43	SQL Server 2008 Failover Clustering	http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx
44	How to configure volume mount points on a Microsoft Cluster Server	http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280297
45	How to create your first report in Microsoft SQL Server Reporting Services?	http://www.sqlservercentral.com/columnists/bknight/designingyourfirstreportinreportingservices.asp
46	Adding Conditional Formatting into Reporting Services	http://www.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/
47	Security permissions that are associated with the existing roles may reset when you use the Analysis Services Deployment Wizard to deploy a SQL Server 2005 Analysis Services project	http://support.microsoft.com/kb/933836
48	SSIS SSAS SSRS Video Tutorials	http://siddhumehta.blogspot.com/2009/07/few-more-ssis-ssas-and-ssrs-video.html
49	SQL BI DEV Blog	http://sql-bi-dev.blogspot.com/
50	How to Create an Analysis Services Cube	http://www.sqlcoffee.com/AnalysisServices_0001.htm
51	SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial	http://www.accelebrate.com/sql_training/ssas_tutorial.htm
52	Microsoft Certified Master Reading List	http://sqlserverpedia.com/wiki/Microsoft_Certified_Master_Reading_List
53	RAID Levels and SQL Server	http://msdn.microsoft.com/en-us/library/ms190764.aspx
54	Disaster recovery 101: backing up the tail of the log	http://www.sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-backing-up-the-tail-of-the-log.aspx
55	Index Black Ops Series	http://sqlserverpedia.com/blog/sql-server-2005/index-black-ops-part-5-%E2%80%93-page-splits/
56	Advanced BACKUP and RESTORE Options	http://www.sqlmag.com/content1/topic/advanced-backup-and-restore-options-129834/catpath/database-backup-and-recovery
57	Tuning the Performance of Backup Compression in SQL Server 2008	http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
58	Suspect_pages	http://msdn.microsoft.com/en-us/library/ms174425.aspx
59	Performing Page Restores	http://msdn.microsoft.com/en-us/library/ms175168.aspx
60	How It Works: What is Restore/Backup Doing?	http://blogs.msdn.com/b/psssql/archive/2008/01/23/how-it-works-what-is-restore-backup-doing.aspx
61	Date Formats	http://www.sql-server-helper.com/tips/date-formats.aspx
62	How to format datetime & date in Sql Server 2005	http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/