Tag | SQL Posts

I have been playing with the WCF RIA Services (erstwhile .NET RIA Services) for sometime and found that most of the samples out there focus on Silverlight based applications. While the new WCF RIA Services preview for VS 2010 is awesome in terms of its Silverlight integration, I also wanted to test out on building plain vanilla ASP.NET Applications and using the power of WCF RIA Services to build a middle tier for the same. Ok, to begin with, I already had Visual Studio 2010 Beta 2 installed and ...
I have recently picked up a copy of Richard Seroter's book "SOA Patterns with BizTalk Server 2009", and thought that I would try and make some useful comments on each chapter as I read it. I am currently working in an environment where we have been implementing BizTalk Solutions as a part of an overall SOA strategy for a number of years, and I am hoping that this book will help me to gain a new perspective on the use of BizTalk in this type of architecture, and hopefully expand my understanding of ...
So you're familiar with TDD (test-driven development)... Failing your tests first, then building up your classes to satisfy your tests so they're all "Green"... This is a typical scenario and is pretty straightfoward with .NET. Well now you have to create a WCF service and implement unit testing to ensure you don't break your service when you build out a new version. This is a bit more challenging but you do have some different options: Separate out your service code into a library and run your tests ...
Technorati Tags: Tutorials Rocky Lhotka is Talking Oslo at ALEMUG At Atlanta Leading Edge Microsoft Users Group Rocky Lhotka spoke about Oslo. Rocky spoke about MCsla, which is the prototype domain specific language and runtime he created for CSLA .NET using the SQL Server Modeling tools. He spoke about designing and defining a DSL with a custom grammar, using the m.exe and mx.exe tools to compile DSL code into instance data, and then defined a schema so that data can be loaded into SQL Server tables. ...
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 ...
Conventinal Way of Searching : When there is a requirement to add a Search feature inside a website to search through knowledge base the first thing that will crack our mind is to add a Free Text Search with some Keywords. If it is a SQL server we will hit a free text query over a specific keyword index else we might lookout for some third party indexing utility like lucene.net to to fetch best matching result for the end user. This is called Keyword Searching. The search key words will be like "CEO ...
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 ...
*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 ...
Microsoft makes an excellent digital music player (the Zune HD), a well-crafted networked storage and backup solution (Windows Home Server), a strong DVR/digital entertainment hub (Windows Media Center) and perhaps the industry leading gaming console (Xbox 360) which itself has a growing number of digital media capabilities. But can they all get along? That was my question almost a year ago, when I returned from the 2009 Consumer Electronics Show, which was riddled with a variety of incompatible, ...
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 ...
News Newell Rubbermaid - Newell Rubbermaid Expects to Save $1.5 Million Managing Brand Web Sites Over Two Years: http://www.microsoft.com/ca... BizTalk Server 2009 R2 Announced at the Microsoft PDC Conference: http://microsoftpdc.com/Ses... Windows AppFabric announced at the Microsoft PDC Conference: http://microsoftpdc.com/Ses... Documents New Features in BizTalk Server 2006 R2 SP1 (pre-release): http://go.microsoft.com/fwl... ...
So I set out on a quest to install a SharePoint 2010 VM with Bob Davis, one of our 101 instructors for SharePoint Saturday Kansas City and a Co-Leader of the KC Office Geeks. We started around 5 pm and ended around 11 pm. Everything that could possible go wrong went wrong in triplicate. Here is a list of things you need to know: Turn on Virtualization in your bios: Bob did not have virtualization turned on in his bios, so the virtual machine I had stubbed out did not work. You need to make sure that ...
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 ...
Lately I’ve been working with EF 4.0 and finding that many of the new features are catching up with the features previously available in other framework like LINQ to SQL. One example of this is the ability to easily attach objects (for example, disconnected objects that come in from another tier). For example, imagine you had a web service where a consumer submitted an object to get saved – you’d want to instantiate a new context, attach the incoming entity, and save the object. In previous versions ...
Part of my current project involves several batch processes that are run after normal working hours. Most of these jobs are doing either one of two things: importing data from a text file or exporting data to a text file. (Since my project is replacing an existing set of applications, we were required to maintain compatibility with the other systems that are sending or receiving data to or from us.) Our data is stored in a typical SQL Server 2005 database. We decided to use .Net based console applications ...

