Blog Post

Free SQL Server Learning Resources - Jan'2013

 Database Normalization (some useful links)

http://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html
http://www.guru99.com/database-normalization.html
http://www.aliencoders.com/content/basics-normalization-examples

SQL Server Programming Fundamentals (some useful links)
http://www.blackwasp.co.uk/SQLProgrammingFundamentals.aspx
http://beginner-sql-tutorial.com/sql-select-statement.htm

SQL Server Database Administration

DBA Responsibilities
http://www.bradmcgehee.com/2011/12/the-day-to-day-tasks-of-the-average-dba/

DBA Best Practices
http://www.bradmcgehee.com/presentations/

Free eBooks (to begin with)

How to become an Exceptional DBA by Brad McGehee
http://www.sqlservercentral.com/articles/books/67441/

Troubleshooting SQL Server: A Guide for the Accidental DBA
http://www.red-gate.com/community/books/accidental-dba

Most likely you will end up reading most of the invaluable free ebooks here
http://www.sqlservercentral.com/books/

 

 

Technet Resources
http://technet.microsoft.com/hi-in/library/bb545450(en-us).aspx
http://technet.microsoft.com/hi-in/magazine/ff628330(en-us).aspx?sdmr=sql&sdmi=topics
http://technet.microsoft.com/en-us/magazine/bb978517.aspx

MCM Resources
http://www.microsoft.com/learning/en/us/certification/master-sql.aspx (Section 7.6 and 7.7)
http://www.sqlskills.com/mcm.asp

http://sqlserverpedia.com/wiki/Microsoft_Certified_Master_Reading_List

SQLServerPro
http://www.sqlmag.com/authors?fl=A

SQL Skills
http://www.sqlskills.com/Resources.asp
http://www.sqlskills.com/blogs/paul/commonsqlservermyths.pdf

Brad M McGehee
http://www.bradmcgehee.com/presentations/

Brad's checklist collections
http://www.bradmcgehee.com/2010/06/sql-server-operating-system-checklist/
http://www.bradmcgehee.com/2010/06/sql-server-hardware-checklist/
http://www.bradmcgehee.com/2010/08/sql-server-monitoring-checklist-2/
http://www.bradmcgehee.com/2010/10/sql-server-database-maintenance-checklist/
http://www.bradmcgehee.com/2010/06/sql-server-instance-checklist/

Brent Ozar
http://www.brentozar.com/sql-server-training-videos/

SQLServerCentral
http://www.sqlservercentral.com/Books/
http://www.sqlservercentral.com/stairway/

Glenn Berry's DMV Collection

SQL Server 2005:
http://sqlserverperformance.wordpress.com/category/sql-server-2005/

SQL Server 2008:
http://sqlserverperformance.wordpress.com/category/sql-server-2008/

SQL Server 2008 R2:
http://sqlserverperformance.wordpress.com/category/sql-server-2008-r2/

SQL Server 2012:
http://sqlserverperformance.wordpress.com/category/sql-server-2012/

SQLPASS Recordings
http://www.sqlpass.org
http://www.sqlpass.org/LearningCenter/SessionRecordings.aspx
http://www.sqlpass.org/LearningCenter/SessionRecordings/24HoursSpring2012.aspx
http://www.sqlpass.org/LearningCenter/SessionRecordings/24HoursFall2012.aspx

Channel9
http://channel9.msdn.com/Tags/sql+server+2008

MCM Readiness Videos
http://technet.microsoft.com/en-us/sqlserver/ff977043

Microsoft Webcasts/VirtualLabs
http://events.microsoft.com

Top SQL Server Bloggers Ranking (gateway to diamond mine)
http://thomaslarock.com/rankings/

sqlblog.com (Aaron Bertrand)
http://sqlblog.com/blogs/aaron_bertrand/archive/2010/10/26/useful-free-resources-for-sql-server.aspx

sqlcrunch.com
http://www.sqlcrunch.com/Default.aspx?tabid=56

PragmaticWorks past webinars
http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/PastWebinars.aspx

mssqltips.com (Whitepapers, Tutorials and Webcasts)

http://www.mssqltips.com/whitepaperlist.asp
http://www.mssqltips.com/tutoriallist.asp
http://www.mssqltips.com/webcastlist.asp

SSIS Step By Step Tutorials

http://www.jasonstrate.com/wp-content/uploads/downloads/2012/01/31-Days-of-SSIS.pdf

http://karthikeyananbarasan.files.wordpress.com/2011/10/free-ebook-sql-server-integration-services-ssis-step-by-step-version-2-0.pdf

 

Miscellaneous (Youtube videos 20+ minutes)
http://www.youtube.com/results?search_query=sql+server%2C+long&lclk=long

 

Happy reading!!Interested to be in-touch with great learning resources?

Like my facebook page: https://www.facebook.com/LivingForSqlServer


Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating