Perform LeftOuterJoin on DataTable Using Linq

Perform LeftOuterJoin on DataTable Using Linq

SQL Server – Generating PERMUTATIONS using T-Sql

 

SQL Server – Generate Calendar using TSQL

Introduction
Recently, I found the way to display Calendar using SQL Server

Implementation
Below is the TSQL which I came up with to generate the Calendar -

How to Resolve: "Multiple connections to a server or shared resource..." Or Access Shared Folder with different Credentials / remove existing credentials

1. Use "net use" to manually release the old connection

- From a command prompt, run "net use". 

- Delete any existing connections to the backup location. ("net use \\pathto\backups /delete").

- re-run net use and verify the connection is gone.

The next attempt by the agent may then be successful.  This method does not always succeed.

2. Restart the "Workstation" service on the agent machine

The "Workstation" service manages shared resource connections.  Restarting the service will force a release of the network connection.  Because of this, however, there are multiple dependent services, the more notable of which include Exchange services.  Many partners prefer to wait for non-business hours to schedule a restart of this service on a production server.

3. Restart the Server

As a last resort, a restart of the agent server will decisively release the network location.

Remove Shared Access Credentials.

======================================

Use CMD : 

net use * /delete /yes

 

rundll32.exe keymgr.dll,KRShowKeyMgr
======================================

Jquery Ui DatePicker Tip: 1. Allow to Select only current and previous date 2. Allow to select date from two days later from current date

I had requirement for a datepicker  

1. Allow to Select only current and previous date

Allow to select only current date and previous date. And exclude Sunday from selection.

So if todays is Monday than enabled date should be last Saturday and today (Monday).

2. Allow to select date from two days later from current date

Allow to select date from two days later from current date . And exclude Sunday from selection.

So if today is Friday then date selection should start on next Monday. And if todays is Monday then date selection should start on next Wednesday.  

Here Is The Script

 

1. Allow to Select only current and previous date
Date1 :
2. Allow to select date from two days later from current date
Date2 :