Microsoft BI-Azure and Project Server Blogs

Hi There , I was preparing for this exam since long and finally I signed up for appearing in exam.Glad to share that I passed the exam with good score. I wanted to share my experience with the exam. Exam duration/number of questions - The exam duration is 2.5 hrs. and there were 50 questions. However in Microsoft site it says that the number of question can change. There were two case studies questions( The question will contain real scenarios and all the BI components which are related to this exam e.g. SSAS/SSRS).There was first question of the exam and other one was at the last of the exam). we should be careful with dealing these questions and utilize the time smartly. There were good amount of questions from SSAS multidim/Tabular( there were alot on choosing the kind of model to be used based on different business scenario). Exam preparation- There were multiple good source available to prepare the exam. I went through book exam Ref 70-768 (similar exam as 466 but for 2016 ...

http://kidshealth.org/teen/your_body/medical_care/insurance.html

Objectives Design efficient schemas. Optimize queries. Fine-tune indexes. Perform efficient transactions. Build efficient stored procedures. Analyze and understand execution plans. Identify and eliminate execution plan recompiles. Avoid scalability pitfalls when you use SQL XML. Tune Microsoft SQL Server. Test and monitor your data access performance. Consider how deployment decisions impact performance and scalability. Overview There are many issues that affect SQL Server performance and scalability. This chapter discusses these issues, starting with data design and ending with deployment. The chapter emphasizes the techniques you can use to obtain the biggest gains in performance and scalability. You usually can obtain the biggest gains by creating efficient data access code for the application and by using correct development techniques. You usually do not obtain such big gains in performance and scalability by changing SQL Server configuration settings. Figure 14.1 shows where y...

Understanding Kerberos and NTLM authentication in SQL Server Connections http://www.blogger.com/img/blank.gif

There are always several questions we face at customer sites on the licensing requirements for their Project Server implementation. It’s best to consult your local Microsoft Solution Sales Specialist (SSP) for the details to ensure compliance. A common scenario we see customers are faced with is loading Project Server with ALL resources in the organization, whether work assignments exist or not, and have them available to perform work as it is assigned. An organization may likely consist of 10,000 people and only 1,200 active on projects at a time and would prefer to only have 1,200 Client Access License (CAL)s for the entire organization. This scenario is not allowed, however, Microsoft allows the CAL to be transferred (as a one off) after a 90 day period to a new user. The simple SQL script below provides a view of all the resources in the named instance you set through the @PUBLISHED_DB_NAME variable to have the discussion with the SSP. Key columns to review from the SQL output that...