Monthly Archives: May 2012

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

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Posted on May 25, 2012 by

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)   MDS and Best Practice Analyzer new features were introduced in sql server 2008 R2, System Health Session – Introduced in Sql server 2008 in Denali Microsoft tried to … Continue reading →

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

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Posted on May 24, 2012 by

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics   Earlier sql server was having diagnoses tool. Default trace. SQLDiag And other tools but could not got the one which we can all it as True Black Box Recorder … Continue reading →

Posted in Denali, Troubleshooting | Tagged | Leave a comment

Denali – Day 23: Data Quality Services (DQS)

Posted on May 23, 2012 by

Denali – Day 23: Data Quality Services(DQS) Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data in it, most of the time, we enter the data but as a user they enter the data … Continue reading →

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

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)

Posted on May 22, 2012 by

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)   As stated earlier on blog on “LocalDB” discussion, developers are involved in development and has to interact with database, in this case Denali has introduced another tool called … Continue reading →

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