Thursday, May 2, 2013

[SQL 2012] SQL Server 2012 Certification Study Guides

[SQL 2012] SQL Server 2012 Certification Study Guides

SQL Server 2012 Certification Study Guides

Posted: 28 Feb 2013 01:51 AM PST

I've finally embarked upon the certification path after (too many) years of broken resolutions.I'm choosing to go the study guide route rather than a boot camp or other course, as it allows me to also fit in the study during quiet periods in my current job.I'm starting from scratch, so the path is easy:70-461, 70-462 and 70-463 for MCSA followed by 70-464 and 70-465 for the Data Platform MSCE and (if I still have the will to live) 70-466 and 70-467 for the BI MCSEI have the Oreilly Study guides for the 3 MCSA exams and am forging my way through them.However, I was just browsing for study guides for the MSCE exams and am unable to find any.Does anyone have any details of study guides for 70-464, 70-465, 70-466 or 70-467 please?Ideally both printed and electronic format, but either would be fine.Thanks in advanceApologies - I should have posted this in the Career/Certification forum.

Performance Primary Keys creation

Posted: 01 May 2013 07:53 AM PDT

Hi,I am trying to figure out if there is a difference in performance between these two statements to create a primary key:ALTER TABLE Customer ADD PRIMARY KEY CLUSTERED ([iCustID] ASC)ALTER TABLE Customer ADD CONSTRAINT PK_ Customer PRIMARY KEY CLUSTERED (iCustID ASC)Is it the same thing?Thanks

AdventureWorks Attach problem

Posted: 24 Mar 2013 11:03 AM PDT

Hi,I'm trying to attach the data file of Adventureworks. I have download the file from http://msftdbprodsamples.codeplex.com/releases/view/55330When I try to attach the file (I remove the log file because I don't have one) I receive the following error: The header for file 'C:\AdventureWorksDW2012_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect.My SQL Server version is SQL Server 2012 Developer edition with sp1Can someone help?

DB Sanity Installation & Error

Posted: 01 May 2013 07:20 PM PDT

Has someone used DB Sanity tool with SQL server... If so can you please help me, I am getting below error in cmd prompt...Local classpath: .;D:\dbsanity\bin;D:\dbsanity\lib\*Exception in thread "Main Thread" org.databene.commons.ConfigurationError: Testdefinition folder not found: dbsanity at org.databene.dbsanity.DbSanity.checkPreconditions(DbSanity.java:498) at org.databene.dbsanity.DbSanity.execute(DbSanity.java:266) at org.databene.dbsanity.Main.main(Main.java:54)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog