4517 0
Validate Email address in SQL Server
In this article, I have provided example query, by executing which you can validate email address in SQL Server.
Type
Article
4332 0
Understanding SQL server COALESCE() with example (ISNULL comparison included)
In this article, I am going to provide you complete details of SQL server COALESCE function with example & will compare it with ISNULL.
Type
Article
4262 0
Best Free SQL Server database hosting
In this article, I have provided list of best free or cheap sql hosting providers available with there features.
Type
Article
3970 1
How to enable full text search on SQL Server database?

I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.

So, how can I enable full-text index to remove above error?

...
Type
Question
3920 0
SQL Server Management Studio (SSMS) Versions
In this article, I have provided list of all SQL Server management studio (SSMS) versions release by Microsoft until now with it's download links.
Type
Article

3883 1
How to fix "SQL server configuration manager cannot connect to wmi provider" error?
In this article, I am going to provide your easy way to fix SQL server configuration manager cannot connect to wmi provider error.
Type
Article
3791 4
SUM and JOIN 2 columns with different tables but it duplicates results

Trying to SUM and JOIN 2 columns with different tables but it duplicates results, here is my query

...
Type
Question
3569 2
Cannot connect to WMI Provider SQL server configuration manager error

I am trying to open SQL server configuration manager, after following this question "How to open sql server configuration manager in windows 10?" and steps to show it on Start menu, but when opening configuration manager getting error pop-up with message

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace

...

Type
Question
3525 2
Relational Algebra and Relational Calculus

I am new to Database systems and I don't really have the best lecturer and we are learning about Relational algebra and relational calculus, not many videos or help online. 

Please can someone assist me with this topic as i would like to get further knowledge 

...
Type
Question
3506 2
Error "Connection was established with server but error occurred during login process" SSMS

When I am trying to login into my local database server using SQL server management studio, I am getting an error, as shown below

A connection was successfully established with the server, but then an error occurred during the login process. 
(provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) 

...

Type
Question

Page 5 of 11