|
|
-
TechDays Coming to Hyderabad!...
|
-
As of now (this post written date) the Service Pack1 for SQL Server 2012 still in CTP4 stage for your own testing on enhancements, which will be ready in next few weeks time as a full RTM'd downloadable package.
During the preliminary testing the list o...
|
-
The first installment for SQL Server 2012 Services Pack1 - CTP4 is available to download and test.
Earlier CTP3 (first public CTP) revealed the Self-Service BI capabilities for Office & SharePoint 2012 compatibility features. IN addition to this fea...
|
-
You may know how to configure the listening port for SQL Server database engine service, via SQL Server Program Group --> Configuration Tools --> SQL Server Configuration Manager by looking into protocols and choose TCP/IP. The port number can be identi...
|
-
Any statement that begins execution on a SQL instance, it will be compiled as a query plan which is taken care by query optimizer to produce the results (thinking an efficient manner). All such compiled query plans are stored in memory which is referred...
|
-
Since SQL Server 2005 the lock escalation has been more effective to provide database consistency and concurrency.
Like it represents the data is modeled as hierarchy of objects in SQL Server, database --> schema --> table (--> table partition) --> page...
|
-
As a DBA parallelism or MAXDOP terms do not need any special introduction, but it is highlgy essential to keep up the necessary settings (default value is 0) on your data platform. In many cases MAXDOP helps to achieve optimization for SQL Server proces...
|
-
It is very rare to see a hotfix or cumulative update for the product that is out of mainstream support (and soon out from extended support too). Also I don't normally blog on a Sunday, but 1 email from MS Security bulletin caught my eye and my knowledge...
|
-
We got SQL Server 2008 R2 Service Pack2 to test and implement on your data platform, now you need to concentrate on Feature Pack for this version too that will help to enhance your programming/design/architecture/support projects.
Feature Pack as the na...
|
-
Here is the news about another release of Service Pack for SQL Server 2008 R2 (10.5 version), service pack2.
This SQL Server 2008 R2 SP2 release consist all the hotfix and cumulative update package solutions from 1 to 5 (SQL Server 2008 R2 builds that ...
|