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

Tables, Columns and Defaults Oh My!

Picture this if you could. You inherit a new database either through the change of a job, or finding a...

The most dangerous command in sql

GUYS,
I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the...

The most dangerous command in sql

GUYS,
I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the...

Upgrading a SQL Azure Database to v12

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

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

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

How to create first basic package with SSIS ? tip #113

Dear friends,
In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in...