DBA Useful Resources
Websites for a DBA
• SQLskill.com: http://www.sqlskills.com/
• SQL Server Central: http://www.sqlservercentral.com/
• SQL Server TechNet: http://technet.microsoft.com/en-us/sqlserver/default
• 380PASS: http://380pass.org/
• QCPASS: http://qcpass.sqlpass.org/
• PASS Professional Association for SQL Server: http://www.sqlpass.org/
• SQL Server Pro: http://www.sqlmag.com/
• MSDN SQL Server Forums: http://social.msdn.microsoft.com/Forums/en/category/sqlserver
• Mssqltips.com: http://www.mssqltips.com/
• Simple Talk: http://www.simple-talk.com/sql/
Videos
SQL Skills: http://www.sqlskills.com/T_MCMVideos.asp
Microsoft: http://technet.microsoft.com/en-us/sqlserver/ff977043
Blogs
• Aaron Bertrand: http://sqlblog.com/blogs/aaron_bertrand/
• Brad M. McGehee: http://www.bradmcgehee.com/
• Brent Ozar: http://www.brentozar.com/
• Buck Woody: http://blogs.msdn.com/b/buckwoody/
• Chad Boyd: http://www.mssqltips.com/author.asp?authorid=2
• Erin Stellato: http://erinstellato.com/
• Greg Low: http://sqlblog.com/blogs/greg_low/
• Jes Borland: http://sqlblog.com/blogs/greg_low/
• Jonathan Kehayias: http://sqlblog.com/blogs/jonathan_kehayias/
• Kevin Kleine: http://sqlblog.com/blogs/kevin_kline/
• Kimberly L. Tripp: http://www.sqlskills.com/blogs/kimberly/
• Ola Hallengren : http://ola.hallengren.com/
• Paul S. Randal: http://www.sqlskills.com/blogs/paul/
• SQLSkills.com: http://www.sqlskills.com/
• Tibor Karaszi: http://sqlblog.com/blogs/tibor_karaszi/default.aspx
• @SQLhelp
• #SQLHelp
• Brent Ozar: @BrentO
• Buck Woody: @buckwoody
• Erin Stellato: @erinstellato
• Jason Strate: @StrateSQL
• Jes Borland: @grrl_geek
• Kim Tripp: @KimberlyLTripp
• Paul Randal: @PaulRandal
Random
http://talk-it.biz/sql-server-2008-development
http://talk-it.biz/sql-server-2008-administration
http://msdn.microsoft.com/en-us/library/aa178138%28v=sql.80%29.aspx
http://www.sqlservercentral.com/stairway/
Interview Questions
http://www.sqlserver-training.com/250-sql-queries-interview-question-answers/-
http://sqlserverquestions.mssqltips.com/questionlist.asp?goback=%2Egde_2320891_member_150613894
http://blog.sqlauthority.com/sql-server-interview-questions-and-answers/
http://www.mssqltips.com/sql-server-tip-category/46/interview-questions-dba/
SQL Server Products and Tools listing
http://www.mssqltips.com/productlist.asp?goback=%2Egde_2320891_member_151297048
Whitepapers
http://www.mssqltips.com/whitepaperlist.asp?goback=%2Egde_2320891_member_143468027
eBooks/Books
http://www.bradmcgehee.com/books/
http://sharebookfree.com/category/computers/database/
http://www.bradmcgehee.com/2012/05/favorite-dba-books/
http://www.red-gate.com/community/books/index#sqldba
Free Tools/Monitoring Solutions
*SQL Server takeover script: http://www.brentozar.com/blitz/
*SSMS useful tool pack (a must have): http://www.simple-talk.com/sql/sql-tools/ssms-tools-pack-2.0/
*Let Powershell do Inventory of SQL Servers: http://www.simple-talk.com/sql/database-administration/let-powershell-do-an-inventory-of-your-servers/
*Microsoft Assessment and Planning Toolkit (MAPS): http://technet.microsoft.com/en-us/library/bb977556.aspx
*SQL Server tracing (automated): http://www.simple-talk.com/sql/database-administration/sql-server-tracing-an-automated-and-centralized-solution/
*CMS and MSM: http://www.simple-talk.com/sql/backup-and-recovery/centralized-management-tips-for-managing-backups-on-multiple-servers/
*Use SSIS to monitor SQL Server: http://www.simple-talk.com/sql/ssis/using-ssis-to-monitor-sql-server-databases-/
Source of this article:
- http://www.linkedin.com/groups/Can-someone-suggest-me-some-72017.S.133775571?view=&srchtype=discussedNews&gid=72017&item=133775571&type=member&trk=eml-anet_dig-b_pd-ttl-cn&ut=0ZqmU95VPTklo1
- http://www.linkedin.com/groups/I-am-Beginner-in-SQL-66097.S.139590360?view=&srchtype=discussedNews&gid=66097&item=139590360&type=member&trk=eml-anet_dig-b_pd-ttl-cn&ut=0uF0E8nN42kBo1
- www.google.com
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5