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

Denali — Day 1: Tempdb Compatibility – Bug?

Denali — Day 1: Tempdb Compatibility – Bug?

 
I have installed sql server 2012 express and evolution edition on my personal laptop, and...

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may...

Denali – Blog a Day Series : May, 2012

Denali

 
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is...

More IMPORTANT miscellaneous info

 
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.

Okay,...

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...