Tag | Database Posts

This blog is the first one of a series of blogs addressing programming practices and lessons learned related to cloud computing. While most developers will be familiar at least conceptually with the techniques exposed, I will provide background information and code samples in an attempt to explain why they are so critical in cloud software development. While most of the information provided will be using Windows Azure and/or SQL Azure, these concepts apply to cloud computing in general. Exponential ...
Looks like bloggers figured out I'd post the submittals first, because today I got hammered with posts. In this 2nd in a row Submittal-only Issue: Alex Golesh(-2-, -3-, -4-, -5-), René Schulte, Alex van Beek, Kunal Chowdhury(-2-), Rudi Grobler. Above the Fold: Silverlight: "Silverlight 5 Multiple Window Support" Kunal Chowdhury WP7: "Augmented Mango - SLARToolkit for Windows Phone" René Schulte WP7: "Windows Phone Mango–What’s New? (“New Sensors & Tooling Enhancements” - Part 3 of 8)" Alex Golesh ...
“Design Patterns 100? is a prerequisite for .NET Developers. (Part 3 – Excerpts from July 2010 – PhillyNJ.NET Presentation) Continuing our discussion from Part-2 we ask. What are the “Gang of Four” (GoF) Creational Patterns and where can we find them in the .NET Framework? Let’s look at a list of the Creational Patterns as defined by the GoF. Abstract Factory Pattern – creates an instance of several families of classes Factory Method Pattern – creates an instance of several derived classes Builder ...
Here are the updated links for quick reference: Windows Phone SDK Beta Download Center: http://go.microsoft.com/?li... Go live license– http://go.microsoft.com/?li... WPDT 7.1 Documentation Windows Phone Developer Tools 7.1 Release Notes: http://go.microsoft.com/fwl... What’s New in Windows Phone Developer Tools: http://go.microsoft.com/fwl... Code Samples for Windows Phone: http://go.microsoft.com/fwl... App Hub Links Announcement: http://create.msdn.com/en-U... ...
Today a new set of tools targeting the Windows Phone 7 “Mango” release is available. This toolset is being called Windows Phone Developer Tools 7.1 This by not means can be translated into the actual product name for the final release! The download is available at Create.MSDN.com [might take a few hours to appear on that site] Direct Download Link Documentation and What’s New is on MSDN: http://msdn.microsoft.com/e... Using these tools a developer can write WP7 application for 7.0 ...
Mondays had been good to me recently. Mondays at work are usually quiet, and occasionally I may even be able to sneak in a nap if you want to. Yeah, I have it good. But this Monday would prove to be a bit trickier than normal. It started out normal enough, I was rushing to work, and hoping for one more day full of naps. As I settled in and logged on to my system, I saw an email from one of the clients. It said he was not able to connect to his SQL Server 2008 instance. Also, he had tried using the ...
Microsoft has just released a new SSIS 2008 transform component called SQL Server Integration Services Balanced Data Distributor. As the download site states “this transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading”. Sounds like we got a component to evenly distribute some data across multiple destinations. Frankly, I though we could do this even before using either a Script Component or the Conditional Split, alas this component has ...
We had a process ot using BizTalk to take in a reference file, then send data in via a table_type parameter in a stored procedure. The stored procedure uses a MERGE statement to insert and update; the update part of which does a CHECKSUM first to determine whether an update is even necessary. Then it happened, we had a reference row that should have been updated by the latest file, but it wasn't done. We checked the incoming and outgoing BizTalk Message in and out of the pipeline; everything looked ...

Today's $10 Deal of the day from Apress at http://www.apress.com is Secrets of the Oracle Database

Full details are at http://www.apress.com/9781430219521

