SQL Server Analysis Services お知らせ
SQL Server Compact お知らせ
SQL Server Express お知らせ
-
リンク
Hello,
Many thanks to Rick Byham who provided me these links :
- SQL Server 2008 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff
- SQL Server 2008 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336
- SQL Server 2008 R2 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b
- SQL Server 2008 R2 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135
I will try to update these links when a new Service Pack or SQL Server "Denali" ( 2011 ? ) will be released
SQL Server Master Data Services お知らせ
-
リンク
We are excited to share the new features which shipped in SQL CTP2.3 public release. You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343
In this monthly release, we added a few highly asked features. Please give it try and look forward to hearing your feedback.
Manage Business Rules (MDS Add-in for Excel)
In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).
Many-to-Many Relationships in Derived Hierarchies
You can now create a Derived Hierarchy that displays many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.
For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.
For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)
Merge Conflicts
If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel).
SQL Master Data Services Team
-
リンク
Please give it a try and let us know your feedback!
SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
In CTP2.2 MDS introduced following changes:
1. Custom Indexes
You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).
2. Entity Sync Relationship
You can share entity data between different models by creating an entity sync relationship. For more information, see Entity Sync Relationship (Master Data Services).
3. Member Revision History
A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).
-
リンク
Hi, we are pleasured to announce the release of MDS Excel add-in. You can download it here:
http://www.microsoft.com/en-us/download/details.aspx?id=42298
This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.
It works with both SQL12 or SQL14. The installation will be in place upgrade so the users don't need to uninstall previous installation. All the MDS connections will be preserved through the installation.
Please download the new version of Excel add-in. Your feedback is welcome!
Thanks,
SQL MDS Team
-
リンク
While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer." Please select this button when a reply answers your question.
There are several reasons to do this:
- Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
- You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
- You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.
You can also vote "Yes" or "No" if the reply was helpful.
Thank you!
Ed Hickey
SQL Server Migration お知らせ
-
リンク
Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.
SQL Server Notification Services お知らせ
-
リンク
The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.
Please use http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.
Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.(Attribution: Jang-uk In)
Hope that helps,
-Lukasz
SQL Server PowerPivot for SharePoint お知らせ
-
リンク
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
-
リンク
Some of you may have been waiting for the Windows 7 and Windows 2008 R2 QFE to be released before installing SharePoint 2010 and PowerPivot for SharePoint. The QFE has just been released!
To read more about how to install the QFE with SharePoint 2010, please see: http://blogs.msdn.com/opal/archive/2009/11/16/installation-notice-for-sharepoint-2010-public-beta.aspx.
Thanks ~
Kathy MacDonald
-
0 投票数
Calculated Mmber Aggregate Wildcard issues
= 1) --WILDCARD + FILTER([Date Dimension].[Date SOP Month].Members,Instr([Date Dimension].[Date SOP Month].CurrentMember.Name,"M2",1) >= 1) + FILTER([Date ...回答済み | 10 返信数 | 5027 表示数 | Created by Ismailc1 - 2020年6月8日 2:07 | 最新の返信 : Ismailc1 - 2020年8月30日 20:52 -
0 投票数
sys.dm_os_memory_pools pool_id
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-memory-pools-transact-sql?view=sql-server-ver15 By default pool_id 0 is internal ...質問 | 8 返信数 | 4962 表示数 | Created by sakurai_db - 2020年8月11日 4:02 | 最新の返信 : sakurai_db - 2020年8月30日 9:55 -
0 投票数
what's actually CMEMTHREAD
https://www.sqlskills.com/help/waits/cmemthread/ what's actually "TREAD-safe-memory-object" ?回答の候補 | 8 返信数 | 4877 表示数 | Created by sakurai_db - 2020年8月11日 8:38 | 最新の返信 : sakurai_db - 2020年8月28日 17:23 -
0 投票数
Multipage allocation vs Large Pageallocation
May I know Multipage allocation vs Large Pageallocation are the same concept ? Any example of what type of Multipage allocation are? I check in my ...回答の候補 | 16 返信数 | 5707 表示数 | Created by sakurai_db - 2020年8月11日 3:32 | 最新の返信 : sakurai_db - 2020年8月28日 8:39 -
0 投票数
DBCC memory status Current commited
May i know if the current committed will also include stack memory allocation ? (which is not control by max server memory ) ?回答済み | 15 返信数 | 5373 表示数 | Created by sakurai_db - 2020年8月11日 9:13 | 最新の返信 : sakurai_db - 2020年8月28日 8:38 -
0 投票数
Filter index question
I am comming to this example https://www.mssqltips.com/sqlservertip/2353/performance-advantages-of-sql-server-filtered-statistics/ CREATE TABLE ...質問 | 5 返信数 | 4149 表示数 | Created by sakurai_db - 2020年8月13日 6:12 | 最新の返信 : sakurai_db - 2020年8月28日 8:36 -
7 投票数
Microsoft.SqlServer.Management.IntegrationServices namespace
After several tries, I am unable to find the Microsoft.SqlServer.Management.IntegrationServices.dll or the namespace stated in the title. I am trying to write a C# application that ...回答済み | 43 返信数 | 22594 表示数 | Created by Bryan Shaw - 2012年5月15日 15:31 | 最新の返信 : Davide Piras - 2020年8月27日 9:25 -
0 投票数
Unable to connect to Integration services
Recently rebuilt my Windows 10 machine and I am no longer able to connect to Integration Services from SSMS when I was able to before. The error message I'm getting is the specified service does not ... -
9 投票数
SSIS package Just fails...not compatible with this version of the DataFlow?
Executed as user: x ...0.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:27:08 AM Error: 2013-01-09 ...回答済み | 19 返信数 | 20229 表示数 | Created by justin1681 - 2013年1月9日 17:39 | 最新の返信 : Ashwin Y - 2020年8月25日 18:19 -
2 投票数
SQL Server 2016 slower than SQL Server 2008
I have two databases with the same data, one on an SQL Server 2008 R2 instance, and one on an SQL Server 2016 instance. Both SQL Server instances are on the same machine, and the database files are on ...質問 | 31 返信数 | 15243 表示数 | Created by pappasa - 2018年3月22日 8:14 | 最新の返信 : jchang61 - 2020年8月25日 17:09 -
2 投票数
Log shipping secondary database created in the wrong location (2008 r2)
Primary SQL Server 2008 r2 Secondary SQL Server 2008 r2 Secondary Database Default locations; Data: D:\SQLData Log: ...回答済み | 7 返信数 | 6804 表示数 | Created by Eric Labashosky - 2014年9月24日 20:50 | 最新の返信 : cjmorgant1101 - 2020年8月25日 16:56 -
0 投票数
dm_os_ring_buffers :RING_BUFFER_OOM'
;WITH rb AS ( SELECT CAST (record as xml) record_xml FROM sys.dm_os_ring_buffers WHERE ring_buffer_type = ...質問 | 4 返信数 | 4606 表示数 | Created by sakurai_db - 2020年8月12日 9:56 | 最新の返信 : sakurai_db - 2020年8月25日 9:47 -
0 投票数
SQL Server resource pool MAX_MEMORY_PERCENT
MIN_MEMORY_PERCENT and MAX_MEMORY_PERCENT These settings are the minimum and maximum amount of memory reserved for the resource pool that can not be shared with ...回答済み | 3 返信数 | 4731 表示数 | Created by sakurai_db - 2020年8月12日 9:14 | 最新の返信 : sakurai_db - 2020年8月25日 9:46 -
0 投票数
Keeping Dynamic DateTime Variable "Static"
In one step of an SSIS package, i create an outgoing XLS filename based on the current datetime setting, a la: "myFileName_" + (DT_WSTR,4)YEAR( ...質問 | 5 返信数 | 9347 表示数 | Created by SethHersh - 2007年4月28日 14:20 | 最新の返信 : Laxmidhar sahoo - 2020年8月25日 9:19 -
0 投票数
Value cannot be null. Parameter name: value (mscorlib)
Hello, I'll try to start PowerShell for Integration services Catalog and i'll get this error ...回答済み | 2 返信数 | 5936 表示数 | Created by Adghar - 2020年3月30日 12:35 | 最新の返信 : Koen Verbeeck - 2020年8月25日 7:01 -
0 投票数
Create multiple sets and union them in MDX
I need to create 2 sets. first set for DD cards which should be affected by DD Date only. and Set2 is Cash load cards which should only affected by Cash loads date. then, union of both sets. ...回答済み | 8 返信数 | 4481 表示数 | Created by Prajwal Potula - 2020年8月14日 18:40 | 最新の返信 : Darren Gosbell - 2020年8月25日 1:56 -
0 投票数
How to supress rows with 0 values. All measures, fact and calculated, are 0
The cube going into browser or Excel, shows the ...回答済み | 5 返信数 | 8778 表示数 | Created by Maria Luz MUNOZ - 2015年7月2日 23:46 | 最新の返信 : issue while adding report server extension vs2019 - 2020年8月24日 12:29 -
0 投票数
SSAS MDX query
Hi Everyone, I have following query regarding mdx, My Dimension having structure and data ...質問 | 3 返信数 | 3743 表示数 | Created by Vidya mane - 2015年2月16日 11:06 | 最新の返信 : issue while adding report server extension vs2019 - 2020年8月24日 12:01 -
0 投票数
[SharePoint List Source [296]] Error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.
I have a running package which reads data from SharePoint List and dumps into SQL tables. I have 3 new list columns which I want to update into SQL table. 1) I opened ...回答の候補 | 8 返信数 | 5227 表示数 | Created by ShahidAliK - 2020年8月10日 12:02 | 最新の返信 : ShahidAliK - 2020年8月24日 9:46 -
0 投票数
how to find out that SSIS Installed in SQLServer Using C#?
i'm writing a windows form application using C# . i use ssisServer = new IntegrationServices(ssisConnection); To run and working with SSIS ...回答済み | 5 返信数 | 5473 表示数 | Created by Shahram_Soft - 2020年8月9日 7:34 | 最新の返信 : Shahram_Soft - 2020年8月24日 8:22 - アイテム 1 に 20 の 199888 次へ ›
SQL Server Analysis Services お知らせ
SQL Server Compact お知らせ
SQL Server Express お知らせ
-
リンク
Hello,
Many thanks to Rick Byham who provided me these links :
- SQL Server 2008 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff
- SQL Server 2008 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336
- SQL Server 2008 R2 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b
- SQL Server 2008 R2 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135
I will try to update these links when a new Service Pack or SQL Server "Denali" ( 2011 ? ) will be released
SQL Server Master Data Services お知らせ
-
リンク
We are excited to share the new features which shipped in SQL CTP2.3 public release. You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343
In this monthly release, we added a few highly asked features. Please give it try and look forward to hearing your feedback.
Manage Business Rules (MDS Add-in for Excel)
In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).
Many-to-Many Relationships in Derived Hierarchies
You can now create a Derived Hierarchy that displays many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.
For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.
For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)
Merge Conflicts
If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel).
SQL Master Data Services Team
-
リンク
Please give it a try and let us know your feedback!
SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
In CTP2.2 MDS introduced following changes:
1. Custom Indexes
You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).
2. Entity Sync Relationship
You can share entity data between different models by creating an entity sync relationship. For more information, see Entity Sync Relationship (Master Data Services).
3. Member Revision History
A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).
-
リンク
Hi, we are pleasured to announce the release of MDS Excel add-in. You can download it here:
http://www.microsoft.com/en-us/download/details.aspx?id=42298
This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.
It works with both SQL12 or SQL14. The installation will be in place upgrade so the users don't need to uninstall previous installation. All the MDS connections will be preserved through the installation.
Please download the new version of Excel add-in. Your feedback is welcome!
Thanks,
SQL MDS Team
-
リンク
While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer." Please select this button when a reply answers your question.
There are several reasons to do this:
- Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
- You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
- You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.
You can also vote "Yes" or "No" if the reply was helpful.
Thank you!
Ed Hickey
SQL Server Migration お知らせ
-
リンク
Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.
SQL Server Notification Services お知らせ
-
リンク
The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.
Please use http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.
Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.(Attribution: Jang-uk In)
Hope that helps,
-Lukasz
SQL Server PowerPivot for SharePoint お知らせ
-
リンク
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
-
リンク
Some of you may have been waiting for the Windows 7 and Windows 2008 R2 QFE to be released before installing SharePoint 2010 and PowerPivot for SharePoint. The QFE has just been released!
To read more about how to install the QFE with SharePoint 2010, please see: http://blogs.msdn.com/opal/archive/2009/11/16/installation-notice-for-sharepoint-2010-public-beta.aspx.
Thanks ~
Kathy MacDonald