Browse by Tags

SQL Server 2008 Service Pack2 announcement and Cumulative Update package releases
18 February 10 05:36 AM | ssqa.net | with no comments

First things first, from the followup of SQL_Server_2008_SP2 post here is the good news to the community that SQL Server Release Services announcement about SQL 2008 SP2 release... Microsoft targets release in Q3/CY2010 . Next on the Cumulative Update...

Filed under: sql server, download, service pack, cumulative update

SQL Server - SSIS package transformation performance issues, follow up
06 February 10 11:19 AM | ssqa.net | with no comments

To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance...

Filed under: sql server, performance, memory, ssis package, monitoring, transformation, sysmon

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure
01 February 10 03:58 PM | ssqa.net | with no comments

A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; ...more from here;

Filed under: sql server, performance, error log, integration services, ssis package, low memory, export, import

SQL Server 2008 R2 gets official release date!
20 January 10 09:34 AM | ssqa.net | with no comments

Here is an exciting news for SQL Server 2008 R2 CTP users, DataPlatform-Insider blog confirms that .. will be listed on Microsoft’s May price list, and will be available by May 2010 .... follow here .

Filed under: sql server, documentaiton, features, new feature, ctp, release, 2008 r2

SQL Server 2008 Service Pack 2 and SQL Server 2005 Service Pack 4 - Whats your choice?
14 January 10 05:47 PM | ssqa.net | with no comments

If you are interested to cast your vote & comment on getting Service Pack release for 2 important versions of SQL Server visit: SQL2005-sp4 & SQL2008-SP2 pages.

Filed under: sql server, service pack, connect, release

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!
12 January 10 02:18 PM | ssqa.net | with no comments

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to...

Filed under: sql server, 2008, 2005, best practices, sp2, service pack, rtm

SQL Server Migration Assistant for MySQL v1.0 - CTP1
12 January 10 02:09 PM | ssqa.net | with no comments

SQL Server Migration Assistant is one of best used tool when there is a huge effort required to migrate the database from other data sources such as MS Access, Oracle & MySQL. As a part of Microsoft Partner network communication I have received this...

Filed under: sql server, download, licensing, migration assistant, mysql

How fast you can obtain information about missing indexes? Its easy and quick!
23 November 09 12:49 AM | ssqa.net | with no comments

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...

Filed under: sql server, index, dba, indexes, best practice, execution plan, feature, dmv, missing index

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!
14 November 09 04:47 AM | ssqa.net | 1 comment(s)

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...

Filed under: sql server, benefits, best practice, ssms, shortcuts, keyboard

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices, SQLBits
11 November 09 05:17 PM | ssqa.net | with no comments

Data is most business-critical for any organization and no doubt that they invest heavily to make data management system more efficient, above all the storage is important piece in the puzzle. Now a days there are no limitation in terms of what kind or...

Filed under: sql server, conference, sqlbits, xml, best practice, solution accelerator, standard, storage

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits
11 November 09 04:57 PM | ssqa.net | with no comments

How can you achieve the High Availability & Disaster Recovery on database platform? What are factors involved to keep the system available to maintain revenue stream? What kind of management principles you need to implement? Well there are lot more...

Filed under: sql server, 2008, conference, sqlbits, dba, high availability, discussion, best practice, backup, disaster recovery

How do I monitor problems with replication?
07 November 09 04:44 PM | ssqa.net | with no comments

When you setup a program or application then you have equal responsibility to monitor the process/problems too. Similar to this monitoring a replication topology is an important aspect of deploying SQL Server replication. As the process is distributed...

Filed under: sql server, replication, bol, monitoring, value, alerts, mode

SQL Server Replication upgrade practices - choose optimal upgrade option
04 November 09 04:39 PM | ssqa.net | with no comments

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...

Filed under: sql server, replication, database, testing, upgrade, best practice

How SQL Server 2008 can help to build fast track data warehouse?
02 November 09 01:41 PM | ssqa.net | with no comments

Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse....

Filed under: sql server, data warehousing, fast track, arrays, storage, disks

Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.
21 September 09 08:20 PM | ssqa.net | with no comments

As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue...

Filed under: sql server, permissions, security, trusted platform, error, achievement, access, external

More Posts Next page »