June 14, 2020 at 9:27 am
Hi all, I am looking for some one to join me in learning and developing a small project. I have some background on MS Sql Server 2012. If there is some one there with a project or we could find one and learn together, please let. I believe the best way to learn quickly is by doing a group project. So please let me know if you are interested or know of someone who maybe interested.
Thanks
Ronny
June 15, 2020 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 15, 2020 at 2:15 pm
You might edit the subject, as it's not clear what you want. You put in the start of a statement rather than a description like "Looking for someone to join a group project".
If you are struggling to learn, I might suggest going through a few items:
June 15, 2020 at 5:47 pm
I agree with Steve here.
On top of that, if you are wanting someone to help with a project, you should provide some details on the project. Is it strictly a SQL Server project or is there some frontend you are thinking too? if there is a frontend, what language are you thinking for that? Is it a web based project or a stand-alone application? Is the database going to be cloud based or is it an on-premise tool? Does a similar tool already exist and you are looking to improve on it/compete with it or is it something completely new?
With your experience with SQL Server 2012, is that development experience, administrative experience, design experience, or all of those and more? Are you familiar with just TSQL, or do youhave SSRS, SSIS, SSAS, power BI, etc experience?
Knowing more about the project and your experience and what you are looking for will result in more appropriate responses. If you have already started the project, having a github link to it (for example) would be helpful.
I know I have professional experience in .NET development, TSQL, SSRS, SSIS as well as database administration with my current profession and I also know that developing efficient SQL code is a LOT different than developing efficient C# code. I am actively helping develop a VB.NET application with another developer, but we have no database back-end for it. It is a stand alone application released for free and open source on github. Not putting a link here because I am not advertising the tool or looking for more maintainers. I am not even a maintainer on it. I just forked it, fixed a few bugs and made pull requests.
Also, are you looking for development related training or administration related training? The administrative side of SQL is a different set of skills (in some cases) from the devleopment side. Both are very important to have, and knowing a bit of both is good. Like if you have a slow running query, it is good to know if the hint that SQL gives you in the execution plan to build an index will be good or bad and how to look that up. On the other hand, if you are not the one who needs to worry about indexes, it can make things easier on you but more annoying to the DBA. Especially since adding indexes may make you one query faster while making others slower. It is a bit of a tradeoff, and rewriting your query may help with performance more than adding that index would.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 16, 2020 at 8:25 am
So sorry for the confusion, guess I should have been more clear.
I would like to get trained on MS Sql server DBA. Yes I have some knowledge of vb.net and have used SQL server and Access as the DB, I am quite familiar with TSQL.
I would like to get some hands on experience to become a Database Administrator. So, is it possible to get training on a (preferably Live) project as to what one would encounter on a day to day basis being a DBA.
Thanks for taking the time to read my thread and also explain,
Rony.
June 16, 2020 at 3:42 pm
My opinion - a SQL Server DBA is not likely to get much training from a project. A database developer would; a database architecht would, but the administration side of things won't get much on a group project.
There are a lot of good resources out there (SSC has a lot of articles and Steve posted some good links). But projects for a day to day basis is tricky. Some of the common day to day tasks as a DBA though are monitoring the databases, installing SQL instances, creating databases, granting/revoking permissions... administrative tasks. On top of that, research and training are important as well as keeping up with patches.
Depending on where you work, you may end up being the on-call person to solve database related issues. And you may be responsible for tuning and disaster recovery. Depending on the work done by the previous DBA, you may be responsible for database documentation as well.
At my workplace, we don't have a need for a full time DBA. Therefore, i am a DBA, database developer, data scientist, database architect, etc... I am an "all in one" database guy. On top of that, I also do application support and development (C#). But my primary role is DBA. If a new SQL instance is required, that's on me. If some instance or database is suddenly running slow, that's on me. If corruption pops up in the database,that's on me. Patching (both the OS and the SQL instance) is on me too.
If you are looking to be a database developer, I think you will have a lot more luck working with a group project, as long as you have a good development team. It is far too easy to end up with a team that doesn't understand SQL Server that well and starts doing row based operations (cursors, loops, etc) rather than set based operations. Or who design tables as heaps because they don't exepct a lot of data and are not even thinking about scaling the application.
If you are looking for a group to work with though on the database side of a project, GitHub is likely going to be a better place to look. You can find projects that are underway that have issues and you can jump in and tackle some of the existing issues. Plus you can pick a project that is interesting to you. Like if you are really looking forward to working on a service desk implementation, there are probably several projects out there looking for help. Or if you are more interested in video game development, any online game or a game with a leaderboard will very likely have some SQL or NoSQL backend (might not be specifically SQL Server, but may push you in the right direction).
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 16, 2020 at 3:53 pm
Thank you so much....
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply