.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

question on async data mirroring

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

In Async (high perf) data mirroring, if the primary goes down and it has some items which were committed on primary but were not relayed to the secondary. (may be there were in the send queue).

What happens to those?

Will I have to force the mirror server to come up (thereby loosing the data in the queue?).

In this scenario, is there a less destructive way where I don't end up loosing the data which was committed on the primary (apart from switching to high-safety).




View Complete Post


More Related Resource Links

A simple Data Modeling Question

  

I have a data modeling question that hopefully this fictious example will help explain.  My application is data driven and the classes reflect the tables to a large degree.   In this example my database has two tables:

  • VendorMaster with an int Primary Key of VendorID
  • VendorContact with an int Primary Key of ContactID

The VendorContact table also has a Foreign Key of VendorID in order to associate the contact with a specific Vendor.  In this example a Vendor can only have one contact.

My question is how to represent these two tables in terms of classes.  In my current design I have two classes:

  • VendorMaster
  • VendorContact

In order to represent the relationship between a VendorMaster and VendorContact, my VendorMaster class contains a property called VendorContact.

My questions are about the VendorContact class and how it represents the relationship between a VendorMaster and itself.

Option #1

The VendorContact class should contain an int property of VendorID

Option #2

The VendorContact class should contain a VendorMaster Property

I am not sure which option is the 'best' option to take. My concern is that if I go with option #2 that I would create a cyclical relationship between the VendorMaster and Vendo

Simple data binding question

  
Newbie binding question here: is it possible to bind a control in XAML to a StaticResource by passing in the key via a data structure? Basically something like this: <TextBlock Text="{Binding ImageKey}" /> <Image Source="{StaticResource ResourceKey={Binding ImageKey}}" /> <-- doesn't work   The TextBlock binding on the first line works correctly, it extracts the key of the StaticResource from my data structure and displays it correctly. What I'm trying to do is get the Image control to bind to the StaticResource with that name (which happens to be a BitmapImage).      

Data Mining Solution Question

  
Hi, I am working for a company that would like to use Aanalysis Services for predictive analytics. My problem is that there are only 40 or so months worth of data. I am wondering if this is enough to even make anything relevant and/or accurate.   So far I've made a time series mining structure, that just uses the booking number as input and predict. I am having a hard time justifying this as they view it as something that could have just been done in excel.   Also I have made a neural network. The company has several (continuous) metrics that they track along with bookings. So I made a neural network to use these inputs to predict the bookings.   This made another problem. The prediction that the neural network makes is different from the next month that that time series predicts and is causing distrust by the potential end users.   I've thought about combining the two models. I could use the output of the neural net and do a natural prediction join of that result into the time series.   Seeking advice, and something that I can do with Analysis Services that could be useful to a company with only a small number of months of data to work with.   -S

SQL server 2008 r2 Data sync question???

  
Sql 2008 r2 data sync, does it involve a db hosted by microsoft or does that involve us hosting the sync functionality locally?  I know we have db's local that need to be sync'd across a wan but does that happen in a db hosted in the ms cloud or does that have to do with a sync functionality that runs locally to keep my db's sync'd?   Thanks, SL

Data Mining Solution Question

  
Hi, I am working for a company that would like to use Aanalysis Services for predictive analytics. My problem is that there are only 40 or so months worth of data. I am wondering if this is enough to even make anything relevant and/or accurate.   So far I've made a time series mining structure, that just uses the booking number as input and predict. I am having a hard time justifying this as they view it as something that could have just been done in excel.   Also I have made a neural network. The company has several (continuous) metrics that they track along with bookings. So I made a neural network to use these inputs to predict the bookings.   This made another problem. The prediction that the neural network makes is different from the next month that that time series predicts and is causing distrust by the potential end users.   I've thought about combining the two models. I could use the output of the neural net and do a natural prediction join of that result into the time series.   Seeking advice, and something that I can do with Analysis Services that could be useful to a company with only a small number of months of data to work with.   -S

Question about quality of data

  
Hello, Thanks for the help on the last question.  We have looked at several open source offers in the field of data integration. We are now wanting data quality software to complete our data integration program.  Do packages exist to suit our needs? Would you know of innovative data quality programs? Thanks to all!

Async Mirroring

  
Does SP 2010 Support Async Mirroring? Also, what do I lose, if I do mirroring outside of SP. (So SharePoint is not aware that SQL is being mirrored).

Data Mirroring and Transparent Client Redirection

  
From what I have read, later versions of MDAC recognize if a database is mirrored and it caches both the primary and the mirror name.  Then if a connection fails to the primary, MDAC transparently redirects to the mirror (which in theory has taken on the primary role).  Could someone explain how applications which rely on a DSN with a specific SQL server name defined can be redirected transparently to another SQL server that is hosting the now "promoted" (formerly a mirror) primary database?  The documentation I have read is high level and just implies it will magically work but I am looking for a deeper explanation of how transparent client redirection works from the application db connectivity perspective.   Thanks, Steve

