SQL Server Samples and Community Projects announcement
-
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!
-
1 VotesAdventureWorks is being replaced by World Wide Importers starting in SQL Server 2016
The AdventureWorks sample databases have been released for SQL Server 2016, but will not be updated or maintained going forward. The product team has released a new sample database called World Wide ...Sticky | 1 Replies | 3488 Views | Created by Samuel Lester - MSFT - Monday, June 13, 2016 6:56 PM | Last reply by Olaf Helper - Monday, June 13, 2016 7:06 PM -
7 VotesFinding 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, ...Sticky | 17 Replies | 19059 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:44 PM | Last reply by CigarDoug - Wednesday, September 09, 2015 1:24 PM -
3 VotesSQL 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 ... -
1 VotesMicrosoft SQL Server 2008 R2 SR1 Product Code Samples
The following link contains product code samples (without database files) for Microsoft SQL Server 2008 R2 ...
-
6 VotesWhere 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 ...Answered | 9 Replies | 16799 Views | Created by Nantz1 - Sunday, October 21, 2012 11:50 PM | Last reply by shreeharshas - Monday, November 20, 2017 8:17 AM -
0 VotesHow was the AdventureWorksDW2012.dbo.FactInternetSales loaded?
I have been trying to figure out how the "AdventureWorksDW2012.dbo.FactInternetSales" table was loaded. The following are its columns: [ProductKey] [int] NOT ... -
2 VotesWhat are the different betweent DataBases installing and deploying?
We offen say deploy database, or say install database, what is their different? Can I think they are the same things? like this, or refer to ...Answered | 2 Replies | 98 Views | Created by zhgart - Thursday, November 16, 2017 3:02 AM | Last reply by Gnana Balaji Kanagaraj - Thursday, November 16, 2017 6:13 AM -
0 VotesOnce quote no is generated insert into another table using a SQL Trigger
I am very new at triggers infact this is my first one and i am rather flustered and confused! I need all the help i can get. My main aim is the ...Unanswered | 8 Replies | 214 Views | Created by JR83 - Monday, October 16, 2017 11:42 AM | Last reply by Tom Phillips - Tuesday, October 17, 2017 11:12 AM -
1 VotesGrouping or Aggregating like Items
Just diving into SQL and had seen a report format that I like and was hope this is the right forum to ask. i am familiar with basic select statements and grouping but I am stumped on how to ...Answered | 7 Replies | 252 Views | Created by tim_thebackpack - Tuesday, October 03, 2017 8:19 PM | Last reply by tim_thebackpack - Wednesday, October 04, 2017 3:42 AM -
0 VotesWildcard in LINQ
Hi. In the Linq below, what should be inside "Contain", so that it is equivalent to '%2[0-9][0-9]-%' in SQL? these are the matching ...Unanswered | 1 Replies | 1072 Views | Created by wkpli - Friday, January 27, 2017 8:25 PM | Last reply by THines01 - Friday, September 22, 2017 3:35 AM -
0 Votesno database
I've lost the ability to create a database. I have windows7Unanswered | 1 Replies | 382 Views | Created by connieklap - Wednesday, August 23, 2017 5:10 AM | Last reply by Olaf Helper - Wednesday, August 23, 2017 5:42 AM -
0 VotesProblems with code: AERP_80_2017.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH '08/01/2017', '08/31/2017', '01/01/2017', '12/31/2017', 'AERP_80_2016'
I am using a program that is based on sql 2008r2. I have a problem because a document is not openning showing me the error: "General SQL Server error: Check ...Unanswered | 2 Replies | 428 Views | Created by adas1234 - Wednesday, August 09, 2017 2:33 PM | Last reply by scott_morris-ga - Thursday, August 10, 2017 1:37 AM -
0 Votesrestore AdventureWorks2016CTP3 fails on SQL 2016 Developer
Hi, all. I have tried to restore sample database AdventureWorks2016CTP3 downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=49502 and failed. Looking for ...Answered | 7 Replies | 609 Views | Created by aalub - Thursday, August 03, 2017 4:48 PM | Last reply by aalub - Saturday, August 05, 2017 10:24 AM -
0 VotesSQL Studio Manager 2017 can't restore any database!
Hello folks! I am facing unusual issue with restore any database through SQL Studio Manager. I have downloaded AdventureWorks 2012, 2014 and ...Proposed | 17 Replies | 608 Views | Created by tocy - Sunday, July 23, 2017 7:23 PM | Last reply by Satish Kumar Gajula - Tuesday, July 25, 2017 3:48 PM -
0 VotesHow to run select query to display column values in correct asc order, if values have letters as lead
<g class="gr_ gr_54 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="54" id="54">Hi</g> I am very new to SQL ...Proposed | 1 Replies | 513 Views | Created by ojoc - Wednesday, July 12, 2017 12:14 AM | Last reply by Lin Leng - Wednesday, July 12, 2017 8:21 AM -
0 VotesSQL Server R Services Tutorials - errors
Hello guys, I am super keep to start using R with SQL Server (so far worked with the latter, the former is not very new to me, but still need to learn how to ...Unanswered | 3 Replies | 1368 Views | Created by Hikari_PL - Sunday, February 05, 2017 12:00 PM | Last reply by 高木ジニー - Thursday, June 29, 2017 6:51 PM -
0 VotesStoreFront for SQL Server 2014
Hello, I really need your help ASAP, I downloaded SQL server 2014 and the AdventureWorks sample database 2014 and every thing is great so far. Now I need an ...Unanswered | 2 Replies | 839 Views | Created by mbarrak - Sunday, April 02, 2017 7:52 AM | Last reply by mbarrak - Monday, April 03, 2017 6:45 AM -
0 VotesAdventureWorksDW2012 Download
Hello, I'm trying to download the AdventureWorksDW2012 database to my SQL 2012 but keep getting this error, "This file does not have a program associated ...Unanswered | 1 Replies | 1636 Views | Created by utoktome - Wednesday, March 15, 2017 7:22 PM | Last reply by scott_morris-ga - Wednesday, March 15, 2017 8:01 PM -
0 VotesSTUFF Function
Greetings, I am using SQL Server 2008 R@ and i am stumped on trying to put all values from a field in my talble into one ROW. example. I have a Table called Items. It only has ONE ...Answered | 2 Replies | 1017 Views | Created by Paul 2 U - Thursday, February 16, 2017 1:09 PM | Last reply by Paul 2 U - Thursday, February 16, 2017 3:42 PM -
1 VotesMSBI Project
Good Morning, This is Ramesh. I have learnt MSBI . But i don't have experience in Real time. Can you send me real time project of SSRS,SSIS & SSAS projects with solution?Then I ...Unanswered | 2 Replies | 1256 Views | Created by Rameshpinni - Friday, February 10, 2017 4:39 AM | Last reply by philfactor - Friday, February 10, 2017 5:31 PM -
0 VotesTrying to create a table..
...Answered | 3 Replies | 1034 Views | Created by JdeBear - Tuesday, February 07, 2017 12:05 AM | Last reply by JdeBear - Tuesday, February 07, 2017 3:08 AM -
0 VotesR Services tutorial problem
I have a problem with the Microsoft tutorial at https://www.microsoft.com/en-us/sql-server/developer-get-started/r The tutorial is about creating a predictive model in SQL ... -
1 VotesAdventureworks 2014 DB
I have a question regarding Adventureworks 2014 db I am missing a table (person.contact) and there is no ContactID in all of the db. I have been struggling to find why this is the ...Answered | 10 Replies | 1767 Views | Created by MajShah - Monday, December 05, 2016 11:57 PM | Last reply by MajShah - Tuesday, December 06, 2016 9:30 PM -
0 VotesBusinessEntityID - Need help understanding.
So the new AdventureWorks is an ultra normalized database and the concept is completely new to me and I have a question about how it would work. My understanding is the BusinessEntityID is the ...Answered | 4 Replies | 14415 Views | Created by adamus1986 - Sunday, February 08, 2009 9:56 AM | Last reply by Ulysses B Brown Jr - Thursday, November 24, 2016 12:43 AM - Items 1 to 20 of 474 Next ›
SQL Server Samples and Community Projects announcement
-
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!
