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 | 7695 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 | 18 Replies | 24458 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:44 PM | Last reply by Alberto1166 - Tuesday, November 27, 2018 11:30 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 ...
-
0 VotesHow to find which SSIS packages are called by which jobs
...Unanswered | 1 Replies | 646 Views | Created by Allepage - Wednesday, November 27, 2019 12:51 PM | Last reply by Vaibhav-Chaudhari - Wednesday, November 27, 2019 12:59 PM -
0 VotesSQL server connecting with ireport in netbeans
when create connection between sql server and irepot error occur as follow. can help? SQL server : 2008 netbeans 6.8 DataBase name : ...Unanswered | 0 Replies | 720 Views | Created by 4-darshaniliynanage - Saturday, November 23, 2019 10:32 AM -
0 VotesAdventureWorks2016.mdf
Where's AdventureWorks2016.mdf or AdventureWorks2016_ext.mdf? (The sample's repository only has .bak files. I'm asking instead of randomly searching because the file ...Answered | 3 Replies | 1207 Views | Created by rootsmusic - Thursday, September 12, 2019 3:29 AM | Last reply by Olaf Helper - Thursday, September 12, 2019 5:51 AM -
1 VotesAdventureWorks2016.bacpac
Can someone please confirm my issue (by connecting to my database) is caused by the repository's source file? If so, please refer me to either another server's database (not DW or LT ...Answered | 3 Replies | 1323 Views | Created by rootsmusic - Wednesday, September 11, 2019 7:18 PM | Last reply by Erland Sommarskog - Wednesday, September 11, 2019 9:23 PM -
0 VotesAdventureWorks version in SQL Database
How can I determine the version of an AdventureWorks database? For example, which versions are: AdventureWorksLT (Azure's sample), OLTP install script, and ...Answered | 3 Replies | 1267 Views | Created by rootsmusic - Monday, September 9, 2019 7:33 PM | Last reply by Jefferson Silva DBA - Tuesday, September 10, 2019 12:42 AM -
0 VotesEntity Relationship diagram for WideWorld Importers or Data model for Wideworld Importers
Hi, I have downloaded the sample database WideWorld Importers for SQL Server. Can anyone please send me the Entity Relationship diagram or Data model diagram for WideWorld ... -
0 Voteslocal machine connecting to AdventureWorks
(Please excuse my ignorance because I'm just a student who's learning.) I don't have a server, and I don't know how to configure one. I can't find any server where non-Azure users can ...Answered | 1 Replies | 1618 Views | Created by rootsfiddler - Wednesday, May 1, 2019 6:59 PM | Last reply by Erland Sommarskog - Wednesday, May 1, 2019 9:21 PM -
0 VotesFont issues while exportting to PDF and word-SSRS
Hi All, while fetching reports from ssrs 2016 i fam facing font rendering issue .please find the bellow mentioned snap ... -
0 VotesSample Database for Sql Server 2016
All, I am trying to install the sample database AdventureWorks or Wide World Importers. The samples download as a pdf with a .bak extension...It will not restore because it doesn't ...Proposed | 7 Replies | 2303 Views | Created by Slimjen06 - Tuesday, February 26, 2019 10:12 PM | Last reply by Erland Sommarskog - Wednesday, February 27, 2019 10:06 PM -
7 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 | 11 Replies | 23520 Views | Created by Nantz1 - Sunday, October 21, 2012 11:50 PM | Last reply by Ayse Ciftci - Friday, January 25, 2019 10:48 AM -
1 VotesSQL Server 2017 Python tutorial not working
I'm following the tutorial https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/use-python-revoscalepy-to-create-model?view=sql-server-2017, and got the following ... -
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, ...Answered | 18 Replies | 24458 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:44 PM | Last reply by Alberto1166 - Tuesday, November 27, 2018 11:30 PM -
0 VotesReplicate a records from a view
Good Morning I'm new to the forum and are not sure if the question is in the correct forum. I have a view ...Answered | 4 Replies | 2840 Views | Created by Jonathas_A_B - Friday, September 14, 2018 11:21 AM | Last reply by Visakh16 - Friday, September 14, 2018 2:21 PM -
0 VotesSSRS Save to Named PDF
The following command string exports a PDF to be saved or opened. start explorer " -
0 VotesWideWorldImporters - design criteria?
The schema in WideWorldImporters does not seem to be normalised. What is the purpose in having a sample DB that is not normalised? Ken EvansUnanswered | 7 Replies | 3152 Views | Created by Ken Evans - Friday, August 24, 2018 8:28 PM | Last reply by Ken Evans - Thursday, August 30, 2018 6:52 PM -
0 VotesSSRS Forms with IIf Statements
Team: Trying to design a form (2) based on a dataset (1) with four fields and results from a SP. The end-result would be that the Count numbers would populate over to the form ... -
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 | 18 Replies | 9160 Views | Created by tocy - Sunday, July 23, 2017 7:23 PM | Last reply by cMajid - Thursday, May 3, 2018 1:00 PM -
0 VotesHTTP and HTTPS on the same report server
Dear All, I need a little guidance/help. My client has installed the SSRS. But, he wants the end users to listen to port ...Answered | 2 Replies | 3595 Views | Created by thelearner86 - Tuesday, March 6, 2018 8:08 AM | Last reply by thelearner86 - Wednesday, March 28, 2018 8:35 AM -
0 VotesAdventureWorks 2016 Join/Union question
I am currently working on a question that im having trouble with, I am new to SQL and having some trouble with Joins. The question must be answered ...Unanswered | 1 Replies | 3791 Views | Created by smatmart - Wednesday, March 28, 2018 1:00 AM | Last reply by scott_morris-ga - Wednesday, March 28, 2018 1:32 AM -
0 VotesSQLSERVER BUG on CASE WHEN STATEMENT
=0) then case when (u.qty_a=1) then v.qty else case when (v.qty>=u.qty_a) and (u.qty_a<>1) ...Proposed | 3 Replies | 3333 Views | Created by JERRYOEI - Monday, March 26, 2018 3:43 PM | Last reply by Erland Sommarskog - Monday, March 26, 2018 9:36 PM - Items 1 to 20 of 495 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!
