eBook downloadGet your free eBook to find out root cause for the performance problems with your application when ASP.NET and SQL Server is involved. The offer is available from Red-Gate software Free eBook: 50 Ways to Avoid, Find and Fix ASP.NET Performance Issues – eBook download. Also Free trial: root out ASP.NET & SQL Server performance problems[...]
Here is the considerable effort you need to put up to download, test and implement cumulative update package and that is announcement from SQL Server Release Services - Cumulative Update 2 for SQL Server 2012 SP1. KBA2790947 talks much about the list of hotfixes with this CU release. As referred previously in the CU release blog[...]
The last post was speaking on the approach one should probably take on assessing performance of a TempDB, and also size appropriately. Today I will share a list of pointers that I had used to assess the configuration of TempDB and its performance. I had to to do this on a production system, and unfortunately[...]
This post is less technical and more on the approach that needs to be considered. So lets get started. Any issue in an environment where an application is already deployed and if there is noted performance overhead which needs a fix, then the troubleshooting has to be done with a pre-meditated approach, plan and steps.[...]
I worked on an exercise a year back and this is a bit old. Nevertheless the learning’s of this assignment gave me very good experience. It’s worth remembering and sharing with you all. Everyone knows about importance of TempDB and the sizing of this database has impact on the performance in OLTP or Analytical systems.[...]
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, since 2008 version release and 64-bit (default) rollout a little overview[...]
A big week ahead indeed, speaking at SQL Saturday conference for the first time… and one more first time is ..in Riyadh, Saudi Arabia. SQLSaturday Riyadh – event will be held (for the first time in the Middle East) in May 23rd 2013 at Holiday Inn (AlQasr), Olaya., Riyadh, Saudi Arabia. No doubt that SQLSaturday’s are[...]
PowerPivot is one of the best feature that is provided for the end-users and one of the best practice is to install PowerPivot once the SQL Server platform is installed on the server side. Microsoft documentation refers that ….the SharePoint farm for configuration consistency, including Application servert s and web-front end servers. The installer package[...]
It is another wonderful opportunity to speak at another SQL Saturday conference #229 in Dublin on June 22nd 2013. SQLSaturday event that is managed by SQLPASS organisation (SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server). The schedule for this event has not yet been made visible to[...]
For the first time its a wonderful opportunity for me to speak at SQLSaturday event that is managed by SQLPASS organisation (SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server). SQLSaturday #208 – on May 23rd 2013 at Prince Sultan University, King Abdullah road, Riyadh, Saudi Arabia.[...]
Here is the chance to win the sweepstakes on the eve of SQL Server 2012 release 1st Anniversary. Here is the text from SQL Server blog: This month, we are celebrating the one year anniversary of SQL Server 2012, and we’d like to give a little shout out to our community to say, “Happy[...]
In addition to the SQL Server 2012 SP1 Feature Pack – exclusive for Analysis Services blog post I had few follow up questions about what’s new added to SQL 2012 SP1 Feature Pack list. Here they are: (Source SQL2012SP1-FP MS Downloads page) Microsoft® Attunity Oracle CDC Designer and Microsoft® Attunity Oracle CDC Service for Microsoft® SQL Server®[...]
SQL Server Feature Pack is one of my favourite options to get to know, because they offer good value for the DBAs/Developers/Architects to obtain required components as these are standalone packages. Further to this each of these components are divided into corresponding services SQL Server, SSAS, SSIS and SSRS. Rather than list what was required[...]
1. Microsoft SQL Server Migration Assistant for Access 2. Microsoft SQL Server Migration Assistant for MySQL 3. Microsoft SQL Server Migration Assistant for Oracle 4. Microsoft SQL Server Migration Assistant for Sybase
In general the Cumulative Update packages deals with interim issues or a specific problem pertaining to specific feature in the product. However the CU2 package for SQL Server 2012 SP1 has got some great and new features associated. They are: Backup and Restore from SQL Server (native) to Windows Azure Blog storage SysPrep includes SSAS,[...]
Cloud Computing is the buzzword for the business and Windows Azure with SQL Server provides much more flexibility on availability. The key factor for the Azure is TCO – Total Cost Ownership, which is reduced where the Windows Azure VM enables the reduction of deployment, management and support for those servers. Using Windows Azure and[...]
SQLMaster
Shyam Viking
Not logged in