Category Archives: Computers and Internet

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

Posted in Computers and Internet, General, Personal | Tagged | Leave a comment

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 also available now. http://www.microsoft.com/sqlserver/en/us/default.aspx After Sql server 2008 (compatibility 10) and sql server 2010 /sql server 2008 R2 … Continue reading

Posted in Computers and Internet, Denali, General, Whats New | Tagged , | Leave a comment

Find Login in Active Directory

Find Login in AD Many times we require to know if particular login is a part of ad user group. Or sometimes we need to know a AD group and wanted to know who all logins are part of it. … Continue reading

Posted in Computers and Internet, Others, Tool | Tagged | Leave a comment

Model Database size has increased.

  Model database has has increased during sql server development processes here is the size of model database SQL Server version Physical file size (bytes) sp_spaceused information model.mdf modellog.ldf reserved data index_size unused 2000 655,360 524,288 528 KB 144 KB … Continue reading

Posted in Computers and Internet, Others | Tagged , | Leave a comment

Denali

The new version of Sql server “11” code name “Denali” has released and CPT3 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx The more infomration on this by experts : http://www.brentozar.com/archive/2010/11/sql-server-code-name-denali-release-date-today/ http://sqlblog.com/blogs/aaron_bertrand/archive/tags/denali/default.aspx http://sqlinthewild.co.za/index.php/2010/11/09/first-impressions/ http://sqlcat.com/whitepapers/archive/2010/11/09/new-spatial-features-in-sql-server-code-named-denali-community-technology-preview-1.aspx http://www.ssistalk.com/2010/11/09/sql-server-future-code-name-denali-ctp1-now-available/ http://download.microsoft.com/download/8/C/1/8C1CE06B-DE2F-40D1-9C5C-3EE521C25CE9/Columnstore%20Indexes%20for%20Fast%20DW%20QP%20SQL%20Server%2011.pdf Will write a blog about Whats … Continue reading

Posted in Computers and Internet, General, What I learned today | Tagged , , | Leave a comment

Torn page detection vs Page Checksum

TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The data page is of size 8k and  combination of 8 pages is called extent. where as hardware storage is stored in … Continue reading

Posted in Basic, Computers and Internet, What I learned today | Tagged , , | 2 Comments

Diskpart command line utility

To get the disk information internal. there is a utility called diskpart this is good utilityto understand your disk information. some good commands are. diskpart diskpart> list disk diskpart> select disk <0> diskpart> detail disk some more commands…. http://support.microsoft.com/kb/300415 Must … Continue reading

Posted in Computers and Internet, General, Software, What I learned today | Tagged , | Leave a comment

Resource database

Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server 2005, this database is hidden and user cannot see and access it directly, all the sys. schema (system objects) are … Continue reading

Posted in Computers and Internet, General, Limitation, What I learned today | Tagged , | Leave a comment

Happy New Year 2011

Wish you all a very happy and prosperous New Year 2011. When I see back year 2010 : >> was started my new blog – http://rdbmsexperts.com/Blogs/ but again back(oct 2010) to wordpress as space is migrated to wordpress. >>Was ok. moved back … Continue reading

Posted in Computers and Internet, Personal | Tagged | Leave a comment

New Blog Location

Hi Friends.   Thanx for your support. for this year onwords I will be bloging on my own website….   Hope to see you there   http://rdbmsexperts.com/Blogs     Thanx. Vinay   http://rdbmsexperts.com/Blogs/http://vinay-thakur.spaces.live.com/blog/http:\www.twitter.com\thakurvinay  

Posted in Computers and Internet | Leave a comment