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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

WCF without dedicated server

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :WCF
 

Hi,

 

I'm planning on developing my first WCF service, the purpose of which is to notify all clients running a WPF app about changes any other client has made to a database and update their instance accordingly. However, seeing as the whole thing runs on a local network, is it possible to just send a notification to the entire local network rather than being routed via a dedicated server?

 

Warm regards,

Matt




View Complete Post


More Related Resource Links

how to allocate memory for a dedicated distributor server

  
Hi all, What is the larget memory consumer in a dedicated distributor server? sql server or the Agent? do i need to grant the 'lock page in memory' permission to sql server account in distributor server(This is a 64 bit box with 32GB memory)? ?dba????(???),???? stswordman#hotmail.com

Governing SSIS resource usage vs Dedicated SSIS server

  

We utilize SSIS extensively to process data feeds and when those files become large, we find the resources on the SQL are pretty well depleted. That in turns causes the application, whcih is connected to that same SQL Server, to suffer from a performance stand point. We have to act on this as the problem will only get worse over time and are considering creating a separate SQL instance for SSIS packages but are also interested if there is anything that can be done now to govern the amount of resources that any given SSIS package can use, with the understanding that doing so will cause them (the SSIS pkgs) to have a longer execution time.

We are using SQL 2008 Enterprise Edition and have been reviewing the Resource Governor within SQL, but it appears that that tool can not govern SSIS package resources, so the question is can anything perform that task?

Thanks in advance for the feedback.

Mike


How to deploy on a windows web 2008 dedicated server the VS 2010 ASP.NET simplest template ?

  

I have installed SQL Server 2008 Express Advance Services Edition on server.


I have copied the standard asp.net VS 2O10 from simplest template (the one with login link and 2 tabs home and about) under the root directory of the server. The website works until I try to login then I get:

Failed to generate a user instance of SQL Server

I cannot find a single article that just explains step by step how to deploy this simple example used by Microsoft or can I ? Then can you point me to this tutorial thanks.


Dedicated Index Server in a SharePoint 2010 Server Farm

  

Hi,

We want to have a dedicated Index server in our Sharepoint 2010 Farm and we have have Query roles on our WFE server itself.

I came across this - http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/f775c95d-4bec-450d-a56c-5114a0f52c0a in which it is written: " By installing WFE on Dedicated index server in SP2007 Farm, you will have benefits"

But as per my understanding , in Sharepoint 2010 Farm Setup, we dont need install WFE role on index server as index server will have to propogate index to query server and we cant avoid any network traffic.

Please validate my understanding and if you have any recommnedations for setting dedicated Index server in SP2010 Farm , please suggest .

Thanks .

 


Vipin Kumar Tanwar ( Technology Architect )

send email from a Win2008 dedicated server

  

I know how to send email from asp.net using my pc and my provider smtp server. But doing the same thing from a Win2008 dedicated server is confusing for me. I have installed the smtp server and configure for my virtual web as explained here :

http://forums.iis.net/t/1157046.aspx

But I'm confused by these two lines


serv.DeliveryMethod = SmtpDeliveryMethod.PickupDirectoryFromIis;
           serv.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["SmtpServerUserName"], ConfigurationManager.AppSettings["SmtpServerPassword"]);


1°) Why PickupDirectoryFromIis since in configuration localhost smtp server has been chosen and not pickup directory ?

2°) When setting up the smtp server no login / password has been asked so is the same as the computer login / password ?


Best practices with SQL? Dedicated SQL cluster/log shipping or SQL server per application (Hosted wi

  

Hi,

I was wondering if anyone had any comment about the above question...

We have been basically installing SQL on each server as it was required for the application... we now have 10+ servers each with their own SQL server installed locally with the application...

Is this a best practice or is it best to provide some kind of dedicated SQL cluster/log shipping etc method...and host all databases on this?

I can see pro's and con's to doing this...

Pro's

All databases in one place (Easier management/Licensing/Backup)

High Availability can be configured in various ways for the databases (At the moment they are all single instance with no HA)

Con's

An issue with the central SQL device will cause ALL applications to be down

Microsoft seems to recommend greater and greater numbers of RAM for each server they bring out (8GB seeming to be the minimum)... with an offloaded SQL server how much RAM is this thing going to need! 

A final query... although mirroring seems to have been around for some time, Microsoft does not seem to be currently recommending its use for their key products such as SCCM...

The only big vendor I have seen openly support it with guides etc is RIM...

Shoul

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
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