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...

Except command in SQL Server

This function returns the distinct values from the left query that are not also found on the right query. For...

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...

Generate Random Date With Starting Point

If you want to create sample random samples when dealing with date calculations to test your results, you can easily...

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...

MS14-044–Security Alert for SQL Server

I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL...

Renaming or Changing SQL Server Cluster Instance

Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...

Round() function in SQL Server

Round():-This function is used to round a numeric field to the number of decimals specified.

Syntax:-

    ROUND ( numeric_expression , length [ ,function ]

numeric_expression...