Visual Studio Magazine

Full-Text Search in SQL 2012 with Custom Proximity

Custom proximity search is a new feature introduced in SQL Server 2012 Full-Text Search. It's facilitated using the NEAR operator, allowing it to be used in the CONTAINS predicate or CONTAINSTABLE ...
Ars Technica

[ASP.NET/SQL CE 4] A parameter is missing. [ Parameter ordinal = 1 ]

Help! This is really strange, as it seems correct to me. Code: Dim PKID As Guid = Membership.GetUser(User.Identity.Name).ProviderUserKey sqlCmd.Parameters.AddWithValue("@PKID", PKID) ...
GitHub

Optional parameter validation causing unnecessary break in deployment

If optional parameters are present and invalid, parameter validation breaks deployment. Is there an ideal solution? If invalid optional parameters are present, no match will be found so parameter file ...