i completed my education in 2010... i did my course on sql server 2005 dba.. can any tell me were can i find pdf of dba and bi so that i can get a proper grip of it and if possible can anyone share with me a live project that you have performed .. it will be very useful for me to crack the interview .. i wanna attend the interview genuinely..
If you completed your education 4 years ago on SS 2005, you should probably download an Express version that is a little more current. It may not allow you do everything, but you should be able to do a lot with it.
And to learn, practice. Create a database, implement it. Test it.
There are 2 distinct streams when dealing with databases, developer and DBA. CP mostly deals with developer requirements, how to move data around an application and process the data.
If you intend to go down the DBA path, where you maintain the health of the database and development is only incidental to your core role then http://www.sqlservercentral.com/[^] is a good resource. You may also want/need to concentrate on a specific database server.
Never underestimate the power of human stupidity
I have a problem with my SSIS 2012, if I put in made a OLDBE Source with a complex query or composite sample
AS WITH TT
e.UniqueID e. [Web Id] from Elements e) SELECT
'Class' + CAST (ROW_NUMBER () OVER (PARTITION BY [Web Id] ORDER BY [class] DESC) AS NVARCHAR) AS ClassNum
I have this error:
Exception From HRESULT: 0xC0202009
Error at Get Products SSIS Error Code DTS_E_OLEBDERROR. A OLE DB error has occured. Error code: 0x80004005
An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Syntax Error, permission violation, or nonspecific Reviews another error"
see Exhibit attached
Note that this same package works wonders on my colleague's machine with vs 2010
Always read the error message - Syntax Error, permission violation, or nonspecific Reviews another error
There is either:
An error in the sql - you can check this by running the sql in isolation.
A permission issue - harder to track, I would test this by creating a simple SSIS package and try to run it from your code.
Non specific error - eliminate the first two possibilities then look into this.
“That which can be asserted without evidence, can be dismissed without evidence.”