Sql server 2012 links

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/

0 comments, 106 reads

Posted in Vinay Thakur on 21 May 2013

Good Bye 2012 and welcome 2013

Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company … yeah If you read my last year good bye Blog I have indicated about my interest for changing the company took … Continue reading →

0 comments, 185 reads

Posted in Vinay Thakur on 19 January 2013

Denali –Memory : Memory Error Recovery in SQL Server 2012

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 →

0 comments, 202 reads

Posted in Vinay Thakur on 25 October 2012

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading →

1 comments, 256 reads

Posted in Vinay Thakur on 6 September 2012

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services. >> After installation when try to access instance. You would get “ACCESS DENIED” error. To resolve this issue, … Continue reading →

0 comments, 268 reads

Posted in Vinay Thakur on 5 September 2012

Normalization & Demoralization

Normalization & Demoralization Someone asked me about this basic thing which we generally do not think much, so realize that should write a short blog on it. Normalization: For any database the way data is stored using different data models … Continue reading →

0 comments, 277 reads

Posted in Vinay Thakur on 4 September 2012

RAID (Redundant Array Independent Disk)

RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk sql server is no exception. Generally all activity happens on memory as memory is very fast compared to Disk. Earlier … Continue reading →

3 comments, 302 reads

Posted in Vinay Thakur on 17 August 2012

Denali – Memory: “any size” page allocations

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 →

0 comments, 375 reads

Posted in Vinay Thakur on 12 July 2012

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons, we may have to move physical file of the database to another location. Following are the different ways to … Continue reading →

0 comments, 364 reads

Posted in Vinay Thakur on 11 July 2012

Download: Consolidated Denali a Day – May 2012

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 →

4 comments, 318 reads

Posted in Vinay Thakur on 5 June 2012

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

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 →

0 comments, 601 reads

Posted in Vinay Thakur on 31 May 2012

Denali – Day 30: Deprecated Features

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 →

0 comments, 821 reads

Posted in Vinay Thakur on 30 May 2012

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

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 →

0 comments, 596 reads

Posted in Vinay Thakur on 29 May 2012

Denali – Day 28: CDC for ORACLE

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 →

0 comments, 534 reads

Posted in Vinay Thakur on 28 May 2012

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

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 →

0 comments, 308 reads

Posted in Vinay Thakur on 27 May 2012

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

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 →

0 comments, 425 reads

Posted in Vinay Thakur on 26 May 2012

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 make it improved and stable.

MDS (Master Data Services) – Introduced…

0 comments, 357 reads

Posted in Vinay Thakur on 25 May 2012

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
by “Bob Dorr – Principal SQL Server Escalation Engineer“”… Read more

0 comments, 396 reads

Posted in Vinay Thakur on 24 May 2012

Denali – Day 23: Data Quality Services (DQS)

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 assuming things are good, like “USA, US or America are… Read more

0 comments, 456 reads

Posted in Vinay Thakur on 23 May 2012

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 “SSDT” a visual studio shell tool for developers… Read more

0 comments, 401 reads

Posted in Vinay Thakur on 22 May 2012

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Vinay Thakur

Sql server 2012 links

Good Bye 2012 and welcome 2013

Denali –Memory : Memory Error Recovery in SQL Server 2012

DBCC Cleaning CACHE – Memory

Error: ACCESS DENIED on installation

Normalization & Demoralization

RAID (Redundant Array Independent Disk)

Denali – Memory: “any size” page allocations

Different ways to move Sql Server file location

Download: Consolidated Denali a Day – May 2012

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

Denali – Day 30: Deprecated Features

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

Denali – Day 28: CDC for ORACLE

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

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

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

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

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Denali – Day 23: Data Quality Services (DQS)

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

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