|
|
-
|
|
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...
|
|
-
|
|
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 processes...
|
|
-
|
|
Few weeks back I had written a blog post sharing the links on why I had selected few areas as latest Data Platform Trends in SQL Server world. Today, I spent a little of my time to put the larger picture and share it.
This time its not going to be text, r...
|
|
-
|
|
Waits are helpful to find missing link for us to find the root cause for a performance problem, let it be a small problem or big problem the wait statistics plays key role in tracking down a performance related problem.
In the recent times I had to spend l...
|
|
-
|
|
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...
|
|
-
|
|
Performance Monitoring - The topic itself is huge enough to say and when it comes to the learning and training in performance tuning, there is always plenty of information to cover.
The basic principle is always to be 'what exactly is the problem' and for...
|
|
-
|
|
It was exciting to know that SQL Server 2012 rolled out sometime in the first week of April 2012, and all the hype and hoopla added more to the festival like atmosphere (at least for MSFT team). It was very much evident with all over the web announcements....
|
|
-
|
|
It is always handy to obtain a pre-configured report about system configuration and resource usage, in this regard SQL Server Management Studio embedded with series of Server-wide and Database-scope reports which are called Performance Dashboard Reports.
T...
|
|