Denali — Day 11: SSMS enhancement

Denali — Day 11: SSMS enhancement

SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...

Denali — Day 10: Sequence object

Denali – Day 10: Sequence object

Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...

Denali — Day 9: Additional Scalability Features

Denali – Day 9: Additional Scalability Features

15,000 Partitions earlier it was 1000For the enterprise system having huge amount of data to...

Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter

Startup Parameters means you are providing the parameter to sql server at the start of sql...

Denali — Day 7: Contained Database

Denali – Day 7 : Contained Database

Contained database is another new feature for sql server 2012 – Denali, earlier version has a big...

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint

I have already blog some information about checkpoint here

As I have already blog about Checkpoint and...

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)

 
There is another great achievement for Denali, especially for Data warehouse, where data...

Denali – Day 4: Editions & Licensing

Denali – Day 4: Editions & Licensing

Editions:

Here is a brief edition summary of Editions available for all sql server from 2005 to...

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

 
I know this should be first or second blog post when...

Denali – Day 2: AlwaysON High Availability (aka Project HADRON)

Denali – Day 2: AlwaysON High Availability (aka Project HADRON )

AlwaysON Availability Group:

is another very important achievement done by development team project...