Tag | Database Posts

With all the noise (not to mention the funk) around HTML 5 and Silverlight at PDC 2010, we could be forgiven for missing the numerous keynote announcements about Windows Azure and SQL Azure. And with all those announcements, we could be forgiven for missing the ostensibly more arcane stuff in the breakout sessions. But one of those sessions covered material that was very important. That session was Lev Novik’s “Building Scale-out Database Applications with SQL Azure,” and given the generic title, ...
Step 1: Download CouchDB on your Android phone from Android Market Place: info available at: http://www.couchone.com/and... Step 2: Download CouchDB on your Windows machine info available at: http://www.couchone.com/get... Download link: http://dl.couchone.com/dl/6... after unzip, it looks like this: Step 3: Check IP of your Windows machine Note: Your Android phone and Windows machine shall be on the same network ...
I was lucky enough to attend Visual Studio Live! in Orlando on November 14th-17th. There were so many great speakers and the networking was great. I met a lot of really cool people and we talked about everything .NET (from WP7, Silverlight, C#, ASP.NET WebForms, AJAX, MVC 3.. and so forth). I took a lot of notes during all the sessions and wanted to provide it to those that could not come out. If you follow me on Twitter then you have seen most of these. Most of the authors put slides/source code ...
For the past several days I have been working on trying to build a WCF service which returns a list of assertions for a member. Because this information will be handed off to a vendor, I have to meet their requirements for how the SAML will look and be encoded. I am having all sorts of issues getting this to work! I know WCF and WIF together should help me. I had the original service built in under three hours but the encoding did not match the vendor code's expectations. Thus, I am hunting for a ...
In this Issue: Michael Washington, Fons Sonnemans, Jeff Wilcox, Alfred Astort, Den Delimarsky(-2-), Peter Bromberg, Sigurd Snørteland, and Xpert360(-2-, -3-). Above the Fold: Silverlight: "Silverlight Super Tabs Interface (using View Model / MVVM)" Michael Washington WP7: "WP7 Panorama: Smoothly fading the background (and enabling fading when changing, too)" Jeff Wilcox Shoutouts: With all the phones out there right now, how about a review of one from a WP7 author: Review of my Windows Phone 7 (HTC ...
First, some background information: I have some javascript that requires data from the database to set values so I dynamically generate the script on the server via an action in my controller. I only want to do this generation when the partial view using it is dispalyed. So here is the problem: You have javascript you only want to load when a certain partial view is displayed. Depending on the state of data in the database, the partial view might load on page load or it might only load after an MVC ...
Readers of my blog and/or column know that I am a big fan of PowerPivot. And because of that, I was excited to see, both at June’s Microsoft BI Conference (part of Tech Ed) and this week’s PASS Summit, that the PowerPivot technology will become more entrenched. What Microsoft showed in June was that the full-fledged SQL Server Analysis Services (SSAS) product would support the in-memory BI (IMBI) engine, known within Microsoft as VertiPaq. This cool columnar, in-memory technology will not be limited ...
The code samples in Microsoft All-In-One Code Framework are updated on 2010-10-10. Download address: http://1code.codeplex.com/r... If it’s the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on YouTube http://www.youtube.com/watc... or read the introduction on our homepage http://1code.codeplex.com/, and this Port25 article http://port25.technet.com/a... ...
I want to introduce a new tool that can bring a huge change to your life by upgrading your Client/Server applications to a Web or Cloud based environment. Most of us are intimidated even by the thought of migrating a large, mission critical application to any technology. If it ain't broken why fix it, right?! However, Visual WebGui is a unique platform that its architecture allows to convert .NET applications to ASP.NET VWG based Web and Cloud (SaaS) in a simple path and practically no risks since ...
Recently I have been given a short term assignment to develop a number of reports in Crystal Reports. Upon arriving to the client location I quickly found out that the only tool I will be using to create the reports is basically the Crystal Reports itself. My initial look at the database quickly revealed that the database structure is far from perfect and that it has some confusing table relationships, another hurdle was in the fact that several columns in various tables were user customizable for ...
It's past the first of November, and time to recognize devs that have a large number of posts in Silverlight Cream. Ground Rules Only posts that go in the database are included The author has to appear in SC at least 4 of the 6 months considered I averaged the monthly posts and am only showing Authors with an average greater than 1. Here are the Top Posted Authors at Silverlight Cream for May 1, 2010 through October 31, 2010: It is my intention to post a new list sometime shortly after the 1st of ...
I recently migrated my dev environment to a new pc. I moved over all the databases and reattached them. Unfortunately, I soon discovered my SSBS services weren’t working. I was sending messages to my service, but nothing was showing up in the queue. I added logging and monitoring to the stored procs that act as an entry point to the services, and the stored procs I use for activation. Still, nothing. When I ran the Broker Server Diagnostic tool (ssbdiagnose) (available in {Program files}\Microsoft ...
In this Issue: Michael Washington, Sigurd Snørteland, Mark Monster, David Anson, Jesse Liberty(-2-), Mike Taulty(-2-), Brad Tutterow(-2-, -3-, -4-). Above the Fold: Silverlight: "Silverlight Attendance Demo using Sterling Silverlight Database" Michael Washington WP7: "How I made the ‘myChannel9' wp7 app (source code included) – Part 1" Sigurd Snørteland From SilverlightCream.com: Silverlight Attendance Demo using Sterling Silverlight Database Michael Washington has a great tutorial up on Code Project ...
It's been a ride! Over six months ago Scott Klein and I started to write a book on SQL Azure. It is now officially out and available. You can find the book on Amazon here: http://www.amazon.com/Pro-S... We used and abused SQL Azure for a few months, used it in projects and pushed some of its limits to understand how it behaves. We present the basics of SQL Azure on a couple of chapters, including what the ...
If you need Logging in your application and Log4Net is not an option (for whatever reason), then the "Logging Application Block" that is part of the Microsoft Enterprise Library may be a good choice. I will look at Enterprise Library Version 4.1 - October 2008, which is available for download here, because is supports Windows Server 2003. If you are not already familiar with the concepts of logging, i recomend to read this rather technical blog-entry "Log Event to Listener Routing in Enterprise Library". ...
Corporations are increasingly relying on data analysis and reporting to improve the overall nature of the business. This is often referred to as Business Intelligence (BI). Bottom line…. It's all about information or data! As a result, data mining and warehousing becomes very important in order to effectively manage and analyze information. Database management is not a trivial task. As business grows, the need for data storage tend to increase. Sometimes, companies end up supporting multiple database ...
Form Based Authentication (FBA) is great when exposing SharePoint on the internet or extranet, users don’t have to know the domain they are authenticating to, you can manage the authentication using LDAP or SQL database amongst other cool stuff. But during the configuration process you end-up disabling the Integrated Windows Authentication (IWA) because you want your users to be provided with an FBA page. Once you disable the IWA you get the following notification If Windows authentication is not ...
Let’s say you added a table to the database created in the previous post, with a foreign key relationship to the original table, like this: The idea here is that you can have multiple rows in NestedData for each single row in TestData. If you create a stored procedure (call it Get_NestedData) with the following select statement: select TestData.TestDataId, StringColumn, IntColumn, Notes from TestData left outer join NestedData on TestData.TestDataId = NestedData.TestDataId where TestDataId = @TestDataId ...
In this Issue: Sigurd Snørteland, Colin Eberhardt, Andrea Boschin, Jesse Liberty, Shawn Wildermuth, Andrew Tokeley, Jeff Blankenburg(-2-), Kunal Chowdhury(-2-), and Martin Krüger. Above the Fold: Silverlight: "Better Silverlight 4.0 Installation and Upgrade Experience" Andrew Tokeley "Developing a Lookless Silverlight Gauge Control (part 2)" Colin Eberhardt WP7: "31 Days of Windows Phone | Day #21: Silverlight Toolkit for Windows Phone" Jeff Blankenburg Lightswitch: "Beginners Guide to Visual Studio ...
*Moved to: TFS 2010 Work Item Seed: TFS Work Item system.id at a predefined numberThis week my customer had a requirement to have all new work items created to have an ID greater than 40,000. They have another system that stores tickets and they don’t want any conflict. There have been a number of ways to achieve this through a database change, but it is not supported by Microsoft. This means that if you make the change and mess it up you are on your own. Read more...Follow my new blog on http://blog.hinshelwood.com ...
Today (20th Oct 2010) I delivered a 90min session to architect on the Windows Azure Platform. Are you an ISV? ISV = Independent Software Vendors - that is you write some kind of product that you sell to more than one customer. My new team is all about helping ISVs and we have a team blog and brand new twitter account which I will increasingly be found on. If you are an ISV, please fave the blog and follow the twitter account. And if you are an ISV please keep an eye on (and sign up to) http://bit.ly/ukmprhome, ...
I ran into a real head scratcher this week. While migrating a very public folder dependant organization, I couldn’t access public folders through OWA. I had full public folder functionality in the Outlook client, only OWA was affected. The environment was still in a hybrid state with production Exchange 2003 servers in the organization as well as DR servers which were using a third party replication package. The exact error I was getting looked like this: I had already established all 2010 and 2003 ...
I've spent time the last few month checking out much of the latest in code generation tools. Again one of the most complete and comprehensive is Iron Speed Designer - now in version 7.1. I had the good fortune to talk for about a half hour with Alan Fisher of Iron Speed and I will be adding content here in the next weeks. Hopefully I can also present some examples. Here's the lastest from their press release. For Immediate Release Iron Speed,Inc. Sephorah Green 408.228.3429 sgreen@ironspeed.com http://www.ironspeed.com ...
This is a basic tutorial for using a stored procedure via a WCF-SQL adapter in BizTalk. It's similar to the examples given in the SDK, but eliminates all the extra garbage of creating custom C# assemblies, enabling the SQL FILESTREAM, etc. You'll need to make sure both the LOB SDK and the Adapter Pack are installed before beginning. First, create a test database call WCFSQLTest, then create a table and a stored proc, using the following scripts: CREATE TABLE [dbo].[TestData]( [TestDataId] [int] IDENTITY(1,1) ...
WebMatrix is a free “one stop shop” supporting all developers’ needs when creating web sites based on standard markup technologies (HTML, CSS, Javascript and jQuery). WebMatrix features an intuitive user interface to help minimize the learning curve and ease navigation and access to all application features. For instance, on startup WebMatrix enables the user to select of the following: 1-Existing sites created in WebMatrix 2-Obtain a site from one of the open source packages through Web Platform ...
DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements DDL DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements DCL DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control ...
In this Issue: Dennis Doomen(-2-), Felix Corke, Kunal Chowdhury, Michael Bach, Jeff Blankenburg, Shawn Wildermuth(-2-), Jeff Handley, David Anson, and Colin Eberhardt. Above the Fold: Silverlight: "Silverlight as an alternative to PowerPoint" Colin Eberhardt WP7: "Architecting WP7 - Part 1 of 10: Navigation Framework" Shawn Wildermuth Themes: "Silverlight 4 theme brush packs" Felix Corke Shoutouts: Robby Ingebretsen never wastes our time, so check out his latest post: The New “App” Sara Summers has ...
Entity Framework 4 Code First CTP4 was released in July and the API for developing without any edmx continues to mature and get better. Code First allows you to define your entity framework configuration with a Fluent API similar to Fluent NHibernate. Although the API for EF Code First is very user friendly, you should still have integration tests to verify that you’ve configured your entities correctly. This post will walk through configuring EF4 Code First optimistic concurrency. Suppose I have ...
As I mentioned in my last post I talked some about how my side project, PiX Eyewear, has given me an opportunity to venture out of the predominantly server-side .NET programming that I’ve been doing at my “day job” for the past several years. In this post I’ll be digging into a simple way that I’ve been able to leverage jQuery to solve a little problem I had with my Shopify site. Before I go any further I want to call out an excellent approach for displaying “related products” on a product page that ...
I am honored to start the series of short Blend lessons for the North Texas Silverlight User Group (http://www.ntsilverlight.com ) on October 11th. The first topic will be handling the Grid with Expression Blend. Join us next month for fun with the pathlist box. Today let’s get started with Grids. Put a grid on the canvas and set it to auto width and height by using the set to auto arrow. Also set the vertical and horizontal alignment to stretch. If you mouse over the top or side bar, you will see ...
Thanks to all those who attended my session Retrofit WebForms with ASP.NET MVC at the Richmond Code Camp 2010.2. To be honest, it was my very first time speaking at a big event like this and I was quite nervous during it. I realized after the demo that I went through the topics quite faster than I should. Nonetheless, I hope my session was helpful and you learned something from it. Thank you all for asking very good questions so I can improve my presentation for next time. Please let me know if you ...
I was looking for a simple way to schedule a job to perform a nightly backup of the production system and restore it to a dev system. I know there are many ways of achieving my goal and I am sure my solution will be frowned upon by some (if not all J) but it works for me so I thought I would share my experience with others. For my scenario the requirement was quite straightforward. Backup a single 5GB database then restore to an existing dev system (over writing the existing dev system). This article ...
With most of our systems pre-configured with SQL server, it was only today that I ran into this issue with my fresh installation instance of SQL Server 2008 R2. I had just created a new SandBox DB to experiment with some aspects of Entity Framework 4.0, but as I was saving foreign key changes to tables I had already created I got the following error: Figure 1 - Unable to save table schema changes error With some research, I found my answer in SQL Books Online: Any Schema changes made to a table would ...
In this Issue: Khawar Yunus, Ning Zhang(-2-), blender, Michael Crump, and Jeff Blankenburg(-2-). Above the Fold: Silverlight: "Silverlight Animation Class Diagram" Ning Zhang WP7: "Windows Phone 7 Design Templates" blender Shoutouts: The McObject folks have posted an update to Perst, including very nice pricing for WP7 folks: McObject’s New Perst Embedded Database Licensing Promotes Silverlight & Windows Phone 7 Development A short list today because I need to post a couple of these and I need ...
Yesterday (5th Oct 2010) I delivered a short (45mins) session on the Windows Azure Platform. Big thanks to all who made it to the far side of beyond in London to attend the afternoon session. I think the event turned out rather well with my old team doing a top job as always – ably supported by our CEO Steve Ballmer doing the keynote :-). For folks wondering, Martin Beeby (IE9) is one of the two chaps that took my old role when I moved to the ISV team in August. Are you an ISV? Speaking of ISVs (Independent ...
In my last blog, I wrote about developers should remain focused on the business instead of database design to dictate application architecture. Some recent events have prompted me to cover similar topic in relation to Business Analysts. Some Business Analysts seem to feel very strongly about getting access to production databases in order to come up with business requirement documents. I can't imagine data scattered in one or more databases is a determining factor for business requirements. I feel ...
One of the most intriguing topics in computer security is defense in depth. This basically means having many layers to security. Think about the walls and defenses in a medieval castle. An intruder has to storm each of the outer walls before they could get access to the castle. This is the same logic that leads to system designs with firewalls, intrusion detection systems, demilitarized zones, etc. The idea is that if one layer is breached then other layer may catch and stop the intrusion. More likely, ...
It is that time of the year again! No not all you can eat at IHop! I am talking about Houston Techfest 2010 on October 9th 2010 at University of Houston. I have to admit that I have attended all the Techfest events in Houston and every year it gets better and better. If you have not registered then register now using the link below: Register for Houston Techfest 2010 I am presenting two topics at Techfest and here are the details of the sessions: NOSQL Using MongoDb In this session Mohammad Azam ...
Back in April I began to work with Oracle again after a multiple year absence from doing so. So naturally I decided I would install Oracle on my home system so I could reacquaint myself with it. That proved to be more difficult than I expected. I was able to get Oracle 10g Express downloaded and installed but could not connect to it. So, to save someone else some of the grief I went through let me go through the final sequence of steps that resulted in a solid working Oracle development environment. ...
[Source: http://geekswithblogs.net/E... * This post is pure speculation, not based on any special insider knowledge, so don't get too excited * BizTalk 2010 has RTM'd, and the Developer Edition is now free. It seems an unusual move to give it away, with the price point of other BizTalk licences. Enterprises who actively use BizTalk will have an IT budget that will probably stretch to MSDN subscriptions for their dev team; conversely, SMBs who aren't prepared to spend £500-odd on a Developer ...
It's past the first of October, and time to recognize devs that have a large number of posts in Silverlight Cream. Ground Rules Only posts that go in the database are included The author has to appear in SC at least 4 of the 6 months considered I averaged the monthly posts and am only showing Authors with an average greater than 1. Here are the Top Posted Authors at Silverlight Cream for April 1, 2010 through September 30, 2010: It is my intention to post a new list sometime shortly after the 1st ...
We came across a bug in SharePoint 2007 backup/ restore or may SharePoint as a whole. I have been working in a project where we have site migrations and lot of other SharePoint stuffs to migrate and change to fit into the new system. What we do is, take backup, restore and do some stuff after restoration. We were getting an error while restoring a site in a particular list - Exception - Error: Exception from HRESULT: 0x80040E2F at Microsoft.SharePoint.Librar... bstrUrl, ...
Here’s how we migrated our TFS 2008 to TFS 2010. This is not an in-place migration. What is generally recommended as upgrade path is to backup the TFS 2008 DBs, restore them in the new TFS data tier and then install TFS 2010. This will migrate all the projects at once. However, we wanted to keep the TFS 2008 environment running for a while, so this path did not do. We first set up a new machine (and a new domain, but that is a whole other story) with TFS 2010 and WSS 3.0. The database tier was on ...
[Source: http://geekswithblogs.net/E... I've had a need on a couple of projects for a monitoring system to record progress of a long-running transaction. Enter Heartbeat - a library which does just that. It's a project of mine on github: Heartbeat progress monitor. The typical use-case is for monitoring a lengthy batch load, where Heartbeat will record progress at set intervals. The intervals can be time-based, or progress-based or both - so you can have an overnight process which writes ...
One of the things I really wanted to do lately was to get SQL Azure, OData, and Windows Phone 7 working together; in essence, expose SQL Azure data using the OData protocol and consume that data on a Windows Mobile Phone 7 device. This blog will explain how to do just that. This example is also in our SQL Azure book in a bit more detail, but with the push for WP7 I thought I'd give a sneak-peak here. You will first need to download and install a couple of things, the first of which is the OData client ...
It's hard to imagine a large scale application without a database. Quite often, an application is not only dependent on databases native to itself; but also to other databases within an organization. It is not uncommon to see developers getting too focused on the database design and changes when it comes to application architecture. Database design is important; however, it should not be the determining factor for the application architecture. Developers should not deviate from the needs, the rules ...
If you plan to compare a database project to a target database on a recurring basis, you can add the schema comparison to your database project. You can then re-compare the schemas by re-opening that comparison. By saving a schema comparison, you save connection information, session-specific options, and values for SQLCMD variables. Results are not saved, and they will be re-generated when you open the .scmp file for the saved schema comparison. To set this feature, go to "How to: Compare Database ...
By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables. When you attempt to do so, it wants you to drop and re-create the table. You will typically see a dialog similar to the following: However, SSMS will actually let you perform such a change without have to drop the table and re-create it. To enable this feature, you need to select Tools / Options from the Menu. Then, navigate to Designers / Table and Database Designers and uncheck the option ...
A customer of mine for years has been using a very expensive bit of labelling software to produce pallet labels. I’ve made use of this software invoking it from the command line to print labels from a windows service that polls a database table of print jobs. This has worked very nicely, in that all the web-services for my mobile application need to-do is drop a description of what label needs to be produced and what printer to send it to into a row in a database table, and my service does the rest. ...
Problem As the DBA, you need to determine if there are any databases in your production environment which have not had a full backup in the last 24 hours. In this tip we cover the step by step process for setting up a policy to identify all the databases which are not backed up in the last 24 hours. Solution Database Administrators can use Policy Based Management (PBM) to identify databases which have not backed up in the last 24 hours. You can follow the below steps to create and evaluate the policy. ...