SQL Server Samples and Community Projects announcement
-
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!
-
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
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.
-
Sticky6Votes
Finding the Correct Version of the AdventureWorks Sample Database
As the AdventureWorks sample database has evolved over the years, there are many different editions to decide from. The following blog post will help you pick the correct version to get started, ...12 Replies | 8151 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:44 PM | Last reply by pjdevries - Saturday, May 04, 2013 6:43 PM -
Sticky1Votes
SQL Server 2008 R2 Developers Training Kit
This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It ... -
Sticky3Votes
SQL Server 2012 Developers Training Kit
The SQL Server 2012 Developer Training Kit includes technical content including labs, demos and presentations designed to help you learn how to develop SQL Server 2012 database and BI solutions. New ... -
Sticky1Votes
Microsoft SQL Server 2008 R2 SR1 Product Code Samples
The following link contains product code samples (without database files) for Microsoft SQL Server 2008 R2 ...
-
Answered3Votes
Exam 70-433 Atach AdventureWorks fails
Hello. I have just spent a day and a half uninstalled SQL 2008, installing SQL 2008R2 and trying to attach the three samples databases. Eventually got AWDW2008 and Northwind but the ...13 Replies | 13374 Views | Created by MicrochipThe First - Tuesday, June 08, 2010 10:06 AM | Last reply by Piyush Kaushik(TheAlphaLion) - Saturday, March 15, 2014 11:45 PM -
Answered0Votes
BusinessEntity table in AdventureWorks sample DB
Dear all, Does anyone could explain be how and when BusinessEntity rows gets created in sample database ? When I check at table design the BusinessEntityID is a ...7 Replies | 119 Views | Created by wakefun - Thursday, March 13, 2014 4:49 PM | Last reply by Olaf Helper - Friday, March 14, 2014 9:53 AM -
Answered3Votes
Where do I get the AdventureWorks log file? Getting error when attaching AW .mdf file. Says "error .ldf log file not found"
Where do I get the AdventureWorks log file? Getting error when attaching AW .mdf file. Says "error .ldf log file not found" I figured I would just copy one of the other ...6 Replies | 5759 Views | Created by Nantz1 - Sunday, October 21, 2012 11:50 PM | Last reply by Aditya Rathi - Monday, March 10, 2014 7:08 AM -
Unanswered0Votes
Excel 2013 cell mapping to SQL 2008 columns
Perhaps there is an example that answers my question: Here is my question: This is a very "newbie" question. I ... -
Answered0Votes
Cannot attcahed to AW 2012 databse version
Dear all, I have install SQL server 2012 and I try to attached to the Advanture work 2012 database file. When doing so I get the following error : The database ...2 Replies | 175 Views | Created by wakefun - Tuesday, February 18, 2014 10:09 AM | Last reply by Shanky_621 - Tuesday, February 18, 2014 10:19 AM -
Answered0Votes
How to repair database using SQL server 2008 and C#
How to repair database in SQL server 2008 using C# Musakkhir Sayyed.2 Replies | 210 Views | Created by MusakkhirSayyed - Friday, February 14, 2014 1:15 PM | Last reply by Shanky_621 - Friday, February 14, 2014 2:32 PM -
Answered0Votes
How to update all cells in columns
Hi, I want to populate all cells in any row. For example I will draw you the ...3 Replies | 280 Views | Created by CAKAta - Wednesday, February 12, 2014 11:34 AM | Last reply by CAKAta - Thursday, February 13, 2014 8:51 AM -
Unanswered0Votes
AdventureWorks2008.bak e AdventureWorksDW2008.bak
I typed this code is giving error. Could someone help me solve this problem , because I am new to sql server 2008 . Thank you ! EXEC ' filestream_access_level ' ...1 Replies | 271 Views | Created by ns_andre - Sunday, February 09, 2014 9:10 PM | Last reply by Shanky_621 - Sunday, February 09, 2014 9:24 PM -
Answered1Votes
Explain BusinessEntity tables in AdventureWorks2008R2
I'm designing my first enterprise level sql server database and want to use AdventureWorks2008R2 as a concept model to copy some of what it demonstrates re good design. But I'm struggling to ...2 Replies | 7762 Views | Created by GaryBarrett - Friday, March 11, 2011 2:27 PM | Last reply by Taazz - Friday, February 07, 2014 9:03 PM -
Answered8Votes
Error attaching Adventureworks 2008 db to SQL Server 2008 [not R2]
Hi ppl, I have SQL Server 2008[NOT R2] installed in my laptop [Windows Vista Home Premium, 64 bit]. There are 2 issues: 1. Downloaded the ...8 Replies | 11669 Views | Created by chips30 - Thursday, April 19, 2012 5:14 PM | Last reply by Naomi N - Thursday, February 06, 2014 9:34 PM -
Unanswered0Votes
AdventureWorks2008.bak e AdventureWorksDW2008.bak
I typed this code is giving error. Could someone help me solve this problem , because I am new to sql server 2008 . I wonder also , where can I download the file ...1 Replies | 227 Views | Created by ns_andre - Wednesday, February 05, 2014 10:45 PM | Last reply by Shanoof Basheer - Thursday, February 06, 2014 4:14 AM -
Unanswered0Votes
AdventureWorks2008.bak e AdventureWorksDW2008.bak
I typed this code is giving error. Could someone help me solve this problem , because I am new to sql server 2008 . Thank you ! EXEC ' ...1 Replies | 262 Views | Created by ns_andre - Tuesday, February 04, 2014 9:44 PM | Last reply by Olaf Helper - Wednesday, February 05, 2014 6:19 AM -
Answered0Votes
AdventureWorks
PurchaseOrderHeader: TotalDue doesn't have a datatype defined yet their are values in the table, Why Status: tinyint? where do the numbers come from entered and ...6 Replies | 312 Views | Created by k-vic - Tuesday, January 28, 2014 5:54 AM | Last reply by k-vic - Tuesday, January 28, 2014 3:41 PM -
Answered0Votes
Avdventureworks 2012
I am wondering if there is easy way to comment out parts of the database script I don't won't created at this time like HumanResources, production1 Replies | 275 Views | Created by k-vic - Monday, January 27, 2014 7:52 AM | Last reply by Olaf Helper - Monday, January 27, 2014 8:04 AM -
Unanswered0Votes
Not able to install AdventureWorks2008_SR4.exe
I tried installing AdventureWorks2008_SR4.exe from link http://msftdbprodsamples.codeplex.com/releases/view/37109 Its giving me fatal error occurred during installation. ...2 Replies | 302 Views | Created by PoojaDalal - Friday, January 24, 2014 5:33 PM | Last reply by PoojaDalal - Friday, January 24, 2014 5:55 PM -
Answered9Votes
How to attach Northwind database sample with sql server express 2012
Hi there , i tried to attach the Northwind sample to my MS SQL SERVER EXPRESS 2012 but its always have error about compatibility versions of sql server , anybody have idea how can we pass this ...9 Replies | 10782 Views | Created by HESHAM HEMDAN - Monday, December 03, 2012 10:14 PM | Last reply by Naomi N - Thursday, December 26, 2013 8:04 PM -
Discussion8Votes
Anchor Modeling
Anchor Modeling is an Open Source community project for creating an agile modeling technique suitable for information that evolve over time. We also have an online and free to use tool that can ...7 Replies | 6876 Views | Created by lasa - Monday, February 20, 2012 5:46 PM | Last reply by lasa - Sunday, December 08, 2013 8:18 PM -
Proposed1Votes
Documentation for Adventureworks 2012 database
Where can I get the documentations for the Adventureworks 2012 database: - Data Structure - Data Dictionary - Other? Thank ...1 Replies | 617 Views | Created by clesben - Sunday, November 10, 2013 1:33 PM | Last reply by Jos de Bruijn - Monday, November 11, 2013 8:47 PM -
Answered2Votes
AdventureWorks 2008 R2 OLTP Script Error
Environment: Windows 2008 R2, SQL Server 2008 R2. SQLCMD mode enabled. FILESTREAM enabled. When I parse the AdventureWorks 2008 R2 OLTP script, the following error is displayed in ...5 Replies | 768 Views | Created by Stephan Bren - Wednesday, October 16, 2013 3:47 PM | Last reply by Mr. Wharty - Monday, October 21, 2013 10:44 PM -
Answered1Votes
Query assistance
Looking for assistance with a select statement - I need to be able to select the FIRST Row of a collection when the collection contains Multiple rows with a common field ...3 Replies | 584 Views | Created by joemac130 - Friday, October 18, 2013 5:52 PM | Last reply by joemac130 - Friday, October 18, 2013 8:47 PM - Items 1 to 20 of 414 Next ›