|
|
-
|
|
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend using 4...
|
|
-
|
|
Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup:
Always run this report with the most recent data, Do not cache temporary c...
|
|
-
|
|
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
|
-
|
|
I like the integration of SSIS and DQS. It's a great way to automate cleansing of data. while exploring further, I learned that currently, DQS does not expose matching functionality for SSIS to use but I guess I'll have to try Fuzzy Grouping Transform t...
|
|
-
|
|
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server ''. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed but d...
|
|
-
|
|
UrlEncode transmites html content to server compitible text but single quote (') or double quote (") or ampersand (&) or slash (\) or space or etc are not able to encode.
when transmitted by request it raises error of potential dangerous request.
the ...
|
|
-
|
|
I just got started with Windows 8 on my laptop without touch and the most difficult part is how to close an app in Metro. The answer is simple ALT + F4. Or you could drag the app from the top bar all the way to the bottom to close it ( not too good)....
|
|
-
|
|
ASP.NET 4 also enables you to configure the characters that are used by the URL character check. When ASP.NET finds an invalid character in the path portion of a URL, it rejects the request and issues an HTTP 400 error. In previous versions of ASP.NET, ...
|
|
-
|
|
I just learnt that, we can access environment variables simply by typing "%VariableName%" in "Run Window" (Win + R). Most of you might have used "%temp%" in your run window to reach the temp folder on your computer and that "temp" actually refers to an ...
|
|
-
|
|
I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z] ;...
|
|