TechDays Data Platform Track Resources
Session 1 - Take Control of the Enterprise:
Effective Solutions for Governing your Environment with Policy-Based Management
Enterprise Policy Management Framework
– https://www.codeplex.com/EPMFramework
Policy Based Management Blog
– https://blogs.msdn.com/sqlpbm/default.aspx
Lara Rubbelke’s Blog
– https://sqlblog.com/blogs/lara_rubbelke/default.aspx
David E. Myers’ Blog:
To learn more about the PowerShell scripting Language
– https://powershell/pages/GettingStartedWithWindowsPowerShell.aspx
Session 2 - Reducing Storage Cost in SQL Server 2008
Session 3 - Beyond Relational SQL Server 2008: Managing unstructured and semistructured Data
Session 4 - Microsoft SQL Server Essential Database Maintenance
8 Steps to Better Transaction Log Throughput
Blog Post on How to Tell if the IO Subsystem is Causing Corruption - https://www.sqlskills.com/blogs/paul/2007/09/12/HowToTellIfTheIOSubsystemIsCausingCorruptions.aspx
CHECKDB Blog Post Series - https://www.sqlskills.com/blogs/paul/CategoryView,category,CHECKDB%2BFrom%2BEvery%2BAngle.aspx
Session 5 - Protecting Your Data - Security from the Application to the Database
Microsoft Source Code Analyzer for SQL injection July CTP - https://www.microsoft.com/downloads/details.aspx?FamilyId=58A7C46E-A599-4FCB-9AB4-A4334146B6BA&displaylang=en
SQL Server Security Blog - https://blogs.msdn.com/sqlsecurity
SQL injection (BOL) - https://msdn.microsoft.com/en-us/library/ms161953.aspx
Preventing SQL injection in ASP - https://msdn.microsoft.com/en-us/library/cc676512.aspx
Giving SQL injection the respect it deserves - https://blogs.msdn.com/sdl/archive/2008/05/15/giving-sql-injection-the-respect-it-deserves.aspx
Raul Garcia’s blog - https://blogs.msdn.com/raulga/archive/tags/sql+injection/default.aspx
BOL - Security Considerations for Databases and Database Applications - https://msdn.microsoft.com/en-us/library/ms187648.aspx
Session 6 - Reporting Services Integration with SharePoint
Reza Alirezaei’s Blog - https://blogs.devhorizon.com/reza
Session 7 - Applying Workload Resource Governance on SQL 2008
Windows Server Resource Manager
https://www.microsoft.com/windowsserver2003/techinfo/overview/wsrmfastfacts.mspx
Soft-NUMA
Soft-NUMA at Slava Oks’s Weblog at https://blogs.msdn.com/slavao/
SQL 2008 Resource Governor
Books Online
https://msdn2.microsoft.com/en-us/library/bb933866(SQL.100).aspx
Blog(s)
https://blogs.technet.com/sqlos/
https://blogs.msdn.com/psssql/archive/2008/01/10/sql-server-2008-resource-governor-questions.aspx
Session 8 - Performance Monitoring and Tuning in SQL Server 2008
SQL Server Manageability Team Blog (Bill Ramos)
https://blogs.msdn.com/sqlrem/archive/2008/01/17/performance-studio-for-sql-server-2008-revealed.aspx
Bill Ramos’ Webcast
https://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032349947&CountryCode=US
Jason Massie's Blog
https://sqlblogcasts.com/blogs/jasonmassie/archive/2008/02/15/sql-server-2008-performance-data-collection-in-5-minutes.aspx
Rob's SQL Server Blog
https://blogs.technet.com/rob/archive/2008/06/20/sql-server-2008-performance-studio.aspx
Paul Randal on Extended Events
https://www.sqlskills.com/BLOGS/PAUL/post/TechNet-Magazine-feature-article-on-Advanced-Troubleshooting-with-Extended-Events.aspx
https://technet.microsoft.com/en-us/magazine/dd314391.aspx (SQL Server magazine, Jan 2009)
Kevin Kline (Refers to Jonathan Kehayias’ excellent Extended Events tool)
https://www.sqlmag.com/Article/ArticleID/100466/sql_server_100466.html