Guest Post on SQL Authority – Default Trace & Deleted Databases

I had the opportunity to write another guest post at SQL Authority:
Finding Out What Changed in a Deleted Database
This one...

IN clause in SQL Server

With IN clause, we can specify multiple values in a WHERE clause.

For example, in case of "IN", one can use...

LEN() function in SQL Server

LEN():- This function is used to get the length of the given string value.

  Syntax:-

    Select len (stringvalue)

  For example,

   ...

LOWER() function in SQL Server

LOWER():- This function is used to convert the value of a column to lower case

 Syntax:-

 Select LOWER (string)
 
 or
 
 SELECT LOWER(column_name) FROM table_name

For...

LTRIM() function in SQL Server

LTRIM ():- This function is used to get the string after the removal of leading blank spaces.

Syntax:-

LTRIM ( character_expression )

For example:-

Select LTRIM ...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

More than sp_help

If you have worked with SQL Server for very long you have probably run across the extremely useful system function...

Presentation slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday.  The abstract...

SQL Server UG in Vegas August 2014 Meeting

  Another Great meeting and topic is coming to the folks in Las Vegas.  This month we have had the luck of finding Mike Fal (blog | twitter) step...