What particularly interested me was the chapter on the Daat Dictionary Base Tables. I wish I had this chapter on my last Oracle contract as I needed to be able to checks across tables for particular data types.

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* 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:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ...
For Microsoft these days, great things are happening at the macro level, and yet there’s fits-and-starts progress down below. This year’s Tech Ed North America conference represented, in event-form, that very duality. On the one hand, this was the largest Tech Ed in my memory, with 10,000 attendees. But the customary Microsoft 2-day, all-morning keynote format was shortened to a Day 1, 90-minute talk on Cloud and Visual Studio. Microsoft’s cloud push reached an almost fever pitch; but various new ...
Ok, so you have locked your SQL down. No users allowed. But then there is this information worker for whom the IT department made a special SSIS package. And they loaded the package in to the SQL server and created a SQL Agent job for it. Well no problem so far. But now the user wants to be able to start the job when ever he needs to. Hmmm, huge problem. Because you need to have SA equivalent rights. What?? Yes, you read it right. SA equivalent !! Hell no! Ok a sql geek will now say, that's wrong, ...

The much esteemed Joe Celko has published an article at http://www.simple-talk.com/sql/t-sql-programming/time-gentlemen-please!-the-sql-server-temporal-datatypes/ discussing the new data and time data types that were introduced with SQL 2008. If you are involved with SQL Server database design and development, I urge you to read this article.

