I have already blogged about validating positive integer numbers in this post (SQL SERVER – UDF – Validate Natural Integer Function).
SQL SERVER – List Database Available for Current User – HAS_DBACCESS
In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.
SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access
I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.
SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention with OPTIMIZE_FOR_SEQUENTIAL_KEY
I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
SQL SERVER Management Studio and SQLCMD Mode
Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.
SQL SERVER – Turning OFF or ON Query Store for All the Database
There were two scripts that were very much asked and they are how to Turning OFF or ON Query Store for All the Database? Let us learn today.
SSMS – Bug – Execution Time-Out
While the new SSMS has fixed many bugs, there is one configuration setting about execution Time-out either does not seem to work.