I am typically starting this blog with the "Hello World" kind of post.  Just to give an brief summary to the curious out there this blog will be a place where I will be putting down my experience with technologies specifically asp.net mvc, jquery, sql server, sharepoint, tdd, design patterns et el.

Also, I plan to record my learnings with developing an asp.net mvc project.

 

Background: Out of first few tasks that were assigned to me in my new project, I was asked to help testing team with promoting an existing partially tested BizTalk interface. After little bit of code re-factoring and ensuring that the design has been simplified (removed some unwanted logging etc.), we put code to the test. Functionality wise there were not many issues which surprised us and we quickly got over it. However, it wasn’t for long that we realized that there was some obvious issue hidden ...
Asynchronous statistics auto update in SQL Server would ensure that the statistics are not updated when a query is executed, ensuring timely response. For this option, we need to set AUTO_UPDATE_STATISTICS_ASYNC to ON and also AUTO_UPDATE_STATISTICS to ON. Here, a separate thread runs in the background, which actually does the job of updating the statistics. So updated stats are available the next time for a query. This can also work the way round, meaning that a query might be using old stats and ...
This should work for SQL Server 2005/2008-- ALTER SCHEMA SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName example: ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture ...
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 ...
Interestingly I had two instances last week when I thought different parts of Microsoft were re-inventing the wheel. The first was while listening to Episode 496 of Dot Net Rocks, where they were talking about project Trident from Microsoft Research. My first thought as they were describing the "visual workflows" was that MS Research had re-invented SSIS. Then as they described the versioned catalogue of workflows it sounded more like the way DTS used to store it's packages. But when they started ...
I was asked a little while back to pull together the best training resources for .NET development to feed into a MSDN UK site. I thought it would be useful to share here as well. By no means everything is listed but sometimes less is more :-). Enjoy: Top Tip: Watch out – these are sometimes big downloads. For instance I just downloaded a high def PDC2009 session at 600MB! I recommend you check out Free Download Manager – it is a great open source tool for working with large files. Offline Training ...
En mi trabajo actual casi no utilizo el SQL Manager. Esto debido a que yo sólo me encargo de cosas del front (funcionalidades e interacción con el usuario) y lo referente a bases de datos lo ve otra persona. Estarme alejando de las cuestiones de bases de datos me preocupa un poco porque siento que podría 'oxidarme' en esa área que de por sí no ha sido mi fuerte; sin embargo, hace algún tiempo me dí cuenta de que en realidad la persona que se encarga de bases de datos tampoco le mete mucho la mano ...
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 ...
I had an issue recently with my SSAS 2008 performance counters - they were all showing up as 0. I could see them listed in Performance Monitor, but none of them worked. The counters for my SSAS 2005 instance worked fine, but the 2008 ones did not. I had observed this behaviour on my old Vista x86 machine and now it was happening on a fresh install of Windows 7 x64. I tried numerous steps to troubleshoot this issue including going through this detailed blog post from the CSS SQL Server Engineers blog, ...
[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. ...
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 ...
A big thanks to all those who attended http://edgeug.net/ last night to hear about SQL Azure and SQL Server 2008 R2. I really enjoyed it and once again “Merry Christmas”! Links http://bit.ly/startazure takes you to the getting started page for SQL Azure (and Windows Azure) Download SQL Server Management Studio R2 which works with SQL Azure Brief walkthrough of using SSMS R2 with SQL Azure (nice screenshots similar to what I showed in the first demo) Download the SQL Azure Migration Wizard http://twitter.com/ericnel ...
Last time I was taking a look at SubSonic’s SimpleRepository functionality and wondering about the return value of the ‘Add<T>’ method. More specifically, I was wondering why the ‘object’ instance being returned was typed as a decimal rather than an int when the object I was persisting had a primary key field that is typed as an int. I had discovered that the while Add<T> was returning a decimal, it was also updating the primary key field (PostID on my Post class instance in this case) ...
I’m very excited to see some progress and buzz at Tampa Code Camp since we announced. We are still accepting speaker submissions and we are working having more sessions now. Continue spreading the word in person, online and even in general public too! We can still use your help to reach out to your fellow geeks and let them know about Windows Phone Camp, you never know who is not admitting to be a fan. Don’t believe the hype? At the very least come out and learn about what’s new for yourself. We ...
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-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; ...
Recently my company just released the first version of a new MVC web site: AlbumCredits.com. This project, led by Oskar Austegard, is was I consider a highly successful real-world implementation of MVC. In a time when most music these days is downloaded, the production and performance engineers, and recording professionals that work on the music don’t always get credit because there is no CD booklet to look through. Album Credits is almost like a LinkedIn for recording professionals. From the about ...
Today was the first day of Microsoft's 2009 Professional Developer Conference, and it kicked off with a 2-hour keynote address led by Ray Ozzie. Ozzie enumerated various new features and launch dates for the Windows Azure Platform, including project "Dallas," a platform for open data feeds based on OData, an opened flavor of ADO.NET Data Services/Astoria. Ozzie also brought on customers and partners, including Automatic/WordPress, Kelley Blue Book, Seesmic and even US Federal CIO Vivek Kundra (via ...
Hot on the heels of one CTP (StreamInsight) and timed to coincide with the opening day of the PDC, Microsoft has just released the latest version of the technology formally known as 'Oslo'. SQL Server Modelling, as we must now learn to call it, has several improvements over the previous CTP release last May. Indeed, the previous CTP was characterised by behind-the-scenes code improvements and rewrites rather than new functionality. It is therefore doubly reassuring to see the slew of new features. ...
[This is the first 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). ] When adding an Entity Data Model to a project you are given the option to: Generate the Model from an existing database (SQL Server, Oracle etc) or Start with an Empty Model and create your conceptual model (sometimes referred to as Application Model or Domain Model) first – adding new Entities and Associations ...
My thoughts and observations of this year’s Microsoft PDC conference in LA. Day 1: Just registered for the conference. They had many reps available to move attendees through the registration process. We arrived early, and had to stand in line for 15 minutes, while all the reps stared blankly back at us; “We don’t open until 7.” Wow.. Great Customer Service. Let me take this moment to comment on the Conference bag this year. ITS A CHEAP PIECE OF CRAP. Literally, it looks like a “reusable” grocery ...
DataSet The dataset is a disconnected, in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database. When the use of this DataSet is finished, changes can be made back to the central database for updating. The data in DataSet can be loaded from any valid data source like Microsoft SQL server database, an Oracle database or from a Microsoft ...
OK... particularly fugly code... wow. I'm about 2/3 of the way refactoring this huge beast of an application. I'm pulling SQL out of the code behind and putting it into the database layer. I'm using StringBuilder to avoid the loooooong chained together strings they used. Anything possible, I'm pushing to Oracle. But some of the worst is the client-side code. Multiple times I've found 60 or 80 non-breakable spaces to move something to the right! Data entry forms with 6 rows of data to fill out, and ...
Until recently, Microsoft’s policy toward Its Professional Developers Conference (PDC), was that it should be held only once every two or three years, and should focus on Redmond’s technology “futures.” This meant that currently- or imminently-shipping products were not to merit much coverage; instead, emerging technologies that were at least 18 months away (or thereabouts) from shipping would get the spotlight. Last year, that was mostly true. We got a pre-beta release of Windows 7, saw glimpses ...
I’ve been spending some time lately digging into SubSonic 3 and have really enjoyed working with it so far. I love the how “low friction” it is to get up and running. I’ve been particularly impressed with the SimpleRepository in this regard. It definitely lives up to it’s name by providing truly simple data access functionality in a pretty sane and straightforward way. That said I don’t think it’s the best choice for every project, but if you don’t have to care much about the implementation details ...
This week I introduced RoundhousE and it’s getting quite a stir. Let’s take a look at the configuration. We are going to focus on the MSBuild/NAnt task configuration for now because the console isn’t yet complete. The console will actually have at least this much if not more (we’ve talked about how to use it to create the migration scripts and not just run them). Because we like to be able to infer things, we have determined that there are only two required items. Thus – the minimal configuration: ...
Had a short training on VMWare on Tuesday, the software development department finally got the official permission (read: get a license) to use VMWare Workstation. I’m no stranger to Virtual Machines (VMs) – started playing with Virtual PC 2005 a fwe years back and I understood the general concepts of hardware virtualization. The biggest problem I have with VMs in general is the slowness; I’d rather develop directly on my PC, which is faster. Can’t say I’ve delved deep into it, but I know enough ...
As I mentioned earlier this week, we now have a CTP release of a version of SSMS that is SQL Azure aware. I thought it might be useful to share my first few minutes with it. First up, I cleared out my SQL Azure account using the portal (dropped all my databases). And I made sure the firewall setting would allow me to connect: (for simplicity I just opened up everything. Don’t do that!) Then I downloaded (155MB) SSMS R2 Nov CTP (32bit or 64bit) and installed it: Which gave me a new menu group for ...
I just started the appetites with my last post on RoundhousE. RoundhousE itself has a migration sample to help you get familiar with how it works. You can get to that by using a subversion client to download the source. When you download the RoundhousE source from SVN and run build.bat, you get a code_drop folder. Go in there and look at the deployment folder for a sample run. Prerequisites: Locally installed (and running) SQL Server 2008 Run That Bad Boy When you get into the code_drop folder, take ...
It is Friday 13th Nov 2009 - which means it is the last day of TechEd Europe in Berlin. Overall I have had a good week – high quality sessions, lots of time with customers and colleagues and a very smooth conference throughout. I spent the week doing a bunch of things. 9am Monday I was presenting on Entity Framework 4 after 4 hours of sleep and using a brand new VPC after my original failed to load following yet another blue screen from the host (the machine will be flattened next week – perhaps ...
I like it when Microsoft bridges its technologies out to other platforms. I like the PHP Driver for SQL Server and the samples in the PHP On Windows Training Kit so much that I did a whole session on them at VSLive! last month. The ADO.NET Data Services (Astoria) bridges for PHP and Java are very exciting to me. The Silverlight plug-in for Eclipse, the Azure SDK for Java, and the Windows 7 support for Eclipse are all good stuff. To add to these recent developments, Microsoft has announced its acquisition ...
Thanks to everyone who attended my LINQ to SQL presentation at RockNUG last night. The code samples can be downloaded here: LINQ to SQL demo code. As a point of clarification from last night’s Q&A session after the presentation regarding using LINQ to SQL with true POCO classes that do not even have [Column] mapping attributes, you can have a class like this: 1: public class Contact 2: { 3: public int ID; 4: public string FirstName { get; set; } 5: public string LastName { get; set; } 6: public ...
One of the coolest projects I have been working on is how to solve issues with database versioning and migration. A project dubbed RoundhousE. RoundhousE is an open source automated database deployment (change management) system that allows you to use your current idioms and gain much more. Currently it only supports Microsoft SQL Server, but there are future plans for other databases. It seeks to solve both maintenance concerns and ease of deployment. We follow some of the same idioms as other database ...
I have had a bit of a “SQL Azure” day at TechEd Europe. I sat through David Robinsons excellent intro to SQL Azure development (smooth, on time, great Q&A), caught up with David afterwards to exchange stories on SQL Azure and find out what I will be missing at PDC next week and then grabbed the chance to capture a short 10minute podcast which I will publish up on Channel 9 next week. David did his demos using a new version of SQL Server Management Studio which works with SQL Azure and announced ...