Do We Care?

Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog,...

ExpressProfiler - new release

Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...

Guest Editorial Live on SSC

My guest editorial is live on SQLServerCentral.com. My argument is a simple one: we don’t care about data and IT...

Intersection command in SQL Server

This function is used to returns distinct values that are returned by both the query on the left and right...

Last Weeks Top “Reading” Links #96

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

LEFT() function in SQL Server

Left():- This function returns the specified number of characters from the left part of the given character string.

Syntax:-

Select LEFT ( character_expression...

Let SQL Server Write Code for You

Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...

Like() function in SQL Server

Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...

New website

As you can see the webpage has changed!
New features are:

– Syntax highlighting on code snippets (and easy copy/paste)

– Better readability

–...

RIGHT() function in SQL Server

Right():- This function returns the specified number of characters from the Right part of the given character string.

Syntax:-

 Select RIGHT ( character_expression...