Tag | Database Posts

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... ...
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 a huge fan of NHibernate. It has excellent documentation and just makes the whole job of getting things into and out of the database much more enjoyable. There is a whole series of posts on NHibernate from one of the committers, Ayende. When Fluent NHibernate (FNH) came out, it was like butter on sliced bread. FNH makes it even easier to use NHibernate. Ayende had a post a while back on how to use Event Listeners. That helped me to get to event listeners set up. Event Listeners namespace somethingimportant.we.hope.... ...
This series of posts discusses the use of an Aspect-oriented programming approach for implementing the validation part of a business domain, using the ValidationAspects aspect library, that sits on top of the PostSharp aspect weaver and allows for placing Design by Contract - style attributes on properties and method arguments, as well as for easy runtime validation of an object's state. This is the second post of a three-part series that discusses the use of these validation aspects throughout the ...
[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 ...
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 ...
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: ...
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 ...
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 ...
Recently after deploying a highly available Exchange 2007 solution for a customer, I had to test recovery procedures and create a recovery document. Since I was already documenting my steps, I figured I’d share them here as well. NOTE: This environment consists of a CCR mailbox cluster and a MS NLB cluster with the Hub Transport and Client Access Roles at the production site. The DR site has a server containing the mailbox role and an a server with the Hub Transport and Client Access Roles. 1. First ...
November Event: Highlights from the PASS Summit Michael DeFehr, Protegra The annual summit for the Professional Association for SQL Server was held in Seattle in the first week of November. With over 160 sessions, thousands of attendees and dozens of SQL server MVPs, it was a huge success and the information exchange was high-bandwidth to say the least. Mike DeFehr attended the event and is attempting to recover by attending another conference this week. He will be back in town and mostly recovered ...
When I started using SQLExpress 2005, everything works on my development machine – however when I wanted to access the database from another machine (trying to access the sqlexpress database remotely) I was not successful. I discovered the solution way back then, also through Google searches, which still yield a valid result. However, every now and then my peers would ask me this same question again. Thus I’m creating this blog so I can forward them to this page (instead of talking about it); it’ll ...
This text is based on the Chris Pels video and code located here. ASP.NET Membership mechanism allows to use the build-in server tables to store and retrieve user data. By default, this mechanism can only be used with SQL Server database to which Microsoft provides suitable MembershipProvider class. Inheriting from this abstract class, developer can use his own table(-es) from any database and use any database engine other than SQL Server, like Oracle, DB2 etc. In this article I would like to show, ...
As I am digging more into SQL Azure, it seems choices for auditing will become a little bit more restricted. Generally speaking there are four ways to audit SQL Server statements; these mechanisms are used by various software vendors to deliver auditing capabilities for compliance mandates and for security reviews. However as we will see, many of the products will stop from working for SQL Azure due to some limitations imposed by the database. At a high level, the four auditing mechanisms are: Server-side ...
I thought it would be useful (at least to me!) to summarise the new stuff in Entity Framework 4 given it actually comes in 2 parts. The list is a simplified and categorised version of this and this. General Foreign Keys now added: EF 4 now includes a new type of associations (Foreign Key Associations) that allow you to have Foreign Key properties on your entities. They are the default although the EF v1 Independent Associations remain. Lazy Loading on by Default in new Models: Also name change from ...
I am currently sitting in a seminar on BI in the Cloud by John Welch at the PASS Summit 2009. SQL Server Azure looks promising for a variety of applications. Currently it only supports SQL Server relational database services but future plans to include the BI stack of SQL Server. I have yet to see how loading of data is handled and security is handled but it seems to have a lot of potential for small data sets (< 10 GB). Couple of points: Apparently data manipulation is slower than normal SQL ...
If you have been using the SQL Azure Portal for creating SQL Databases and connecting to them from your SQL Server Management Studio, you would have realized the ability to query the Azure Cloud Databases from within the management studio. While this provides great opportunities in terms of relation capabilities and accessibility over the Cloud, there has been a recent upgrade to SQL Azure and in that process there has been a Firewall Support added to the SQL Azure Portal access. Specifically when ...
I stumbled across a recently released collection of guidance and best practices for SharePoint DBAs and those who love them. From the download page… “ This book is a guide for database administrators who implement or maintain Microsoft Office SharePoint Server 2007. It provides guidelines for improving the performance of Office SharePoint Server 2007 solutions that run on Microsoft SQL Server 2008…” Get it here in either doc or pdf formats ...
I'm dealing with this custom database where an attribute for an authorization can store many things (amount approved, flags, yes/no, etc.) For the attribute that store the amount approved, I have a job that starts off periodically to put a TermDate on it based on some business rules. I had an expression like this in the where clause: CONVERT(MONEY, @value, 1) > 10000 simply because @value comes in as a VARCHAR field. This fails, which I can understand. it's doing a table scan and failed when converting ...
Presenters: Simon Skaria and Umesh Unnikrishnan This was my second session during the week. It was one in which my hopes were that they would talk about the deployment differences that SharePoint 2010 would have over 2007. I was not disappointed. So to sum it up a bit: 2010 has a much more flexible model compared to 2007. Improved security model Claims Based Authorization/SAML Better administration with Central Administration and also PowerShell Service Isolation Now the Services that you deployed ...
I will use the AdventureWorks database to demonstrate how to perform CRUD operations using LINQ. You can use LINQPad (a free tool) to execute your C# statements without going through the hassle of writing a program using Visual Studio 2008. Launch LINQPad, add your SQL Server Connection and select AdventureWorks as the Database. Remember to select C# Statement(s) as the Language Type. Create Record 1: Department newDept = new Department()2: {3: Name = "Consulting",4: GroupName = "Consulting",5: ModifiedDate ...
Back Links LINQ Overview, part zero LINQ Overview, part one (Extension Methods) LINQ Overview, part two (Lambda Expressions) Note: I realize it has been a really long time since I've posted anything. It is both exciting and humbling that I continue to receive such positive feedback on these articles. In fact, that is why I am trying to put in the effort and finish off this series before moving on to more recent topics. This nomad has been on some interesting journeys these past months, and I am really ...
For those of you who missed the chat today, here is the raw transcript. By raw, I mean that I copied and pasted the discussion without any edits. This is divided into two parts, the top part is the answers from the Microsoft Experts and the bottom part is the discuss (questions) from the audience. Answers from Microsoft: KarelD_MSFT (Expert)[2009-10-27 11:58]: Karel Danihelka - Developer in Partner Response Team. davbo_msft (Moderator)[2009-10-27 11:59]: Our chat today covers the topic of Windows ...
As an ASP.NET developer we frequently deal with long running tasks for example: Making long-lasting webservice calls. Making prolonged calls to database that runs complex queries. Do lengthy file operation Calling remote objects etc. When the server is busy performing the lengthy time consuming task/tasks, the poor user has to wait for the response. The most common technique used to interact with user is to display a loader icon or show some kind of progress bar on the page until the task is complete. ...
for the ado database sync, the method public virtual SyncContext ApplyChanges(SyncGroupMetadata groupMetadata, DataSet dataSet,SyncSession syncSession) on server side is not efficient, as it receive the changed data from client side, but it again sent it back to client within the SyncContext. In the returned SyncContext object, I found DataSet and GroupProgress.Changes is almost the same as input dataset. by verifying the code inside sync framework, I found: internal SyncGroupMetadata ResetProivderState(SyncGrou... ...
Visual Studio 2010 Beta 2 is out and has a slick new UI. Also, this Beta has most of the features that would ship with the final version compared to the earlier Beta. Note that while new features might be added, there are chances that some of the features demonstrated here may also not be a part of the final release. But, for now, lets examine the current Beta 2. The first thing you would notice and probably like, is the UI enhancements. Herebelow, is the launch screen. Also, the start page has been ...
Day 2 of the SharePoint Conference has just about come and gone, and I’ve shifted my focus from yesterday’s pure developer angle to topics of data and business intelligence. And there has been a lot to see. I’m sitting in the last session of the day, attending the “Business Intelligence Power Hour” and began the day with an in-depth look at SharePoint’s Business Connectivity Services (BCS, formerly known as the Business Data Catalog, or BDC). I work very closely with Microsoft Business Intelligence ...
When one of our users attempted to synchronize a Windows Mobile 6.1 device in our Exchange 2003 SP2 environment, the user would get the following error message on their mobile device. Result: ActiveSync encountered a problem on the server. Support code: 0x85010014 Last synchronized: None Last attempt: Today: 9:16 AM In a nutshell, we use ISA Servers and Exchange 2003 Front-End servers in our Exchange ActiveSync environment. So, when the user would synchronize their device, the user would get the ...
http://itunes.apple.com/Web... I'm very proud to have had my first iPhone app posted to the Apple Store today. iCountCalories is a calorie tracking tool that I wrote for myself while in the process of losing 55lbs. I'm not expecting it to sail to #1 but hopefully some people find the application as useful as I did while developing it. Additionally I hope i can get some good feedback so that I can improve it and make it even more useful! Current ...
Recently I attended the Business Analysis Conference in London that I spoke about in my previous post. My reason for being there was I accepted an invite to be a speaker on a panel discussing “The Role Of The BA: What Is Expected And What Is Delivered” Part of the Business Analysts role is to capture, distil and communicate business requirement to Technical staff so it was of great relevance that I played my part as the technical representative on the panel. If technical staff are to understand business ...
I have been working on database synchronization for a couple of weeks, and seems it at the final testing stage, I am using Microsoft Sync Framework 2.0, the DB server is SQL server 2008 Standard, and clients are SQL Server 2008 Express as I use Change Tracking to track DB changes instead of TombStone Tables and Guid tracking columns, I use WCF+IIS+SSL to host server side service, the binding uses Gzip binary encoding. The reason we are not using SQL Server Replication is because our tables need dynamic ...
Recently I had cause to investigate performance and tuning of BizTalk Server 2004, and found that although there was some useful and interesting information available, there was usually little actual guidance on how to apply even the simplest settings to your specific solution/environment. When you take a look at the guidance available for tuning IIS, there are some reasonably simple steps that you can follow to get you started; for example you can make some simple changes to machine.config based ...
I won’t complain, because it is free… But (expletive here)… My Particular Experience was with IIS on Windows Server 2008, but the experience should be about the same for XP, Vista, Server 2003, and 2008. The Apache configuration appears to be well documented in the Win32Install directions https://wiki.mozilla.org/Bu... If you’ve installed any open-source software before some of the steps for bugzilla may already be done so I’ll outline the steps and you can skip any ...
I started to look into SQL Azure, the database cloud computing initiative from Microsoft, and I was completely blown away. Microsoft is providing an interesting option that strikes an interesting balance between a plain-old RDBMS implementation and a scalable platform. By definition, relational databases have difficulty scaling due to the many features and constraints that make them popular. However, SQL Azure removes some of those features in order to provide a more scalable SQL Server, while keeping ...
I delivered a session on Windows Azure Storage and SQL Azure Database at the UK Azure user group on the 6th of October. A big thanks to everyone who attended – and for putting up with my last minute improvisation when we realised that 2/3rd of the audience were actually brand new to Windows Azure (and presumably therefore brand new to the user group) Links: www.azure.com Main site and where you register to get tokens. Remember you need separate tokens for Windows Azure and SQL Azure. Or… a more streamlined ...
In this Issue: Gavin Wignall, Manish Dalal, Jeff Wilcox, Terence Tsang, and Mark Tucker . Shoutouts: Rishi, the author of nRoute had to move his site. Last night I transitioned all his links in the database to point to the new site, so feel free to re-acquaint youself with his posts. András Velvárt has another thought and comment-provoking post up Silverlight is slowly becoming the real WPF/Everywhere ... check it out and join in the discussion! Particularly if you have a touch system, check out ...
Every now and again you may come across an error when trying to update a database from a data driven control (i.e. gridview, formview) that is tied to a SQL or Object data source. The errors usually are along the lines of “Could not find xxx that has parameters” along with a list of those parameters. Or an error that states there are too many parameters being passed. Aside from looking for typos, counting or lining up the parameters I will use one of these techniques to try and narrow down what may ...
Yes, I know, the multiple file uploading in ASP.NET issue has been exhaustively covered already elsewhere. There are examples of multiple file uploading using ASP.NET user controls, there are examples using jQuery, there are examples using flash to provide progress feedback, and even examples in Silverlight. However, what I wanted was a simple solution which allows the user to select a variable number of files, didn’t rely on postbacks in order to increase or decrease the number of files selected, ...
Here’s a great list of new Azure and cloud related projects on CodePlex. All of these are very helpful tools. Client Cloud Services, Client Cloud Services (CCS) is a set of Windows Azure-based services which help application developers integrate licensing, trial management, feedback, error reporting and product usage into their applications Azure Storage Manager, Azure Storage Manager helps you organize your Azure Storage Accounts and to modify data on them. It is written in C# 3.5 and has no other ...
Sure many sharepoint Admin/ Developers/Architects must have come across this issue when trying to uninstall and re- install Sharepoint 2007. I have uninstalled sharepoint instance before just by going to the Add Remove programs and it was a breeze. But on my Dev server when i tried the same but nothing basically happened. The status bar did show as if it was uninstalled but when i go back and check nothing was removed :( I later found this which did help :www.howtonetworking.com/ms... ...
If you like to migrate your Web tier or the ASP.NET Application to Windows Azure, check my new posts Part I and Part II In the previous post we had examined on getting access to SQL Azure, creating your first database, accessing it with SQL Server Management Studio and then migrating the Northwind database schema to SQL Azure using the SQL Azure Migration Wizard Beta. UPDATE: The latest version of SQL Azure Migration Wizard migrates both Data and Schema. You can download the same from http://sqlazuremw.codeplex.... ...
If you like to migrate your Web tier or the ASP.NET Application to Windows Azure, check my new posts Part I and Part II SQL Azure is the latest buzz around Cloud Computing and the ability to take relational database to the cloud as is, is something most would welcome compared to the earlier model of ACE (Authority, Container, Entity) that was there when SQL Azure was SSDS. Well, like others, I also got interested and wanted to explore the SQL Azure. SQL Azure is currently in CTP and offers token ...
I was having in interesting discussion with Yossi Dahan following a recent SBUG meeting, as most user group sessions go the meeting was good but there was also some good discussion in the pub afterwards. Anyway we got onto the subject of caching and BizTalk and we discussed a few things I wrote ages ago about using NCache with BizTalk. As a follow up to this discussion I ran a few tests to get some rough figures to show some of the benefits of caching of data in this context. The previous article ...