New website

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

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

– Better readability

–...

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

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

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

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

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...

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

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

Best practices for Database Programming

1. All the tables in the database have properly defined relationship using primary keys and foreign keys . 

2. Indexes should...

Between function in SQL Server

This function is used to select the values within a specified range. These values can be of Int type or...