|
|
-
|
|
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 of f...
|
|
-
|
|
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 featur...
|
|
-
|
|
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 identifie...
|
|
-
|
|
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 as...
|
|
-
|
|
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 sh...
|
|
-
|
|
Until SQL Server 2005 SP3 I used to remember the version from the build number of SQL Server, however since 2008 version it was hard to remember due to the fact of cumulative update package releases.
Since the changes affected from SQL Server Release Servi...
|
|
-
|
|
SQL Server 2008 R2 has two new additions to its Analysis Services (BI) hat, PowerPivot for Excel and PowerPivot for SharePoint.
Similarly SQL Server 2012 also includes new features for PowerPivot component that features for both SharePoint and Excel. To ch...
|
|
-
|
|
SQL Server administration is one of the key responsibilities for every DBA to keep up the availability, performance, and scalability of the data platform. Well not an easy or small job/task to manage MultiServer administration unless the automation is incl...
|
|
-
|
|
I treat Scalability and Performance like a two-side coin whenever the SQL Server operability consulting is involved. The Scalability and Performance is guaranteed when the reliable storage is configured at the hardware level. In general, the storage conf...
|
|
-
|
|
Distributor has an important place and piece of puzzle within the SQL Server replication. The key objective for distributor and distribution database to store metadata and historical data pertaining to all types of replication transactions.
By default we ...
|
|