MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Browse by Tags

Blogs

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

Syndication

News

Blog Archive List

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

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...

Published Mon, Aug 17 2009 1:20 by SqlServer-QA.net

Filed under: sql server, transaction log, update, kba, index, maintenance, smo, clustering, tempdb, service pack, backups, collation, knowledgebase, fulltext, device, cumulative update, clustered index, maxdop
SQLBits V - session submission is now open

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...

Published Wed, Jul 29 2009 2:22 by SqlServer-QA.net

Filed under: sql server, update, users, event, sqlbits, conference, r2
Update your local copies of SQL Server 2008 books Online - May 2009 release

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...

Published Tue, May 26 2009 4:02 by SqlServer-QA.net

Filed under: sql server, download, update, documentation, best practice, information, books online
Cumulative Update 3 for SQL Server 2008, another one in the series

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...

Published Tue, Jan 20 2009 1:01 by SqlServer-Qa.net

Filed under: sql server, update, hotfix, service pack, best practice, cumulative update, sql engine, incremental model
SQL Server 2005 Service Pack 3 (SP3) is released

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...

Published Tue, Dec 16 2008 2:15 by SqlServer-QA.net

Filed under: sql server, download, update, BOL, best practices, 2005, service pack, sp3
Download SQL Server 2005 Books Online - Updated DECEMBER 2008

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...

Published Mon, Dec 15 2008 1:37 by SqlServer-QA.net

Filed under: sql server, download, update, 2005, books online
Microsoft Security Bulletin MS08-067 – Critical

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...

Published Sun, Oct 26 2008 15:52 by SqlServer-QA.net

Filed under: microsoft, security, update, windows, 2000, xp, 2003, server services, worm
SQL Server 2008 Books OnLine (BOL), latest and updated

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...

Published Tue, Aug 19 2008 2:32 by SSQA.net

Filed under: sql server, msdn, download, update, BOL, books online, SQL Server 2008, developement
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

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...

Published Tue, May 13 2008 13:45 by SSQA.net

Filed under: sql server, update, i/o, kba, insert, delete, statement, sp4
SQL Server Reporting Services - Do you cache popular reports for better performance?

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...

Published Mon, Jan 7 2008 5:30 by SSQA.net

Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports
SQL Server 2005 Books Online September 2007 available for download - update your local copy

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...

Published Tue, Dec 18 2007 4:25 by SSQA.net

Filed under: sql server, msdn, technet, update, localhost, BOL, 2005, books online, download center
November 2007 update SQL Server 2008 Books Online CTP - update your local copies

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...

Published Sun, Dec 2 2007 6:46 by SSQA.net

Filed under: sql server, microsoft, download, update, users, 2008, books online, ctp5, utilities
How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?

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...

Published Fri, Nov 23 2007 8:51 by SSQA.net

Filed under: sql server, package, microsoft, update, sp2, best practices, hotfix, service pack2, testing, cumulative
Keep your eyes open for Cumulative Update 4 for SQL Server 2005 Service Pack 2 - now you can rest now (available now)

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...

Published Tue, Oct 16 2007 16:50 by SSQA.net

Filed under: sql server, download, update, kba, support, service pack2, 2005, cumulative, servicing model, costs
Cumulative update package 4 for SQL Server 2005 Service Pack 2 - available now

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...

Published Tue, Oct 16 2007 4:43 by SSQA.net

Filed under: sql server, update, kba, service pack2, 2005, cumulative, available
A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2

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...

Published Mon, Oct 1 2007 4:40 by SSQA.net

Filed under: sql server, performance, ssis, trace, update, error, kba, installation, instances, 4014, netmon
Is SQL Server 2005 Books Online updated in September 2007?

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...

Published Fri, Sep 28 2007 4:38 by SSQA.net

Filed under: sql server, microsoft, download, update, BOL, books online
FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005

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...

Published Tue, Sep 11 2007 16:37 by SSQA.net

Filed under: sql server, performance, update, replication, kba, statistics, conflict
How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

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...

Published Tue, Sep 11 2007 4:03 by SSQA.net

Filed under: sql server, update, replication, monitor, merge, publisher, subscriptions
Need to grant permission to view stored procedure text

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...

Published Mon, Sep 10 2007 3:24 by SSQA.net

Filed under: sql server, security, update, permissions, stored procedure, schema, execute, view definition

1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

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

SQLBits V - session submission is now open

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

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

SQL Server 2005 Service Pack 3 (SP3) is released

Download SQL Server 2005 Books Online - Updated DECEMBER 2008

Microsoft Security Bulletin MS08-067 – Critical

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

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

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

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

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

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

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

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

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

Is SQL Server 2005 Books Online updated in September 2007?

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

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

Need to grant permission to view stored procedure text