Tag | server Posts

You have at least 2 choices: Source 1: SQL Server 2008 Feature Pack http://www.microsoft.com/do... ... this includes Microsoft OLEDB Provider for DB2 Source 2: Available from IBM, is the IBM I Access pack http://www-03.ibm.com/syste... Remember, whichever one you use, you will need to specifiy which libraries under the detail/advance settings in ODBC ...
Our engine is written in almost pure C++ with some part in C# that run on Mono. The code base is huge which mans that we’re primarily looking for platforms that support C++ development. Looking at the current set of platforms on the market this is really not a big issue with Windows Phone being the only platform that does currently not support native development. Sadly this means that we’re currently not planning a Windows Phone release in the near future. Looking at other platforms, about a year ...
Today was Day 0 of the Microsoft Build conference here in Anaheim - a day for attendees to travel, get their registration done early, and set up their session schedule for the remainder of the week.But this conference is quite different. Microsoft is holding its cards very tightly around Windows 8, and no information will really be available until after the initial keynote tomorrow. Normally when you register for a conference you already have access to the sessions - not so here. In fact the Build ...
Download Demo - LINQpad Query In this blog post I’ll be showing you how to query TFS using LINQpad. 1. Download LINQpad Those who are familiar with LINQpad know its benefits and ease of use, i would urge others to try it. You can download LINQpad and read more about it from here => http://www.linqpad.net/ 2. Download TFS SDK I have a blog post on where and how to download the TFS SDK from => here 3. Querying TFS using LINQpad Open LINQpad Select Query Properties by selecting Query from menu ...
In the world of custom web application development a critical component of our success is the hosting environment and services. We can choose to deploy our web applications using 3rd party hosting providers such as GoDaddy.com, Rackspace, DiscountASP.NET, or another provider, or we can choose to deploy to on premise servers either virtual or physical. In either case the web application must be serviced up to consumers by a web server software such as Internet Information Service (IIS), which is included ...
I've been working lately on web application that uses Asp.Net MVC, WordPress and MySQL database. To communicate from .NET code to MySQL database using Entity Framework we installed MySql .NET Connector. It worked fine out of the box on developer's workstations but once deployed to hosted web server application started to throw following error: [NotSupportedException: Unable to determine the provider name for connection of type 'MySql.Data.MySqlClient.MyS... System.Data.Entity.ModelCon... ...
On the 9th Sep, the SQL Azure team announced that the new version of SQL Azure had just been release. In this version not only the SQL Azure engine had been upgraded, the SQL Azure Management Portal had been upgraded massively. Below are the features and improvements available in this release: Foundational updates for scalability and performance. Co-administrator support, which enables customers to specify multiple database administrators. Increased capability for using spatial data types, which ...
In the previous post I droned on about how to apply the AsyncOperationService to an API conforming to the .NET Asynchronous pattern. In this post I’ll be building a more real world example. Well I say “real world” please don’t confuse that with something actually useful. Its still a little contrived and is not an example of best practice but it is something you could actually build and test. What are we going to build? We are going to build an ambitious ground breaking Silverlight app that allows ...
We have a webscraper ASP.Net application, that worked fine on developers and test environments, but didn’t work on some machines with more strict security settings. HttpWebRequest failed with System.Net.WebException: Unable to connect to the remote server It start working when my colleague added the site that application tried to access to his “Trusted Sites” zone using Internet Explorer. What we couldn’t understand, how it affected an application that ran under DIFFERENT account. I didn’t find any ...
While undeploying a BizTalk Applciation recently something went wrong, leaving BizTalk in a strange state. When opening the BizTalk Server Administration Console the following message would be displayed: Schema referenced by Map 'xxxxxxx' has been deleted. The local, cached version of the BizTalk Server group configuration is out of date. You must refresh the BizTalk Server group configuration before making further changes. The problem with this was that any attempt to refresh the BizTalk group in ...
DECLARE @RegLoc VARCHAR(100) select @RegLoc='SOFTWARE\Microsoft... NT\CurrentVersion' EXEC [master].[dbo].[xp_regread] @rootkey='HKEY_LOCAL_MACHINE', @key=@RegLoc, @value_name='ProductName' The above code will return the installed version of windows on which the current instance of Sql Server is running. references: http://www.mssqlcity.com/Ar... ...
Just a quick one. I was trying to add and deploy a WSP file.Both went well until i tried adding the webpart and i get the error Web Part Error: No available sandboxed code execution server could be found. After doing some joggling around i came to know i had to start the Solution:You need to start the SharePoint Foundation Sandbox Code Service service instance from services on server.. This has to be done in the SP 2010 Central Admin > App Management > Service Apps > Manage Services on Server. ...
On SQL Server Central there is a very good article at http://www.sqlservercentral... on least priviledge access to a database. The only thing I can add to such an excellent article is that where there is a series of applications each with its own database on a common database server, there should never be a common account across all the databases that the applications use ...
Recently I implemented a rather complex page allowing the user to input pairs of colors and quantities, with some relatively "odd" validation rules. I knew that I probably wanted to implement the page entirely with javascript and probably jquery templates, but for a demo I just needed a quick prototype of the page, so to get that done I threw together a quick and dirty webforms page using the telerik radgrid to display the data, but not save & validate. Took me maybe 2 hours including some basic ...
Introduction By now, most of you have heard that Windows Phone 7 – Mango release will support Local Databases (SQL CE) using Linq to SQL. But what you probably haven’t heard much about is how to extract the .SDF that is created in isolated storage to your local computer and view the contents. I find this extremely important for debugging application and making sure my database is setup exactly like I want it. So, that is what we are going to do today. Getting Started with a sample application: For ...
In this Issue: Alex Golesh(-2-, -3-), Andrea Boschin, Peter Kuhn, Shawn Wildermuth, WindowsPhoneGeek(-2-), Jesse Liberty, Pete Vickers, Sumit Dutta, Asim Sajjad, Chad Campbell, Vikram Pendse, Michael Crump, and David Kelley. Above the Fold: Silverlight: "Silverlight 5 : Low-Latency Sound Effects" Vikram Pendse WP7: "Windows Phone codenamed "Mango" Training Course" Alex Golesh Shoutouts: Michael Palermo's latest Desert Mountain Developers is up My friends at SilverlightShow posted their top 5 for ...
To start, I love Red Gate Software’s Tools. I have loved them since the first time I started using SQL Backup and SQL Compare when I first started Geekswithblogs.net. I think they create quality products and have been a “Friend of Red Gate” for years. So know that this review is coming from a “fan boy” of sorts. What is SQL Compare? Well the name sort of says it all, this product compares SQL databases. But not just databases, but backups, snapshots, and source control using their product SQL Source ...
Having worked with TFS & SVN for a while now, I recently was put in a position where I had to get up to speed with Git. My only experience with Git up to now was attending a brief presentation on the subject and spending a few hours playing around with it – interesting at the time, but foreign enough for me not to hold any strong opinions on the matter. For the last two weeks I have had to get exposure to Git, and after getting over the initial “uncomfortable” stage I must say that Git is seeming ...
Over the past couple of days I have noticed that our time on our computers just keeps getting further and further off. I noticed that our Domain Controller had the incorrect time, so, after doing some research I found a nice solution: 1. Locate the PDC Server. 2. In CMD type C:\net stop w32time 3. To configure the server to and external source type: C:\w32tm /config /syncfromflags:manual /manualpeerlist:"0.pool.ntp... 1.pool.ntp.org" 4. Once this command completes, type : C:\w32tm /config /reliable:yes ...
Every now and then, the day job causes me to want to rip my hair out. I know, this is shocking news, especially for those of you that have seen me. However, it is true1. This weeks Tour de Pain comes to us courtesy of cryptography. Before we begin, let me say this. By the nature of the beast, you can't know what you're doing while you're doing it2. As such, most adventures into the subject will lead to heartache. The sad part is that the .NET Cryptographic providers were not the true source of heartache. ...
Recently I used Entity Framework 4.1 with Code First approach and step on a hidden rake. My application should create an SQL Server CE database file using supplied model classes. I created some model classes, one of the classes was declared as namespace MyProject.Models { public class Object { public int Id {get; set;} public String Name {get; set;} } } Then, I tried to declare property of DbSet<MyProject.Models.O... type in my class derived from DbContext: namespace MyProject.Models { public ...
If you are developing you WCF service for web service deployment under IIS and coding with the Visual Studio web server you are in for a rude awakening when it comes time to deploy your solution. Ok, so that is a little over dramatic, but there are a few steps and precautions you need to know about. Below are the main steps to deploying your application to IIS assuming WCF is already installed and registered. The first step is to create an application pool. Make sure that for your .NET 3.5 WCF service ...
Rich internet applications are growing fast in the business and enterprise application landscape as more and more software managers and corporate decision makers are electing to place rich internet applications (RIA's) into their organizations. But with the many advantages of rich internet applications over the client/server deployments, organizations also find many new aspects they need to master and overcome - one of them is understanding the new security vulnerabilities of the rich web based applications ...
Our brand new and first service release for SharpBox 1.1 is out. This is the first release which follows the idea to deliver every 4 to 6 weeks a small service release with the latest bugfixes from the field. This release contains an important change for all storage provider developers. The assembly AppLimit.CloudComputing.Sha... contains all storage provider which are not part of the core API. This location should be a home for only a short period of time until the ...
It’s been quite a while since I’ve done a GeeksWithBlogs.net Influencers review. This time, I had the opportunity to check out Red Gate’s SmartAssembly 6.1, which is a integrated collection of tools for modifying and manipulating assemblies. Now that phrase, while accurate, is quite a mouthful. So what all does it actually do? SmartAssembly has the ability to: Do strong name signing; Add automated error reporting; Add feature usage reporting; Merge dependencies (e.g. libraries) into the main assembly ...
Apologies in advance for any problems caused as I move over to http://ericnelson.wordpress... over the next few days. I will blog again on here when the move is fully complete. I have had a superb time on http://geekswithblogs.net which I moved to back in January 2009 – but it doesn’t quite match what I am after in a blogging platform right now where as wordpress.com broadly does. This will be my second change of platform in 7 years – it was back in July 2004 I created my first technology blog over ...
In my previous post I have shown how we can use a C# function in the XSLT. Now I want to go one step further and use in the transformation the ASP.NET controls along with their events. Let's start from the sample xml data: <files> <file Id="F58C2962-AC0D-4C55-80A8... Name="file 1" Path="D:\Temp\" Extension="iso"/> <file Id="FDC1358E-D9C8-4A70-ABE0... Name="file 2" Path="D:\Temp\" Extension="jpg"/> </files> I want to create a table from it and for each ...
If your question is, what is this? or perhaps more around … what does this mean? Let me explain a bit about it. Microsoft has been providing this type of services through partners within a given competency to clients that are looking to deploy and implement Microsoft products like SharePoint, Exchange or the strategy behind Windows and Office deployments. The way it works, well you purchase your products and perhaps those products come with Software Assurance and they have training/service credits. ...

Please vote for Ola Hallengren, in my opinion he has the best maintenance scripts, and best of all “THERE FREE!”.

You can check out his scripts and well as the link to vote from this page SQL Server Backup, Integrity Check, Index and Statistics Maintenance

till later,
John

NHibernate has many ways to create and executes queries. With one of them* - the Named Queries we can execute our manually created stored procedures. This example is dedicated to SQL Server. This is important to notice, because this code is database specified. That means, for each database the query can look diffrent. E.g. in SQL Server we call the stored procedure by using the syntax: exec <procedure>. In Oracle it is: call <procedure>, so we must remember it. Let's assume we have a ...
I had a bit a of trouble today getting some classic ASP pages to load in IIS 7. Here is what I had to do: 1. Install ASP Feature for IIS if it is not installed. Server Manager -> Roles -> "Role Services" section : Check ASP under Application Development. 2. Check your application host config file for the line: <add name="ASPClassic" path="*.asp" verb="GET,HEAD,POST" modules="IsapiModule" scriptprocessor="C:\Windows... resourcetype="File" precondition="bitness64" /> ...
Business operation framework is the investments Microsoft is making towards SOA and becoming Cloud ready. SysOperation framework is the future replacement for RunBase batch framework. The only reason Microsoft have not depreciated RunBase Batch is because there is still a lot of existing code base using Runbase. SysOperation framework follows the MVC pattern and it ensures that the server side code is executed by the .NET framework. That’s why it is necessary to generate incremental IL when you make ...
I just wanted to return from sql server data as xml. This is very easy to do, because sql server has a build-in suppot for that. select Id, Name from Extensions FOR XML RAW('Extension'), ROOT('Extensions') But using this query, the returned column has name like XML_F52E2B61-18A1-11d1-B105... It's been some time when I manually created a sql query, so I lost few minutes to think, how to alias this column using the AS keyword. Correct query looks as follows select (select Id,Name from Extensions ...
Our SharePoint team at work noticed that our SharePoint 2010 farm wasn’t returning search results based on the contents of OneNote files that were saved in document libraries. I did a little research and found a solution, by putting together steps from different posts. First, some details: we’re running SharePoint 2010 SP1 (with the June 2011 CU) on Windows Server 2008 R2 SP1. However, this issue was seen before we applied the service packs and cumulative updates, so I’m not sure what effect, if ...
There are many reasons that you may want to add email capability to your Windows Phone 7 application. There are a number of ways you can communicate information out from an application. The mechanism for sending email from your WP7 application is the EmailComposeTask API. The difference between this API and the one that you would use for an ASP.NET application is that it opens a screen to allow the user to select an account to use and then creates a message which the user then has to send. This makes ...
Recently we upgraded to Hyper-V. Everything was working great, until Friday. I had just installed Windows Updates for August, and was going through and restarting our two domain controllers (on separate hosts), one at a time. Which probably shouldn't be done during the day, but I've NEVER had problems with it before. Well, after one restarted, and I logged in, I restarted the second one. Which restarted with any problems, until my Hyper-V host said that the management console couldn't reach the host. ...
SQL Server “Denali” is at CTP3 – and would therefore very much welcome feedback. SQL Azure continues an aggressive cycle of release - and would therefore very much welcome feedback. Which is why we have https://connect.microsoft.c... A great place to give feedback and to to see what others care about. For SQL Azure (and the Windows Azure Platform in general) we also have http://www.mygreatwindowsaz... Thanks in advance… ...
In this Issue: AfricanGeek, Dhananjay Kumar, Erno de Weerd, Jesse Liberty(-2-), Den Delimarsky, Austin Andrews, John Papa, Morten Nielsen(-2-), Andrej Tozon(-2-), and Michael Washington. Above the Fold: Silverlight: "Papa's Perspective: Fundamental MVVM" John Papa WP7: "Connecting Windows Phone 7, Zune, a Proxy Server and an Intranet Web Service" Erno de Weerd LightSwitch: "Using WCF RIA Services With LightSwitch: I Know You're Scared, I Understand" Michael Washington Shoutouts: Michael Crump is ...
For a period of time, I have access to both an MSDN and a TechNet subscription. Both offer Microsoft software for download. I wondered what the similarities and differences were between the two subscriptions. I copied the two download lists into Excel and aligned them. Most of the material I would never use. Some products I have never heard of. I present the lists, current as of today, for your reviewing pleasure. TechNet MSDN Applications (63) Applications (79) Access 2.0 Access 2003 Access 2003 ...
We had an issue once we deployed our .Net 4.0 C# ZeroMQ solution to a Windows Server 2008 instance where the application would freeze up or block, seemingly on the initialization of our ZeroMQ library. Upon furthter investigation it was discovered that the application was blocking on the construction of each new zmq Context object. Having exhausted all other alternatives, an internet search revealed a stack overflow post : http://stackoverflow.com/qu... ...
Since exchange versions from 2007 and up put more emphasis on the webservices for use in the distribution of the offline address book, out of office, the scheduling assistant and autodiscover (a.k.a outlook connectivity to exchange) the correct configuration of the virtual directories and IIS components is the main key to a healthy exchange environment. It is for this reason that I have compiled a quick reference as to how these components should be configured in order to function properly and so ...
I have a simple database table with only id and one xml column as shown below. In this column I have a list of available extensions saved as xml. public class FileExtensionsList { public FileExtensionsList() { Id = Guid.NewGuid(); } public virtual Guid Id { set; get; } public virtual XmlDocument Extensions { set; get; } } This xml I'm not creating manually. I have a custom entity which I serialize to xml: [XmlRoot("FileExtensionsLis... [Serializable] public class FileExtension { [XmlAttribute] public ...
The Microsoft SQL Server team has been interacting on a regular basis with developers and users in the form of surveys. If you have 15mins spare and would like to do your bit to help shape the roadmap for SQL Server then please pop over to http://www.zoomerang.com/Su... And… My own simple one question version if you only have one minute to spare. Apologies in advance for stuff I left out! Related Links: More details of the survey are posted on the ADO.NET team blog ...
Several Outlook 2010 users with Exchange 2010 mailboxes reported the following issues. When creating a new message and adding a Universal distribution list to the To: field, they attempt to expand the membership of the DL and they get an “Cannot perform the requested operation. The command selected is not valid for the recipient. The connection to Microsoft Exchange is unavailable. Outlook must be online or connected to complete this action.” error message. In addition, if they tried to look at the ...
The origin of the following is now lost in the mists of time but it bears repeating. A big party is being held to honor relational database systems & their impact on the modern society. Outside the venue, the host awaits the guests. The first limousine arrives and out steps Oracle followed by 4 people Host: Who have you brought along? Oracle: I have 4 DBA’s in tow. One to install me, one to design the databases, one to administer me and the other to justify the cost. A second limo arrives and ...
Recently i caught in a peculiar situation where i need to modify the check constraint expression to include more criteria to be validated through T-SQL. Although there is no declarative command or mechnism to modify the expression except dropping and recreating the check constraint. One exception is to use the Sql Management studio to modify it in design mode. But modifying using design mode was out of scope. The actual work was to alter or modify the defintion of a check constraint created with ...
Performing Composite Operations on Oracle Database is very similar to SQL Server Database. I just want to point out one mistake developers might easily make during the send port configuration. For any composite operation, the generated binding script doesn't include the composition operation tag in SOAP action header, therefore a new line needs to be manually added for each composite operation during the send port configuration. For WCF SQL Adapter, it looks like <Operation Name="CompositeOperationName" ...
Everyone has a journey. You start off young & stupid, and 2 decades later, you're closer to understanding the nature of reality. That’s one of the main goals in life, to seek knowledge (justified, true beliefs – pick any 2 J ). I must have read 5000 books in my life. From some of my readings it could be construed that reality computes itself, It from Bit. From others, it can be concluded that Entropy is decreased by increased rates of computation, and in the short span of human civilization, ...
The KB article is so short, I may as well paste it in. KB article 2021894 MSMQ ReceiveContext does not receive messages from the queue and no exception is thrown On a computer that is running Windows Server 2008 or a later version, you experience the following symptoms: In Microsoft Message Queueing (MSMQ) 4.0, the ReceiveContext feature fails silently. Additionally, the Windows Communication Foundation (WCF) application does not receive any messages from the queue. The ReceiveContext feature's Complete ...
No matter which ORM or data access technology you use, at some point you just need to do some CRUD, and you need to do it fast. In this post, I’m going to show you how to get your CRUD on with the latest version of Entity Framework in no time flat. In fact, I’d be surprised if the code to get your first CRUD operation done takes you more than a few minutes. The one thing the EF team did right with Code-First is make it really easy, but most of the “getting started” videos and documentation is packed ...