SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : update

SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

Mon, 17 Aug 2009 06:20:00 GMT

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications...(read more)

SQLBits V - session submission is now open

Wed, 29 Jul 2009 07:22:00 GMT

SQLBits V is the theme, 5th instalment of world class SQL Server event and making it even bigger and better than last time, now spanning 3 days, and still keeping everything that has worked so well at previous events. SQLBits goes west - will be held...(read more)

Update your local copies of SQL Server 2008 books Online - May 2009 release

Tue, 26 May 2009 09:02:00 GMT

Here is the quick update for you to refresh your local copies of SQL Server 2008 Books OnLine (aka BOL) May 2009. Why you need to do it? It is one of the best practice that will enable you to keep up with latest information about recent feature release...(read more)

Cumulative Update 3 for SQL Server 2008, another one in the series

Tue, 20 Jan 2009 07:01:00 GMT

Here comes another instalment of Cumulative Update package 3 for SQL 2008 version and this contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. As usual the Microsoft guidance refers that this is a supported cumulative...(read more)

SQL Server 2005 Service Pack 3 (SP3) is released

SqlServer-QA.net — Tue, 16 Dec 2008 08:15:00 GMT

From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News...(read more)

Download SQL Server 2005 Books Online - Updated DECEMBER 2008

SqlServer-QA.net — Mon, 15 Dec 2008 07:37:00 GMT

Here is another update on Books Online (BOL) for SQL Server 2005 - Download an updated version of the documentation and tutorials, to see what kind of updates are updated in the documentation once you downloaded & install see the " Additional...(read more)

Microsoft Security Bulletin MS08-067 – Critical

SqlServer-QA.net — Sun, 26 Oct 2008 20:52:00 GMT

Here is the monthly security update that I receive from Microsoft that I would like to share, this is more important to put this into practice to secure your Server environment. This security update resolves a privately reported vulnerability in the Server...(read more)

SQL Server 2008 Books OnLine (BOL), latest and updated

SSQA.net — Tue, 19 Aug 2008 07:32:00 GMT

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as...(read more)

KBA - UPDATE Statements May be Replicated as DELETE/INSERT Pairs & Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations

SSQA.net — Tue, 13 May 2008 18:45:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications UPDATE Statements May be Replicated as DELETE...(read more)

SQL Server Reporting Services - Do you cache popular reports for better performance?

SSQA.net — Mon, 07 Jan 2008 11:30:00 GMT

Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required...(read more)

SQL Server 2005 Books Online September 2007 available for download - update your local copy

SSQA.net — Tue, 18 Dec 2007 10:25:00 GMT

As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will...(read more)

November 2007 update SQL Server 2008 Books Online CTP - update your local copies

SSQA.net — Sun, 02 Dec 2007 12:46:00 GMT

As the subject states you have to update (uninstall & install) the local copy of Books Online for SQL Server 2008 CTP that is released in November 2007. This BOL update consists all the changes from the previous CTPs and what's new with current...(read more)

How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?

SSQA.net — Fri, 23 Nov 2007 14:51:00 GMT

Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & http://sqlserver-qa.net/blogs/tools/archive/2007...(read more)

Keep your eyes open for Cumulative Update 4 for SQL Server 2005 Service Pack 2 - now you can rest now (available now)

SSQA.net — Tue, 16 Oct 2007 21:50:00 GMT

August 19 2007: As per the KBA-BlogPost on Cumulative Update 4 for SQL 2005 SP2, Microsoft confirms that this cumulative update package will be released in the October 2007 timeframe. The information that is presented here is subject to change at any...(read more)

Cumulative update package 4 for SQL Server 2005 Service Pack 2 - available now

SSQA.net — Tue, 16 Oct 2007 09:43:00 GMT

August 19 2007: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications...(read more)

A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2

SSQA.net — Mon, 01 Oct 2007 09:40:00 GMT

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package...(read more)

Is SQL Server 2005 Books Online updated in September 2007?

SSQA.net — Fri, 28 Sep 2007 09:38:00 GMT

Well this is confusing me, this DownloadLink refers SQL Server 2005 Books Online as May 2007 update that can be installed on the machine. But when you search for any content on MSDN library for SQL Server it refers " SQL Server 2005 Books Online...(read more)

FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005

SSQA.net — Tue, 11 Sep 2007 21:37:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: The merge agent does not use a specified custom user update to handle conflicting...(read more)

How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

SSQA.net — Tue, 11 Sep 2007 09:03:00 GMT

Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION...(read more)

Need to grant permission to view stored procedure text

SSQA.net — Mon, 10 Sep 2007 08:24:00 GMT

If you need to grant permissions to a login that only needs to view stored procedures (contents not just names of SP's). Further you may not want to grant that login with DB_OWNER or DB_DDLADMIN roles within that database, so how to achieve this task...(read more)