-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
From last night I have been doing lot of planning to setup a virtual environment on my laptop.It was kind a little complex one as I will be dealing with 3 VM’s…
Yes ! The wait is over and you can now download the TechEd India 2012 session videos. http://india.msteched.com/ I wanted to attend the event in person,but couldn’t make it this time.Microsoft did a very good…
Today I had to remove multiple named instances of SQL2012 RC 0 editions. Suddenly an idea came to my mind. Is there a way were we can remove multiple named instances all…
Today I was querying sys.databases system view in SQL 2012 and was curious to find one column named target_recovery_time_in_seconds.I was pretty sure that this column was not available before 2012. I…
Today I came across an error for the Distribution clean up: distribution job in one of the environments Message – Executed as user: Domain\Sqlagentaccount. Could not remove directory ‘\\MachineName\ReplData\unc\MachineName_Replica_Replica10_PUB\20120403180393\’. Check the security…
Today there was an interesting question on max_files column value which is available under sys.traces view object.The question was like this – max_files in sys.traces is 0 and that means…
Couple of days back Microsoft released BPA for SQL 2012.There are no major changes which I could catch within the tool and the whole install,scanning looked similar to the earlier…
SQL 2012 comes up with lot of improvements and changes.One of the major change which the DBA’s should be aware is related to how memory allocations are made. Prior to…
Yesterday there was an interesting discussion related to OLEDB wait type getting spiked when DBCC is executed. This was pretty interesting question for me and was curious to really understand…
I was quite surprised to see Metro style UI tiles in codeplex site while downloading Adventureworks 2012 database. http://msftdbprodsamples.codeplex.com/ Great user experience is what this is all about,and earlier this month I…
Cloud & SQLSailor 