Tag | server Posts

We all get those requests where there is a certain service that requires to send mails by using your company email server. Whilst an open relay is generally a way to get your domain blacklisted forever, allowing an internal relay is usually a necessity. By default Exchange is setup to deny relaying from any IP address, including your internal network. In this section I will show you how to allow relaying from your internal network. Exchange 2003: 1. Open the Exchange system manager 2. Expand the ...
Running a CCR or DAG is a great way to have a server resilient database. Relying on an asynchronous copy of the log files (Each log file gets copied over only when the store has released it) it copies over the log files from the active node to the passive node so it can be played in to the passive nodes database. But whilst being a great failover solution both solution are also quite high-maintenance, CCR more so than a DAG. Running in to a situation where the CCR or DAG is down because of to many ...
If your connection hangs while attempting to start sql server broker service, its likely caused by the system trying to gain exclusive access to your database. Some people recommend stopping and restarting the sql server instance. I find that a little heavy-handed, like swatting a fly with a sledge hammer. Instead switch the database into single user mode, enable the broker service, and restore the database to multi-user mode. 1) Set the database to single user mode: ALTER DATABASE [DBNAME] SET SINGLE_USER ...
This discussion on the printing of Database diagrams is an on-going one. If affects several versions of SQL Server yet microsoft has failed to reproduce it.Please go to the the discussion at http://social.msdn.microsof... There is now an example of this problem posted ...
I have seen a number of questions lately regarding how SQL Azure handles throttling and how to determine why the throttling occurred. Sometimes those questions are followed by another question asking how to handle throttling conditions in their applications. Troubleshooting SQL Azure Throttling GREAT NEWS! There actually is a way to find out if you are throttled and why, and the results of the throttling. The key is to look at the error message coming back to you. You’ll typically see an error message ...
When you place a Visual Studio solution into TFS or pull it down for the first time a default working path is set in the workspace mappings. There are times when you need to point source code to a new location. Once option you have is to simply use the Manage Workspaces dialog to edit the local folder for the your solution. Select your workspace. Click on the Local Folder and an ellipse button will appear to allow to set a new folder. The problem with this approach is that it doesn’t seem to consistently ...
It's important to understand the account that IIS is running under when you need to make changes to the security settings. If, for example, your Web application writes to files or to a database, you'll need to grant the correct permissions to the folder or database. Before you can change these security settings, it's important the know what account IIS is using. This FAQ details the various options available, both for "classic" ASP and ASP.NET applications. There is a big difference between classic ...
Udi Dahan briefly chats about MSMQ on his blog and provides a useful link: Microsoft has put MSMQ in the Developer Preview of Server 8 (as Brian Buvinghausen has written here). There’s good news on Brian’s blog: “Finally! Microsoft added MSMQ to Server Core in Windows Server 8” So it will be interesting to see how they got round the limitations of previous versions of Windows Server Core ...
Architecture of PeopleSoft Adapter: The BizTalk PeopleSoft Adapter is based on the BizTalk Server Adapter Framework. More info: How the Adapter Is Designed: The Adapter Framework. The PeopleSoft adapter basically communicates with the PeopleSoft Component Interfaces via the PeopleSoft JOLT protocol (over TCP/IP). The adapter communicates with PeopleSoft system by receiving a XML message which is later encapsulated into a SOAP request using the PeopleSoft psjoa classes. With this connection we can ...
Step 9: Completing the Database Setup: This step is a very critical step and should performed with very much attention. Below mentioned steps are the ones which I thought were required for the environment I was building but I very highly recommend that you perform this step from the Oracle Installation document which can be found here. Look at Chapter 7 in this document. Updating PeopleTools System Tables: Here PS_HOME is the directory where you have installed your PeopleTools. In our case its C:\PT852 ...
Environment what we are building consists of: Operating System: Windows Server 2008 SP2. Database Server: SQL Server 2008 with SP2. PeopleSoft Application: PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 PeopleTools: PeopleSoft PeopleTools 8.52 Web Server: Oracle Web Logic Server 10.3.4 The machine name given for this environment is WIN2K8 and currently only 1 user, the default username is Administrator and it is the local admin. The below steps are performed with ...
In this article, I will show you some tips to improve your ASP.NET performance. 1. Disable the Debug Mode or Set Debug =”false”How it affect performance: By default this attribute is "true" when you create new application and is useful when you are developing the application. Debug = true means that pdb information to be inserted into file and this results a larger file size and it's performance issue. Before deployment you should set the following tag <compilation defaultLanguage="Vb" debug="false"> ...
The Objective Three of the 6 development teams using TFS are moving to a different network and domain. There is no on-line connection between the old (source) and new (target) networks. The objective was for the teams to come in Monday morning, bring up their development machine on the new network and have everything as it had been on the old network. Failed Approaches Clone the data tier and move the data tier to the new network. This failed because the procedures for moving the hardware to a new ...
After reading this chapter you should be able to Identify and explain the functions of the core TCP/IP protocols Explain how the TCP/IP protocols correlate to layers of the OSI model Discuss addressing schemes for TCP/IP in IPv4 and IPv6 Describe the purpose and implementation of DNS and DHCP Identify the well-known ports for key TCP/IP services Describe common Application layer TCP/IP protocols Characteristics of TCP/IP (Transmission Control Protocol / Internet Protocol) TCP/IP is a suite of specialized ...
After reading this you should be able to Identify a variety of uses for WANs Explain different WAN topologies, including their advantages and disadvantages Compare the characteristics of WAN technologies, including their switching type, throughput, media, security, and reliability Describe several WAN transmission and connection methods, including PSTN, ISDN, T-carriers, DSL, broadband cable, ATM and SONET Describe multiple methods for remotely connecting to a network WAN Essentials A WAN is a network ...
It is stupid to compare those two beasts. BizTalk Server is a pricey, huge development and run-time system, it includes tons of the tools, supports tons of protocols and systems. It works for very specialized middle ware integration stack. It integrates big and complex systems as SAP, CRM, Oracle and intermediates many protocols and standards as SOAP, EDI, SWIFT, FTP, tons of them. It is a messaging system. ZeroMQ is a low-level, wire-level protocol, the same level as TCP. It has ultra-simple API. ...
One of the great things about 2012 is that I am not in our office nearly 100% of the time during business hours. This is the first time I have been able to work from our office this much in about 4 years. In fact, we have moved three times during that four years and I have only averaged about 10-25% of my time in the office. This means I can actually setup my desk for development instead of business related tasks only. That means THREE MONITORS! My first reaction after a week with this setup: I never ...
This is my first post in this new year and was thinking about a topic to write on. Lately I have been working on varied things that flexes the brain muscles and things which I haven't done before. So a lot of learning and some unlearning this new year. One of the big issue which most people faces is learning to learn!.So, today I will share my experience of how I go about learning a technology, a skill or anything you want. The first and foremost thing is the motivation. This thing is very personal ...
This post is an example of how to write a WCF Service using a class. The example uses Visual Studio 2010, written in C#, SQL Server 2008 and hosted in IIS. So lets have at it. The table is pretty simple just three columns, an TestID (int), Value1 (varchar(50)) and Value2 (varchar(50)). The stored procedure used will return one record from the table using the TestID as a parameter. Table SQL: CREATE TABLE [dbo].[Table_1]( [TestID] [int] IDENTITY(1,1) NOT NULL, [Value1] [varchar](50) NOT NULL, [Value2] ...
This is the second post about SQL Azure Federation. In my first post I described a little bit about the theory of data partitioning, included the different between the horizontal partitioning and the vertical partitioning. I also talked about the features need to be done when we implemented the horizontal partitioning. And finally, I described some basic concept about SQL Azure Federation. In this post, I will demonstrate how to use SQL Azure Federation in the SQL Server Management Studio (SSMS). ...
The following procedures describe my approach toward a minimal error prone migration of Microsoft Dynamics CRM 4.0 to MS CRM 2011. 1. I start by installing CRM 2011 with a dummy organisation, yes, I don't import the CRM 4.0 organisation, because I want to make sure CRM 2011 is installed and deployed with out any problems. More over it gives the flexibility to map user, if it is from a different domain. (1,5 Hour) 2. I install all the latest updates and roll-up for the CRM 2011, verify if everything ...
We’ve used dbdeploy.net on a number of projects and have found it to be a useful tool, especially around CI environments. We recently started a Windows Azure project that uses SQL Server and discovered that DbDeploy.Net didn’t work. There have been a few nagging issues with DbDeploy.Net as well, like the lack of support for recursive script directories, and when we looked into the code base, we discovered that it’s not really written to modern software development standards, and that getting it there ...
As many of you may already know that, I'm working at a global gaming and entertainment company taking the responsible for design and implement the next generation platform which will be running on the cloud, and also design the cloud platform as well. Currently one of the goal is to replace the active directory integrated security and identity solution with certificate-based solution in our product. In short, we need to work with Active Directory Certificate Service to request and issue the certificates ...
Before I describe about my session, let me introduce the history of making this great event. We SharePoint Experts Community arranged this Community Day jointly with Microsoft to introduce SharePoint 2010 on 7th January 2012 which is the first time in Bangladesh. Thanks to Microsoft Bangladesh to Sponsor the whole Program and others co-sponsors. We planned 6 months ago to arrange this type of event for Developers and IT Professional who might be interested about SharePoint Technology and proposed ...
It is one more description of the Ordered Delivery (OD) in BizTalk. The main article about it is in MSDN. Here I am discussing the BizTalk Ordered Delivery “implementation details”. OD Considerations Ordered Delivery (sequential) mode is opposite of the “Parallel Delivery” mode. Parallel Delivery is the most productive mode; the Ordered Delivery is less productive mode. Transports such MSMQ and protocols, supporting the WS-ReliableMessaging, are the protocols supporting OD. Other protocols as FTP, ...
I’ve been seeing many members in the forums asking how to display a large copy of the image on mouseover. Some of them are displaying the image in a Repeater, GridView or DataList control. I didn’t find any direct solution that shows the scenario they wanted so I thought of writing this post to demonstrate how to go about it. I know there are lot of ways of doing/implementing a solution for this scenario and this is just one them. In this example I’m going to use the DataList control for displaying ...
ASP.NET Enterpise Manager is a web based database management system designed specifically for the management of Microsoft SQL databases through a web browser, without the need for any desktop database management systems such as Microsoft’s SQL Server Management Studio. ASP.NET Enterprise Manager is included as default with an installation of Plesk for Windows, meaning that if you are a customer who uses Plesk based Windows hosting, you will most likely have used ASP.NET Enterprise Manager at least ...
This article is a Part 6 of the Interview Questions series. Part 1: BizTalk: Questions for interview without answers Part 2: BizTalk: Interview questions and principles Part 3: WCF: Questions for studying and interviewPart 4: WCF: Questions for studying and interview: DiscoveryPart 5: WCF: Questions for studying and interview: Routing Service Part 6: BizTalk: Advanced Questions Note: There is BizTalk Administrator interview questions by Tord Glad Nordahl. It is time for fun! These questions are for ...
Windows Azure Platform How to Sort Azure Table Store results Chronologically How to upload your Excel and CSV data to the Cloud - Blob Storage SQL Azure Database Notification and Job Scheduling Service for SQL Azure SQL Azure Tutorials – Blog SQL Azure Tutorials - Helping you with Cloud Databases How to build a SQL Server Reporting Services report with SQL Azure? Middleware in the cloud SAP meet Azure Service Bus – EAI/EDI December 2011 CTP Azure Service Bus EAI/EDI December 2011 CTP – New Mapper ...
At http://twimgs.com/darkreading/databasesecurity/S3100711_SQL.pdf there is a free report on SQL Injection Attack. It is always important to remember that SQL Injection attacks can occur with any back-end database server if the input is not properly validated and processed.
Scribe - Test Scribe is a documentation power tool designed to construct documents directly from TFS for test plan and test run artefacts for the purpose of discussion, reporting etc. Scribe only works with Microsoft Test Manager, so if you needed to generate documentation for TFS Builds, what options do you have? You could potentially modify the Build Process template to generate report documentation as the build is executed or you could use the TFS data warehouse to extract data to create rich ...
It’s time to dust things off here at DotGeek and get busy with learning some newer things in 2012 and in turn, hopefully providing myself some more opportunities in the long run too. I kind of let 2011 get away from me, but I had a later start to be fair. So what better time to start than at the first of 2012 and with a plan of action. So I’ve known for sometime that I wanted to become more than just front man and I wanted to be involved more with the backend operations of various projects. Whether ...
After reading this chapter you should be able to Identify organizations that set standards for networking Describe the purpose of the OSI model and each of its layers Explain specific functions belonging to each OSI model layer Understand how two network nodes communicate through the OSI model Discuss the structure and purpose of data packets and frames Describe the two types of addressing covered by the OSI model Networking Standards Organizations What are standards? Standards are documented agreements ...
At several client sites, I have had a problem printing Database diagrams directly from Sql Server Management Studio. The workaround is to right click, copy the diagram and paste into word to print it.If you encounter this, please report the problem at:http://social.msdn.micro... ...
I received the good news on Jan 1st that, for the 4th year in a row, I was awarded a Microsoft MVP award for ASP.NET/IIS. There’s some movement as there always is – some people not getting renewed their MVP award, new people attaining it. Some people have publically voiced how they turned down the award or just didn’t bother working for it for a variety of reasons that I won’t get into here. There’s also been some passionate Twitter discussions around community and groups and how valid they are, ...
I live in a world of continuous integration servers, extensive unit, integration & regression tests and a whole bunch of other checks and balances to insure the quality of the systems we develop. I live in this world because I know things can go wrong and I want to have a safety net to make sure I am not going to mess things up. I didn’t always have these checks in place – I remember the cowboy days where we would click build, if it compiled we were good to go and would release to the world. ...
I have a real-time reporting server with a database which is basically a copy of my production database, but it's populated using transactional replication and replication only copies the primary keys over, i.e. none of the secondary indexes are included. So what I do is every time I need to recreate replication--which is every deployment with schema changes--I script out DROPs and CREATEs for all the reporting indexes I've created and then run the script after replication has been recreated. The ...
I’ve used the platform for ClearQuest migrations to TFS and Subversion migrations to TFS. The setup for testing the configuration can be tricky to ensure you’re starting again from a blank slate. Problem I was puzzled after running a number of test migrations to find that no source code would be migrated for some team projects, but not others. I was starting with a new migration configuration, new destination team project and even a re-install of the platform and the SQL Server DB for the platform. ...
I originally heard about this website several years ago when I was attending user groups with Rob Reynolds and Dru Sellers. At the time it was still early on in my career and I didn't feel it was the right time to start something like this. Now, 5 years later, I feel it's tje right time to start giving back, or at least trying to, and hopefully help someone like so many have helped me along the way.I am a programmer in Topeka, Ks. I moved here after graduating from Kansas State University and began ...
Hello all, before I start this article, I want to wish Happy New Year 2012 for you, hope this year will bring more success and happiness for all of us. In this article, I will show you how to create web.config file for ASP.NET application. The .NET Framework relies on .config files to define configuration options. The .config files are text-based XML files. Multiple .config files can, and typically do, exist on a single system. And FYI, I use HostForLife.eu as my hosting provider.System-wide configuration ...
With TFS 2010 a basic installation of TFS has been reduced to a matter of clicks, the pain however lies in getting an appropriate environment provisioned from the Infrastructure team. There will be planned and unplanned downtime as the infrastructure team takes the environment down for patching. There are various TFS hosting services available out there that’ll take this pain point away from you. Some of the leading players amongst others include DiscountASP.net, TeamDevCentral, Praktik Hosting… ...
Its been a while since I've played with Message Queuing and C# and decided that I should reduce that counter.During the simple process of figuring how to follow Microsoft's MSDN directions, I ran into a couple of headaches that could have been solved with a few navigational pictures. To the small number of people that this may help (and my future self when I need to do this again) here are the needed pictures.My journey started out with google and the keywords "installing MSMQ", the first selection ...
What is the Streetlight Store?The Streetlight Store is a .Net library which uses the Entity Framework and a Microsoft SQL Server database to perform the "back-end" operations required for a typical e-commerce application. While the Streetlight Store is intended to be used for e-commerce, it is "front-end agnostic" meaning that you could just as easily create a point-of-sale user interface.Why is there a Streetlight Store?Why develop another e-commerce solution when there are so many already available? ...

