Category Archives: Denali

Sql server 2012 links

Posted on May 21, 2013 by

Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/

Posted in Denali, DMV, What I learned today, Whats New, Whitepapers | Tagged , , , | Leave a comment

Denali –Memory : Memory Error Recovery in SQL Server 2012

Posted on October 25, 2012 by

  Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a new feature of Sql server 2012 in association with windows server 2012 called Memory Error Recovery in SQL Server … Continue reading →

Posted in Denali, Memory, Whats New | Tagged , , | Leave a comment

Denali – Memory: “any size” page allocations

Posted on July 12, 2012 by

I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided into two parts: BPool – Single page allocation Mem_to_Leave – Multipage allocation. Single page allocation is a 8k page allocated … Continue reading →

Posted in Denali, Memory | Tagged , | Leave a comment

Download: Consolidated Denali a Day – May 2012

Posted on June 5, 2012 by

Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for the month of May 2012, then I can provide you a consolidated (for all 31 days) blog into a … Continue reading →

Posted in Denali, Whats New | Tagged , | Leave a comment

Denali – Day 31: Discontinue and Breaking/Behavior change features

Posted on May 31, 2012 by

Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that in Denali there are some features which has already discontinued. Means if you try to use those features they … Continue reading →

Posted in Denali | Tagged | Leave a comment

Denali – Day 30: Deprecated Features

Posted on May 30, 2012 by

Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but it’s highly possible that would not be available in future version of sql server, so you should plan your … Continue reading →

Posted in Denali | Tagged | Leave a comment

Denali – Day 29: Resource Governor Enhancements (Database Engine)

Posted on May 29, 2012 by

Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql server 2008. It requires Enterprise and developer edition.   As name implies It controls the resources allocation for users, … Continue reading →

Posted in Denali | Tagged | Leave a comment

Denali – Day 28: CDC for ORACLE

Posted on May 28, 2012 by

Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture Change Tracking http://www.mssqltips.com/tipprint.asp?tip=1819 Change data capture is introduced in 2008 now on Denali it supports for ORACLE database as … Continue reading →

Posted in Denali | Tagged , , | Leave a comment

Denali – Day 27: System Center Advisor (aka ‘Atlanta’)

Posted on May 27, 2012 by

Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis Microsoft has introduced a Tool for sql server called “System Center Advisor – SCA – aka Atlanta. Its internet … Continue reading →

Posted in Denali, Performance Tuning, Tool | Tagged | Leave a comment

Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)

Posted on May 26, 2012 by

Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent)   If you are good with: Xls Pivot table Power point   And you are on administration position to get reports and want to get stats. Power View … Continue reading →

Posted in Denali, SSRS, Tool | Tagged , , | Leave a comment