tag:blogger.com,1999:blog-35156275530353305762024-03-16T02:09:05.703+01:00Zoltán Horváth on MSBIZoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-3515627553035330576.post-44020884502152756762013-07-12T02:06:00.001+02:002013-07-12T02:06:15.454+02:00I'm a Microsoft Community Contributor! :)Hey, I've just received an email from the MCC team with a subject "Your online community contributions have been recognized by Microsoft"!<br />
<br />
What is an MCC? According to its description at the <a href="https://www.microsoftcommunitycontributor.com/default.aspx" target="_blank">site of the MCC program</a>, "The Microsoft Community Contributor badge seeks to recognize notable contributions to Microsoft online communities such as TechNet, MSDN and Microsoft Community. The value of these resources is greatly enhanced by participants who voluntarily contribute their time and energy to improve the online community experience for others. Each day around the world, Microsoft Community Contributor recipients contribute to Microsoft online technical communities in a range of ways, including providing helpful answers, translating online resources into local languages and serving as moderators."<br />
<br />
You can read more about the differences between the MCC and the MVP program in a TechNet Wiki page: <a href="http://social.technet.microsoft.com/wiki/contents/articles/4913.differences-between-the-mvp-and-mcc-awards.aspx" target="_blank">Differences Between the MVP and MCC Awards</a>.<br />
<br />
If you're interested in becoming an MCC or an MVP, check the following TechNet Wiki page: <a href="http://social.technet.microsoft.com/wiki/contents/articles/4827.how-to-become-an-mvp-or-mcc.aspx" target="_blank">How to Become an MVP or MCC</a>.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com2tag:blogger.com,1999:blog-3515627553035330576.post-80609187456529611662012-09-10T20:00:00.000+02:002012-09-10T20:00:02.840+02:00Performing and Automating Microsoft BI Related Tasks with PowerShellI just ran into PowerShell somehow. If you have some familiarity in using .NET, then it should be around 2 hours to pick it up. Of course, you will be on the same basic level like me, but these scripts will work as expected :)<br />
<br />
I quicly wrote some scripts and shared them in the TechNet Galleries:<br />
<br />
<ul>
<li><a href="http://gallery.technet.microsoft.com/Listing-Enabled-SQL-Agent-e93b720e" target="_blank">Listing Enabled SQL Agent Jobs Executing SSIS Packages</a>: there was a request from someone to write it, after they could list all their packages in MSDB with an earlier <a href="http://gallery.technet.microsoft.com/List-all-SSIS-packages-in-901addce" target="_blank">T-SQL script</a>.</li>
<li><a href="http://gallery.technet.microsoft.com/List-Elevated-Permissions-e5e84cbe" target="_blank">List Elevated Permissions in an Analysis Services Database (PowerShell)</a>: this script is nice to have before starting some security audit activities on SSAS databases.</li>
<li><a href="http://gallery.technet.microsoft.com/Listing-Not-Processed-699b2204" target="_blank">Listing Not Processed Objects on an SSAS Instance (PowerShell)</a>: this is for those who have a lot of databases, and would like to check if something should be processed.</li>
<li><a href="http://gallery.technet.microsoft.com/Bulk-Report-Deployment-f03e1aac" target="_blank">Bulk Report Deployment with PowerShell</a>: this is useful for those who have a nice report folder structure, and would like to deploy easily.</li>
</ul>
<div>
If you need some changes to the scripts, please let me know on the Q and A sections of these contributions. If you don't need any changes, and the scripts are OK, then please don't forget to rate them :)</div>
Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com3tag:blogger.com,1999:blog-3515627553035330576.post-29424771594563915452012-08-07T21:00:00.000+02:002012-08-07T21:00:00.581+02:00T-SQL script for refreshing all views in a database<br />
There are scenarios when SELECT * is used in views - it's not uncommon in a relational data warehouse.<br />
<br />
If WITH SCHEMABINDING is not specified when the view is created, then changing the tables behind the views might corrupt the mapping of the table columns to the output columns, which can have a very confusing result.<br />
<br />
A stored procedure called sp_refreshview can be called to correct the mappings. But if you don't have time to look for the corrupted one, you can fabricate a script to loop through all of them.<br />
<br />
Or, you can download my one and simply run it. I posted a script to TechNet Galleries, which refreshes all views in a database, regardless of their schema.<br />
<br />
Basically it's a cursor solution, calling sp_refreshview for each view in the database.<br />
<br />
You can find it <a href="http://gallery.technet.microsoft.com/Refreshing-all-views-in-a-9a1070ef" target="_blank">here</a>.<br />Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com3tag:blogger.com,1999:blog-3515627553035330576.post-12085764650751576922012-07-21T10:00:00.000+02:002012-07-21T10:00:01.362+02:00SSIS Transformations Wiki: Pivot<br />
Again, a new page for TechNet Wiki, now about the <a href="http://social.technet.microsoft.com/wiki/contents/articles/12510.ssis-pivot-transformation.aspx" target="_blank">Pivot transformation</a>.<br />
I introduced it through a small example.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-15864943312241929062012-07-14T00:25:00.000+02:002012-07-14T00:25:00.449+02:00SSIS Transformations Wiki: UnpivotA new page to TechNet Wiki, about the <a href="http://social.technet.microsoft.com/wiki/contents/articles/12129.ssis-unpivot-transformation.aspx" target="_blank">Unpivot </a>transformation.<br />
Of course, I updated the <a href="http://social.technet.microsoft.com/wiki/contents/articles/6752.ssis-list-of-transformations.aspx" target="_blank">List of Transformations</a> page as well to refer to this one.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com1tag:blogger.com,1999:blog-3515627553035330576.post-29981792096003675722012-05-07T18:47:00.003+02:002012-05-07T18:47:49.922+02:00Sample: Automatically Incrementing Columns in SSIS<div style="text-align: justify;">
There are cases when you don't have a chance to add an auto-incrementing column to a source of a data flow. Sometimes it's not possible (for example, using a flat file source), sometimes it doesn't make a sense (when the data will be resorted or filtered in the data flow later).</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I just uploaded a small example to <a href="http://gallery.technet.microsoft.com/Autoincrementing-Values-in-368d489c" target="_blank">TechNet Gallery</a> how you can add an auto-incrementing column in the middle of a data flow. It's an SSIS 2008 R2 package - if you need another version, let me know via the Gallery. The package adds two columns to the data flow with Script Components - the sample codes are the same, just written in C# and VB.NET as well.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The package also shows how to use a recursive CTE (in the data source) to generate 500 rows of data. You will need to have a tempdb on your localhost, or to edit the connection manager to refer to any accessible SQL 2008 database.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Ratings, comments and questions are always welcome.</div>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com1tag:blogger.com,1999:blog-3515627553035330576.post-42414971292788397912012-04-08T14:34:00.001+02:002012-04-08T14:34:43.596+02:00SQL Server 2012 exams and certificationsThe changes arrived with SQL Server 2012 are reflected in the related exams and certifications as well.<br />
The most important change is that two MCITP-level certifications will be introduced: the Data Platform and the Business Intelligence certifications. <strong>Yeah, the administrator and the developer certifications had been merged.</strong><br />
<br />
As the official MS Learning site <a href="http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2" target="_blank">writes</a>, you'll have to pass five exams to achieve a Professional level (MCITP) certification. Nothing had been shared yet regarding the Technology Specialist level. If you already hold an MCITP certification for SQL Server 2008, it will be enough to pass three of them only, as an upgrade. More details will be provided in mid-April. But if you're planning to clear an MCITP exam on SQL Server 2008 - holding an MCTS SQL Server 2008 certification already -, you can save the fee of one exam by choosing the version upgrade path from MCITP 2008 to MCITP 2012.<br />
<br />
It's just a guess from me, but since three of five exams are the same on the Data Platform and on the BI track, I presume these 3 will be needed for the MCTS level.<br />
<br />
<strong>The common exams for both tracks will be:</strong><br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-461" target="_blank">70-461</a>: Querying Microsoft SQL Server 2012<br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-462" target="_blank">70-462</a>: Administering Microsoft SQL Server 2012 Databases<br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-463" target="_blank">70-463</a>: Implementing a Data Warehouse with Microsoft SQL Server 2012<br />
<br />
<strong>The MCITP level Data Platform exams will be:</strong><br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-464" target="_blank">70-464</a>: Developing Microsoft SQL Server 2012 Databases<br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-465" target="_blank">70-465</a>: Designing Database Solutions for Microsoft SQL Server 2012<br />
<br />
<strong>The MCITP level exams for Business Intelligence will be:</strong><br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-466" target="_blank">70-466</a>: Implementing Data Models and Reports with Microsoft SQL Server 2012<br />
<a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-467" target="_blank">70-467</a>: Designing Business Intelligence Solutions with Microsoft SQL Server 2012<br />
<br />
There are some seats announced for a <a href="http://borntolearn.mslearn.net/btl/b/weblog/archive/2012/03/22/register-for-sql-server-2012-beta-exams.aspx" target="_blank">beta exam program</a>, but these are <a href="http://borntolearn.mslearn.net/btl/b/weblog/archive/2012/04/04/update-sql-2012-beta-exams-filling-up-register-now.aspx" target="_blank">filling up</a>. The exam codes start with 71 in this case.<br />
<br />
Good luck!Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com1tag:blogger.com,1999:blog-3515627553035330576.post-28890026206253614992012-03-20T12:50:00.000+01:002012-03-20T12:50:46.758+01:00You can find BIDS features in SQL Server Data Tools for SQL Server 2012The development environment for business intelligence (and database) solutions - earlier Business Intelligence Development Studio - is called SQL Server Data Tools in SQL Server 2012.<br />
It can be installed using the SQL Server 2012 installation kit.<br />
<br />
It's a Visual Studio 2010 Shell in Integrated Mode. Check out my <a href="http://addictivemeasures.blogspot.co.uk/2012/02/common-misunderstanding-vs-vs-bids-vs.html" target="_blank">earlier post</a> regarding VS modes, BIDS, and SSMS.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com3tag:blogger.com,1999:blog-3515627553035330576.post-50314591815714028732012-03-13T15:13:00.001+01:002012-03-13T15:13:23.784+01:00HUG-MSSQL website launched todaySome of you might already know that I organize the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL).<br />
<br />
Today we <a href="http://hug-mssql.hu/post/2012/03/13/Ready-to-Roll-Out.aspx" target="_blank">launched</a> its website! There will be blogs, news, and events posted regarding everything about MSSQL and MSBI.<br />
<br />
It will be in Hungarian, but some of you already translated this blog with free online tools anyway :)Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-85564295416642250492012-03-12T11:04:00.000+01:002012-03-12T11:04:01.182+01:00How to install SQL 2012 on Windows 8During the weekend, I was playing around with Windows 8 Customer Preview.<br />
<br />
First I tried to install SQL Server 2012 RC0 as I had the installer already, but I ran into an issue (missing system CLR types). I decided not to handle this, since <a href="http://www.microsoft.com/download/en/details.aspx?id=29066"><span style="color: #0000aa;">SQL Server 2012 RTM is available</span></a> now. So I tried to install that one instead.<br />
<br />
A smaller issue came up again. But <a href="http://www.winvistaside.de/" target="_blank"><span style="color: #0000aa;">Andre Ziegler</span></a> saved my day with <a href="http://social.msdn.microsoft.com/Forums/en-US/windowsdeveloperpreviewgeneral/thread/670dd964-11cf-4006-96ee-1bf2e16e9979#1648c1d3-6de1-4da2-b94b-13e4b56c5fd5"><span style="color: #0000aa;">his post</span></a> in one of the Windows 8 Developer Preview forums.<br />
<br />
So, it's better running the script before you start the installation.<br />
You'll have to run cmd as administrator, insert your Windows install disc and type:<br />
<pre>dism.exe <span style="color: grey;">/</span>online <span style="color: grey;">/</span>enable<span style="color: grey;">-</span>feature <span style="color: grey;">/</span>featurename:NetFX3 <span style="color: grey;">/</span>Source:d:\sources\sxs <span style="color: grey;">/</span>LimitAccess
</pre>Don't forget to check the drive letter of the source and replace it if necessary.<br />
<br />
SQL Server 2012 is installed and running now on Windows 8. Thanks Andre :)Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com41tag:blogger.com,1999:blog-3515627553035330576.post-13452223600845074492012-02-15T18:17:00.001+01:002012-03-20T13:35:01.976+01:00A common misunderstanding: VS vs BIDS vs SSMSI saw many posts on community sites where people are trying to figure out:<br />
<ul>
<li>why business intelligence projects cannot be created in VS after installing Visual Studio 2008</li>
<li>why they can't create Visual Studio projects in BIDS</li>
<li>why they don't see VB, C# and other Visual Studio project types, if they have a machine with only BIDS installed</li>
<li>why all the project types are missing from Visual Studio that they had in SSMS, even if they installed SSMS and Visual Studio as well</li>
<li>etc.</li>
</ul>
The answer is because these three environments are not the same. However they are built on nearly the same base, they are different because<br />
<ol>
<li><a href="http://msdn.microsoft.com/en-us/library/52f3sw5c(v=vs.90).aspx" target="_blank">Visual Studio 2008</a> is a set of development tools.</li>
<li>SSMS uses an <a href="http://msdn.microsoft.com/en-us/library/bb685691(v=vs.90).aspx" target="_blank">isolated Visual Studio Shell</a>, including 3 own project types.</li>
<li>BIDS uses an <a href="http://msdn.microsoft.com/en-us/library/bb129445(v=vs.90).aspx" target="_blank">integrated Visual Studio Shell</a>, and is able to handle the BI related project types. However these projects can be used in VS2008 as well, if both installed.</li>
</ol>
SSMS and BIDS are <strong><em>not</em></strong> extensions of Visual Studio. They are separate applications running Visual Studio Shell.<br />
<br />
For a better understading and more information on the VS Shell and SSMS:<br />
<ul>
<li>Visual Studio Integration SDK: <a href="http://msdn.microsoft.com/en-us/library/bb685612(v=vs.90).aspx">Visual Studio Shell-Based Applications</a></li>
<li>SQL Server 2008 R2 Books Online: <a href="http://msdn.microsoft.com/en-us/library/ms174206.aspx">Files that manage solutions and projects</a></li>
</ul>
Regarding BIDS: as of 15th Feb 2012, the <a href="http://msdn.microsoft.com/en-us/library/ms173767.aspx" target="_blank">Books Online</a> is wrong. It states that BIDS (for SQL Server 2008 and SQL Server 2008 R2) is "Visual Studio 2008 with additional project types".<br />
<br />
No, it is not. For those who already read themselves through the links given above, it might be clear.<br />
<br />
By the way, BIDS and its BI project types (Reporting Server, Analyis Services, Integration Services and 4 others) can be installed using the SQL Server installation utility. SSMS as well.<br />
A SQL Server Developer Edition costs about <a href="http://www.microsoftstore.com/store/msstore/en_US/pd/productID.221634300" target="_blank">$50 per developer</a>.<br />
<br />
Hope it helped.<br />
<br />
[Update: There is no BIDS for SQL Server 2012. Instead, there is <a href="http://addictivemeasures.blogspot.co.uk/2012/03/you-can-find-bids-features-in-sql.html" target="_blank">another tool</a>.]Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com3tag:blogger.com,1999:blog-3515627553035330576.post-36048418518163953712012-02-11T00:36:00.000+01:002012-02-11T00:36:09.521+01:00New SSIS Wiki pages for you, and a surprise for meI have continued to add content to Technet Wiki this week, and I just spot that I'm on the <a href="http://social.technet.microsoft.com/wiki/contents/articles/default.aspx" target="_blank">leaderboard</a>. Very funny - it seems I'm more active this week than Ed Price. He must be on holiday or something :)<br />
<em>OK, I have created less popular articles, but hey - he is an Official Wiki Ninja!</em> :) [LOL, nice acronym.]<br />
<br />
Anyway, it's not unthinkable that I'll get higher on this list since there is a lot of things to write and link <a href="http://social.technet.microsoft.com/wiki/contents/articles/6752.ssis-list-of-transformations.aspx" target="_blank">here</a>.<br />
If you're interested in SSIS transformations, and you would like to see short summaries including references to the details, just follow the link.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com1tag:blogger.com,1999:blog-3515627553035330576.post-6007467290776790282012-02-07T07:00:00.001+01:002012-02-07T07:00:07.331+01:00SSIS Transformations Wiki: Conditional SplitAgain, I added a new page to Technet Wiki.<br />
<br />
The second page is about the <a href="http://social.technet.microsoft.com/wiki/contents/articles/7288.ssis-conditional-split-transformation.aspx" target="_blank">Conditional Split transformation</a>.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-69532023671148433582012-02-07T04:55:00.000+01:002012-02-07T04:55:17.973+01:00Gallery script: List all SSIS packages in MSDB (SQL 2008-2012)Just uploaded a small contribution to the <a href="http://gallery.technet.microsoft.com/List-all-SSIS-packages-in-901addce" target="_blank">Technet Gallery</a>. It was created <a href="http://gallery.technet.microsoft.com/List-all-SSIS-packages-3b247394" target="_blank">originally by Olaf Helper</a>, however it was working on SQL Server 2005 only.<br />
<br />
So <a href="http://gallery.technet.microsoft.com/List-all-SSIS-packages-in-901addce" target="_blank">this script</a> will list the SSIS packages stored in the MSDB from SQL Server 2008 to 2012, with some additional details:<br />
<ul style="text-align: justify;"><li><span>Package type</span> </li>
<li><span>Owner name</span> </li>
<li><span>Encryption</span> </li>
<li><span>Date of creation</span> </li>
<li><span>Version</span> </li>
<li><span>Version comment</span> </li>
<li><span>Package size in bytes</span></li>
</ul><span>This script fails on SQL 2005.</span><br />
<span>I checked the <a href="http://msdn.microsoft.com/en-us/library/ms181582(v=sql.110).aspx" target="_blank">documentation</a> of SQL 2012, and it is subject to change, but it seems that the system table names for the MSDB package won't be modified.</span>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com1tag:blogger.com,1999:blog-3515627553035330576.post-35836028427125224652012-02-06T19:30:00.009+01:002012-03-28T17:16:32.567+02:00Analysis Server Properties A-Z: CollationName<div style="text-align: justify;">
<strong>The official documentation says...</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
This property is "<em>A string property that identifies the server collation.</em>" according to <a href="http://msdn.microsoft.com/en-us/library/ms174921.aspx" target="_blank">the documentation</a>.<br />
It is a property which can have a value from the Windows collation list. For those who are familiar only with the SQL engine: Analysis Services supports only Windows collations - no SQL collations are allowed.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<div style="text-align: justify;">
<strong>How and where it can be set?</strong><br />
In the Language/Collation page of the Analysis Server Properties window:<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZ0rwy5TeTIQE5q6kKxuJdvEDoJLjhyOHYSUQsfpyonHKgMSwuR_onCulNa3Hw1NBEabJTkVVvg7nXu43hg097ZIsGh1dMmpXC3FaDDiq-N_Pg9LY8nA_nNAHEYqDNPT42G66cHn4eYYhF/s1600/SSASProperties01Collation.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="287px" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZ0rwy5TeTIQE5q6kKxuJdvEDoJLjhyOHYSUQsfpyonHKgMSwuR_onCulNa3Hw1NBEabJTkVVvg7nXu43hg097ZIsGh1dMmpXC3FaDDiq-N_Pg9LY8nA_nNAHEYqDNPT42G66cHn4eYYhF/s320/SSASProperties01Collation.PNG" width="320px" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Analysis Server Properties - Language/Collation page</td></tr>
</tbody></table>
</div>
<div>
<strong>What happens if the value of this parameter changes?</strong></div>
<div style="text-align: justify;">
<br /></div>
This change will be applied in the <CollationName> tag of msmdsrv.ini. A change in collation can affect sorting and character comparison. Just for an example, "fruit" and "Fruit" won't be the same if you set a case-sensitive collation (check out <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/02/15/mind-that-collation-ssas.aspx" target="_blank">this related post</a> of Jamie Thomson).<br />
If you don't specify collation from the client side, then this will be the collation used in the session, which also affects sorting.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Restart needed to apply changes:</strong></div>
<div style="text-align: justify;">
No. Your changes are applied immediately.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<div style="text-align: justify;">
<strong>Category:</strong></div>
<div style="text-align: justify;">
N/A. It's a property which is not on the General page.</div>
<br />
<strong>Default Value:</strong></div>
<div style="text-align: justify;">
The value of this property is specified during installation, when Latin1_General_CI_AS is offered by default.</div>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-5904667510855541152012-02-06T12:38:00.000+01:002012-03-28T17:16:13.089+02:00Analysis Server Properties A-Z: AllowedBrowsingFolders<div style="text-align: justify;">
<strong>The official documentation says...</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
As the official documentation says <a href="http://msdn.microsoft.com/en-us/library/ms174921.aspx" target="_blank">here</a>, the AllowedBrowsingFolders property is "<em>A string property that defines the names of the folders where logs, backups, and other objects are allowed to be created on the server, in the form of a comma-separated list.</em>"</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
But well, it's a <em>pipe-separated</em> list.</div>
<div style="text-align: justify;">
<br />
<strong>How and where it can be set?</strong><br />
In the General page of the Analysis Server Properties window, after the "Show Advanced (All) Properties" checkbox had been set:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiA7iavoGDNfvJaBHVyySDUWqC1Pi5FDPxmW7WvRKxspBMLZWThgIydTkvdkHIm0cHkxofyY-Ur41mK77EKQ0UrAau92iADWZigxFDHHf6uJRDzRXLz9KKqrciOHmZqTR0snLedXublFIlk/s1600/SSASProperties02AllowedBrowsingFolders.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="287px" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiA7iavoGDNfvJaBHVyySDUWqC1Pi5FDPxmW7WvRKxspBMLZWThgIydTkvdkHIm0cHkxofyY-Ur41mK77EKQ0UrAau92iADWZigxFDHHf6uJRDzRXLz9KKqrciOHmZqTR0snLedXublFIlk/s320/SSASProperties02AllowedBrowsingFolders.PNG" width="320px" /></a></div>
<br />
This change will be written into the msmdsrv.ini file, in the <AllowedBrowsingFolders> tag.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>
<div style="text-align: justify;">
<strong>What happens if the value of this parameter changes?</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
For example, when you connect to your instance with SSMS, and add a new database, you will be prompted for the storage location of the new database:</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeRgHHF-KZLoReI1J84L7Jlevw1MwVhS34R-F5fzmHBY3B14iOylD3BUeU-L1pOq1c5iGZI_-0RSAaJjM1bYNeoyFBNxpGhI1RJC1HSNUIWirRZfwmpQVSQvgG8sQC9XalkdjCWcysgGZj/s1600/SSASNewDatabase.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="287px" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeRgHHF-KZLoReI1J84L7Jlevw1MwVhS34R-F5fzmHBY3B14iOylD3BUeU-L1pOq1c5iGZI_-0RSAaJjM1bYNeoyFBNxpGhI1RJC1HSNUIWirRZfwmpQVSQvgG8sQC9XalkdjCWcysgGZj/s320/SSASNewDatabase.PNG" width="320px" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Analysis Services New Database dialog</td></tr>
</tbody></table>
When you click the ellipsis button, a list will appear where you can select the location of the new Analysis Services database:<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZIRqjNanYQfkWRQnBpf2DpXDTPuZbVQUVaOYyT0jjnJ4cUaEadEV8g_AuQy5ZiK8BBD5bR1VktxOzFRDCaCahBYIxjAsNqFFrevk3d2UXvUuKzrWL2k_y8qokYIiKGGqbkMv3wjYJ7LIO/s1600/SSASNewDatabaseBrowseForRemoteFolder.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="389px" nfa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZIRqjNanYQfkWRQnBpf2DpXDTPuZbVQUVaOYyT0jjnJ4cUaEadEV8g_AuQy5ZiK8BBD5bR1VktxOzFRDCaCahBYIxjAsNqFFrevk3d2UXvUuKzrWL2k_y8qokYIiKGGqbkMv3wjYJ7LIO/s400/SSASNewDatabaseBrowseForRemoteFolder.PNG" width="400px" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Browse for Remote Folder dialog</td></tr>
</tbody></table>
<br />
<div style="text-align: justify;">
The AllowedBrowsingFolders property controls this list, so only items defined in the Analysis Services Properties window at this property can be seen here.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Restart needed to apply changes:</strong></div>
<div style="text-align: justify;">
No. Your changes are applied immediately.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Category:</strong></div>
<div style="text-align: justify;">
Advanced</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Default Value:</strong></div>
<div style="text-align: justify;">
"\data". This is a relative path to your Analyis Services installation folder.</div>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-78036000817659511272012-02-06T11:00:00.000+01:002012-02-06T11:00:35.213+01:00SSIS Transformations Wiki: Union AllI just added a new page to Technet Wiki. I plan to add all transformations of SSIS, however someone might be faster :)<br />
<br />
The first page is about the Union All transformation, you can read it <a href="http://social.technet.microsoft.com/wiki/contents/articles/7257.ssis-union-all-transformation.aspx" target="_blank">here</a>.Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-67876065801711189402012-01-25T12:11:00.000+01:002012-01-25T12:11:25.299+01:002012-03-07: SQL Server 2012 Virtual Launch EventYeah, at last we have a date! :)<br />
<a href="http://www.sqlserverlaunch.com/ww/Home">http://www.sqlserverlaunch.com/ww/Home</a>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-831229930654474362012-01-25T11:49:00.003+01:002012-01-25T15:42:31.598+01:00Untrusted foreign keys in Reporting ServicesThis week one of my colleagues, <a href="http://iamberke.com/" target="_blank">Janos Berke</a> mentioned <a href="http://www.brentozar.com/blitz/" target="_blank">a script from Brent Ozar</a>. Since I have a quite fresh sandbox of SQL Server 2008 R2, I became curious what the takeover script will find.<br />
This instance is on a dev box, so SSDE, SSAS, SSIS, and SSRS are installed as well.<br />
The result wasn't shocking, however it was very interesting.<br />
The ReportServer and ReportServerTempDB databases of SSRS contain <em>untrusted foreign keys right after installation</em>.<br />
<br />
<span style="font-family: inherit;">It is not a big issue, you might think. You might be right. But the fact that the result of Brent Ozar's script includes issues regarding your SSRS databases is very annoying :)</span><br />
<span style="font-family: inherit;">It's easy to correct the issue... Just an example:</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: blue;"><span style="color: blue;"><span style="color: blue;"><span style="color: blue;">ALTER</span></span><span style="color: black;"> </span><span style="color: blue;"><span style="color: blue;">T</span></span>ABLE</span></span> [ReportServer].[dbo].[Catalog] <span style="color: blue;"><span style="color: blue;">WITH</span></span> <span style="color: blue;"><span style="color: blue;">CHECK</span></span> <span style="color: blue;"><span style="color: blue;">CHECK</span></span> <span style="color: blue;"><span style="color: blue;">CONSTRAINT</span></span></span><span style="font-family: "Courier New", Courier, monospace;"> [FK_Catalog_ParentID]</span><br />
<br />
<span style="font-family: inherit;">..., etc. I hope you can fabricate the rest. (The double "<span style="color: blue; font-family: Courier New;">CHECK</span>" is not a typo.)</span><br />
<br />
<span style="color: blue;"><span style="color: blue;"><span style="color: red;"><span style="color: red;"><span style="color: black;"><span style="font-family: inherit;">I reported this on </span></span><a href="https://connect.microsoft.com/SQLServer/feedback/details/720699" target="_blank"><span style="color: blue; font-family: inherit;"><span style="font-family: inherit;">Connect</span></span></a><span style="color: black;"><span style="font-family: inherit;"><span style="font-family: inherit;"> - hopefully no cleanup</span> will be needed in future releases.</span></span></span></span></span></span><br />
<br />
<span style="color: blue;"><span style="color: blue;"><span style="color: red;"><span style="color: red;"><span style="color: black;"><span style="font-family: inherit;">...ah, all right, here is a script which will have a result with all necessary statements :)</span><br />
<br />
<span style="font-family: inherit;"><span style="color: blue; font-size: x-small;"><span style="color: blue; font-size: x-small;"><span style="font-family: "Courier New", Courier, monospace; font-size: small;">SELECT</span></span></span><span style="font-family: "Courier New", Courier, monospace;"> <span style="color: red;"><span style="color: red;">'ALTER TABLE [ReportServer].['</span></span> <span style="color: grey;"><span style="color: grey;">+</span></span> s<span style="color: grey;"><span style="color: grey;">.</span></span>name <span style="color: grey;"><span style="color: grey;">+</span></span> <span style="color: red;"><span style="color: red;">'].['</span></span> <span style="color: grey;"><span style="color: grey;">+</span></span> o<span style="color: grey;"><span style="color: grey;">.</span></span>name <span style="color: grey;"><span style="color: grey;">+</span></span> <span style="color: red;"><span style="color: red;">'] WITH CHECK CHECK CONSTRAINT ['</span></span> <span style="color: grey;"><span style="color: grey;">+</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>name <span style="color: grey;"><span style="color: grey;">+</span></span> <span style="color: red;"><span style="color: red;">']'</span></span> <span style="color: blue;"><span style="color: blue;">AS</span></span> Command <span style="color: blue;"><span style="color: blue;">FROM</span></span> ReportServer<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">sys</span></span><span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">foreign_keys</span></span> i <span style="color: grey;"><span style="color: grey;">INNER</span></span> <span style="color: grey;"><span style="color: grey;">JOIN</span></span> ReportServer<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">sys</span></span><span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">objects</span></span> o <span style="color: blue;"><span style="color: blue;">ON</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>parent_object_id <span style="color: grey;"><span style="color: grey;">=</span></span> o<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: magenta;"><span style="color: magenta;">object_id</span></span> <span style="color: grey;"><span style="color: grey;">INNER</span></span> <span style="color: grey;"><span style="color: grey;">JOIN</span></span> ReportServer<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">sys</span></span><span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">schemas</span></span> s <span style="color: blue;"><span style="color: blue;">ON</span></span> o<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: magenta;"><span style="color: magenta;">schema_id</span></span> <span style="color: grey;"><span style="color: grey;">=</span></span> s<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: magenta;"><span style="color: magenta;">schema_id</span></span> <span style="color: blue;"><span style="color: blue;">WHERE</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>is_not_trusted <span style="color: grey;"><span style="color: grey;">=</span></span> 1 <span style="color: grey;"><span style="color: grey;">AND</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>is_not_for_replication <span style="color: grey;"><span style="color: grey;">=</span></span> 0</span></span><br />
<span style="color: blue;"><span style="color: blue;"><span style="font-family: "Courier New", Courier, monospace;">UNION</span></span></span><span style="font-family: "Courier New", Courier, monospace;"> <span style="color: grey;"><span style="color: grey;">ALL</span></span></span><br />
<span style="color: blue;"><span style="color: blue;"><span style="font-family: "Courier New", Courier, monospace;">SELECT</span></span></span><span style="font-family: "Courier New", Courier, monospace;"> <span style="color: red;"><span style="color: red;">'ALTER TABLE [ReportServerTempDB].['</span></span> <span style="color: grey;"><span style="color: grey;">+</span></span> s<span style="color: grey;"><span style="color: grey;">.</span></span>name <span style="color: grey;"><span style="color: grey;">+</span></span> <span style="color: red;"><span style="color: red;">'].['</span></span> <span style="color: grey;"><span style="color: grey;">+</span></span> o<span style="color: grey;"><span style="color: grey;">.</span></span>name <span style="color: grey;"><span style="color: grey;">+</span></span> <span style="color: red;"><span style="color: red;">'] WITH CHECK CHECK CONSTRAINT ['</span></span> <span style="color: grey;"><span style="color: grey;">+</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>name <span style="color: grey;"><span style="color: grey;">+</span></span> <span style="color: red;"><span style="color: red;">']'</span></span> <span style="color: blue;"><span style="color: blue;">AS</span></span> Command <span style="color: blue;"><span style="color: blue;">FROM</span></span> ReportServerTempDB<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">sys</span></span><span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">foreign_keys</span></span> i <span style="color: grey;"><span style="color: grey;">INNER</span></span> <span style="color: grey;"><span style="color: grey;">JOIN</span></span> ReportServerTempDB<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">sys</span></span><span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">objects</span></span> o <span style="color: blue;"><span style="color: blue;">ON</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>parent_object_id <span style="color: grey;"><span style="color: grey;">=</span></span> o<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: magenta;"><span style="color: magenta;">object_id</span></span> <span style="color: grey;"><span style="color: grey;">INNER</span></span> <span style="color: grey;"><span style="color: grey;">JOIN</span></span> ReportServerTempDB<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">sys</span></span><span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: green;"><span style="color: green;">schemas</span></span> s <span style="color: blue;"><span style="color: blue;">ON</span></span> o<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: magenta;"><span style="color: magenta;">schema_id</span></span> <span style="color: grey;"><span style="color: grey;">=</span></span> s<span style="color: grey;"><span style="color: grey;">.</span></span><span style="color: magenta;"><span style="color: magenta;">schema_id</span></span> <span style="color: blue;"><span style="color: blue;">WHERE</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>is_not_trusted <span style="color: grey;"><span style="color: grey;">=</span></span> 1 <span style="color: grey;"><span style="color: grey;">AND</span></span> i<span style="color: grey;"><span style="color: grey;">.</span></span>is_not_for_replication <span style="color: grey;"><span style="color: grey;">=</span></span> 0</span></span></span></span></span></span>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com2tag:blogger.com,1999:blog-3515627553035330576.post-73748146890772999912012-01-23T17:50:00.005+01:002012-03-28T17:16:23.851+02:00Analysis Server Properties A-Z: BackupDir<div style="text-align: justify;">
<strong>The official documentation says...</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
As the official documentation says <a href="http://msdn.microsoft.com/en-us/library/ms174921.aspx" target="_blank">here</a>, the BackupDir property is "<em>A string property that identifies the name of the directory where backup files are created by default, in the event a path is not specified as part of the the Backup command.</em>"<br />
<br />
<strong>How and where it can be set?</strong><br />
In the General page of the Analysis Server Properties window. After connecting to your SSAS instance with SSMS, right-click on its node, and select Properties.<br />
<br />
<strong>What happens if the value of this parameter changes?</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Nothing immediately - except this change will be applied in the <BackupDir> tag of msmdsrv.ini. But later when you want to backup one of your databases with SSMS, you will be prompted for the backup file name: </div>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwpdYsvHlpcVtavyPeOEPcdaXeHkmrY30DOCShev-Aya0_qUhaAzNHztHzT10fIDtRIGHQXqNR28vRDPtO3G0e3BZCnx-z2sruOOi62wTlUMUySu4rD109CShmctDHKzZSjC1gOaVLhfQI/s1600/SSASBackupDatabase.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="358px" nfa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwpdYsvHlpcVtavyPeOEPcdaXeHkmrY30DOCShev-Aya0_qUhaAzNHztHzT10fIDtRIGHQXqNR28vRDPtO3G0e3BZCnx-z2sruOOi62wTlUMUySu4rD109CShmctDHKzZSjC1gOaVLhfQI/s400/SSASBackupDatabase.PNG" width="400px" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Backup Database dialog</td></tr>
</tbody></table>
<br />
<div style="text-align: justify;">
As you can see, no directory is explicitly set. It means that the backup file will be created in the folder specified in the BackupDir property. When you click the Browse button, a list will appear where you can select the location of the backup file:</div>
<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga86Fw2IGESkFaVETGi5uhgQgnviBdJJ1Ta7Jxa01hf1X7miqbo00eXarw0P11CAWTXcqh2aqN0zbJEFt06EECB9E-YhMN40UrPT-sRCsqIy0YHyusdgsKDOLAHRNYFS7dDFN6p7lVagAP/s1600/SSASSaveFileAs.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="400px" nfa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga86Fw2IGESkFaVETGi5uhgQgnviBdJJ1Ta7Jxa01hf1X7miqbo00eXarw0P11CAWTXcqh2aqN0zbJEFt06EECB9E-YhMN40UrPT-sRCsqIy0YHyusdgsKDOLAHRNYFS7dDFN6p7lVagAP/s400/SSASSaveFileAs.PNG" width="331px" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Backup SSAS database - Save File As dialog box</td></tr>
</tbody></table>
<div style="text-align: justify;">
The <a href="http://addictivemeasures.blogspot.com/2012/01/analysis-server-properties-z-1.html" target="_blank">AllowedBrowsingFolders property</a> controls this list, so only items defined in the Analysis Services Properties window at that property can be seen here. If you select an item here, it will be filled in the Backup file editbox:</div>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCElw0LjKBu1IkMa27Oak96UiixQ2HXRnMAVfYqp6uhj3DIvyJMd82qDlRvfqhv17gKDoCWUHElVVCKsRu8YrtcYvyJPWz_I8FhzzCM9xpMYafISPOS8ICZyIl2_lERYgqxMwhOn2ZxMz1/s1600/SSASBackupDatabase2.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="358px" nfa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCElw0LjKBu1IkMa27Oak96UiixQ2HXRnMAVfYqp6uhj3DIvyJMd82qDlRvfqhv17gKDoCWUHElVVCKsRu8YrtcYvyJPWz_I8FhzzCM9xpMYafISPOS8ICZyIl2_lERYgqxMwhOn2ZxMz1/s400/SSASBackupDatabase2.PNG" width="400px" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Backup Database dialog with a directory path applied</td></tr>
</tbody></table>
<div style="text-align: justify;">
<strong>Restart needed to apply changes:</strong></div>
<div style="text-align: justify;">
Yes. Your changes are applied only after a restart of the Analysis Services instance.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Category:</strong></div>
<div style="text-align: justify;">
Basic</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Default Value:</strong></div>
<div style="text-align: justify;">
None. The default value is empty.</div>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-22135392892743896932012-01-23T12:17:00.000+01:002012-01-23T12:17:30.008+01:00How to set the location of the SSIS top-level folders<div style="text-align: justify;">Look for the %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml file. Open it in any editor. By default, it will look like this:</div><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"><?xml version="1.0" encoding="utf-8"?><br />
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><br />
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown><br />
<TopLevelFolders><br />
<Folder xsi:type="SqlServerFolder"><br />
<Name>MSDB</Name><br />
<ServerName>.</ServerName><br />
</Folder><br />
<Folder xsi:type="FileSystemFolder"><br />
<Name>File System</Name><br />
<StorePath>..\Packages</StorePath><br />
</Folder><br />
</TopLevelFolders><br />
</DtsServiceConfiguration></span><br />
<br />
<div style="text-align: justify;">You can change the "." (localhost) to any of your SQL Servers. It's especially useful when this name can't be resolved, e.g. a clustered environment :) Or, if you would like to change the location of the File System folder, just simply replace the "..\Packages" to any other location which is accessible by the Integration Services service account.</div><div style="text-align: justify;">You can add, of course, additional top-level folders, if you follow the structure:</div><br />
<span style="font-family: Courier New; font-size: x-small;"> <Folder xsi:type="SqlServerFolder"><br />
<Name>MSDB-sqlserver2-1567</Name><br />
<ServerName>sqlserver2,1567</ServerName><br />
</Folder></span><br />
<div style="text-align: justify;">Of course, copying a <Folder> block, then changing its content means less effort :)</div><div style="text-align: justify;"><em><span style="font-size: x-small;">In this example, the number after the comma is the port (when you don't know the name of the SQL Server instance, or you don't want to use SQL Server Browser because there are only fixed ports set up). If you know the instance name, you can use the servername\instancename format as well.</span></em></div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">After you've set up everything, save this xml file, then restart the SSIS service. Your new top-level folders will be available after then.</div>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com0tag:blogger.com,1999:blog-3515627553035330576.post-34553856070037092242011-11-08T13:27:00.002+01:002012-01-23T15:57:29.932+01:00SQL Server 2012 LicensingThere are a few changes in the licensing options compared to SQL Server 2008 R2. Just to list the main changes:<br />
<ul><li>There will be no Datacenter Edition of SQL Server 2012. Customers should buy Enterprise Edition instead.</li>
<li>There will be three main editions: Standard Edition, BI Edition, and Enterprise Edition.</li>
<li>There will be no processor-based licenses. There will be core-based licenses and Server/CAL licenses.</li>
<li>BI Edition will be available only with the Server/CAL licensing option. The Enterprise Edition will be available only with the core-based licensing option. Standard will still be available with both.</li>
<li>The price of 4 core licenses of SQL Server 2012 will be around the price of a processor license of 2008.</li>
<li>The core licenses will be sold in as 2-core packs. Minimum amount to order is 4 cores (two 2-core packs) per physical processor.</li>
<li>The price of a CAL increases with around 25%.</li>
</ul>Sources:<br />
<ul><li><a href="http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx" target="_blank">Microsoft: SQL Server 2012 Editions</a></li>
<li><a href="http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx" target="_blank">Microsoft: SQL Server 2012 Licensing</a></li>
<li><a href="http://redmondmag.com/articles/2011/11/05/microsoft-unveils-sql-server-2012-licensing-and-pricing.aspx" target="_blank">Redmondmag.com</a></li>
<li><a href="http://biprojekt.hu/blog/SQL-Server-2012-BI-Edition.htm" target="_blank">BIprojekt.hu</a></li>
</ul>Zoltán Horváthhttp://www.blogger.com/profile/16113617283519624522noreply@blogger.com1