SQL SERVER – Cursor, Log File and More – Memory Lane #004
This is the 4th episode of memory lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite article this week is an article discussing cursor and log file. Let me know which one of the following is your favorite article from memory lane.
SQLAuthority News – Android Efficiency Tips and Tricks – Personal Technology Tip
SQL SERVER – Removing Leading Zeros From Column in Table – Part 2
SQL SERVER – Using RAND() in User Defined Functions (UDF)
Here is the question I received in email.
“Pinal,
I am writing a function where we need to generate random password. While writing T-SQL I faced following issue. Everytime I tried to use RAND() function in my User Defined Function I am getting following error:
SQLAuthority News – Microsoft SQL Server 2012 Service Pack 1 Released (SP1)
SQL SERVER – Weekly Series – Memory Lane – #003 – Database Encryption
Here is the list of selected articles of SQLAuthority.com across all these years. In this blog post, we will talk about database encryption.


