VSS KB Articles

Redirect from HTTP to HTTPS using the IIS URL Rewrite module
2/12/2018
This is the most common requirement on most of the Exchange servers hosted on IIS. The server admins configure an http to https redirect.


Sonicwall disconnects from network every 10-15 minutes on Verizon FIOS
2/11/2018
ISP temporarily disabling port due to receiving excessive ARP requests from SonicWall. Here are the settings to resolve it.


Encrypting Connections to MS SQL Server
2/8/2018
If you want to use encryption with a failover cluster, you must install the server certificate with the fully qualified DNS name of the failover clustered instance on all nodes in the failover cluster. For example, if you have a two-node cluster...


DFS management console throws a “the value does not fall within the expected range”
1/13/2018
Windows Server DFS management console throws a “the value does not fall within the expected range”


How to change network profiles on Window 2012R2 Server
1/12/2018
After a restart of one of our servers (a Windows Server 2012 R2), all private connections become public and vice versa. Things like pinging and iSCSI stopped working, and after some investigation it turned out this was the cause.


    

5/10/2011
How to Combine columns with NULL values in SQL 2008 R2

How to Combine columns with NULL values in SQL 2008 R2 using coalesce

I ran into a problem where a NULL value was preventing the rest of the other columns I was trying to combine fail for UPS WorldShip interface.  I discovered that coalesce would be my solution for the issue.  I have profided a working sample below for reference:

/****** Object: View [dbo].[UPS_View] Script Date: 05/10/2011 03:16:03 ******/

SET

 

ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

 

 

 

QUOTED_IDENTIFIER, ANSI_NULLS ON;

 

GO

SET

 

QUOTED_IDENTIFIER ON

 

 

GO

 

 

 

ALTER

 

VIEW [dbo].[UPS_View]

 

AS

SELECT

 

dbo.ac_Orders.OrderNumber, coalesce(dbo.ac_OrderShipments.ShipToCompany,'') + ' ' + coalesce(dbo.ac_OrderShipments.ShipToFirstName,'') + ' ' + coalesce(dbo.ac_OrderShipments.ShipToLastName,'') AS [ShipToName], dbo.ac_OrderShipments.ShipToAddress1, dbo.ac_OrderShipments.ShipToAddress2,

 

 

dbo

.ac_OrderShipments.ShipToCity, dbo.ac_OrderShipments.ShipToProvince, dbo.ac_OrderShipments.ShipToPostalCode,

 

 

dbo

.ac_OrderShipments.ShipToCountryCode, dbo.ac_OrderShipments.ShipToResidence

 

FROM

 

dbo.ac_Orders INNER JOIN

 

dbo

.ac_OrderShipments ON dbo.ac_Orders.OrderId = dbo.ac_OrderShipments.OrderId

 

 

 

 

 

GO