Hi Everyone,

Welcome to my first blog!

Here I will write things I find interesting, with particular focus on Team Foundation Server ...

Regards, Dave

A little more than three months ago, Microsoft hosted the //build/ conference at which they unveiled the upcoming version of Windows (commonly called Windows 8, though I don’t know if the marketing folks have accepted the fact that that is the name most of us are expecting for it yet). They released to the developer world a build of it called the Windows Developer Preview (and Windows Server Developer Preview) along with various tools for creating the new “Metro style” apps. I wasn’t able to make ...
I have just installed the UDDI 3 server on my BizTalk development environment. All looked good until I tried to open the publish page on the web interface. The page 'http://localhost/uddi/edit... returned a page cannot be displayed error. The same error occured when I tried to open the Subscribe and Coordinate pages.After playing around with the configuration for a while I tracked the problem down to the page using https. By connecting to the UDDI Service Console, right clicking on the ...
Wishing a very happy and blessed New Year to you in advance! A new release of Microsoft All-In-One Code Framework is available on December 29th. We expect that its 11 new code samples covering typical programming scenarios in Windows Phone 7, ASP.NET, WPF, Windows Shell, and WDK would ease your development in the coming New Year. You can download the code samples using Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, ...
We needed to swap out the DB box. Our DB box runs SQL Server, SSRS and SSAS. The AT is on its own box and SharePoint is on its own box.NOTE: I will update the blog post per resolution of the issue :) The Microsoft procedure I used was: Restore Data to a Different Server or Instance Setup new DB box with WS08 R2 with all updates applied. Installed SQL SQL 2008 R2 on new DB box (same version as on the old DB box). Took TFS offline. Disabled the transaction backup job from existing backup plan (runs ...
This is a strangest error I have come across whilst working with SharePoint 2010, the full error is this. [12/20/2011 5:29:10 PM] Warning: [WSS_Content] The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier. RESTORE DATABASE is terminating abnormally. The error message was written to the file restore.log found in the SharePoint backup folder, it seems that the following keyword in TSQL caused the error. IF EXISTS ( SELECT * FROM master..sysdatabases ...