This Script will allow you to backup all dbs in the fly. the script looks for .mdf file in your sql instance and back all of the files it find except the system databases … Job done !
You might know some pretty large perfect squares. But what about the NEXT one? Complete the findNextSquare method that finds the next integral perfect square after the one passed as a parameter. Recall that an integral perfect square is an integer n such that sqrt(n) is also an integer. If the parameter is itself not… Continue reading C# Find the next perfect square!
Hello and Happy New Year After holidays break I decided to share script that I wrote the other day. The script can handle daily routine job of some of SharePoint and Windows Administrators and do all the automation. Recieved all error and warnings about entire SharePoint and Widows Servers Environments via e-mail day by day… Continue reading SharePoint Health Analyzer + Windows Eventviewer daily mailer from localhost and remotely logs via e-mail
Introduction In this article we can try to create a custom Timer Job in SharePoint. The tools we are going to use are the following: Visual Studio 2010 SharePoint DevTools from CodePlex We can start with analyzing what a Timer Job is. What is a Timer Job? A Timer Job is a periodically executed task… Continue reading SharePoint Timer Job in C#
how to get the middle string you need something like that declare @text varchar(64) set @text = ‘123|456|798’ SELECT SUBSTRING(@text,CHARINDEX(‘|’, @text) + 1,LEN(@text) – CHARINDEX(‘|’, @text) – CHARINDEX(‘|’, REVERSE(@text)) )
I had the issue with saving data to DB using Entity Framework and SaveChanges() method, and fixed it by adding the following lines to the web.config of my application: <runtime> <assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″> <dependentAssembly> <assemblyIdentity name=”Microsoft.SqlServer.Types” publicKeyToken=”89845dcd8080cc91″ /> <bindingRedirect oldVersion=”188.8.131.52-184.108.40.206″ newVersion=”10.0.0.0″ /> </dependentAssembly> </assemblyBinding> </runtime> This forces the EntityFramework to use the version 10 of the… Continue reading Entity Framework cannot update database – SaveChanges() related to SetClrFeatureSwitchMap error