-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Many times I have seen this question coming from users – Can I still buy per socket licenses for installing SQL2008 R2 ? This question comes into the mind as SQL…
Automatic Page Repair is one feature which is not really famous, however pretty much known to most of us. I wanted to write about Automatic Page Repair since a very…
Page level restore is not something new for us, however page restore via SSMS (GUI) is something new, and it’s a feature available for SQL Server 2012. Page level restores…
During the month of April 2012 Microsoft released CU1 for SQL Server 2012. Earlier I was focusing only on Service Packs (SP) whenever they are released. I moved on from…
How many times you have seen heavy CPU utilization,heavy disk I/O happening when ever a backup job is running on a production SQL server.The CPU utilization hits top values if backup…
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…
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…
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…
Its been long that I wanted to capture Wait Stats using extended events session,and today I got a chance to demonstrate the same. The focus was to capture CXPACKET wait stats which…
Cloud & SQLSailor 