Answer If you get the following error message on your client when you try to use a licensed feature, even though your license server has definitely been started, then the communication between the server and client has probably been blocked. “<command line>”: Error: A1439E: Cannot obtain license for “<featurename>” with license …
Section 1 — Background What is a MAC? MAC stands for Message Authentication Code. In general, a MAC can be thought of as a checksum for data passed through an unreliable (or more importantly, unsecure) pipeline. A sender will typically generate a MAC code by first passing their message into …
Understanding NULLIF and ISNULL Introduction One of my friends wants to know about two functions NULLIF and ISNULL. In this article I am trying to discuss about that. Understanding NULLIF First we look at the syntax of the NULLIF The syntax is: NULLIF(Expression, Expression) Return type: Return type is the …
Copying Table with INDEX and CONSTRAINTS Introduction When we are trying to copy a table (Structure only or with Data) we are unable to copy the Indexes, constraint with it. Can we copy Indexes and Constraint with Table structure in the same database? This article is related to it. General …
Dynamic SQL result stored in a TABLE Introduction As we all know that the dynamic SQL is not good where performance is concern. But sometimes we don’t have other choices. As I personally think that, no developer chooses the dynamic SQL with interest, but they choose it as they have …
“IN”, “EXISTS” clause and their performance Introduction To improve the performance of the Query, the general guideline is not to prefer the “IN” Clause. The guideline of the MS SQL query performance says that if we needs “IN” clause, instead of using “IN” clause we must use the “EXISTS” clause. …
Function in WHERE clause Introduction When we are using the function in the SELECT statement it returns data depends on the number …
Improve the performance by Execution Plan Introduction Developers ask a common quest “How to improve the performance of a SQL Query”. It …
The Transport Layer Security (TLS) protocol provides communications security over the Internet. The protocol allows client/server applications to communicate in a way that is designed …
Accidental DELETE and UPDATE Introduction Accidental DELETE and UPDATE? Data loss… This article gives us a clear idea about it and what …
Make PDFs searchable pre { background-color:#444; white-space:pre-wrap; font-size:80%; padding:0px 6px; } I searched for a good way to make scanned documents searchable. …
Columns Without Data Type Introduction ”Can you make a table with CREATE TABLE statement, where there are 4 columns and 1 of …
Building PHP extensions with C++, the easy way (update: MySQL, threads) pre { background-color:#444; white-space:pre-wrap; font-size:80%; padding:0px 6px; } Here is an …
sql_variant Introduction Data type is a very important factor. Think about situations when we the developers are little bit confused related to …