Another basic Data Binding question

  
3 days ago (thanks to Olaf) I was able to make progress with binding a data collection to a DataGrid. Since then I have searched the web in vain for a VB example to enable me to switch off the DataGrid AutoGenerateColumns and enter my own columns and appropriate Paths to the Collection’s properties.   The following code works fine but I can’t work out how to enter my own individual columns etc. Can anyone give me the syntax for an example of one column please?   Why is it so difficult to find VB examples of WPF demos etc? (Nearly everything is in C#.)   I have some experience in Access VB so have picked VB in trying to use WPF. I would be grateful for any links to VB WPF resources. Option Explicit On Option Strict On Imports System.Collections.ObjectModel Partial Public Class DataGrid_FilledFromCodeBehind Private _ocEng As ObservableCollection(Of EnPlayer) Public Property EngSqd() As ObservableCollection(Of EnPlayer) Get Return _ocEng End Get Set(ByVal value As ObservableCollection(Of EnPlayer)) _ocEng = value End Set End Property Private Sub Window_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded _ocEng = New ObservableCollection(Of EnPlayer)() For i = 0 To 4 EngSqd.Add(New EnPlayer(ref(i), names(i), ages(i), bat(i))) Next Me.DataCon

Basic Data Access question (ObjectDisposedExpection)

  
I am just starting to look at .NET 4.0 and Entity Framework 4 and having trouble finding the best way to achieve something. I'll explain with a quick example:I got my CategoryManager class that looks like this:public sealed class CategoryManager { public System.Data.Objects.ObjectSet<Category> Categories { get { try { StoreEntities storeDb = new StoreEntities();                    using (storeDb)                    {                        return storeDb.Categories;                    } } catch (Exception) { //TODO  throw; } } } public List<string> GetCategoryNames() { try { var categories = from category in this.Categories select category.Name; return categories.ToList();

Pipeline Data Cube Design Question

  

 

The Analysis team wants to analyze sales pipeline data. Our CRM system(Source system) send the Data Warehouse team transaction as the Product moves through the different stages.

 

To mention a few: Creation, CallMade,LeadEngaged,CreditCheck,PapersReceived,Closed.There are more than 100 tracking statuses like mentioned above.

 

Sample transactions fact table:

ID LeadID

security question about dynamic data

  

apologies if this has been answered before.

it seems that the scaffolding that generates the list, edit, details apsx pages uses querystrings to pass the primary key for the relevant record. thus is i have a list.aspx showing me a grid of records, the edit hyperlink will be something like http://../tblTable/edit.aspx?ID=n where n is the key of the record to edit.

however, obviously this is not secure for a multi-user site as someone else with a valid login could potentially see records which they shouldnt simply by trying different "ID=n" values?

is there a way to change this behaviour in a Dynamic Data site or will i have to manually code to ensure a user only see records intended for them?

any help is gratefully appreciated

John

 


Using Sharepoint 2003 - Data Security Question

  
We need to limit visibility of data in a datasheet to users based on their ID, NOT on who created or loaded the data.  If this is possible, how do we accomplish this?

I have a newbe question about sql standard 2008, How do I merge 1 row of data from another DB to the

  

Hi everyone,

 I am new to data base type work. I have very little exsperience in database code. I set up an application that retrieves data from the UI that has four forms. The application calculates and modifies this data for storage in different fields in a database. The application itself is not very simple as to the operation of the print and rs232 operations. But I have all of that code written and have written code for updateing the local db with this information. I was able thru searches to find enough information to update the local db.

 I have not been able to find any code example for merging 1 row of data from one DB to another DB. That has the same data table and fields in both data bases.  Now these DB's are set up exactly same except for DB name and Table name. They have exactly the same field and column names. The only difference is the data in the primary key field, the database that is local builds two rows that the key field has the same data except for one letter and is build at different times. The remote data base has the same data in the key field except it does not have the letter at the end of the data.

 Local data base    Key                     Re

Data Flows in SSIS - Mapping Multiple source tables to Destination table **Newb question**

  
Hi I am new to SSIS and had a basic question. I have around 30+ tables in a db that needs to be migrated to a newer schema in the DB. The data flow task seems to be ideally suited for my requirement. My question is do I need to create 30+ different data flow tasks for this which will get executed one after the other or is there a better way to migrate large number of tables. Also how are referential constraints taken care of during such migration. Thanks and Regards, Ganesh Ranganathan
Ganesh Ranganathan
[Please mark the post as answer if it answers your question]
blog.ganeshzone.net

Data Conversion Transformation question

  

Hi Experts,

I used the Data conversion transformation object to convert a data format to the right format {im a newbie}, and i was wondering how it did this without me specify the format i want the results to be in? IF i wanted to convert to convert text to numeric, do i just have to add the Data conversion transformation or do i need to configure it?

Thanks


question about sending form data to web service

  

Hello, i have some web service in outsource server (not on the form server) and i need to send to this web service few text boxes fill by the user (text only - no files) i need to send the data + the number 1 + some guid string (that not changing - the same guid always) is anyone have an idea how im doing that? ( all the data need to be sending to asmx file.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend