Tag | server Posts

If you have not heard the latest technical news yet, the SQL Server 2012 Virtual Launch event is today March 8, 2012! Register to not to miss this opportunity to interact with technology experts and win cool prizes! I am thrilled and excited! Why? Because like in the automotive industry, every new iteration of a vehicle is more fuel efficient, safer, more polished, looking more attractive and fun to drive. Sure, the the new version of the SQL Server is ready to take me further in what I can deliver ...
It is now possible to move your SQL Azure server from one subscription to another. Last week, the Windows Azure team added this new feature to the Windows Azure Management Portal. Permissions for moving a server between subscriptions simply require that you are an account administrator, Co-administrator, or service administrator in both the source and target subscriptions. Moving a SQL Azure server is simple; log in to the Windows Azure Management Portal and select the Database option in the Navigation ...
Last week was the Microsoft MVP Global Summit, where Microsoft brings together their independent experts and community leaders for a week of sessions, product group interactions, and some fun along the way. These nights are always epic, stretching into the wee hours of the morning. I brought my camera and flipcam with me this year to capture the events, and so I give you The Most Epic MVP Attendee Party EVAR in Three Acts! It has everything – Playing football on an NFL field, singing karaoke with ...
A large portion of my work consists of designing Exchange 2010 environments for customers all around the world.Recently I was working on an assignment where we wanted to implement Exchange UM to replace cisco unity for 23 offices. The whole deployment is planned to run virtualized, this directed me to the specific requirements of UM on virtualization. This project made it once again clear to me that some good research is valuable even when you think you know your stuff.What I already knew was that ...
From Brian Keller: “I’m very pleased to announce the availability of the Visual Studio 11 Beta ALM Virtual Machine along with 6 hands-on-labs / demo scripts. This marks an exciting milestone in our journey towards RTM. You can now roll up your sleeves and start learning about the many capabilities we announced at TechEd North America last year and have been talking about in greater detail since then. You can download and install the beta of Visual Studio 11 (and Team Foundation Server 11, .NET Framework ...
Microsoft Dynamics 4.0 has a 32-bit BizTalk Adapter which is not compatible with 64-bit versions of Windows or BizTalk. Under Windows Server 2003, the AX 4.0 Adapter would not even install on the 64-bit version of the OS. On Windows Server 2008 R2 (which is only 64-bit), the Adapter installs, but it won’t work. However one of my colleagues, Justin, figured out what is wrong with the Adapter and a workaround to “fix it” so that it would work. The AX 4.0 BizTalk Adapter is a remoting adapter and there’s ...
I have two Great Plains databases, let's call them DB1A and DB1B, that are schematically identical and the data is 99% identical but DB1B has a tiny bit more data. I'm trying to optimize a very complex query that uses views nested in views and is way too long to post all of here. The query was averaging 1 min 43 sec before I started. I noticed that all of the tables involved were heaps (Microsoft's fault, not mine) so I started converting them to clustered one by one, checking the plans and parallelism ...
At http://www.itpro.co.uk/6389... Davey Winder of ITPro has published a very disturbing article on the problems of being infected by DNSChanger. The effect of DNSChanger is to point infected machines at a substitute server. The original botnet has been taken down by the FBI and a benign DNS server substituted. This allows infected machines to continue to access the internet, however the danger is that this substiute server will be turned off ...
Recently I have gone through the process of selecting a web hosting company for one of my clients. There are a lot of options out there and a number things you need to be cautious about. I will go over some of the decision points and questions you will want to ask a company before signing a contract. The first thing you need to do is define the features that make up you site. Is it made up purely of static content or does not use a database? If that is the case then you can choose just about any ...
While coding a very simple orchestration in BizTalk Server 2010, I ran into the dreaded "cannot implicitly convert type 'System.Xml.XmlDocument' to '<message type>'" issue. I've seen this happen a few times over the years, and it has often mystified me. My orchestration defines a message using a schema type. In a Message Assignment shape, I create the message as an XML Document and then assign the document to the message. I initially wrote the code to populate the XML Document with some dummy ...
Working though the white paper Microsoft Dynamics® AX 2012: Using Microsoft BizTalk Server 2010 to exchange documents with Microsoft Dynamics AX I came across an issue with incorrect information in the guidance given relating to some of the namespaces used:1. On page 19 the document states:"In the Properties pane, enter the Default Value for the sales order create operation: http://schemas.microsoft.co... Dynamics/2008/01/services/S... This is incorrect and the namespace ...
Working though the white paper Microsoft Dynamics® AX 2012: Using Microsoft BizTalk Server 2010 to exchange documents with Microsoft Dynamics AX I came across an issue when a Dynamics 2012 inbound port was attempting to consume a file created by a BizTalk 2012 send port.Initially the error given was that Dynamics could not access the folder specified. Giving the Dynamics user in question permisions on the folder led to a follow on issue where Dynamics could not consume the file as it was not the ...
I have recently started a new project where we will be integrating a large number of systems with Dynamics AX 2012 using BizTalk Server 2010.We are working alongside consultants from both PWC and Microsoft and it is apparent that there is not a great deal of experience or information out there regarding Dynamics AX 2012 integration, nevermind specifically using BizTalk 2010!To that end I thought I would make some notes on the lumps and bumps along the road to integrating Dynamics AX 2012.So far I ...
In this post we will see few of the initial steps for developing BizTalk Solutions for integrating with PeopleSoft Enterprise Systems using PeopleSoft Adapter. In order to proceed further, you must have Installed and Configured PeopleSoft Adapter properly, both on BizTalk side and PeopleSoft System side. This particular post is based on PeopleSoft HRMS 9.0 system. But the steps shown below should be same for any PeopleSoft Enterprise System. The steps will be same to connect to any Component Interface ...
I have some basic rules when it comes to checked in code to TFS. The one at the top of the list of rules is that, any developer should get the latest code from TFS, deploy and have a working web part, workflow or any other customization in SharePoint. This means that all dependencies should be deployed with the customization. If the web part uses a custom list as a data source, then a developer should not have to manually create site columns with the ‘correct’ internal and display name, list instances ...
Our Universities and Colleges haven’t gotten it yet, and its producing a disservice to the technical industry and trickling down to every other industry that relies on technical people (read: All of them). I’m talking about the lack of soft-skills, leadership, interpersonal, and professional training that organizations are demanding from their IT professionals. Gone are the days of the stereotypical programmer that sits in a dark room lit only by a computer monitor, with food and requirements slid ...
Let me start off by stating that I am in no way an expert on MSBuild, writing build scripts, MSDeploy, Web Deploy, etc. I learned a lot in this process about those things which helped me find a workable solution. I'm sure there are better ways to accomplish what I'm trying to do, but this is what I came up with. My goal in writing this is that someone will hopefully avoid wasting their time as I did trying to get app_offline.htm to work.For those of you who don't know what app_offline.htm is, it's ...
The key charactersYou may very well run into the same issue I did if you are using the following technologies:Team Foundation Server (TFS) with Team Foundation Build (TFB) - in my case, 2010Visual Studio Unit Tests - also 2010, in my caseReliance on loading assemblies at runtime: Assembly.Load()How might someone run into #3, you might ask? It's pretty common these days teeming with reliance on reflections and other fancy run-time logic. In my case, it was Enterprise Library.IssueI was seeing an issue ...
Today's $10 deal of the day from APress at http://www.apress.com/97814... is Pro ASP.NET 4 CMS"This book will immerse you in a variety of advanced topics, including architecting different application data tiers, memory caching paradigms, data mining, and search engine optimization. " I have reviewed this book and recommended it last 30/Nov as follows: This book is more than just a book about an ASP.NET CMS system - it has much practical advice and examples for the Dot Net web developer. I liked ...
Some Background The AdventureWorks database has been around for over a decade; a staple amongst sample databases. The first version of the AdventureWorks database appeared in time for SQL Server 2000. Microsoft has been good at keeping the AdventureWorks sample database up to date as new versions of SQL Server are released. Case-in-point: SQL Server 2012 is at RC0 and yet you can already find a version of AdventureWorks for it (albeit, it really isn’t that different from the SQL Server 2008 R2 version). ...
Commonly when you try to connect the Enterprise Applciatons with BizTalk Adapters you might get errors like : E-PSFT0029: JVM was not started OR Unable to find JAVA_HOME. As the error says, it is unable to locate the JVM.dll and unable to start it. Resolution: Make sure the folder having JVM is present as a value in PATH variable of environment variables. Say for PeopleSoft Applications, the JVM can be found with the app called JRockit so make sure the folder path of JRockit containing the JVM is ...
We’re only in February, but the rest of the 10 months left in 2012 look to be very interesting in the Microsoft space with products that Developers and IT Pros will find intriguing. Redmond Channel Partner posted a great article outlining what products we can expect to make an appearance this year and when. Some highlights: Windows 8/Windows Server 8 Well we all know this is coming, and that it will be a huge focus of Microsoft’s marketing (once their people are actually allowed to talk about it). ...
A quick note - possibly "note to self" - about how you can add administration pages to central administration ("CA"). Start with an empty SharePoint project.Add a mapped folder - to Template/admin.Add an application page to this folder. This is a three step process; add the page, move it from the layouts folder (where Visual Studio decided that you really wanted it), and rename the namespace. Next you'll want to add this page to CA. Do this by adding a custom action group and a custom action. Cksdev ...
A couple of days ago I decided to reinstall the latest Microsoft Developer Training Kits. One of those kits was the Windows Azure Training Kit. It turned out to be a web matrix install that seemed to take forever. More importantly it installed SQL Server 2012 for me. It may have prompted me but I don’t remember but once installed I entered a couple of days of nightmare mode. My RSSBus ADO connection to QuickBooks had stopped working and worst of all LightSwitch was totally broken. The problem is ...
Today's $10 Deal of the Day from APress at http://www.apress.com/97814... is Pro SQL Azure."Pro SQL Azure introduces you to Microsoft's cloud-based delivery of its enterprise-caliber, SQL Server database management system—showing you how to program and administer it in a variety of cloud computing scenarios." ...
You get an error message with Microsoft Test Manager 2010: Automatic connection to the following team project failed: <project_name> on server <tfs server>. Click refresh to display all currently available team projects, then connect to the project that you want to use. This error message displays everytime you are trying to connect to the MTM 2010 though you are able to connect to TFS successfully from the VS 2010. The issue doesnt goes off after installing the hotfix and deleting the ...
The same article in the TechNet. If you are working with queues in BizTalk Server, the most possible it is the MSMQ (in my experience). MSMQ is an old man of the Microsoft technology stack. It was created when there were no good standards for messaging. Now MSMQ is wrapped partly in the .NET System.Messaging namespace. It is just a small facelift. MSMQ is still a proprietary technology without well-defined messaging protocol. It means, you cannot use the MSMQ messaging protocol without MSMQ itself. ...
Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; ...
Classes starting soon...First topics to start with will be Visual Studio and .NET 4. After that there are sessions on SharePoint 2010 - Admin, Dev & General Usage Inviting all the people who wish to expand their knowledge in the field of Microsoft Technologies. I will be conducting FREE classes on various streams in Microsoft Technologies like: SharePoint - Administration and Development Visual Studio - 2010 C# and .NET 4 LINQ Team Foundation Server 2010 SSIS ASP .NET Programming Office Apps ...
The Problem After setting up a new instance of TFS I attempting to use the TFS 2010 Power Tools (Dec ‘11) Team Foundation Backups wizard. However, during the Backup Plan Wizard Readiness Checks, the “Grant Backup Plan Permissions” step failed with the error – Account… failed to create backups using path… The Fix Digging into the log created during the Readiness Check I found the following error - Error @xxx Microsoft.SqlServer.Managem... Backup failed for Server 'xxx'. ...
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; ...
Translate this pageArabicBulgarianCatalanC... SimplifiedChinese TraditionalCzechDanishDutch... CreoleHebrewHindiHungarianI... TranslatorCheck out this page in {0} translated from {1}translated fromOriginal:Translated:Aut... translation powered by Microsoft® TranslatorStart translatingStop translatingCloseClose ...
This blog provides links to a presentation and a sample application that shows how to load data in SQL Azure using different techniques and tools. The presentation compares the following techniques: INSERT, BCP, INSERT BULK, SQLBulkCopy and a few tools like SSIS and Enzo Data Copy. The presentation contains load tests performed from a local machine with 4 CPUs, using 8 threads (leveraging the Task Parallel Library), to a SQL Azure database using the code provided below. The test loads 40,000 records. ...
Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; ...
In the lifespan of an organisation it’s messaging environment be transitioned to a newer version several times. Whilst this is not a complicated thing to do it does require some level of planning and thought. I’ll be addressing the transitioning from Exchange 2003 to 2007 from a fairly simple view here. Since the general outlines of the process are the same for nearly every situation there is no need for different detailed documents on this. We’ll be working with the following infrastructure in this ...
This article is written to assist SQL Azure customers to copy a SCHEMA container from one SQL Azure database to another. Schema separation (or compress shard) is a technique used by applications that hold multiple customer “databases” inside the same physical database, but separated logically by a SCHEMA container. At times it may be necessary to copy a given SCHEMA container from one database to another. Copying a SCHEMA container from one database to another can be very difficult because you need ...
When you first create a new table, there is no index created by default. In technical terms, a table without an index is called a “heap”. We can confirm the fact that this new table doesn’t have an index by taking a look at the sysindexes system table, which contains one for this table with an of indid = 0. The sysindexes table, which exists in every database, tracks table and index information. “Indid” refers to Index ID, and is used to identify indexes. An indid of 0 means that a table does not ...
Nationwide search on dice.com

Feb. 4, 2012

C# - 8,518
ASP.NET  4,957
.NET MVC 1,101

Biztalk  409
Microsoft Dynamics CRM   461
Sharepoint 4,022
SQL Server 14,390


Java  16,854
groovy  292

Oracle 18,118

Monster.comNationwide searchJob Title: Empty ; Skills/keyword: mvc location: emptyResults: 523 jobs nationwide (mostly java )Change to Skills/keyword ASP.NET MVCResults: 80 jobs nationwide.net mvc = 129groovy = 66 jobsgrails = 44 jobsC# 3,481VB.NET 855.NET >5,000ASP.NET 2,245Java > 5,000Delphi = 93VB = 2,559Visual Basic 2,604ORM - 150Hibernate - 851NHibernate - 53Linq = 162Entity Framework = 97fxcop = 5 jobsOracle = >5,000SQL Server = 4,148mysql = 1,431db2 = 699Nunit = 120JUnit = 422Selenium ...
Most of us spend our time in Visual Studio writing .NET code within a Visual Studio solution. Given this situation we find it very easy to integrate with Team Foundation Server for our source control and have a well known work pattern. But what happens when you want to use TFS as source control for non-Microsoft development? The most important thing to remember is that source control should be as transparent as possible to the developer. If the particular language or product does not have an Integrated ...
Pros and Cons of NOLOCKI have seen some developers use WITH (NOLOCK) when querying in SQL Server and wonder why they use. Now i explored it and found that its useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is currently being updated in the Table ie Without lock protection, you cannot be guaranteed that the data isn’t changing during the time that the query is running.With ...
The landscape of SQL Azure backups is changing rapidly. A few tools are becoming available at no charge and Microsoft is adding capabilities over time. Here a quick update.Microsoft ToolsMicrosoft offers two primary backup mechanisms so far:Export/Import feature available on the Azure Management portalThe COPY operation as part of its T-SQL CREATE DATABASE statementThese mechanisms do not offer a scheduling component and do not work together. To obtain a transactionally consistent backup, you first ...
Inviting all the people who wish to expand their knowledge in the field of Microsoft Technologies. I will be conducting FREE classes on various streams in Microsoft Technologies like: SharePoint - Administration and Development Visual Studio - 2010 C# and .NET 4 LINQ Team Foundation Server 2010 SSIS ASP .NET Programming Office Apps & Open XML Basic SQL Server and Queries Windows Azure One Note All the courses will be taught using Microsoft Official Curriculum. Soft copies of Lab material, Virtual ...
Back in 2009 I was tasked with automating database dictionaries and schemas outputs for the CI (Continuous Integration) Server called Hudson ( which is probably now owned by Oracle and will become a name like Jenkins, but I digress. CruiseControl and CruiseControl.NET for Windows is another popular free CI, both of which are superior to the lightweight CI of TFS ).I setup ANT scripts with regular expressions that would get called nightly to rebuild the creation of html and image files with the schemaspy ...
I ran into this particular issue and didn’t find any answers to this specific question online. Here’s how I was able to accomplish this. A couple notes about my scenario: I used slsvcutil.exe to generate my service. I could not get connected to a service through “Add Service Reference” when connecting from outside the ISA server protected connection. This connection was tested and successfully retrieved data from a Windows Phone 7 device. I figured on the scale of success this was the platform that ...
Exchange is a complex and large product which can have one thousand and one possible issues, one more obscure as the next. The purpose of this guide is to shed some light, where possible, to how things work in Exchange (and outlook), how they can break and how you should approach the issue at hand. Unfortunately it is very time consuming to create a complete troubleshooting guide where every dependency is explained in detail. But that is not the aim of this document anyways. What is the aim? Give ...
As you might, or not, be aware off there is no item level based recovery in Exchange that is natively supported by Microsoft. So to perform recoveries we need the recovery storage group (captain obvious). The purpose of this is to mount the database you want to recover from on the Exchange server and use exmerge to merge the data you are recovering into the active database. An RSG will not be accessible to users and you can only create one at a time. Exchange 2003: 1. Open Exchange system manager ...
This blog has moved to https://hornedowl.netTroubl... the information store service can be straightforward yet immensely complicated if you don’t know what is going on. For this reason I think it is important to know that there are 3 likely culprits that will cause your information store service to go down and refuse to come up: · Database problems · Active directory problems · Antivirus software Trying to work out which is the culprit can be hard, elimination is probably the easiest way to ...
Usually you’ll get alerted to this issue with a call saying that users have not gotten any new email for a while. They will still be connected to Exchange in outlook, you can still log on to the OWA and, when looking at your hub servers, you can see that the all services are up and running (Note that it is possible the transport service could be stopped…). A number of reasons can exist as to why you are not getting any mail flow: · Your recipient polies are not configured correctly · The receive ...
A fairly common (and annoying) problem which seems to like to popup after migrations, yet not unsolvable. The key issue here is that there are new users added to the directory but they are not showing up in outlook. Now, if you are like most organisations then outlook will be operating in cached mode. So log in to OWA and test if you can see the new users there. I’m giving it a 99% chance that you will (and if you don’t you have a serious problem at hand!) The reason you are not seeing these new ...