Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Winner of the contest

Dear Readers, I am very please to announce winner of the contest about describing best HA & DR solution. The contest was successful, there are about 5 entries I have get from various sources like linkedin and email, I would like to thank all the participant...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Thu, May 5 2011
Filed under: Filed under: Replication, Log Shipping, Clustering, High Availability, SQL Server MVP, database mirroring, Book on SQL Server 2008, cluster resources, packt publication
Azure Data Sync - Class not registered EC413D66-6221-4EBB-AC55-4900FB321011 - 0x80040154

I’m building a little sync app to sync data between databases and came across this error. I thought it was a duff install but spent some time on it this morning. Well the issue was that when you create a windows application in Visual Studio 2010 not only...

Posted to SimonS Blog on SQL Server Stuff by on Mon, Mar 21 2011
Filed under: Filed under: Replication, Azure, Visual Studio
Describe HA and DR strategy and win

Dear Readers, I am very please to made an announcement about the contest. As you aware that I have wrote a book on SQL Server 2008 High Availability which was published on 24th January 2008 by Packt Publication . Now you have a chance to win a subscription...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Sun, Mar 6 2011
Filed under: Filed under: Replication, Log Shipping, Clustering, High Availability, Sql server 2008, SQL Server MVP, database mirroring, Book on SQL Server 2008, database administration, cluster resources
SQL Server 2008 High Availability – A Book

I have no words to explain my excitement and happiness to share news with you all - my book on SQL Server 2008 High Availability is published!! I have started authoring this book in May 2010 and as the time passes and gradually I move to the final chapter...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Tue, Jan 25 2011
Filed under: Filed under: Replication, Log Shipping, Clustering, Sql server 2008, database mirroring, sql server high availability, Hemantgiri S. Goswami, sql server citation, Book on SQL Server 2008
Don’t, don’t, don’t change the server name if you are using replication

Replication is a very old beast that has been developed over the years. Because it communicates to other machines in interesting ways it has some quirks. One of those is the server names. We all know and love @@servername but that doesn’t have to be the...

Posted to SimonS Blog on SQL Server Stuff by on Fri, Aug 20 2010
Filed under: Filed under: Replication
SQL Server High Availability Options Preview

As it is named, all the SQL Servers and databases should be highly available ( HA ) to cater the business requirement, and, the business application should be up and running all the time. To achieve this Microsoft has introduced SQL Server Cluster which...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Sun, Nov 8 2009
Filed under: Filed under: Replication, database mirroring, sqlserverpedia, sql cluster, peer- peer replication, sql server ha, sql server high availability, merge replication, snapshot replication, transaction replication
SQL Server upgrade practices - choose optimal upgrade options

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 26 2009
Filed under: Filed under: sql server, upgrade, replication, version, access, jet, oledb, merge, transactional replication
SQL Server - Types of replication in simple terms that relates to architecture

I tend to get emails that relates to SQL Server questions from the user, by default I suggest them to post on the forums to get quicker response and do reply in simple terms. One of the them I got recently asking about how can I explain the replication...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Sep 20 2009
Filed under: Filed under: sql server, data, replication, version, publisher, model, compatibility, subscriptions, new feature, peer-to-peer
Removal of SQL DMO in future release of SQL Server - take action now!

If you remember about SQL Server 2005 installation & feature documentation SQL-DMO has been referred as backward compatibility, and that feature will be removed in a future version of SQL Server. So the documentation has been heavy on users to avoid...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Aug 18 2009
Filed under: Filed under: sql server, msdn, replication, features, best practices, smo, dmo, backward compatibility
SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

Replication will be very handy to distribute the load of application when you have large scale of data management, as it evolved from SQL Server 6.0 version the transactional replication is first baby that was primarily used to support reporting applications...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 28 2009
Filed under: Filed under: sql server, availability, replication, BOL, best practices, scalability, tablediff, replication monitor, peer-to-peer
Community launched | Surat SQL Server User Group | DotNetChaps

Hi, We have formed a Technical Community User Group. The aim of this User Group is to share/exchange what all we have in terms of the knowledge. We have two separate forums for MS SQL and for Dot Net technology to avoid confusion. You may post all your...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Mon, Mar 9 2009
Filed under: Filed under: sql server, sql 2005, Replication, Log Shipping, MS Sql server, ssis, sql server 2000, sql server cluster, sql 2008, DotNetChaps, database mirroring, Surat SQL Server User Group, Community launched
The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)

The above error clearly specifies the connectivity issues between 2 instance, to give more information I have been dealing with this problem at a client's place. The setup that was configured and deployed was a very complicated replication between...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 11 2009
Filed under: Filed under: sql server, services, replication, error, cluster, msdtc, distributor, subscriptions, linked server, error 7391
Strategy to provide Availability and Scalability - SQL Server Replication

Scalability is the potential for the database to maintain performance goals while adapting to increased workloads. At the same time Availability is another important factor to keep up this scalability which involves scale-up strategies of upgrading hardware...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 7 2009
Filed under: Filed under: sql server, availability, replication, windows server 2008, scalability, new feature, sql server data services, geo-replication
sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

Another security vulnerability or rather call in the sense of security experts that " A zero day vulnerability has been reported in SQL Server "! Though its a not serious flaw or problematic loophole to worry but still its a security flaw in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Dec 17 2008
Filed under: Filed under: sql server, security, replication, permissions, best practices, tsql, sp_repl, functional
Replication and Database Mirroring - things to take care and best practices to administer the environment

Replication and Database Mirroring are the ones which can provide high availability option without an extra cost what it implies on a Clustering setup. So in this scenario Database mirroring can be used in conjunction with replication to provide availability...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Dec 15 2008
Filed under: Filed under: sql server, high availability, replication, monitor, maintenance, database mirroring, publisher, failover, subscriptions, setup
Replication Monitor enhancements in SQL Server 2008

Replication Monitor is an useful tool that gives information about publisher view of all replication activity including status information for publications and subscriptions. When you load the replication monitor by default it will display warnings only...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 17 2008
Filed under: Filed under: sql server, replication, subscriptions, merge agent, transactional replication, replication monitor
SQL Server 2008 - Replication and Filestream, are both supported together?

Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 26 2008
Filed under: Filed under: sql server, replication, BOL, features, support, filestream
SQL Server Replication - resolving too many snapshots issues?

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 15 2008
Filed under: Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule
SQL Server 2005 - specific roles for replication agents

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Feb 22 2008
Filed under: Filed under: sql server, replication, permissions, best practices, roles, agent, publisher, beginners, distributor, subscriptions
Replication FAQ - how to know Distributor and Publisher with scripts

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Feb 19 2008
Filed under: Filed under: sql server, replication, snapshot, script, merge, publisher, transactional, distributor, schedule

Page 1 of 3 (56 items) 1 2 3 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

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.