|
|
-
|
|
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 job by streaming most of the sessions,key...
|
|
-
|
|
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 on the laptop.One has to be setup as a domain controller and a windows cluster has to be s...
|
|
-
|
|
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 at once.
If you look the below screen, you can see that there are multiple instances a...
|
|
-
|
|
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 decided to learn more about this,and a quick search on...
|
|
-
|
|
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\2012...
|
|
-
|
|
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 zero, not NULL – correct?
Before we get into the details,I wou...
|
|
-
|
|
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 version.SQL Server 2012 Best Practices Analyzer will offer scanning of both ...
|
|
-
|
|
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 if OLEDB wait type has a dependency with DBCC.
OLEDB is a common...
|
|
-
|
|
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 2012
Prior to 2012 we had 2 memory managers.One was for handling allocations of 8k ...
|
|
-
|
|
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 saw metro UI for SQL Azure t...
|
|