SQL Server

How to configure SQL Express 2012 to accept remote connections

Source: http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/ When you try to connect to an instance of Microsoft SQL Server 2012 Express from a remote computer, you might receive an error message. INTRODUCTION Named SQL instances listen on dynamic ports. This is the function of the Sql Server Browser Service to inform the clients of the actual port. The Sql Browser listens on UDP… Continue reading How to configure SQL Express 2012 to accept remote connections

SQL Server

HOW TO CLEAR SQL SERVER TRANSACTION LOG TO REGAIN SPACE

Nguồn : http://www.sqlserverlogexplorer.com/how-to-clear-transaction-with-dbcc-shrinkfile/ A Transaction Log is a file that contains all the records of transactions and the database modifications made by each transaction in SQL Server database.The log file plays a very important part of SQL Server database when it comes to disaster recovery and it should not be in corrupted state. In case of… Continue reading HOW TO CLEAR SQL SERVER TRANSACTION LOG TO REGAIN SPACE

SQL Server

ASCII() , CHAR() — String Functions

Source: https://sqljunkieshare.com/2012/01/11/ascii-char-string-functions/ Before we go ahead about these functions first I will introduce little bit about ASCII ASCII stands for American Standard Code for Information Interchange. Computers can only understand numbers, so an ASCII code is the numerical representation of a character such as ‘a’ or ‘@’ or an action of some sort. ASCII was developed a long… Continue reading ASCII() , CHAR() — String Functions