SSC Editorial: The Problem Solver

The Problem Solver. Ever scoffed at personality types? Surely none of us are just one thing, but often we are...

The default instance has a name

The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...

Your presentation matters! Do it right!

This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov...

Buffer Pool Extension in SQL Server 2014 part 2: benchmark testing

Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For...

At SQL Server Geeks 2015 - Pre Conference Session - Benjamin Nevarez

Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at...

How SQL store your data?

What happens when you create a table?
Have you ever give it a thought, how sql server actually managing your table?...

How SQL store your data?

What happens when you create a table?
Have you ever give it a thought, how sql server actually managing your table?...

syntax error in textheader of stored procedure - Cause and Solution

Hi Folks,

Comments play an important part in writing any code. Especially when somebody else reads your code. So the other...

Pluralsight Authoring – Upcoming Course

I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on Monitoring AlwaysOn Availability Groups and was accepted on the...

Pluralsight Authoring – Upcoming Course

I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on...