Max() function in SQL Server

Max():- This function gives the maximum value of the selected column

Syntax:-

Select Max (col1) from table_name

In this article, we are...

One of Those Must Read Books – The Cuckoo’s Egg

I was reading a book about network security monitoring and it mentioned The Cuckoo’s Egg by Cliff Stoll. Stoll’s book has been...

RTRIM() function in SQL Server

RTRIM():-This function is used to get the string after the removal of all trailing blanks.

Syntax:-

RTRIM ( character_expression )

For example:-

Select RTRIM('Vivek Johari ...

Say Thank You

I was approached by a man at SQL Bits who only wanted to thank me for blogging. He said, “I...

SQL Server for VM Admins vBrownBag Webinar

Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL...

Tableau Conference Is Bigger Than PASS Summit

I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe,  I was astounded to see that...

The Murder Train chugs into Denver!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...

T-SQL Tuesday #57: SQL Family and Community

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that...

Writing Parametrized MDX for Reporting Services

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long.  If all...

Deny vs Revoke

Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE 

Well lets start with some definitions
GRANT – Grants permissions on...