I just got a call from a recruiter who knows most of my experience is with Oracle Databases. He has a client that is looking for a Sql Server DBA. He said that they don't mind someone coming from an Oracle background. However, how different are the 2.
Will this cause me problems later? Is it hard to transition from Oracle to SQL Server?
I am using sql server(NT server) and msaccess as the front end for the majority of my dbs (some oracle) in windows xp. My company would like to make the transition to web front ends and they have offered to have me trained to do so. I have some training in Html but nothing in regards to linking a webpage to a database. My question is where do I begin? I've tried researching what coursework I would need to go through and haven't found the right information to determine what is the best path of coursework.
Should I take a courses in PHP, Java, vb, perl, etc? Is there one straight answer to this question?
Any help would be appreciated. ps I wasn't sure which forum to post this to, so I started here since the majority of my data is in sql server.
Thanks,
Dan
One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.
What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!
Hi,
I am trying to learn more about SQL Server, so I can try to make the transition from Access, as I have read, and heard from many people that SQL server is far superior.
I have a few questions that I am unsure of, I have basically no real experience with SQL server.
1) I have been watching the "How Do I" videos, posted on MSDN (which are AWESOME, btw), and for most of their examples, they use the SQL Server 2005 Express which comes with VWD.
I do not have any problem running any of the sample applications on my local machine, but what about for when you want to actually create a web app to publish online? From what I have read, most hosts do not give support for the express edition of SQL Server 2005, so how do you go about changing your app?
For example, if you wanted to use the Login control, which automatically creates a SQL express database for you, can it be changed to implement regular SQL server 2005, or SQL server 2000?
I am just confused as to how to make use of the features available other than on a local machine.
2) Where would be a good place to learn more? Any recommended books?
3) Does anyone know of a good (affordable) host that would offer SQL Server 2005/ASP.NET 2.0 support?
Any advice would be greatly appreciated. I know these are probably very basic questions, but I am very new to SQL server.
Thanks,