syron

DECLARE @rowCount INT
      , @rowsToDelete INT = 5000
      , @highestDate DATETIME2(7) = '2015-03-01'
      
      
WHILE 1 = 1
BEGIN
  DELETE TOP (@rowsToDelete) T FROM Table T
  WHERE T.DateTimeColumn < @highestDate
  

syron

<system.serviceModel>
    <bindings>
        <basicHttpBinding>
            <binding name="BasicHttpBinding_ILogApiService" />
        </basicHttpBinding>
    </bindings>
    <client>
        <endpoint address="http://localhost/IM/LogAPI/LogApiService.svc"
            binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_ILogApiService"
            contract="IM.Libraries.Contracts.ServiceContracts.ILogApiService" name="BasicHttpBinding_ILogApiService" />

syron

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,Log4net"/>
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
  <log4net>
    <appender name="FileAppender" type="log4net.Appender.FileAppender">

syron

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,Log4net"/>
  </configSections>
  <appSettings>
    <add key="IM.Log4Net.IsOneWay" value="false" />
  </appSettings>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />

syron

@equals(actions('YOURACTION').status, 'Failed') 

syron

@concat('YOURTARGETPATH/',triggers().outputs.body.FileName)

syron

HybridConnectionManager.exe Error: 0 : Install failed! Exception: System.Management.Automation.CmdletInvocationException: Could not load file or assembly 'Newtonsoft.Json, Version=4.5.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Newtonsoft.Json, Version=4.5.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.
   at System.Net.Http.Formatting.JsonMediaTypeFormatter..ctor()
   at System.Net.Http.Formatting.MediaTypeFormatterCollection.CreateDefaultFormatters()
   at Microsoft.HybridConnectionManager.Commands.GetHybridConnection.ProcessRecord()
   at System.Management.Automation.CommandProcessor.ProcessRecord()
   --- End of inner exception stack trace ---
   at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
   at System.Management.Automation.PowerShell.Worker.

syron

gacutil /i {{Path to newtonsoft.json.dll}}

syron

Welcome to StackEdit!
===================

[TOC]


Hey! I'm your first Markdown document in **StackEdit**[^stackedit]. Don't delete me, I'm very helpful! I can be recovered anyway in the **Utils** tab of the <i class="icon-cog"></i> **Settings** dialog.

----------

syron

var shiftIsPressed = false;
$("#LogAddForm textarea").keyup(function(e) {
	if (e.keyCode === 16) shiftIsPressed = false;
});
	
$("#LogAddForm textarea").keydown(function(e) {
	if (e.keyCode === 16) shiftIsPressed = true;
	
	if (e.keyCode === 13 && !shiftIsPressed) {
		$("#LogAddForm").submit();