Data Mining announcements
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
SQL Server Reporting Services, Power View announcements
-
Link
We have released a beta version of the Reporting Services Migration Tool. The tool is available for download at:
http://www.microsoft.com/download/en/details.aspx?id=29560
This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server. Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.). Some additional details are in this blog post, along with the download link:
http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx
We are working on enabling more features in this tool, so feel free to share any feedback or report any issues. Thanks!
-
Link
Last Update: Mar 4, 2011.
SQL Server 2008 R2 was released to manufacturing on April 21, 2010. You can read more about it here.
Downloads available:
- Report Builder 3.0 RTM
- SQL Server 2008 R2 RTM - Developer Trial Edition
- SQL Server 2008 R2 RTM - Express Edition with Advanced Services
- SQL Server 2008 R2 RTM - Documentation
- SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
- Reporting Services 2008 R2 Add-in for SharePoint 2010
- Visual Studio 2010 Report Viewer Redistributable
Cumulative Updates:
-
SQL Server 2008 R2 RTM Cumulative Update #6 (build 10.50.1765)
-
SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
- SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
- SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
- SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
- SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)
You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP. You can research and ask questions on the dedicated MSDN forum.
-
Link
When posting questions in this forum, please include the version of SQL Server Reporting Services you are using. This will help us be more efficient in answering questions. If you are using the Report Viewer Control, it will helpful if you include the version of the control as well.
Thanks,
Sean -
Link
Last update: Mar 27, 2011.
Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services!
Important downloads for Reporting Services 2008:
SP2:
- Report Builder 2.0 (SP2 Download)
for Reporting Services 2008 (build 10.00.4000)
- SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
- SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
- SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
- Download SQL Server 2008 SP2
- Download SQL Server 2008 SP2 Express
- Download SQL Server 2008 SP2 Feature Packs
- RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000)
Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
SP1:
- RS 2008 SP1 Add-In for SharePoint Integrated Mode (build 10.00.2531)
Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
- SQL Server 2008 SP1 Cumulative Update #13 (build 10.00.2816)
- SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
- SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
- SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
- SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)
- SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)
- SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)
- SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)
- SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
- SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
- SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723)
- SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714)
- SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
- SQL Server 2008 Service Pack 1 (build 10.00.2531)
RTM:
- SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)
- SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)
- SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
- SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
- SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
- SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
- SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
- SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787)
- SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
- SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
- SQL Server 2008 RTM (build 10.00.1600.22)
- Updated SQL Server 2008 Books Online (July 2009 Update)
Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release. - Report Builder 2.0 (SP2 Download)
-
Link
Last update: Mar 27, 2011.
MSDN information aggregator site for Reporting Services 2005.
Important downloads for Reporting Services 2005:
SP4:
- SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
- SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
- SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
- SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)
SP3:
- SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325)
- SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317)
- SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315)
- SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
- SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309)
- SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)
- SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)
- SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)
- SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)
- SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)
- SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230)
- SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)
- SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)
- SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)
- SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207)
- SQL Server 2005 SP3 RTM (build 9.00.4035)
SP2:
- SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2
- SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)
- SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)
- SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328)
- SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325)
- SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315)
- SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301)
- SQL Server 2005 SP2 RTM (build 9.00.3042)
- RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download)
- SQL Server 2005 Books Online (December 2008 Update)
SQL Server Analysis Services announcements
.NET Framework inside SQL Server announcements
-
Link
This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.
Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads
Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/
Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads
Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads
Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads
Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads
Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads
Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads
Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.
SQL Server Replication announcements
SQL Server Setup & Upgrade announcements
-
Link
- Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
- What's new.(Why upgrade)
SQL Server Notification Services announcements
-
Link
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 Compact announcements
SQL Server Express announcements
-
Link
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 Samples and Community Projects announcements
-
Link
Welcome to the SQL Server Samples and Community Projects Forum.
This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.
Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.
- Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
- Try searching the forum . Search the forum to see if your question has been asked before and answered. If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
- Don't be brief . The more information you can give in your question, the better the response will be.
- Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
- No Spam. Spamming will have your thread deleted and may also result in your account being banned.
- Be polite. You will get better assistance if you're polite to other members so no flaming or trolling. If you persist with flaming or trolling, your accountmay get banned.
- Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question. Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.
Dead thread/Answer policy.
Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.
Setting up your alerts
If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice. -
Link
All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.
For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx -
Link
This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.
Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.
Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.
Let us know what's missing, let know what could be better and let us know what we're doing right!
Database Design announcements
-
Link
The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.
Books
A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
Eric Johnson and Joshua Jones
An Introduction to Database Systems
Chris Date
Applied Mathematics for Database Professionals
Lex de Haan, Toon Koppelaars
Architecting Regulatory-Compliant Architectures
Mike Walker, MicrosoftGraeme Simsion and Graham Witt
Database Modeling and Design: Logical Design
Toby Teorey
Information Modeling and Relational Databases
Terry Halpin
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Fabian Pascal
Pro SQL Server 2008 Relational Database Design and Implementation
Louis Davidson, Kevin Kline, et al
Online Resources
A Simple Guide to Five Normal forms and Relational Database Theory
http://www.bkent.net/Doc/simple5.htmData Modeling vs. Database Design
http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.htmlData Models
http://www.databaseanswers.org/data_models/index.htmDatabase Design - Ten Common Database Design Mistakes, Louis Davidson
http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/Database Design Issues -EAV Model Discussion (Querying an EAV Table)
http://tinyurl.com/yks8huDatabase Design Issues –EAV and OTLT
http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.htmlDatabase Design ROI by Paul Nielsen
http://www.sqlserverbible.com/files/databasedesignroi.pdfIntroduction to the Unified Dimensional Model (UDM)
http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspxLibrary of database models
http://www.databaseanswers.org/data_models/On Normalization and Repeating Groups by Fabian Pascal
http://www.dbdebunk.com/page/page/622318.htmORM white paper
http://www.orm.net/pdf/ORMwhitePaper.pdfOverview of the Relational Model
http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.htmlUnderstanding Data Model Quality, Graeme Simsion
http://www.tdan.com/view-articles/5100 -
Link
Out of Scope
Some topics are out of scope for this forum.
1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:
https://connect.microsoft.com/SQLServer
Rules of Conduct
· Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.
· Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.
· Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.
· Confidentiality: Confidential information should not be posted. This is a publicly available forum.
· Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.
· Advertising/Solicitation: Advertisements should not be posted, and will be removed.
Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.
Marking AnswersBy their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.
Welcome to the Database Design Forum
This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.
We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.
In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.
But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.
We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.
Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.
SQL Server Migration announcements
-
Link
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 Master Data Services announcements
-
Link
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
-
Link
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).
-
Link
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
-
Link
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
Power Pivot announcements
-
Link
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
-
Link
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services -
Link
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.
The solution is to upgrade the beta components to their released versions when they become available.
SQL Server PowerPivot for SharePoint announcements
-
Link
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.
-
Link
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 Votes
Ntvdm illegal instruction at import in file in cmd
C:\WINDOWS\system32\cmd.exe - mysql -u root olymnusdb1 -p The NTVDM CPU has encountered an illegal instruction. CS:0dfa IP:0105 OP:63 75 6d 65 6e Choose ... -
0 Votes
OLE DB Destination fails with illegal instruction
in the status screen. during the execution SQLDumper.exe is triggered. Analyzing the dump tells me: (2b40.2938): Illegal instruction - code c000001d ...Unanswered | 4 Replies | 6282 Views | Created by lwulfers - Wednesday, July 26, 2006 3:35 PM | Last reply by Duane Douglas - Saturday, September 2, 2006 6:27 AM -
0 Votes
Illegal Character in flat file cause truncating the row
As Exception ' Do whatever you want with the exceptionAnswered | 8 Replies | 6387 Views | Created by Mehdi Entezary - Wednesday, January 7, 2009 7:42 PM | Last reply by VentsyV - Friday, January 9, 2009 5:46 PM -
0 Votes
SQL 2005 x64 exception
and register DLL's again. Now at last two exception is not the same situation. Can you see something from there with "Non-yielding Scheduler". Is it also possible that it ...Proposed | 13 Replies | 1538 Views | Created by ast12 - Friday, April 25, 2014 1:19 PM | Last reply by ast12 - Sunday, May 4, 2014 8:10 PM -
0 Votes
SQL 08 R2 Standard x64 installation failure - "Illegal characters in path"
System.ArgumentException: IllegalAnswered | 4 Replies | 7984 Views | Created by Chad Hilton - Wednesday, October 19, 2011 4:37 PM | Last reply by MuradQerib - Sunday, July 5, 2015 2:09 PM -
0 Votes
Begin and Commit Tan
Hi, What impact on performance or what issue occurs when we doesnt take begin tran and commit trant in procedure(Insert,update,Select) ThanksAnswered | 7 Replies | 3622 Views | Created by SunitaA - Wednesday, July 6, 2011 10:13 AM | Last reply by SunitaA - Wednesday, July 6, 2011 11:31 AM -
0 Votes
SqlDataSource.FilterExpression causing exception on DataBind
= '1/1/2009' AND CreatedOnAnswered | 2 Replies | 5063 Views | Created by P.Brian.Mackey - Wednesday, January 14, 2009 3:35 PM | Last reply by P.Brian.Mackey - Thursday, January 15, 2009 9:03 PM -
1 Votes
Illegal character in File Path
am getting an error on "Illegal character in file path." Here is the path.Answered | 4 Replies | 7732 Views | Created by achtro - Saturday, February 4, 2012 2:40 PM | Last reply by Russ Loski - Saturday, February 4, 2012 3:44 PM -
0 Votes
illegal characters in path
On one of my Windows Server 2008 boxes the File... Open... Analysis Services Database option of BIDS keeps giving me an 'illegal characters in path' message The ...Unanswered | 1 Replies | 9406 Views | Created by sbogar - Monday, June 7, 2010 1:29 PM | Last reply by Vinuthan - Wednesday, July 10, 2013 7:00 PM -
0 Votes
Access To Dts.Variables Causes Exception
Hey all...I'm pretty new to SSIS packages and things are coming along nicely. My problem is accessing variables in script tasks. I've created two variables (package scope, ...Answered | 1 Replies | 4768 Views | Created by GianniBrasco - Thursday, August 23, 2007 11:00 PM | Last reply by Karunakaran - Thursday, August 23, 2007 11:15 PM -
0 Votes
ASP.Net ReportViewer causes Exception in JScript
section in code behind, so basically it should just display the report (I tried setting the report dynamically, which basically causes the same exception) however it just comes up ...Answered | 3 Replies | 4163 Views | Created by David Faber - Wednesday, May 16, 2012 2:31 PM | Last reply by Mike Yin - Thursday, May 24, 2012 5:30 PM -
0 Votes
System.ArgumentException 'illegal characters in path.'
Good day <?!?>. This error "System.ArgumentException: illegal characters in path" is not specifically for SQL Server connection but to .Net ...Unanswered | 7 Replies | 2117 Views | Created by TheMax24 - Saturday, December 15, 2018 3:15 PM | Last reply by TheMax24 - Tuesday, December 18, 2018 1:26 PM -
0 Votes
XML Data Type - Illegal Characters
There is no built-in function to entitized illegal XML chars. Since SQL2005 do support CLR, you can develop your own built-in function using C# to do it.Answered | 2 Replies | 12096 Views | Created by Amos Soma - Monday, August 28, 2006 6:07 PM | Last reply by Gordon Shannon - Friday, September 1, 2006 7:10 PM -
1 Votes
To Pagefile or not X64 Win2K3 & SQL2005 X64
There is, and Microsoft provides very detailed instructions for how to determine what the pagefile should be for your system when running on x64:Discussion | 1 Replies | 7985 Views | Created by danny1s - Tuesday, November 24, 2009 5:21 PM | Last reply by Tome Tanasovski - Wednesday, November 25, 2009 3:13 AM -
0 Votes
User input causing “XML parsing: line 1, character 185, illegal xml character”
this error “XML parsing: line 1, character 185, illegal xml character” when updating their record with a sproc. Does anyone know what they could possibly be ...Unanswered | 1 Replies | 7309 Views | Created by sdolier - Thursday, July 5, 2007 8:52 AM | Last reply by Martin Honnen - Thursday, July 5, 2007 12:17 PM -
0 Votes
CreateSPs Sample Application Causes Exception.
When I use the CreateSPs sample app on a sample database (Person), with a sample table (Contact), the following exception occurred.=============================================Answered | 5 Replies | 17747 Views | Created by Doug Holland MVP - Tuesday, August 9, 2005 6:05 PM | Last reply by Judd.Aiken - Friday, February 25, 2011 2:11 AM -
0 Votes
error : Illegal characters in path.
Hi AmyBI, I am not sure which factor cause this problem. Is there other detailed error information? In addition, if you download the project in local folder, then use ...Unanswered | 3 Replies | 449 Views | Created by AmyBI - Tuesday, December 11, 2018 3:35 PM | Last reply by Zoe Zhi - Thursday, December 13, 2018 8:00 AM -
0 Votes
Installation Instructions
sold in retail and we sell 10,000+ units per year. I have been going over the MSDN site, these forums, Technet etc. and I haven't found a good, inclusive instruction set on installing ...Unanswered | 3 Replies | 4295 Views | Created by asowles - Friday, December 21, 2007 10:55 PM | Last reply by Madhu K Nair - Saturday, December 22, 2007 2:50 AM -
0 Votes
"Illegal Characters In Path" error when deploying from SSDT to SharePoint 2013
Hi, Your issue can be caused by the schem information is not correct. Did you report which failed to depoy to Sharepoint can preveiw successfully in ...Unanswered | 2 Replies | 2746 Views | Created by Developer_46038 - Tuesday, February 17, 2015 1:40 PM | Last reply by Developer_46038 - Wednesday, February 18, 2015 3:09 PM -
0 Votes
Illegal character XMl
Try and work out which row is causing the error by adding a WHERE clause to the inner SELECT. When you find the row, try just casting it to VARCHAR(MAX) and inspect the XML.Answered | 1 Replies | 6763 Views | Created by Kuldeep C - Monday, November 7, 2011 9:57 PM | Last reply by wBob - Monday, November 7, 2011 11:16 PM - Items 1 to 20 of 122762 Next ›
Data Mining announcements
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
SQL Server Reporting Services, Power View announcements
-
Link
We have released a beta version of the Reporting Services Migration Tool. The tool is available for download at:
http://www.microsoft.com/download/en/details.aspx?id=29560
This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server. Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.). Some additional details are in this blog post, along with the download link:
http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx
We are working on enabling more features in this tool, so feel free to share any feedback or report any issues. Thanks!
-
Link
Last Update: Mar 4, 2011.
SQL Server 2008 R2 was released to manufacturing on April 21, 2010. You can read more about it here.
Downloads available:
- Report Builder 3.0 RTM
- SQL Server 2008 R2 RTM - Developer Trial Edition
- SQL Server 2008 R2 RTM - Express Edition with Advanced Services
- SQL Server 2008 R2 RTM - Documentation
- SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
- Reporting Services 2008 R2 Add-in for SharePoint 2010
- Visual Studio 2010 Report Viewer Redistributable
Cumulative Updates:
-
SQL Server 2008 R2 RTM Cumulative Update #6 (build 10.50.1765)
-
SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
- SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
- SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
- SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
- SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)
You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP. You can research and ask questions on the dedicated MSDN forum.
-
Link
When posting questions in this forum, please include the version of SQL Server Reporting Services you are using. This will help us be more efficient in answering questions. If you are using the Report Viewer Control, it will helpful if you include the version of the control as well.
Thanks,
Sean -
Link
Last update: Mar 27, 2011.
Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services!
Important downloads for Reporting Services 2008:
SP2:
- Report Builder 2.0 (SP2 Download)
for Reporting Services 2008 (build 10.00.4000)
- SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
- SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
- SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
- Download SQL Server 2008 SP2
- Download SQL Server 2008 SP2 Express
- Download SQL Server 2008 SP2 Feature Packs
- RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000)
Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
SP1:
- RS 2008 SP1 Add-In for SharePoint Integrated Mode (build 10.00.2531)
Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
- SQL Server 2008 SP1 Cumulative Update #13 (build 10.00.2816)
- SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
- SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
- SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
- SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)
- SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)
- SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)
- SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)
- SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
- SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
- SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723)
- SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714)
- SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
- SQL Server 2008 Service Pack 1 (build 10.00.2531)
RTM:
- SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)
- SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)
- SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
- SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
- SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
- SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
- SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
- SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787)
- SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
- SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
- SQL Server 2008 RTM (build 10.00.1600.22)
- Updated SQL Server 2008 Books Online (July 2009 Update)
Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release. - Report Builder 2.0 (SP2 Download)
-
Link
Last update: Mar 27, 2011.
MSDN information aggregator site for Reporting Services 2005.
Important downloads for Reporting Services 2005:
SP4:
- SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
- SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
- SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
- SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)
SP3:
- SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325)
- SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317)
- SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315)
- SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
- SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309)
- SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)
- SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)
- SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)
- SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)
- SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)
- SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230)
- SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)
- SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)
- SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)
- SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207)
- SQL Server 2005 SP3 RTM (build 9.00.4035)
SP2:
- SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2
- SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)
- SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)
- SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328)
- SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325)
- SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315)
- SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301)
- SQL Server 2005 SP2 RTM (build 9.00.3042)
- RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download)
- SQL Server 2005 Books Online (December 2008 Update)
SQL Server Analysis Services announcements
.NET Framework inside SQL Server announcements
-
Link
This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.
Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads
Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/
Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads
Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads
Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads
Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads
Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads
Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads
Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.
SQL Server Replication announcements
SQL Server Setup & Upgrade announcements
-
Link
- Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
- What's new.(Why upgrade)
SQL Server Notification Services announcements
-
Link
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 Compact announcements
SQL Server Express announcements
-
Link
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 Samples and Community Projects announcements
-
Link
Welcome to the SQL Server Samples and Community Projects Forum.
This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.
Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.
- Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
- Try searching the forum . Search the forum to see if your question has been asked before and answered. If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
- Don't be brief . The more information you can give in your question, the better the response will be.
- Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
- No Spam. Spamming will have your thread deleted and may also result in your account being banned.
- Be polite. You will get better assistance if you're polite to other members so no flaming or trolling. If you persist with flaming or trolling, your accountmay get banned.
- Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question. Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.
Dead thread/Answer policy.
Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.
Setting up your alerts
If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice. -
Link
All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.
For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx -
Link
This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.
Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.
Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.
Let us know what's missing, let know what could be better and let us know what we're doing right!
Database Design announcements
-
Link
The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.
Books
A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
Eric Johnson and Joshua Jones
An Introduction to Database Systems
Chris Date
Applied Mathematics for Database Professionals
Lex de Haan, Toon Koppelaars
Architecting Regulatory-Compliant Architectures
Mike Walker, MicrosoftGraeme Simsion and Graham Witt
Database Modeling and Design: Logical Design
Toby Teorey
Information Modeling and Relational Databases
Terry Halpin
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Fabian Pascal
Pro SQL Server 2008 Relational Database Design and Implementation
Louis Davidson, Kevin Kline, et al
Online Resources
A Simple Guide to Five Normal forms and Relational Database Theory
http://www.bkent.net/Doc/simple5.htmData Modeling vs. Database Design
http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.htmlData Models
http://www.databaseanswers.org/data_models/index.htmDatabase Design - Ten Common Database Design Mistakes, Louis Davidson
http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/Database Design Issues -EAV Model Discussion (Querying an EAV Table)
http://tinyurl.com/yks8huDatabase Design Issues –EAV and OTLT
http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.htmlDatabase Design ROI by Paul Nielsen
http://www.sqlserverbible.com/files/databasedesignroi.pdfIntroduction to the Unified Dimensional Model (UDM)
http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspxLibrary of database models
http://www.databaseanswers.org/data_models/On Normalization and Repeating Groups by Fabian Pascal
http://www.dbdebunk.com/page/page/622318.htmORM white paper
http://www.orm.net/pdf/ORMwhitePaper.pdfOverview of the Relational Model
http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.htmlUnderstanding Data Model Quality, Graeme Simsion
http://www.tdan.com/view-articles/5100 -
Link
Out of Scope
Some topics are out of scope for this forum.
1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:
https://connect.microsoft.com/SQLServer
Rules of Conduct
· Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.
· Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.
· Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.
· Confidentiality: Confidential information should not be posted. This is a publicly available forum.
· Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.
· Advertising/Solicitation: Advertisements should not be posted, and will be removed.
Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.
Marking AnswersBy their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.
Welcome to the Database Design Forum
This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.
We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.
In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.
But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.
We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.
Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.
SQL Server Migration announcements
-
Link
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 Master Data Services announcements
-
Link
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
-
Link
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).
-
Link
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
-
Link
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
Power Pivot announcements
-
Link
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
-
Link
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services -
Link
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.
The solution is to upgrade the beta components to their released versions when they become available.
SQL Server PowerPivot for SharePoint announcements
-
Link
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.
-
Link
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