Cristian's BlogTo SQL or To SQL - There's no Question!
http://sqlserver.ro/blogs/cristians_blog/atom.aspxCommunity Server2010-01-20T12:25:00ZMicrosoft MVP Virtual Conferencehttp://sqlserver.ro/blogs/cristians_blog/archive/2015/05/11/microsoft-mvp-virtual-conference.aspx2015-05-11T16:36:00Z2015-05-11T16:36:00Z<p><b>Where?</b> A:online</p>
<p><b>When?</b> A:May 14th & 15th</p>
<p><b>What?</b> A: The MVP Virtual Conference will showcase 95 sessions of content for IT Pros, Developers and Consumer experts designed to help you navigate life in a mobile-first, cloud-first world. Microsoft’s Corporate Vice President of Developer Platform, <a href="http://blogs.msdn.com/b/stevengu/archive/2015/04/02/announcing-the-mvp-virtual-conference.aspx">Steve Guggenheimer</a>, will be on hand to deliver the opening Key Note Address. </p>
<p><b>What's In It For Me?</b> A: The conference will have 5 tracks, IT Pro English, Dev English, Consumer English, Portuguese mixed sessions & Spanish mixed sessions, there is something for everyone! Learn from the best and brightest MVPs in the tech world today and develop some great skills!</p>
<p><b>How can I attend?</b> A: Register <a href="http://mvp.microsoft.com/en-us/virtualconference.aspx">here</a></p>
<p><img src="http://oi60.tinypic.com/35ivnro.jpg" border="0"></p><img src="http://sqlserver.ro/aggbug.aspx?PostID=9687" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxROSQL Meeting 28 Apr 2015http://sqlserver.ro/blogs/cristians_blog/archive/2015/04/27/rosql-meeting-28-apr-2015.aspx2015-04-27T08:29:00Z2015-04-27T08:29:00Z<p>
<b>ROSQL</b> invites you to a special event dedicated to Microsoft SQL Server on 28th of April 2015 @ Microsoft Romania.
</p>
<p>
For registration please use the following URL: <a href="http://bit.ly/rosql150428"> http://bit.ly/rosql150428</a>
</p>
<p>
Agenda
</p>
<p>
17:30 - 18:00 Welcome and registration</p>
<p>
18:00 - 18:30 Free Tools for Microsoft SQL Server, Cristian Lefter, SQL Server MVP
</p>
<p>
18:30 - 18:50 SQL Database Dynamic Data Masking, Cristian Lefter, SQL Server MVP
</p>
<p>
18:50 - 19:00 Break
</p>
<p>
19:00 - 20:00 Execution Plan Caching and Reuse, Alexandru Miron Gatej, .NET Developer at Ubisoft
</p>
<p>
Additional details on the event's Facebook page
<a href="http://on.fb.me/1IqaRI7">http://on.fb.me/1IqaRI7</a>
</p>
<p>
<img src="http://imageshack.com/a/img537/350/khZ749.jpg" border="0">
</p><img src="http://sqlserver.ro/aggbug.aspx?PostID=9686" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxROSQL Meeting with Peter Myers 5th of March 2015http://sqlserver.ro/blogs/cristians_blog/archive/2015/02/16/rosql-meeting-with-peter-myers-5th-of-march-2015.aspx2015-02-16T18:43:00Z2015-02-16T18:43:00Z<p>
<b>ROSQL</b> invites you to a special meeting dedicated to SQL Server, on 5th of March 2015, starting at 17:30, at Microsoft Romania.
</p>
<p>
For registration please use the following URL: <a href="http://1drv.ms/17auGq1"> http://1drv.ms/17auGq1</a>
</p>
<p>
Agenda
</p>
<p>
17:30- 18:00 Microsoft's Data Platform lately - Cristian Lefter, SQL Server MVP, sqlserver.ro
</p>
<p>
18:10 - 19:30 End-to-End SQL Server Master Data Services - Peter Myers, SQL Server MVP, Director - Training and Mentoring at BizData
</p>
<p>
About our guest and his session
</p>
<p>
Peter Myers has worked with Microsoft database and development products since 1997.
<br>
Today, he specializes in all Microsoft BI products and provides mentoring, technical training, and training course content authoring for SQL Server, Office, and SharePoint.
<br>
Peter has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE and MCT certifications. He lives in Melbourne, Australia and has been a SQL Server MVP since 2007.
<br>
End-to-End SQL Server Master Data Services
<br>
This presentation describes how SQL Server Master Data Services can be used to implement Master Data Management (MDM). It introduces the discipline of MDM and maps common processes to the feature set of Master Data Services.
<br>
Topics include defining models, entities, attributes and hierarchies, to store and manage master data. Additionally, administrative tasks including business rules to validate data, the import and export of master data, model versioning, and permission management will be described. The two Microsoft user interfaces (the Master Data Manager web application, and the Excel add-in) will be covered, in addition to T-SQL scripting opportunities to automate master data processes.
<br>
This session will be of interest to data stewards, ETL developers and ETL administrators to appreciate what SQL Server 2012 (or 2014) Master Data Services can achieve.
</p>
<p>
<a href="http://sqlserver.ro/photos/cristianblog/images/9676/original.aspx">
<img border=0 src="http://sqlserver.ro/photos/cristianblog/images/9676/500x375.aspx">
</a>
</p><img src="http://sqlserver.ro/aggbug.aspx?PostID=9675" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxFiltering forum usershttp://sqlserver.ro/blogs/cristians_blog/archive/2013/06/04/filtering-forum-users.aspx2013-06-04T09:24:00Z2013-06-04T09:24:00ZIf you run an online community you will probably encounter this challenge: how to filter regular users from spammers?
An asnwer can be found here: http://www.stopforumspam.com/search
You can search your new users here and if and also you can report spam data.
I find it very useful and very accurate.<img src="http://sqlserver.ro/aggbug.aspx?PostID=9538" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxQuestion: How can I see programmatically the rights on a stored procedure?http://sqlserver.ro/blogs/cristians_blog/archive/2013/01/03/question-how-can-i-see-programmatically-the-rights-on-a-stored-procedure.aspx2013-01-03T11:13:00Z2013-01-03T11:13:00ZStarting with SQL Server 2005, the sys.fn_my_permissions function can be used.<br>It has a quite simple syntax: <font face="Courier New">fn_my_permissions ( securable , 'securable_class')</font><br><br>To answer the question, the code would be:<br><table style="background-color:#f2f2f2;border:solid 1px #e5e5e5;" cellpadding="0" cellspacing="0"><tr style="vertical-align:top;line-height:normal;"><td style="width:40px;text-align:right;"><pre style="font-family:courier new;font-size:11px;color:gray;margin:0px;padding:2px;border-right:solid 1px #e7e7e7;">1<br>2<br>3<br> </pre></td><td><pre style="margin:0px;padding:2px;padding-left:8px;"><span style="color:Black;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;"><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">USE</span> MyDatabase;<br>GO<br><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">SELECT</span> * <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">FROM</span> fn_my_permissions (<span style="color:Red;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'myStoredProcedure'</span>, <span style="color:Red;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'OBJECT'</span>);</span></pre></td></tr></table><br><br><img src="http://sqlserver.ro/aggbug.aspx?PostID=9499" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSQL Server Certification - Beyond MCSAhttp://sqlserver.ro/blogs/cristians_blog/archive/2012/08/10/sql-server-certification-beyond-mcsa.aspx2012-08-10T07:08:00Z2012-08-10T07:08:00ZWith Microsoft Certification recently redesigned, the usual certification path for an SQL Server professional would be the following:
<br><ol>
<li><font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx">MCSA (Microsoft Certified Solutions Associate) SQL Server 2008 </a></font><br>It requires two exams: <a href="http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-432&locale=en-us">Exam 70-432 - Microsoft SQL Server 2008, Implementation and Maintenance</a> + <a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx">Exam 70-448 - Microsoft SQL Server 2008, Business Intelligence Development and Maintenance</a><br><br></li>
<li><font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx">MCSA (Microsoft Certified Solutions Associate) SQL Server 2012 </a></font><br>It requires three exams: <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-461">Exam 70-461 - Querying Microsoft SQL Server 2012</a> +<a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-462"> Exam 70-462 - Administering Microsoft SQL Server 2012 Databases</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-463">Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012</a><br>There is also an upgrade path for holders of <a href="http://www.microsoft.com/learning/en/us/certification/mcts.aspx#tab2">MCTS - SQL Server 2008 certification</a>: <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-457">Exam 70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-458">Exam 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2</a> <br><br></li>
<li><font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-data-platform.aspx">MCSE (Microsoft Certified Solutions Expert) - Data Platform - SQL Server 2012 </a></font><br>It requires <a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx">MCSA (Microsoft Certified Solutions Associate) SQL Server 2012</a> and two additional exams: <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-464"><br>Exam 70-464 - Developing Microsoft SQL Server 2012 Databases</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-465">Exam 70-465 - Designing Database Solutions for Microsoft SQL Server 2012</a><a href="http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2"> </a><br>There is an upgrade path from <a href="http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2">MCITP - Database Administrator 2008</a> or <a>MCITP - Database Developer 2008</a>: <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-457">Exam 70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-458">Exam 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-459">Exam 70-459 - Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform </a><br>
<br>
</li>
<li><a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx"><font size="4"></font></a><font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-data-platform.aspx">MCSE (Microsoft Certified Solutions Expert) - Business Intelligence - SQL Server 2012 </a></font><br>It requires <a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx">MCSA (Microsoft Certified Solutions Associate) SQL Server 2012</a> and two additional exams: <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-466"><br>Exam 70-466 - Implementing Data Models and Reports with Microsoft SQL Server 2012</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-467">Exam 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012</a><br>There is an upgrade path from <a href="http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2">MCITP - Business Intelligence Developer 2008</a>: <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-457">Exam 70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-458">Exam 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2</a> + <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-459">Exam 70-460 - Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence </a><br><br></li></ol>
So, what happens after MCTS, MCITP, MCSA and MSCE?
On the SQL Server 2008 track there is the advanced certification <font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/master-sql.aspx">Microsoft Certified Master: Microsoft SQL Server 2008</a></font> requiring two exams:<br><ul><li><a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=88-970&Locale=en-us">Exam 88-970 - SQL Server 2008 Microsoft Certified Master: Knowledge Exam<br></a> (priced at
<b>US$500</b>)</li><li><a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=88-971&Locale=en-us">Exam 88-971 - SQL Server 2008 Microsoft Certified Master: Lab Exam</a> (priced at <b>US$2,000</b> )<br></li></ul><p>To prepare for the MCM certification you can use free documentation resources provided by Microsoft or you can enroll in the <b>SQL Server 2008 Microsoft Certified Master (MCM) Accelerated Exam Preparation Program</b> (priced at
<b>US$2,900</b>).</p><p>Once you've obtained your MCM you can go further by applying to the <font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/architect.aspx#tab3">Microsoft Certified Architect Program</a></font> for SQL Server 2008. The application fee is
<b>US$125</b> and if you are accepted into the program, the fee to take the MCA Board Exam is <b>US$7,500</b>.</p><p>Similar to the MCM certification - there is the <font size="4"><a href="http://www.microsoft.com/learning/en/us/certification/ssas-maestros.aspx#tab1">SQL Server Analysis Services (SSAS) Maestro program</a></font>, dedicated as the names says to the Analysis Services 2008 R2. The program's training is priced at <b>€7000 + VAT</b>.</p><p>Last but not least - for SQL Server 2012 - Microsoft re-branded the MCM certification as <a href="http://www.microsoft.com/learning/en/us/certification/mcsm.aspx"><font size="4">Microsoft Certified Solutions Master (MCSM)</font></a>. On the Microsoft Learning site there is a note "<i><b>The first two MCSM certifications will be for <a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx">SQL Server 2012</a> tracks.</b></i>"<br><br>Good luck! <br></p><img src="http://sqlserver.ro/aggbug.aspx?PostID=9354" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSQL Server 2012 Update for Developers Training Workshophttp://sqlserver.ro/blogs/cristians_blog/archive/2012/04/30/sql-server-2012-update-for-developers-training-workshop.aspx2012-04-30T18:31:00Z2012-04-30T18:31:00ZThis article: <a href="http://bit.ly/sql2012ro">http://bit.ly/sql2012ro</a><br>Workshop Dates:<br>2,3 May 2012<br>31 May 2012, 1 June 2012<br><br>Resources:<br><a href="http://social.technet.microsoft.com/wiki/contents/articles/6967.sql-server-2012-early-adoption-cook-book-en-us.aspx">SQL Server 2012 Early Adoption Cook Book</a> <a href="http://bit.ly/sql2012cookbook">bit.ly/sql2012cookbook</a><br><a href="http://www.microsoft.com/en-us/download/details.aspx?id=347">Product Documentation for Microsoft SQL Server 2012 (Books Online)</a><br><a href="http://msdn.microsoft.com/data/tools">Microsoft SQL Server Data Tools</a><br><a href="http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx">SQL Server Virtual Labs</a><br><a href="http://www.microsoft.com/en-us/download/details.aspx?id=29049">BI Image X: SQL 2012 RC0</a> (<a href="http://www.microsoft.com/en-us/download/details.aspx?id=28802">multiple files</a>)<br><a href="http://technet.microsoft.com/en-us/hh965401">Technet SQL Server 2012: The New World of Data</a><br><a href="https://www.microsoftvirtualacademy.com/tracks/cloud-on-your-terms-with-microsoft-sql-server-2012-scale-on-demand">MVA - Cloud on your terms with Microsoft SQL server 2012: Scale on demand</a><br><a href="http://msdn.microsoft.com/en-us/sqlserver/hh323832">Data Quality Services "How Do I?" Videos</a><br><a href="http://technet.microsoft.com/library/hh231699%28SQL.110%29.aspx">Tutorials for SQL Server 2012</a><br><a href="http://www.google.com/url?sa=t&rct=j&q=microsoft%C2%AE%20sql%20server%C2%AE%202012%20best%20practices%20analyzer&source=web&cd=2&ved=0CEcQFjAB&url=http%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fen%2Fdetails.aspx%3Fid%3D29302&ei=3t2eT52_IoSk4gTp6OypDg&usg=AFQjCNHLQ0BSOsIcIA68PVtZY3qd65T0Bw&cad=rja">Microsoft® SQL Server® 2012 Best Practices Analyzer</a><br><a href="http://technet.microsoft.com/en-us/edge/ff832960?query=1&Category=SQL%20Server%202012">TechNet Edge SQL Server 2012 Videos</a><br><a href="http://go.microsoft.com/?linkid=9805898">SQL Server AlwaysOn Solutions Guide</a><br><br>Articles:<br><a href="http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html">Comparison of SQL Server Compact, SQL Server Express 2012 and LocalDB</a><br><a href="http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx">SQL Express v LocalDB v SQL Compact Edition</a><br><img src="http://sqlserver.ro/aggbug.aspx?PostID=9230" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxMicrosoft Security Bulletin MS11-049http://sqlserver.ro/blogs/cristians_blog/archive/2011/06/15/microsoft-security-bulletin-ms11-049.aspx2011-06-15T14:57:00Z2011-06-15T14:57:00Z<p class="subtitle"><b><font face="Arial">Vulnerability in the Microsoft XML Editor Could Allow Information Disclosure</font></b></p><p class="subtitle">It's been a while since SQL Server security needed a patch and today it just happened. A vulnerability in
Microsoft XML Editor allows an attacker to obtain sensitive information by using a custom Web Service Discovery
(.disco) file. Read more about this vulnerability here<br></p><ul><li><font face="Arial"><a href="http://www.microsoft.com/technet/security/bulletin/MS11-049.mspx">Microsoft Security Bulletin MS11-049</a></font></li><li><font face="Arial"><a href="http://www.microsoft.com/downloads/en/details.aspx?familyid=80e98567-1b28-49b1-a646-579f8c115a41&displaylang=en">Security Update for SQL Server 2008 R2 RTM (KB2494088) </a><br></font></li></ul><p class="subtitle"><font face="Arial"><br></font></p><img src="http://sqlserver.ro/aggbug.aspx?PostID=8782" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxDo you want to test Windows Azure and the credit card condition stops youhttp://sqlserver.ro/blogs/cristians_blog/archive/2011/04/02/do-you-want-to-test-windows-azure-and-the-credit-card-condition-stops-you.aspx2011-04-02T12:00:00Z2011-04-02T12:00:00Z<font size="4"><font size="3">Do you want to test Windows Azure and the credit card condition stops you?<br><br></font><b>Not anymore! </b></font><br><br><font size="3">You can test Windows Azure without having a credit card using a new promotion: <br><a href="http://windowsazurepass.com/">http://windowsazurepass.com/</a></font><br><br>There is a small catch - you need a code to use this promotion and the code can be obtained simply by writing an email or message to me.<br><img src="http://sqlserver.ro/aggbug.aspx?PostID=8680" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSave a treehttp://sqlserver.ro/blogs/cristians_blog/archive/2010/05/15/save-a-tree.aspx2010-05-15T13:52:00Z2010-05-15T13:52:00Z<b>Did you know?</b><br><ul><li>A ton of recycled paper is equivalent to recycling a newspaper and two white sheets daily for one year.</li><li>A ton of recycled paper saves 20 trees, 3.800 kWh, 32.000L of water and prevents 27 kg of pollutants from being released into atmosphere.</li></ul><br><b>So why we recycle paper?</b><br><br><ul><li>To reduce deforestation, and this way there will be fewer: landslides, climate change, floods, habitat and biodiversity destruction and destruction of recreation areas;</li><li>To reduce the imports of wood</li><li>To reduce water consumption by up to 60%;</li><li>To reduce energy consumption by up to 40%;</li><li>To reduce air pollution by up to 70%;</li><li>To diminish pollution by up to 35%;</li><li>To decreases the amount of garbage deposited in landfills or incinerators.</li></ul><br>Personal story: I lost 60kg of extra weight today :) - I mean by that recycling 60 kg of paper. (
For Bucharest you can use <a href="http://www.depozitmaculatura.ro/centru-maculatura-bucuresti.html">"Depozitul de maculatura"</a>.)<br><br><br>
<a href="http://tweetphoto.com/22513784" title=""><img src="http://lhvatq.blu.livefilestore.com/y1pzCKT9-ytIPDdfpqnGLeM3vfRs3wuJMLv_Yo7YlzGcqOGDRTu-WpKoreZY-hhxMEiJsUNg5wlBkMgLj6AepA4sWzryi0IHYoS/ReclycledPaper.jpg"><br></a>
<br><br><img src="http://sqlserver.ro/aggbug.aspx?PostID=8285" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSQL Server 2008 R2 resources (reloaded)http://sqlserver.ro/blogs/cristians_blog/archive/2010/04/22/sql-server-2008-r2-resources-reloaded.aspx2010-04-22T07:13:00Z2010-04-22T07:13:00Z<img src="http://sqlserver.ro/photos/cristianblog/images/8187/original.aspx" border="0">
<br>
<br>
The SQL Server 2008 R2 RTM is here and with it a lot of new resources. <br><ol><li>Test Drive<br>
</li>
<ul><li><a href="http://www.previewsqlserver.com/">SQL Server 2008 R2 Hosted Trial: Free Virtual Labs</a></li><li><a href="http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx">SQL Server 2008 R2 Trial</a></li><li><a href="http://www.microsoft.com/downloads/info.aspx?na=45&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=fe0c6a31-5ad6-4eea-a865-73bbe2608bd1&u=details.aspx%3ffamilyid%3d020EE0D5-BCE4-4A45-9D64-B0C49C8831E5%26displaylang%3den">Microsoft® SQL Server® 2008 R2 November Community Technology Preview Feature Pack</a></li><li><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca">Microsoft® SQL Server® 2008 R2 - PowerPivot for Microsoft® Excel 2010 - November Community Technology Preview</a></li><li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en">Microsoft SQL Server JDBC Driver 3.0</a><br></li></ul><li>Webcasts, Videos and events<br></li><ul><li><a href="http://www.sqlserverlaunch.com">SQL Server 2008 R2 Virtual Tour</a></li><li><a href="https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032441804&EventCategory=5&culture=en-US&CountryCode=US">TechNet Webcast: How Microsoft IT Developed Best Practices in Offering PowerPivot as a Service (Level 300)</a></li><li><a href="https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449573&EventCategory=4&culture=en-US&CountryCode=US">TechNet Webcast: SQL Server 2008 R2: Server Consolidation (Level 300)</a></li><li><a href="https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449575&EventCategory=4&culture=en-US&CountryCode=US">TechNet Webcast: SQL Server 2008 R2: Simplify Management of Your SQL Server Data Platform (Level 300)</a></li><li><a href="http://ug.gitca.org/sites/FireSideChats/Lists/Fire%20Side%20Chats/DispForm.aspx?ID=18">SQL Server 2008 R2 Technical Preview: New features and capabilities in SQL Server 2008 R2 </a> Tom Casey, General Manager, SQL Server Business Intelligence (GITCA Fireside Chat)<br></li><li><a href="http://ug.gitca.org/sites/FireSideChats/Lists/Fire%20Side%20Chats/DispForm.aspx?ID=19">SQL Server 2008 R2: Self Service Analytics</a> Donald Farmer (GITCA Fireside Chat)</li><li><a href="http://www.sqlpass.org/summit/eu2010/AboutUs/News/R2LaunchTourKickOff.aspx">Microsoft Kicking Off SQL Server 2008 R2 Launch Tour at PASS European Conference 2010</a>
</li><li><a href="http://www.sqlpass.org/24hours/2010/">24 Hours of PASS: Celebrating SQL Server 2008 R2</a></li><li>For MCT and Educators - <a href="http://www.mctvirtualsummit.com/">MCT & Educator Virtual Summit 2010</a></li><li><a href="http://www.microsoft.com/presspass/presskits/sqlserver/videoGallery.aspx?contentID=sql_vid_tweetup">SQL Server 2008 R2 Tweetup Video Montage</a></li></ul><li>Blog posts <br></li><ul><li><a href="http://sqlblog.com/blogs/mds_team/archive/2010/04/21/updated-product-documentation-and-resources.aspx">Updated Master Data Services Documentation and Resources</a> (source <a href="http://sqlblog.com/blogs/mds_team/default.aspx">Master Data Services Team)</a></li><li><a href="http://blogs.technet.com/dataplatforminsider/archive/2010/04/21/sql-server-2008-r2-released-to-manufacturing.aspx">SQL Server 2008 R2 Released to Manufacturing!</a> (source <a href="http://blogs.technet.com/dataplatforminsider/default.aspx">Data Platform Insider</a>)</li><li><a href="http://blogs.technet.com/andrew/archive/2010/02/18/multi-server-management-in-sql-server-2008-r2.aspx">Multi Server Management in SQL Server 2008 R2</a> - <a href="http://blogs.technet.com/andrew/default.aspx">Andrew Fryer's blog</a><br></li><li><a href="http://cwebbbi.spaces.live.com/blog/cns%217B84B0F2C239489A%216257.entry">Subselects and Calculated Members in R2</a> - <a href="http://cwebbbi.spaces.live.com/default.aspx">Chris Webb's BI Blog</a></li><li><a href="http://www.beyeblogs.com/donaldfarmer/archive/2010/01/qlikview_from_a.php">QlikView from a PowerPivot standpoint</a> - <a href="http://www.beyeblogs.com/donaldfarmer/">Donald Farmer: Foraging in the Data Forest</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/A-SQL-Server-2008-R2-change-for-Service-Broker.aspx">A SQL Server 2008 R2 change for Service Broker</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/Filestreams-Remote-Blog-Storage-and-SQL-Server-2008-R2.aspx">Filestreams, Remote Blog Storage, and SQL Server 2008 R2</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/Filestreams-transactions-and-SQL-Server-2008-R2.aspx">Filestreams, transactions and SQL Server 2008 R2</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/Inside-the-StreamInsight-Object-Model-Metadata.aspx">Inside the StreamInsight Object Model - Metadata</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://blogs.technet.com/dataplatforminsider/archive/2010/04/02/microsoft-ships-the-final-technology-preview-for-sql-server-2008-r2-parallel-data-warehouse.aspx">Microsoft ships the final Technology Preview for SQL Server 2008 R2 Parallel Data Warehouse</a> - <a href="http://blogs.technet.com/dataplatforminsider/default.aspx">Data Platform Insider, Official news for Microsoft's Data Platform</a></li><li><a href="http://blogs.msdn.com/sqlrsteamblog/archive/2009/11/09/sql-server-2008-r2-november-ctp-what-s-new-in-reporting-services.aspx">SQL Server 2008 R2 November CTP – What’s New In Reporting Services?</a> - <a href="http://blogs.msdn.com/sqlrsteamblog/default.aspx">SQL Server Reporting Services Team Blog</a></li><li><a href="http://sqlblog.com/blogs/greg_low/archive/2010/01/11/sql-server-2008-r2-what-is-streaminsight-used-for.aspx">SQL Server 2008 R2: What is StreamInsight used for</a> - <a href="http://sqlblog.com/blogs/greg_low/default.aspx">The Bit Bucket (Greg Low): IDisposable</a><br></li><li><a href="http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-data-analysis-expressions-dax-language.aspx">PowerPivot: Data Analysis Expressions (DAX) Language</a> - <a href="http://social.technet.microsoft.com/wiki/">TechNet Wiki</a></li><li><a href="http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-overview.aspx">PowerPivot: Overview</a> - <a href="http://social.technet.microsoft.com/wiki/">TechNet Wiki</a></li><li><a href="http://blogs.msdn.com/jdbcteam/archive/2010/04/21/micorosoft-sql-server-jdbc-3-0-released.aspx">Microsoft SQL Server JDBC 3.0 Released</a> - <a href="http://blogs.msdn.com/jdbcteam/">Microsoft JDBC Driver Team's blog</a><br></li></ul><li>Books</li><ul><li><a href="http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx">Free ebook from Microsoft Press: Introducing Microsoft SQL Server 2008 R2</a></li><li><a href="http://bit.ly/9e5HRR">Microsoft Press: Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition </a><br></li></ul><li>Documentation<br></li><ul><li><a href="http://msdn.microsoft.com/en-us/library/ms130214%28SQL.105%29.aspx">SQL Server 2008 R2 Books Online</a> - downloadable format <a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c18bad82-0e5f-4e82-812b-5b23e5d52b9c">here</a></li><li><a href="http://msdn.microsoft.com/en-us/library/bb500435%28SQL.105%29.aspx">SQL Server 2008 R2 Books Online - What's new</a><br></li><li><a href="http://download.microsoft.com/download/E/C/F/ECFC6D23-85B2-4C4B-9B6A-BB1A02541F6B/SQL2008R2_Resource_Kit.zip">SQL Server 2008 R2 Resource Kit</a></li></ul><ul><li><a target="_blank" href="http://download.microsoft.com/download/4/0/1/4016B1B8-B04A-4B11-B707-D05BF84772B0/MSSQLR2RG.doc">SQL Server 2008 R2 Guide</a></li><li><a href="http://msdn.microsoft.com/en-us/library/ee391536%28SQL.105%29.aspx">StreamInsight Server Architecture</a></li><li><a href="http://blogs.msdn.com/sqlperf/archive/2010/04/21/kilimanjaro-ships.aspx">Benchmarks</a> (source<a href="http://blogs.msdn.com/sqlperf/default.aspx"> SQL Server Performance</a> blog)</li><li><a href="http://go.microsoft.com/?linkid=9710868">SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)</a>
</li></ul><li>Whitepapers</li><ul><li><a href="http://go.microsoft.com/fwlink/?LinkId=187888">Organizational Approaches to Master Data Management</a></li><li><a href="http://msdn.microsoft.com/en-us/library/ff459274.aspx">SharePoint Workflow Integration with Master Data Services</a></li><li><a class="normal" title="Introducing Microsoft StreamInsight™ in SQL Server 2008 R2 " href="http://download.microsoft.com/download/F/D/5/FD5E855C-D895-45A8-9F3E-110AFADBE51A/Microsoft%20CEP%20Overview.docx">Introducing Microsoft StreamInsight™ in SQL Server 2008 R2</a></li><li><a class="normal" title="SQL Server 2008 R2 Manageability" href="http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQL2008R2Manageability.docx">SQL Server 2008 R2 Manageability</a></li><li><a class="normal" title="Microsoft SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2 " href="http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008R2onWinServer2008R2.docx">Microsoft SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2</a></li><li><a href="http://go.microsoft.com/fwlink/?LinkID=184267&clcid=0x409">Microsoft SQL Server PowerPivot Planning and Deployment</a></li></ul><li>E-Learning Clinics (thanks to Greg Low)<ul><li><a href="http://www.microsoft.com/learning/elearning/course/10334ae.mspx">Clinic 10334: Introduction to Managed Self-Service BI with SQL Server 2008 R2</a> (New)<br>[quote]This clinic covers the following topics:<br>
<ul><li>Self-service Analysis</li><li>Self-service Report Authoring</li><li>Enhancing Report Visualization</li><li>Managed Self-service BI </li></ul>[/quote]</li><li><b><a href="http://www.microsoft.com/learning/elearning/course/10331ae.mspx">Clinic 10331:
Introduction to Microsoft SQL Server 2008 R2 Master Data Services</a></b> <br>[quote]
This clinic covers the following topics:Master Data Services concepts,
hierarchies, how to plan and implement Master Data Services Projects.
[/quote]</li><li><b><a href="http://www.microsoft.com/learning/elearning/course/10335ae.mspx">Clinic 10335: Introduction to Microsoft SQL Server 2008 R2 StreamInsight</a></b> <br>
[quote]
This clinic covers the following topics:
<ul><li>StreamInsight core concepts </li><li>Querying Stream-based Events </li><li>Designing and Working with Event Models </li><li>Hosting Queries and configuring Adapters </li></ul>
[/quote]</li><li><b><a href="https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=169478">Clinic 10336: Introduction to SQL Server 2008 R2 Application and Multi-Server Management </a></b><br>
[quote]
<br>
This clinic covers the following topics:
<ul><li>Introducing Application and Multi-server Management </li><li>Working with data-tier applicationsManaging change in data-tier applications. </li><li>Managing data-tier applications<br></li></ul>
[/quote]</li><li><b><a href="http://www.microsoft.com/learning/elearning/course/10332ae.mspx">Clinic 10332: Introduction to Microsoft SQL Azure</a></b><br>
Obviously this clinic is not related to SQL Server 2008 R2 but it's worth mentioning it :)
[quote]
<br>
This clinic covers the following topics:
<ul><li>Understanding the SQL Azure Platform</li><li>Designing Applications for SQL Azure</li><li>Migrating Applications to SQL Azure</li><li>Achieving Scale with SQL Azure</li></ul>
[/quote]</li><li>Clinics on Parallel Data Warehouse, SQL Virtualization to published soon.</li></ul></li><li>Local Resources<br></li><ul><li>Slides from the SQL Server 2008 R2 launch (in Romanian from <a href="http://zoli.herczeg.ro/">Zoli's blog</a>)</li><ul><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/1-Zoli-Herczeg-Petru-Jucovschi-SQL-Server-2008-R2-nout%C4%83%C8%9Bi-%C8%99i-beneficii-peste-edi%C8%9Biile-anterioare.pptx">Zoli Herczeg Petru-Jucovschi - SQL Server 2008 R2 noutati si beneficii peste editiile anterioare.pptx</a>
</li><li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/2-Cristian-Lefter-SQL-Server-2008-R2-managementul-aplica%C8%9Biilor-%C8%99i-a-mediilor-multi-server.pptx">Cristian Lefter - SQL Server 2008 R2 - managementul aplicatiilor si a mediilor multi-server.pptx</a></li><li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/3-Ciprian-Jichici-SQL-Server-2008-R2-business-intelligence.pptx">Ciprian Jichici - SQL Server 2008 R2 business-intelligence.pptx</a></li><li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/4-Teodor-Blid%C4%83ru%C8%99-Scenariu-aplica%C8%9Bii-de-business-online.pptx">Teodor Blidăruș - Scenariu-Aplicatii de business online - Optimizarea performantei.pptx</a></li><li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/5-Ciprian-Jichici-Scenariu-Datawarehousing-ETL-StreamInsight-Master-Data-Services.pptx">Ciprian Jichici - Scenariu Datawarehousing ETL StreamInsight Master Data Services.pptx</a>
</li><li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/6-Ciprian-Jichici-Scenariu-Consolidare-asincron%C4%83-de-date-Service-Broker.pptx">Ciprian Jichici Scenariu Consolidare asincronă de date Service Broker.pptx</a>
</li><li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/7-Mihai-Matei-Scenariu-Consolidare-sincron%C4%83-de-date-replicare.pdf">Mihai Matei Scenariu Consolidare sincronă de date replicare.pdf</a>
</li></ul><li>Rafal Lukawiecki - BI with Microsoft SQL Server 2008 R2 and Microsoft Office System 2010 (event slides - source: <a href="http://zoli.herczeg.ro/">Zoli's blog</a>)</li><ul><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/1-The-Big-Picture-of-Business-Intelligence.pptx">Session 1: The Big Picture of Business Intelligence: Goals, Concepts, and the Platform</a>
<br>
This session will introduce the overall picture of Business Intelligence and will relate the Microsoft BI Platform to it.
</li><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/2-The-Knowledge-Workers-Perspective.pptx">Session 2: The Knowledge Worker’s Perspective: Self-Service of BI
</a><br>
This session will concentrate on how Office System 2010, in particular
SharePoint 2010 and its PerformancePoint Services enable anyone to
create and use BI in an organization. We will also introduce the very
new Microsoft Power Pivot stressing how existing Excel skills enable
self-service analysis and also mention other self-service aspects of
BI, such as self-service reporting. This session will also discuss the
IT Professional challenge of managing the life cycle of a potentially
fast, organically growing BI system built by its users.
</li><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/3-The-IT-Perspective.pptx">Session 3: The IT Perspective: Data Warehousing, Management, and Analytical Structures
</a><br>This session aims to take a look at BI capabilities of the SQL
Server 2008 R2. We will introduce Master Data Management and new
approaches to massive Data Warehousing. </li><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/4-The-Analysts-Perspective.pptx">Session 4: The Analyst’s Perspective: Ad-hoc Analysis with Microsoft Power Pivot and Office 2010 Excel
</a><br>
We will introduce a new language for analysis known as DAX which can
help more advanced users create powerful analytical applications all
inside Excel and PowerPivot. Finally, we will review the existing Data
Mining technologies of SQL Server 2008 R2.
</li><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/5-Summary-and-QA.pptx">Summary: Microsoft BI for Your Enterprise</a>
</li></ul></ul></ol><br><img src="http://sqlserver.ro/aggbug.aspx?PostID=8213" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSQL Server 2008 Express R2 RTM?http://sqlserver.ro/blogs/cristians_blog/archive/2010/04/21/sql-server-2008-express-r2-rtm.aspx2010-04-21T11:03:00Z2010-04-21T11:03:00ZAt least the following downloads are available:<br><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b">Microsoft SQL Server 2008 R2 RTM - Express</a><br><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135">Microsoft SQL Server2008 R2 RTM - Express with Advanced Services</a><br><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=967225eb-207b-4950-91df-eeb5f35a80ee">Microsoft SQL Server 2008 R2 RTM - Express with Management Tools</a><br><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=56ad557c-03e6-4369-9c1d-e81b33d8026b">Microsoft SQL Server 2008 R2 RTM - Management Studio Express</a><br><br>In case you didn't know the SQL Server 2008 R2 Express Edition - expands the size limit of a user database to 10GB.<br><br>Also looking at the <a href="http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx">downloads related to SQL Server 2008 R2</a> it seems that also a <a href="http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx">trial</a> is available for download.<br><img src="http://sqlserver.ro/aggbug.aspx?PostID=8211" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxTo tweet or not to tweet?http://sqlserver.ro/blogs/cristians_blog/archive/2010/04/11/to-tweet-or-not-to-tweet.aspx2010-04-11T17:15:00Z2010-04-11T17:15:00ZProbably this is not the right question. What is certain is that <a href="http://twitter.com/">twitter</a> has become a valuable source of information. I had to add new words to my language, words like "<i><b>to tweet</b></i>" "<i><b>tweetup</b></i>" "<i><b>twitterview</b></i>". You have no idea what <i><b>tweetup</b></i> or <i><b>twitterview </b></i>means? <i><b>Tweetup </b></i>or <i><b>tweet-up</b></i> is defined by Macmillan Dictionary as [quote] <a href="http://www.macmillandictionary.com/buzzword/entries/tweetup.html"><i>a meeting of two or more people who know each other through the Twitter short messaging service</i></a> [/quote]. Impressions from a SQL Server 2008 R2 tweetup can be found on <a href="http://www.facebook.com/sqlserver">SQL Server Team's FaceBook page</a> and on <span><a href="http://blog.dkranch.net/2010/04/tweetup.html">The blog from the dkRanch - The Tweetup</a>.</span><br>As for <i><b>twitterview</b></i> - I will assist at the first one (for me) in a few hours: <br>[quote]<i><br></i><blockquote><i>Donald Farmer ‘Twitterview’ with SQL Server Magazine</i><br></blockquote><blockquote><i>Attention SQL Server enthusiasts: mark your calendar for April 14, 9:30 AM PDT. SQL Server Magazine is hosting a ‘Twitterview’ with Donald Farmer, Principal Program Manager for SQL Server. This is your opportunity to ask Donald your burning BI questions. This is a continuation of SQL Server Magazine’s article by Shelia Molnar about Microsoft’s BI Strategy.</i><br><i>Not participated in a Twitterview before? It’s easy! Donald will answer your questions via the SQL Server Magazine Twitter account (@SQLServerMag) from 9:30 AM to 10:00 AM PDT. </i><br></blockquote>[/quote]<br><br>If you ever need help with SQL Server use the hashtag (a hash tag is simply a tag with the hash "#" symbol as prefix) #sqlhelp.<br><br>I will close by mentioning just a few of the channels I follow: <br>
<ul>
<li>
<a href="http://twitter.com/MS_SQL_Server">@MS_SQL_Server</a> - The official SQL Server twitter</li><li><a href="http://twitter.com/billramo">@billramo</a> - Bill Ramos <span class="bio">SQL Server expert on manageability and performance
troubleshooting and fan of agile and UI development</span></li><li><a href="http://twitter.com/SQLServerMag"><span class="bio">@</span>SQLServerMag</a> - <span class="bio">SQL Server Magazine is dedicated to helping DBAs, database
developers, and BI professionals get the most out of SQL Server.</span></li><li><a href="http://twitter.com/SSRS"><span class="bio">@</span>SSRS</a> - Blogs Posts and Connecting with the SQL Server Reporting Services Team</li><li><a href="http://twitter.com/buckwoody">@buckwoody</a> - Buck Woody - Database Guy</li><li><a href="http://twitter.com/mssqltips">@mssqltips</a> - <span class="bio">MSSQLTips - Your source for daily SQL Server tips</span></li><li><span class="bio"><a href="http://twitter.com/donalddotfarmer">@donalddotfarmer</a> - </span><span class="fn">Donald Farmer - </span><span class="bio">Working @ Microsoft in Business Intelligence.
Personal interests: philosophy, art, and indulgences starting with food
and wine and ending who knows where?</span></li><li><span class="bio"><a href="http://twitter.com/sqlpass">@sqlpass</a> - </span><span class="bio">Professional Association for SQL Server. Connect, Share, Learn.</span></li>
</ul>
Come to the twitterview with Donald Farmer <img src="http://sqlserver.ro/emoticons/emotion-21.gif" alt="Yes" /><br><br><u>Published Update</u><br><a href="http://www.sqlmag.com/blogs/business-intelligence/tabid/786/entryid/12740/Twitterview-Microsoft-s-Donald-Farmer-on-SQL-Server-2008-R2.aspx">Twitterview: Microsoft’s Donald Farmer on SQL Server 2008 R2 (the transcript)</a><br>SQL Server 2008 R2 Tweetup Video Montage<br><br><object width="660" height="405"><param name="movie" value="http://www.youtube.com/v/eoiOjg64h2g&hl=en_US&fs=1&border=1"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/eoiOjg64h2g&hl=en_US&fs=1&border=1" type="application/x-shockwave-flash" width="660" height="405"></object><br><img src="http://sqlserver.ro/aggbug.aspx?PostID=8188" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSQL Server 2008 R2 resourceshttp://sqlserver.ro/blogs/cristians_blog/archive/2010/04/11/sql-server-2008-r2-resources.aspx2010-04-11T06:53:00Z2010-04-11T06:53:00Z<img src="http://sqlserver.ro/photos/cristianblog/images/8187/original.aspx" border="0">
<br>
<br>
With SQL Server 2008 R2 RTM knocking at the door a list with R2 resources may come in handy.
<br>
So here you are:<br>
<ol>
<li>
<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=FFFAAD6A-0153-4D41-B289-A3ED1D637C0D&displaylang=en"><font size="4">
<b></b></font></a><font size="4"><b><a href="http://go.microsoft.com/?linkid=9710868">SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)</a></b>
</font>
<br>[quote]
<br>
The <i>SQL Server 2008 R2
Update for Developers Training Kit</i> is ideal for developers who want to understand
how to take advantage of the key improvements introduced in SQL Server 2008 and
SQL Server 2008 R2 in their applications, as well as for developers who are new
to SQL Server.
<br>
[/quote]
<br>It contains <b>presentations </b>(22), <b>demos </b>(29), <b>hands-on labs</b> (18), <b>videos </b>(35) as well as an utility to help configuring your computer for running the demos.<br>
</li>
<li><font size="4"><b>E-Learning Clinics</b></font> (thanks to Greg Low)</li><ul><li><b><a href="http://www.microsoft.com/learning/elearning/course/10331ae.mspx">Clinic 10331:
Introduction to Microsoft SQL Server 2008 R2 Master Data Services</a></b> <br>[quote] This clinic covers the following topics:Master Data Services concepts, hierarchies, how to plan and implement Master Data Services Projects. [/quote]</li><li><b><a href="http://www.microsoft.com/learning/elearning/course/10335ae.mspx">Clinic 10335: Introduction to Microsoft SQL Server 2008 R2 StreamInsight</a></b> <br>
[quote]
This clinic covers the following topics:
<ul>
<li>StreamInsight core concepts </li>
<li>Querying Stream-based Events </li>
<li>Designing and Working with Event Models </li>
<li>Hosting Queries and configuring Adapters </li>
</ul>
[/quote]</li><li><b><a href="https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=169478">Clinic 10336: Introduction to SQL Server 2008 R2 Application and Multi-Server Management </a></b><br>
[quote]
<br>
This clinic covers the following topics:
<ul>
<li>Introducing Application and Multi-server Management </li>
<li>Working with data-tier applicationsManaging change in data-tier applications. </li>
<li>Managing data-tier applications<br></li></ul>
[/quote]</li><li><b><a href="http://www.microsoft.com/learning/elearning/course/10332ae.mspx">Clinic 10332: Introduction to Microsoft SQL Azure</a></b><br>
Obviously this clinic is not related to SQL Server 2008 R2 but it's worth mentioning it :)
[quote]
<br>
This clinic covers the following topics:
<ul>
<li>Understanding the SQL Azure Platform</li>
<li>Designing Applications for SQL Azure</li>
<li>Migrating Applications to SQL Azure</li>
<li>Achieving Scale with SQL Azure</li>
</ul>
[/quote]</li><li>Clinics on Self-Service BI and Reporting, Parallel Data Warehouse, SQL Virtualization to published soon.</li></ul><li><b><font size="4">Webcasts</font></b></li><ul><li><a href="https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032441804&EventCategory=5&culture=en-US&CountryCode=US">TechNet Webcast: How Microsoft IT Developed Best Practices in Offering PowerPivot as a Service (Level 300)</a></li><li><a href="https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449573&EventCategory=4&culture=en-US&CountryCode=US">TechNet Webcast: SQL Server 2008 R2: Server Consolidation (Level 300)</a></li><li><a href="https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449575&EventCategory=4&culture=en-US&CountryCode=US">TechNet Webcast: SQL Server 2008 R2: Simplify Management of Your SQL Server Data Platform (Level 300)</a></li></ul><li><a href="http://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx"><font size="4"><b>Whitepapers</b></font></a></li><ul><li><a class="normal" title="Introducing Microsoft StreamInsight™ in SQL Server 2008 R2 " href="http://download.microsoft.com/download/F/D/5/FD5E855C-D895-45A8-9F3E-110AFADBE51A/Microsoft%20CEP%20Overview.docx">Introducing Microsoft StreamInsight™ in SQL Server 2008 R2</a></li><li><a class="normal" title="SQL Server 2008 R2 Manageability" href="http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQL2008R2Manageability.docx">SQL Server 2008 R2 Manageability</a></li><li><a class="normal" title="Microsoft SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2 " href="http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008R2onWinServer2008R2.docx">Microsoft SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2</a></li><li><a href="http://go.microsoft.com/fwlink/?LinkID=184267&clcid=0x409">Microsoft SQL Server PowerPivot Planning and Deployment</a><br></li></ul><li><font size="4"><b>GITCA Fireside Chats</b></font></li><ul><li><a href="http://ug.gitca.org/sites/FireSideChats/Lists/Fire%20Side%20Chats/DispForm.aspx?ID=18">SQL Server 2008 R2 Technical Preview: New features and capabilities in SQL Server 2008 R2 </a> Tom Casey, General Manager, SQL Server Business Intelligence</li><li><a href="http://ug.gitca.org/sites/FireSideChats/Lists/Fire%20Side%20Chats/DispForm.aspx?ID=19">SQL Server 2008 R2: Self Service Analytics</a> Donald Farmer <br></li></ul>
<li><font size="4"><b><a href="http://www.sqlpass.org/">PASS - The Professional Association for SQL Server</a><br></b></font></li><ul><li><a href="http://www.sqlpass.org/summit/eu2010/AboutUs/News/R2LaunchTourKickOff.aspx">Microsoft Kicking Off SQL Server 2008 R2 Launch Tour at PASS European Conference 2010</a>
</li>
<li><a href="http://www.sqlpass.org/24hours/2010/">24 Hours of PASS: Celebrating SQL Server 2008 R2</a>
</li>
</ul>
<li>
<font size="4"><b>Articles and blogs</b></font><br></li><ul><li><a href="http://blogs.technet.com/andrew/archive/2010/02/18/multi-server-management-in-sql-server-2008-r2.aspx">Multi Server Management in SQL Server 2008 R2</a> - <a href="http://blogs.technet.com/andrew/default.aspx">Andrew Fryer's blog</a><br></li><li><a href="http://cwebbbi.spaces.live.com/blog/cns%217B84B0F2C239489A%216257.entry">Subselects and Calculated Members in R2</a> - <a href="http://cwebbbi.spaces.live.com/default.aspx">Chris Webb's BI Blog</a></li><li><a href="http://www.beyeblogs.com/donaldfarmer/archive/2010/01/qlikview_from_a.php">QlikView from a PowerPivot standpoint</a> - <a href="http://www.beyeblogs.com/donaldfarmer/">Donald Farmer: Foraging in the Data Forest</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/A-SQL-Server-2008-R2-change-for-Service-Broker.aspx">A SQL Server 2008 R2 change for Service Broker</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/Filestreams-Remote-Blog-Storage-and-SQL-Server-2008-R2.aspx">Filestreams, Remote Blog Storage, and SQL Server 2008 R2</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/Filestreams-transactions-and-SQL-Server-2008-R2.aspx">Filestreams, transactions and SQL Server 2008 R2</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://www.sqlskills.com/BLOGS/BOBB/post/Inside-the-StreamInsight-Object-Model-Metadata.aspx">Inside the StreamInsight Object Model - Metadata</a> - <a href="http://www.sqlskills.com/blogs/bobb/">Bob Beauchemin's Blog</a></li><li><a href="http://blogs.technet.com/dataplatforminsider/archive/2010/04/02/microsoft-ships-the-final-technology-preview-for-sql-server-2008-r2-parallel-data-warehouse.aspx">Microsoft ships the final Technology Preview for SQL Server 2008 R2 Parallel Data Warehouse</a> - <a href="http://blogs.technet.com/dataplatforminsider/default.aspx">Data Platform Insider, Official news for Microsoft's Data Platform</a></li><li><a href="http://blogs.msdn.com/sqlrsteamblog/archive/2009/11/09/sql-server-2008-r2-november-ctp-what-s-new-in-reporting-services.aspx">SQL Server 2008 R2 November CTP – What’s New In Reporting Services?</a> - <a href="http://blogs.msdn.com/sqlrsteamblog/default.aspx">SQL Server Reporting Services Team Blog</a></li><li><a href="http://sqlblog.com/blogs/greg_low/archive/2010/01/11/sql-server-2008-r2-what-is-streaminsight-used-for.aspx">SQL Server 2008 R2: What is StreamInsight used for</a> - <a href="http://sqlblog.com/blogs/greg_low/default.aspx">The Bit Bucket (Greg Low): IDisposable</a><br></li>
<li><a href="http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-data-analysis-expressions-dax-language.aspx">PowerPivot: Data Analysis Expressions (DAX) Language</a> - <a href="http://social.technet.microsoft.com/wiki/">TechNet Wiki</a></li>
<li><a href="http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-overview.aspx">PowerPivot: Overview</a> - <a href="http://social.technet.microsoft.com/wiki/">TechNet Wiki</a>
</li>
</ul>
<li><font size="4"><b>Downloads</b></font></li>
<ul>
<li><a href="http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx">SQL Server 2008 R2 November CTP</a>
</li>
<li><a href="http://www.microsoft.com/downloads/info.aspx?na=45&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=fe0c6a31-5ad6-4eea-a865-73bbe2608bd1&u=details.aspx%3ffamilyid%3d020EE0D5-BCE4-4A45-9D64-B0C49C8831E5%26displaylang%3den">Microsoft® SQL Server® 2008 R2 November Community Technology Preview Feature Pack</a></li>
<li><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca">Microsoft® SQL Server® 2008 R2 - PowerPivot for Microsoft® Excel 2010 - November Community Technology Preview</a></li></ul>
<li><font size="4">
<b>Local Resources</b></font></li>
<ul><li>Slides from the SQL Server 2008 R2 launch (in Romanian from <a href="http://zoli.herczeg.ro/">Zoli's blog</a>)</li><ul><li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/1-Zoli-Herczeg-Petru-Jucovschi-SQL-Server-2008-R2-nout%C4%83%C8%9Bi-%C8%99i-beneficii-peste-edi%C8%9Biile-anterioare.pptx">Zoli Herczeg Petru-Jucovschi - SQL Server 2008 R2 noutati si beneficii peste editiile anterioare.pptx</a>
</li>
<li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/2-Cristian-Lefter-SQL-Server-2008-R2-managementul-aplica%C8%9Biilor-%C8%99i-a-mediilor-multi-server.pptx">Cristian Lefter - SQL Server 2008 R2 - managementul aplicatiilor si a mediilor multi-server.pptx</a></li>
<li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/3-Ciprian-Jichici-SQL-Server-2008-R2-business-intelligence.pptx">Ciprian Jichici - SQL Server 2008 R2 business-intelligence.pptx</a></li>
<li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/4-Teodor-Blid%C4%83ru%C8%99-Scenariu-aplica%C8%9Bii-de-business-online.pptx">Teodor Blidăruș - Scenariu-Aplicatii de business online - Optimizarea performantei.pptx</a></li>
<li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/5-Ciprian-Jichici-Scenariu-Datawarehousing-ETL-StreamInsight-Master-Data-Services.pptx">Ciprian Jichici - Scenariu Datawarehousing ETL StreamInsight Master Data Services.pptx</a>
</li>
<li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/6-Ciprian-Jichici-Scenariu-Consolidare-asincron%C4%83-de-date-Service-Broker.pptx">Ciprian Jichici Scenariu Consolidare asincronă de date Service Broker.pptx</a>
</li>
<li><a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/7-Mihai-Matei-Scenariu-Consolidare-sincron%C4%83-de-date-replicare.pdf">Mihai Matei Scenariu Consolidare sincronă de date replicare.pdf</a>
</li></ul><li>Rafal Lukawiecki - BI with Microsoft SQL Server 2008 R2 and Microsoft Office System 2010 (event slides - source: <a href="http://zoli.herczeg.ro/">Zoli's blog</a>)</li>
<ul>
<li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/1-The-Big-Picture-of-Business-Intelligence.pptx">Session 1: The Big Picture of Business Intelligence: Goals, Concepts, and the Platform</a>
<br>
This session will introduce the overall picture of Business Intelligence and will relate the Microsoft BI Platform to it.
</li>
<li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/2-The-Knowledge-Workers-Perspective.pptx">Session 2: The Knowledge Worker’s Perspective: Self-Service of BI
</a><br>
This session will concentrate on how Office System 2010, in particular SharePoint 2010 and its PerformancePoint Services enable anyone to create and use BI in an organization. We will also introduce the very new Microsoft Power Pivot stressing how existing Excel skills enable self-service analysis and also mention other self-service aspects of BI, such as self-service reporting. This session will also discuss the IT Professional challenge of managing the life cycle of a potentially fast, organically growing BI system built by its users.
</li>
<li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/3-The-IT-Perspective.pptx">Session 3: The IT Perspective: Data Warehousing, Management, and Analytical Structures
</a><br>
This session aims to take a look at BI capabilities of the SQL Server 2008 R2. We will introduce Master Data Management and new approaches to massive Data Warehousing.
</li>
<li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/4-The-Analysts-Perspective.pptx">Session 4: The Analyst’s Perspective: Ad-hoc Analysis with Microsoft Power Pivot and Office 2010 Excel
</a><br>
We will introduce a new language for analysis known as DAX which can help more advanced users create powerful analytical applications all inside Excel and PowerPivot. Finally, we will review the existing Data Mining technologies of SQL Server 2008 R2.
</li>
<li>
<a href="http://zoli.herczeg.ro/wp-content/uploads/2010/03/5-Summary-and-QA.pptx">Summary: Microsoft BI for Your Enterprise</a>
</li>
</ul>
</ul><li><font size="4"><b>Other resources</b></font></li><ul><li>For MCT and Educators - <a href="http://www.mctvirtualsummit.com/">MCT & Educator Virtual Summit 2010</a></li></ul><li><a href="http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx"><font size="4"><b>Free ebook: Introducing Microsoft SQL Server 2008 R2</b></font></a><br></li></ol>Enjoy!<br><ol><ul>
</ul>
</ol><img src="http://sqlserver.ro/aggbug.aspx?PostID=8186" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspxSQL Server 2008 R2 gets a release datehttp://sqlserver.ro/blogs/cristians_blog/archive/2010/01/20/sql-server-2008-r2-gets-a-release-date.aspx2010-01-20T10:25:00Z2010-01-20T10:25:00ZAccording to <a href="http://blogs.technet.com/dataplatforminsider/default.aspx">Data Platform Insider</a> blog, May 2010 will bring SQL Server 2008 R2 both on Microsoft's products price list and also to the customers.<br><br>More details here: <a href="http://blogs.technet.com/dataplatforminsider/archive/2010/01/19/sql-server-2008-r2-gets-an-official-date.aspx">SQL Server 2008 R2 gets an official date</a><img src="http://sqlserver.ro/aggbug.aspx?PostID=7995" width="1" height="1">xmldeveloperhttp://sqlserver.ro/members/xmldeveloper.aspx