Apr 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Calculate Simple Interest

SQL SERVER – Function to Calculate Simple Interest

April 30, 2021
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

It was very surprising that they would write a complicated function. Let us see a very simple way to write Function to Calculate Simple Interest.

Read More

SQL SERVER – Difference Between Count and Count_Big

April 29, 2021
Pinal Dave
SQL Tips and Tricks
Data Type, SQL Scripts, SQL Server

Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.

Read More
learning resources

Learning Resources I Use and Recommend (Updated: April 2020)

April 27, 2021
Pinal Dave
SQL Tips and Tricks
Instant Learning

In today’s blog post I will be sharing a few of the learning resources which I have been using to further train my skills. 

Read More
Greenbox Around Icon

Android Greenbox Around Icon – Unable to Scroll

April 23, 2021
Pinal Dave
SQL Tips and Tricks
Android

I thought it might be just a temporary thing and I had restarted it but that was not the case. In My android phone, I had a Greenbox Around Icon.

Read More
Join Type

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

Read More
python3

Install Python3 on Linux

April 21, 2021
Pinal Dave
SQL Tips and Tricks
Kali Linux, Linux, Python

My major focus is always on SQL Server. I know a little bit about other technology as well. It is very straightforward to install Python3 on Linux.

Read More
change password

SQL SERVER – Change Password at the First Login

April 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.

Read More
Previous 1 … 21 22 23 24 25 26 27 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version