He who fails to plan, plans to fail. – unknown In many ways, one of the most dreaded tasks of every iteration is the Sprint Planning Meeting. This meeting is a very important meeting, but many, many things can go wrong and make this meeting a very long and very painful experience. However, this meeting is critical to the success of the team. If the team doesn’t know what they’re doing at the beginning of the iteration, how can they commit to getting the work done? To hopefully help ease the pain ...
I'm still getting used to this whole schema-less, document oriented database thing. I've been trying to determine out what document structure to store my Twitter data in, and I keep flipping back and forth. I've been writing software in the land of relational databases for 15 years, and consider myself pretty good at designing database schemas for enterprise class solutions. But when it comes to this whole schema-less document store thing, I'm not sure what the best approach is. With this Twitter ...
It's already the 15th of May, and it's now time to recognize devs that have a large number of posts in Silverlight Cream. Ground Rules I pick what posts are on the blog 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 November 1, 2010 through April 30, 2011: It is my intention to post a ...
Sorry for the repost and also hosing over the results a while ago, but since it's been so long that I did one of these, I pooted the query. Original post: Wow...it's quite a bit past the first of May, and I realized I had not done the 'top posted' list for April. When I went to update the sproc that runs that code I realized I had not done the list for February either :( ... so let's do that one first... it's now time to recognize devs that have a large number of posts in Silverlight Cream for the ...
Ive recently just setup BizTalk 360 (http://www.biztalk360.com/) to try out the monitoring capabilities. I also thought it would be interesting to see how things go since this given environment was a BizTalk 2006R2 environment and fairly old stuff now. I had a couple of issues during the install/setup but i was able to solve all of these using the troubleshooting page on the BizTalk 360 website and a little common sense. To be honest a couple of them were me being a bit lazy and not reading the install ...
Below are a few links, that can help, if you need Restore SQL Server Database from suspect MyITforum.com : How to recover user databases from a “Suspect” status( http://www.myitforum.com/ar... ) http://forums.devx.com/arch... You could also try detaching the DB, then do a single file attach only using the db, dropping the log file. That solved the suspect issue for one of our DBs. Somewhere in the SQL message logs it indicated that the LOG file was corrupted ...
In this Issue: Chris Rouw, Kevin Dockx(-2-), WindowsPhoneGeek, Jesse Liberty, Jeremy Likness, Telerik Phone Team, Mike Taulty(-2-), Pete Brown, and András Velvárt. Above the Fold: Silverlight: "Locking and Unlocking controls in a Silverlight LOB Application" Chris Rouw WP7: "WP7 ToDo Lists App Built with RadControls" Telerik Phone Team Just too cool not to list: "Kinect + Bing Maps–the gestures" András Velvárt Shoutouts: The SilverlightShow folks sent me their top 5 from last week: SilverlightShow ...
When I am working on some project, it is normal to need to analyze the queries that are executed on the database to detect a possible bug or something that is not matched with what I expected. For this, SQL Server Profiler gives me a good and quick overview of what is being requested for each connection to the database. The case of a registration in the profiler can be shown as: As can be seen in the Application Name column has the value ".Net Sql Client Data Provider", which makes it very difficult ...
Let’s focus on Exam 70-583 this time. This exam is PRO: Designing and Developing Windows Azure Applications. This guide itself will be a different approach to preparing for the exam itself. Instead of just taking the individual topics, let’s review the topic in as much information as we can. Here is a set of resources to get started. This is the topic I will be presenting at TechEd North America 2011, so expect more information after 5/18/2011. Here is the link to the session: http://northamerica.msteche... ...
Let’s focus on Exam 70-516 this time. This exam is TS: Accessing Data with Microsoft .NET Framework 4. Additional Resources: http://msdn.microsoft.com/e... The exam objectives are: Modeling Data Map entities and relationships by using the Entity Data Model http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... Map entities and relationships by using LINQ to SQL http://msdn.microsoft.com/e... ...

Over the last couple of weeks I have been discussing with clients and peers the proper way of managing the database side of a SharePoint deployment.

Yesterday, Microsoft released the official version of that guidance.

You can get that here

RedGate SQL Source Control is a Management Studio add-in that allows you to seamlessly (hopefully...) connect your existing source control system to SQL Server. It is advertised as doing all the typical stuff you'd expect: Source control schemas and data within SSMS Connect databases to TFS, SVN, Sourcegear Vault, Vault Pro, Mercurial, Perforce, Git, Bazaar, and any source control system with a capable command line Work with shared development databases, or individual copies Track changes to follow ...
I have found myself using more and more of the tools Red Gate software makes. They have proven (to me) to be effective and to the point. This time I am talking about SQL Source Control. Simple to use, simple to add a database to be under Change Control, which really is the goal. Don’t take me wrong, Visual Studio is a great tool, yet it is a developer’s tool. As a DBA or Database Developer (referring to an individual who codes T-SQL) we want to launch SQL Server Management Studio and be able to control ...
If you have a web site using Umbraco and you wish to add the ability to comment on submitted articles then UComment is a quite brilliant little package, the functionality can be added in no time at all. My problem was that the web site in question uses Umbraco 4.0.x.x and I couldn’t upgrade to the most recent (4.7 at the time of writing) due to not being able to back up the database before I begin (shared web hosting). This meant I was forced in to using UComment 1.0 because 1.1 is tied to Umbraco ...
Sometimes, the way that LINQ to Twitter materializes queries into entities isn’t immediately clear. It’s easy to get confused until you see the patterns or make a correlation between the Twitter API results and their representations as LINQ to Twitter entities. In this post, I’ll explain some of the logic behind the design of LINQ to Twitter entities and demonstrate an example of one of the more oddly designed entity types, Search. Note: They'll be talking about MVC3 during multiple sessions at Tech-Ed. ...
The list provided below is my “Best-Of” FREE Frameworks, Tools and Controls for Windows Phone 7. I have used everything listed below in an my WP7 applications. Most of them are in the marketplace at this point and some are still in development. Let’s get started. If you are developing WP7 Applications, this is one that you have probably heard of already. It is Microsoft’s official set of controls that comes complete with full source code of course. Project Description: Welcome to the Silverlight ...
In this Issue: Michael Washington, Morten Nielsen, John Garland, Bil Simser, Adam Nathan, András Velvárt, WindowsPhoneGeek(-2-), Jesse Liberty(-2-), Martin Krüger, Damon Payne, and Xianzhong Zhu. Above the Fold: Silverlight: "Using ICustomTypeProvider in Silverlight 5" Damon Payne WP7: "Hardware Back Button + Marketplace Certification" Adam Nathan Lightswitch: "Deploy Your LightSwitch Application As A DotNetNuke Module" Michael Washington From SilverlightCream.com: Deploy Your LightSwitch Application ...
After several months of research, review and revision, a white paper I wrote for the SQL Azure team, “NoSQL and the Windows Azure Platform”, has been published by Microsoft. If you go to http://www.microsoft.com/wi... and do a find within the page for “NoSQL” you’ll see a link for it. If you’d rather download the PDF directly, you can do so by clicking here. The 25-page (not including cover and TOC) paper provides an introduction to NoSQL database technology, and its major subcategories, ...
In TFS2008, deleting a build removes it from the database itself. If you delete a build called Build_20110423.1 or 1.0.0.1 from Build Explorer and trigger the build again then you will see that new builds starts with same number (Build_20110423.1 or 1.0.0.1) but not with an incremental number (Build_20110423.2 or 1.0.0.2). But, it doesn’t work the same way in TFS2010. I queued a build in TFS2010 which got failed with Build Number 1.0.14.0 due to compilation errors. I wanted to reuse the same build ...
The error seems to be quite simplistic, but you might need to do quite a bit to resolve this. I created a new BI site and was welcomed by the Error Message "The WorkBook cannot be opened". Did some google and tried to find out a solution. Found a good post which kinda came to the rescue to resolve this irritant. You can follow the article by Jeremy to resolve the issue: http://blogs.msdn.com/b/jja... ...
Todays $10 deal of the day from Apress at http://www.apress.com/97815... is: Pro Entity Framework 4.0 is a professional-level guide to Microsoft's Entity Framework, the future of data access in .NET programming. Readers learn to implement easy-to-program and highly-performing database access solutions ...
HTML5 introduces markup-level functionality for rich graphics, animation and web multimedia. It also supports a richer web application functionality and extends the client capabilities with local storage. Many pundits see it as the next generation web - web 3.0 if you like - and an open standard replacement for propriety plug-ins, Microsoft Silverlight and Adobe Flash. But, for all its new features, HTML5 is still only the end product. This article looks at HTML5 from the web programmer's point of ...
Here’s a quick start introduction to the ADO.NET Entity Framework Code First Development Pattern. For a more complete (but still intro) walkthrough, check out ScottGu’s blog. At the time of this writing, you’ll need the EF 4.1 Release Candidate. After EF 4.1 is released you’ll no doubt be able to find it on the ADO.NET team blog. 1. Create a new empty ASP.NET MVC2 Web Application, add a reference to System.Data.Entity. If using the EF4.1 RC - add a reference to the EntityFramework dll that comes ...
Thanks to everyone who attended my session at Philly Code Camp 2011.1. It was a very fun and interactive session for me, and I hope it was an informative and helpful session for you as well. I apologize for the delay in getting the presentation materials uploaded since I was busy catching up with work from last week this morning. The Database backup file (.bak) included in the zip file will have to be restored on your SQL Server. Please let me know if anything doesn't run (or) compile or you are ...
While connecting to Lotus notes database from dotnet application using Interop.Domino dll, I was getting the following error. (“Retrieving the COM class factory for component with CLSID {29131539-2EED-1069-BF5D-00... failed due to the following error: 80040154”) When i installed Domino Server setup we the issue was solved. But unforunately this will not roll out as we might have to run the migration application in different machines. After searching a lot i net i found an article in IBM site ...
I ran into this one because I was working with some tables in a normalized database and I needed to quickly check to see if an id existed, and if it didn't, I needed to insert and then get the id. This is what I came up with in the end: inside your PL/SQL block, you can have any number of sub blocks, like this (here I am using 2 PL/SQL variables: thisVehicleFuelTypeId and thisVehicleFuelType): BEGIN ---------- sub-block begins SELECT FUEL_TYPEID INTO thisVehicleFuelTypeId FROM TBL_FUEL_TYPE WHERE ...
Previously we've talked about how to fetch the data from the database and populate the form with EF. In this example I'm going to demonstrate how to do Edit,Update and Delete operations in the form with Entity Framework. And oh since this is a continuation of my previous example I would suggest you to refer that first before you go any further. STEP 1: Setting up the UI Since this is a continuation of my previous example then I'm jus going to use the same layout and extend it a bit by adding some ...
In Part 1 we've talked about how to insert data to the database with Entity Framework. In this part I'm going to demonstrate how to fetch the data from the database and populate the form fields with Entity Framework. STEP 1: Setting up the Form To get started let's go ahead and fire-up visual studio and add a new WebForm. For the simplicity of this demo I just set up the form like this: <asp:Content ID="Content2" ContentPlaceHolderID="MainC... runat="server"> <asp:DropDownList ID="ddlUser" ...
Few months ago I wrote a series of articles regarding how to Insert, Update, Fetch and Delete data in the form using LINQ to SQL. You can view the series of articles below: Inserting Data to Database using LINQ to SQL Fetching Data from Database and Populating fields in the Form using LINQ to SQL Editing, Updating and Deleting Data in the Form using LINQ to SQL In this article I'm going to demonstrate the basics on how to work with MS Entity Framework. Basically in this part I'm going to show you ...
I have a .Net 4.0 site that uses Entity Framework and Linq to SQL. After reworking a few tables and a few page operations, a new error appeared: "Row not found or changed". Every time I commit changes to a particular table, this error would be raised. From a quick review of msdn and the internet, the primary reason for this exception appears to be data concurrency issues - (The source data in the database is out of sync with the data you are attempting to update.) That did not apply to my development ...
Windows Phone 7 development is an exciting topic. I have been exploring WP7 development for a little while now and I figured I would post some of the basic concepts that might be helpful to beginners. So here they are in no particular order. Panorama control I kept seeing references to the Panorama Control. It seems that this was a control that existed separately during the beta for WP7. In the final release this is now incorporated into a page type, so you won’t see the control in the toolbox. So ...
I'm just getting to grips with MVC linq etc etc and came across what looks like a common stumbling block. For the more experienced of you reading this please refrain from shouting "Dumbass" at me. All the tutorials are either Code First examples or they create the database from scratch in the App_Data directory. All well and good for a tutorial that need to be easily portable to the readers computer, but not very helpful when setting up a full scale MVC application. My first problem was my lack of ...
(these are lifted verbatim from Microsoft here, here and here and are presented below only because it’s convenient to have them lumped altogether…) Getting Started with Windows Phone Windows Phone development platform supports both XNA Framework and Silverlight. This unit takes you through the step-by-step creation of your first Windows Phone Silverlight application. Hands-On Labs · Hello Windows Phone This lab intends to be the classic "Hello World" application, introducing you to the tools and ...
A question popped up not so long ago on the MSDN SSIS Forum from somebody struggling with a leading zero being dropped from the data being exported to a flat file to be returned back. The person asking was also interested in trimming (not rounding) the values to a certain scale. As an aside, this issue occurs when you have decimal or floating point numbers in a database and its value is between 0 and 1 e.g. 0.445 or a negative one e.g. -0.123 which you want to export to a flat file as CSV being used ...
When we don't want to others have access to our Stored Procedures, Triggers or Views code, created on a database, you can create and encrypt easily, just by adding a "WITH ENCRYPTION". Here’s an example to create a Stored Procedure: view plaincopy to clipboardprint CREATE PROCEDURE encrypted_SP(@var varchar(10)) WITH ENCRYPTION AS -- this is an encrypted stored procedure print @var CREATE PROCEDURE encrypted_SP(@var varchar(10)) WITH ENCRYPTION AS -- this is an encrypted stored procedure print @var ...
Problem I noticed a new feature that was first introduced in SQL Server 2005, which is the Emergency state for a database. It looks that it may facilitate dealing with a suspect database. How can I use the Emergency state for a database effectively while working with a suspect database? Solution During a disaster recovery process, the Emergency state provides flexibility to perform several operations on a corrupt/suspect database. When a database is put in the Emergency state, it makes three major ...