|
|
-
|
|
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...
|
|
-
|
|
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) --> pages. ...
|
|
-
|
|
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 name ...
|
|
-
|
|
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...
|
|
-
|
|
This month’s T-SQL Tuesday is hosted by Erin Stellato, asking participants to talk about “A Day in the Life”.
I had been ignoring this event all this while and it’s because I had other things on my plate, and this time I had deci...
|
|
-
|
|
In continuation to my previous posts on waits, [Waiting on wait tasks, adds more weight to fix a performance problem] I got few follow up references on the other wait types async_network_io (SQL 2005 onwards) and networkio (until SQL 2000).
Just on basics...
|
|
-
|
|
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...
|
|
-
|
|
MAP Toolkit is a very helpful tool (personally I have been using this since last 5 years) whenever you have a migration task in your IT environment. Not only for the migration tasks I believe it is useful to get an audit of information on the IT inventory....
|
|