Building The SQLSaturday Orlando Marketing Plan-Part 32

I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...

Building The SQLSaturday Orlando Marketing Plan-Part 33

More notes, hopefully not repeating any from previous posts!
Karla has used the chart showing registration growth as a way to...

Clustered Columnstore Indexes – part 38 (“Memory Structures”)

Continuation from the previous 37 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In the past I have been writing quite a lot on the...

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