Passed MS 70-483 exam

Yay! Today, I passed MS 70-483 exam. Usually I don't go for certifications, but I thought to give it a try to test my skills. I am preparing for MCSD App Builder and this is one of the pre requisite for that. I thought this exam would be easy as I am working in .Net … Continue reading Passed MS 70-483 exam

Advertisements

SQL STUFF()

SQL STUFF() function is very useful function and can be used for replacing some text or inserting some text or doing both. Let's see some examples of how it can be used. Before moving to the examples, lets check out the syntax of STUFF(). STUFF(<expression>, <start index>, <length>, <replace_expression>) Below are  the explanation of its … Continue reading SQL STUFF()

SQL Server : IsNULL vs COALESCE

Sometimes we are overwhelmed with different options we have, however sometimes these options seems same but can be a bit different and may be useful in one or the other scenarios. Lets discuss one of such scenario in SQL Server which is IsNULL and COALESCE and see how they are similar and how they are … Continue reading SQL Server : IsNULL vs COALESCE

Error SQL70001: This statement is not recognized in this context

Today, I got this weird error on my SQL script in Visual Studio 2017, where in it was highlighting various SQL statements when I copied the SQL file and added it to the project. Below is the exact error in Visual Studio 2017. Error SQL70001: This statement is not recognized in this context. However, the … Continue reading Error SQL70001: This statement is not recognized in this context

How to update Warning Site Count and Maximum Site Count of SPContentDatabase

This seems pretty simple as you can just set the properties of SPContentDatabase and you are good to go. However, this didn't work atleast in my case. I was trying to use the below command earlier which didn't work:- Get-SPContentDatabase | foreach-object{$_.WarningSiteCount = 0; $_.MaximumSiteCount=$_.CurrentSiteCount} Ideally, if the above command executes successfully & correctly then it should … Continue reading How to update Warning Site Count and Maximum Site Count of SPContentDatabase

Unable to remove SharePoint server from Farm – “cacheHostInfo is null”

I was creating a new farm from an existing farm due to project requirements, but I came across a situation wherein I was not able to remove the server from the farm using the SharePoint 2013 UI(server was already removed using the command or you can remove it by using configuration wizard on the server … Continue reading Unable to remove SharePoint server from Farm – “cacheHostInfo is null”

MySite – EnsureMySiteUrl: PersonalSiteUrl of page is null

Mysites configuration is pretty simple which has the basic pre-requisites: User Profile Service must be running Mysite host site collection should be created Mysite managed path for users' site should be created mysites should be configured mysite web application should have self site creation on. Also, the end users who want to create mysites should have … Continue reading MySite – EnsureMySiteUrl: PersonalSiteUrl of page is null