Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Get Your Own Blog

If you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com.

Contact the author

All Blogs

Feeds

Archives for this blog

Vinay Thakur

Sql Server 2014…….What!!!

Yes, its true. Microsoft vice president has announce  that new version of sql server 2014, will release on 2014… do you think it is possible, as  not most of us not familiar with 2012 only…. any way…as MS already clear … Continue reading →

Read more

0 comments, 191 reads

Posted in Vinay Thakur on 17 June 2013

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/

Read more

0 comments, 139 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 →

Read more

0 comments, 193 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 →

Read more

0 comments, 207 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 →

Read more

1 comments, 268 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 →

Read more

0 comments, 283 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 →

Read more

0 comments, 290 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 →

Read more

3 comments, 313 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 →

Read more

0 comments, 395 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 →

Read more

0 comments, 386 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 →

Read more

4 comments, 328 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 →

Read more

0 comments, 611 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 →

Read more

0 comments, 833 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 →

Read more

0 comments, 616 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 →

Read more

0 comments, 564 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 →

Read more

0 comments, 325 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 →

Read more

0 comments, 441 reads

Posted in Vinay Thakur on 26 May 2012

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

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…

Read more

0 comments, 371 reads

Posted in Vinay Thakur on 25 May 2012

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

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, 418 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, 481 reads

Posted in Vinay Thakur on 23 May 2012

Older posts

 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.