Tag | Database Posts

A while ago I posted an article about an issue when the tracking information for BizTalk appeared not to be working and it was because the stream status was out of sync and information was not passing from the messagebox database to the tracking database. http://geekswithblogs.net/m... Since then I did a small SQL script which could be used to check if they were in sync and if not could fix the issue. This script is below incase anyone needs it. Note: I ...
www.prairiedevcon.com I am VERY thrilled and excited to announce a new Canadian software development conference scheduled for 2010: the Prairie Developer Conference! The conference will be held June 2 – 3 in Regina, SK at the Delta Regina Hotel and Conference Center. It will feature 40 sessions spread over 4 tracks: - Web and Rich Internet Applications - Development Foundation - Application Lifecycle Management - Database and Business Intelligence I’ll be announcing registration pricing later this ...
Using SQL Azure for your applications is relatively straightforward. All you need is... a connection string... and since SQL Azure uses TDS as its underlying communication protocol, just like SQL Server, it may seem natural that you don't need to change much in your application design approach when connecting a SQL Azure database. However, this may not necessarily be true. SQL Azure was designed for ease of deployment and scalability; and as such you may need to take certain things into consideration ...
Persistence ignorance is, I believe, one of the most important features of an ORM tool and it is coming with Entity Framework 4 and Visual Studio 2010. When your classes are persistence ignorant, they don't know anything about the data layer they are attached to and carry no dependency to said data layer. Any application where your data will be passed between layers, like in a web service or web application, will greatly benefit from an ignorant set of data classes. This was possible with Entity ...
In this Issue: Mark Monster, Colin Eberhardt, Andy Beaulieu, Stephen Price, Tim Heuer, Vibor Cipan, Koen Zwikstra, Jeff Prosise, Dan Wahlin, and David Poll. Shoutouts: I know I've congratulated a few of the new and re-awarded MVPs for January 1st, but Tim Heuer has the big list on his site, so I'll just give a link to Tim: January 2010 Silverlight MVPs Jeff Blankenburg had a contest up on January 1st... obviously it's over, but it was fun to work through: Click The Button - The Contest Jesse Liberty ...
I was recently turning one of my clients database to help improve performance in their high transactional environment. One of the major caveats that we had was that the client was dealing with ever increasing size of their databases (which all organizations do) that were surging to over TB in size and had limited window of maintenance due to high availability and constant change of data. With this in mind we knew that regular database indexing was not an option adding the sizes of indexes that were ...
Tech bloggers like to have a predictions post at the beginning of each year (or the end of the previous one). I’ve never actually written one before, although I have made year-ahead predictions in panel discussions for the now defunct NYSIA. Since there’s no panel this year, and since I’m taking better care of this blog, I’d thought I’d give clairvoyance a whirl right here. The following predictions are pretty random and probably not comprehensive, but I’m making it my new year’s resolution to prevent ...
Hi this Article is aimed at discussing only the outlines of ASP.NET DataBinding. ASP.NET provides a rich set of controls for working with data.ASP.NET provides the DataBound controls,DataSource Controls to work with data. DataBound Controls : We can use DataBound Controls in our application's to generate the user interface for working with data.The DataBound Controls are used to display the data and modify the data. There are three types of DataBound Controls are available. List Controls Tabular ...
This last year I had a focus to get more involved in Open Source (OSS). The year before I had been involved a little by submitting a patch here and there, but 2009 was a big year for me in OSS. I now manage 4 open source projects that have solved a need for me and others. Coming up on the end of the year it was important for me to get some final touches into at least two projects to finish out the year. UppercuT UppercuT (UC), for those of you who have never heard of it, is an automated build tool ...
Recently I had an interesting task to consume a particular XML document and populate a C# object from it. The structure of the XML document looked roughly like this: 1: <root xmlns="http://www.w3.org/20... 2: <entry> 3: <id>1</id> 4: <title>abc</title> 5: <content> 6: <div xmlns="http://www.w3.org/19... 7: <table> 8: <tr> 9: <td>Item1</td> 10: <td>111</td> 11: </tr> 12: <tr> 13: <td>Item2</td> ...
In the new film “Up in the Air,” George Clooney’s character, Ryan Bingham, poses a question relevant to the premise of BI as a cloud computing offering. Bingham is a career transition specialist -- i.e. someone who fires people as an outsourced service – and he insists that his services must be delivered on-premise (if you will), despite his firm’s new initiative to start doing so via Web conference technology. That initiative is being pushed by his colleague, Natalie Keener (played by Anna Kendrick), ...
Earlier I had written on migrating your Northwind database from SQL Server to SQL Azure. In that, I had mentioned that the SQL Azure Migration Wizard supports migrating the schema and doesn’t do the data migration which has to be done manually. Meanwhile, George Huey has published a recent version on the SQL Azure Migration Wizard at CodePlex which also does data migration. What this means is that, you can take an existing database and generate the scripts and go ahead and deploy the database along ...
Now that we have some basics for LINQ for XML. Lets get deep into some using LINQ against Relational databases, aggregate functions, like group by and sort. The database we will be using is books, this can be obtained from this page. Once you download the database, mount it in SQL Server by attaching this mdf file. Once the mdf file is mounted, we can start with the following steps to do our first LINQ to SQL console program. 1) First of all we need to add a new DB by selecting Tools > Connect ...
Previously I wrote an article regarding Unit Testing WCF with Unity. Unit testing allows you to test a single component of your application, completely independent of any other components or systems. Once you have successfully created your unit tests, the logical next step is to see how your service works when connected to other components. These integration tests allow you, for example, to run tests against your service and see how it behaves when writing to a database or consuming another service. ...
Here’s simple code to add to a project’s “Build Events” post-build properties: if exist "$(ProjectDir)Web.$(Configu... (copy "$(ProjectDir)Web.$(Configu... "$(ProjectDir)Web.config") It searches for a build-type web.config, then replaces the current web.config with the build-type web.config file. Example of a build-type web.config’s web.Release.config web.Debug.config This is best if you don’t want to continually set the <compilation debug="true"> attribute or ...
Earlier I had written 2 posts – Taking your Northwind Database to SQL Azure and binding it to an ASP.NET GridView Part I and Part II . I thought, I will complete the series with a post on moving your ASP.NET Application as well to Windows Azure making it a truly cloud based application. Before we start, there are a bunch of things that you would need to do. First and foremost, you would need a Token for Windows Azure. You can request for a free token for Windows Azure from here after providing your ...
If you have used the Entity Framework that shipped with Visual Studio 2008 SP1, you would really start appreciating the flexibility it offers for building schema driven data access layer and get it to the UI Layer either directly or using a middle tier such as WCF RIA Service. Check my earlier post on this, if you are interested further :) Meanwhile, the other exciting stuff that has been around is the SQL Azure which is part of the Windows Azure platform. SQL Azure provides relational data over ...
While working on SQL Azure connectivity from Visual Studio 2010, I faced the above error. The full error text is as below:- “Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.window... Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match. “ As the message suggested, I tried putting ...
The next version of Entity Framework has many new features, many of which are enabling it to catch up with features previously available in other frameworks like LINQ to SQL. One of these new features is the updated stored procedure support. In previous versions of EF, working with stored procedures was quite limited and really only usable with CRUD operations that were mapped to already defined entities. With EF 4, you can start with your stored procedure and have the designer automatically generate ...
MojoPortal is an open-source content management platform that we have started using at StrongEye because it offers an extensive out of the box starting point for ASP.NET Web applications, and also because it is incredibly developer-friendly. UPDATE: For most common Web site tasks, you probably can go very far in MojoPortal without having to create custom code. These steps are advanced and for developers who want to create new functionality that cannot be accomplished with the existing feature set ...
Technorati Tags: Application Architecture and Design Strategies 10 Key Skills Architects Must Have to Deliver Value Architect Roles and Responsibilities Project architect Does not work at the enterprise level, but must understand the EA context and provide feedback on how EA actually works from the project perspective. Acts as a bridge between enterprise context, business domain, and the project design. Business architect Business goals, strategy, alignment using value chains, Business Motivation ...
While at TechEd Europe in November 2009 I had a chance to catch up with David Robinson, Program Manager in the SQL Azure team and discuss... SQL Azure :-) We cover the "reboot", large databases, the new support for SQL Azure in SQL Server Management Studio, customer feedback and futures. V2 hints include: - bigger database - automatic partitioning - spatial data types You might also want to check out the slides of a SQL Azure session I recently delivered based on the session David gave at TechEd ...
UPDATE: 5th January 2012If the client machine does not have SQL Server Configuration Manager, then head over to this MSDN article, http://msdn.microsoft.com/e... Qureshi has written an excellent comment for how to use the command line utility, cliconfg.exe, on a client machine which lacks SQL Server Configuration Manager. Isn’t this old hat? In a distant SqlBits, far, far away (actually the very first SqlBits) I gave two grok talks; the first on developers using SQL Server ...
I know it's a tough call dealing with users all day, but sometimes you just have to wonder WTF is going on with the Help Desk. My client has a tool they run called Sulimina, you can look it up, and I might get some heat for this, but the dang thing looks like it was written in DOS. It's used in the factory to enter data into the database and it sucks. Now, I'm saying that without ever having used the factory tool, but I can safely say it because I have to deal with the data they enter. Many fields ...
*Moved to: Create a VHD from the Windows 7 Image diskThis being my first week at SSW, and still waiting for my nice shiny new laptop to arrive, I am sitting here at my Wife’s laptop (which is PINK, a requirement to keep the WAF high), until it arrives. Figure: Current workspace…one wall short of working in a cupboard, but it beats trying to work with the kids underfoot. Read more...Follow my new blog on http://blog.hinshelwood.com ...
Part 1: BizTalk Monitoring Engine Overview There are a few products on the market today that provide monitoring capabilities for BizTalk Server. So, in a market that provides seemingly abundant choices, what makes Minotaur special? What differentiates Minotaur from its competition? This post delves into the details of what makes Minotaur the leading choice for monitoring BizTalk Server enterprise solutions. Agent-less deployment Minotaur was designed to perform its monitoring services from a central ...
In this Issue: Pete Brown, Davide Zordan(2), René Schulte(2), David Anson, Ning Zhang, Jeff Prosise, Antoni Dol, nmarun, Deborah Kurata(2), and Fredrik Normén. Shoutouts: John Papa announced the availability of his "What's new in Silverlight 4" whitepaper: What’s New in Silverlight 4 – Download and Run! The Expression Team Blog has a post up about Expression Blend: What's new Koen Zwikstra is reacting to Silverlight 4B along with everyone else with a Document Toolkit Roadmap Check out Pete Blois' ...
I am a huge fan of code reuse, as any good developer would be, but there it the tendency at times to write "near-duplicated" code. Near-duplicated code is when you have a function, like a database save or delete, that is rewritten multiple times, but with small, but seemingly important differences. There are many times where those "seemingly important" differences can be easily abstracted away. For example, I can write a Save method in the Entity Framework as follows: 1: public Person SavePerson(Person ...
We are working on a cloud based application for a long time existing customer. we came across a pretty interesting challenge. The problem was; the New cloud based application needed to be able to integrate with our existing legacy applications. in particular our call center application. We have no intentions of moving this application to the cloud, however we need to be able to have access to some of that data with our new Application. Couple of weeks ago At PDC, during the Keynote Andy Lapin of ...
This post touches the ASP.NET MVC async controller. Its included in the futures library and is available on codeplex. This may become part of ASP.NET MVC 2. Download and add reference to the "Microsoft.Web.Mvc" dll. Make the following changes in the Global.asax to set the rounte to handle async request. public static void RegisterRoutes(RouteCollection routes) { routes.IgnoreRoute("{resour... routes.MapAsyncRoute("Defau... "{controller}/{action}/{id}", new { controller = ...
If you google for “SQL Server 2008 Management Studio Express” you will find a MS resource which downloads a 172MB setup. But this setup does not offer a separate “SQL Server 2008 Management Studio Express” option. Why ever. So i startet a new search and i found this solution: Download & install the web platform installer http://www.microsoft.com/we... Start the installer and use the “customize” link in the Database section to activate “SQL Server 2008 Management Studio Express” ...
I, like many developers, was raised on the idea of getting the database complete before writing the code. The database was the foundation of our application, and building a house without a finished foundation is insane. Also, don’t even THINK about changing the foundation once the house-building has begun. If you MUST change the foundation once development has begun, you’d better have a damn good reason. When I started to learn about agile and lean software development, I learned about emergent design. ...
Below is a Microsoft.IdentityModel configuration you might find in a web.config or app.config that hosts websites or webservices that leverage Claims based authentication and authorization. If your requirements require you to do this at runtime at the start of the app you can do the following.... void Application_Start(object sender, EventArgs e) { FederatedAuthentication.Ser... += new EventHandler<ServiceConf... ...
In this all-submittal Issue: ITLackey, AfricanGeek, Yasser Makram, Rob Houweling, James Bacon, Max Paulousky, Andrea Boschin, Andrew Veresov, Michael Washington, Corey Schuman, Mark Tucker, Fons Sonnemans, Pencho Popadiyn Thanks for all the submittals! Very glad *that* holiday is behind us... let's get back to posting! From SilverlightCream.com: Silverlight Metronome ITLackey has built a very cool Silverlight metronome with lots of features. If you're a musician, bonus! If you're not a musician think ...
Soo… Long time no write… A quick project was assigned to me and two other guys at work the other week – one of those quick 2-3 day projects, the ones were speed is paramount. Quality can be worked on after release… Sooo.. 3 parts, 3 of us, we split it 3 ways and all was good – one on database duty (using LINQ to SQL), one on UI (Adobe Flash 10) and me, on WCF service… All was going well, the database was up and running, I was using the libraries to interact it with it without any problems, then we ...
Welcome to eBoard Hello and welcome to this series of application development using asp.net mvc, jquery, automapper, ninject. Though the world doesn't need another blog engine, but sometimes reinventing the wheel teaches you many unknown things and it's the learning experinece that counts more than anything else. I have been using asp.net mvc + jquery for about a year now. So, it's time to put down something which will help the beginner with this technologies get a good graps of the fundamentals ...
We look to learn the Silverlight, WPF and ASP.NET MVC 2 over the next few months. We’ll start developing a data driven application to explore each one of these. I am now in the process of finding a sample database for use. We will start our tutorials from next week. Stay tuned until then. Technorati Tags: ASP.NET,MVC,Silverlight,WPF ...
[I haven’t done QandAs for a long while – very remiss of me.] Anyway, I have been asked this one so many times lately that I felt a more public answer was needed. The short answer is: Mostly. Certainly it is good enough to get work done. The longer answer is below… History In the first version of Entity Framework (which came with .NET Framework 3.5 SP1), the Entity Framework Designer was… bad. I mean very bad. I mean dumbly bad. We had a decent enough runtime but the design surface just wasn’t up ...
[This is the fourth in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009).] Complex Types make it easier to work with objects, allowing the grouping of related properties in Entities and the reuse of these groupings across Entities. The first release of Entity Framework included Complex Type support but did not expose this capability through the Entity Data Model Designer. The good ...
Two areas I am looking at right now are SQL Azure and Entity Framework 4. PDC had plenty of content on both these areas. Just need to find the time to watch some of it! I have added direct links to the standard definition WMV and the PPTs to download (which is what I am doing right now). SQL Azure SQL Azure Database: Present and Future Windows Media Video PPT Using the Microsoft Sync Framework to Connect Apps to the Cloud Windows Media Video PPT The Future of Database Development with SQL Azure Windows ...
When you have command line arguments to parse (whether on Windows or Linux), the place to look is Mono.Options. To date, I have not found anything better to get the job done. It is a single C# file if you do not want to download the entire Mono Library to use it. I was first introduced in Mono 2.2. The equivalent product is NDesk.Options by Jonathan Pryor. His single Options.cs file has been implemented as Mono.Options. To demonstrate how easy command line parsing can be, I’m going to show you is ...
[Source: http://geekswithblogs.net/E... Following on from the sample for processing Excel uploads with nServiceBus, I have a comparable version using BizTalk on MSDN Code Gallery here: BizTalk and nServiceBus Excel Upload. The BizTalk (2006 R2) sample uses a FILE receive port with a simple pipeline component to disassemble the Excel file into separate messages. A SQL send port subscribes to the messages, and with an outbound map calls the AdventureWorks stored procedure to insert each product. ...
With the release of Windows 2008 R2, highly available Hyper V deployments have increased in popularity. One of the big questions during these deployments is what to virtualize and what to leave on physical hardware and in particular when it refers to domain controllers. Domain controllers are basically highly transactional database servers which service most basic network functions including authentication, name resolution, replication, and of course many secondary services like DHCP or Radius. In ...
I own a company, Tiger Computer Services Ltd, which is an Independent Software Vendor (ISV) providing .NET software solutions to clients in the London area. One of the most significant considerations when running a small ISV is the cost of supporting software in the field. For some clients, support is not a billable item, especially if the fault is within the software we have provided. This means that every time the telephone rings, we bleed money, and if we have to actually go on site to resolve ...
There is a small configuration issue with the Microsoft Business Rules Composer in BizTalk Server 2009. This will only affect you if you deploy the rules engine by itself without the rest of BizTalk Server. In a full installation of BizTalk Server, BTS provides a set of BTS-specific Rule Framework components in as assembly called Microsoft.BizTalk.RuleEngin... This includes a RuleSetDeploymentDriver component that manages deployment of rules via the SQL Server repository. The BTS-specific ...
We used MsTest framework for a project that mainly had integration tests for Wcf Services, and found particularly useful to use AssemblyInitialise method to start the services hosts before all the tests are run and AssemblyCleanup to stop all the hosts after all the tests in the assembly have run. At some point, the company decided they would like to change this project to use NUnit instead of MsTest (for sake of uniformity, as all thi other project were using NUnit). The only problem that I saw ...
Versioning your database is as important as versioning your code. How much time do we waste currently before we are even productive when we have to fix or enhance something in a database? RoundhousE versions your database how you want. The recommended way is to version based on source control, but that may not be your solution. But for a moment let’s pretend it is. Why would versioning your database based on source control be a big help? What happens if you get a prod fix (or work order) to fix a ...
The DotNetNuke web hosters at PowerDNN have put together a nice 3 minute survey to analyze your needs on what version of DotNetNuke that you might need to have. The survey has 3 categories. 1. Website Size 2. Website Usage 3. Project Details With an easy UI of drop down lists, you just answer the questions listed in each category and then submit them to the site. After you submit, you'll get reasons why you should use either the Community or Professional Edition of DotNetNuke. Here's an example of ...
Today I had a twittersation about build servers, and how closely they should match the development and production environments. Damian’s position was that the build server should match the development environment, while I held that the build environment should be as close to production as possible. Martin Fowler’s Continuous Integration article says: Test in a Clone of the Production Environment The point of testing is to flush out, under controlled conditions, any problem that the system will have ...
When an itinerary is created using the itinerary designer you can deploy the Itinerary in different ways. Listed some of them and also I created a app which is basically derived from ESBImportUtil to do the deployment : ESBImportUtil.exe You can use ESBImportUtil.exe utility located at C:\Program Files\Microsoft BizTalk ESB Toolkit 2.0\Bin. Ex: ESBImportUtil.exe /f: onewayitinerary.xml /c: deployed /o Power Shell Script Check out the Itinerary sample in the C:\projects\microsoft.pract... ...