Tag | Database Posts

How often does it happen: you write an application that uses a SQL Database as source, and when you want to fetch data you get a time-out. Damn! But when you need to get a time-out (for example, if you want to test an exception), you don’t get one. In SQL Server you can create your own time-outs if you want. One of the simplest ways to generate a time-out, is to lock an object, and running a query against the object in another session. You can lock an object with a simple query: SELECT * FROM Company ...
/* 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; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ...
For more formatted view .. Goto http://ankitagrawal57.blogs... any web application, performance is basic necessity. Earlier internet speed used to be limited thus users got inclined to pages which load within 3-4 secs. But now the internet speed is no more a constraint but still time does remain a constraint. Imagine yourself visiting a website which takes a lot of time (30 – 60 secs) just to load the page. You would not like to go to that site again.To mitigate this issue, developers and ...
In this Issue: Eric Jensen, Andrea Boschin, Gill Cleeren, Rene Schulte, Colin Eberhardt(-2-), Mark Tucker(-2-), Mark Monster, Walter Ferrari, and Michael Washington(-2-). Above the Fold: Silverlight: "Welcome to Zombieland, the Metro Style Land of WinRT and the Undead" Rene Schulte WP7: "Adding Tactile Feedback to your app the easy way" Mark Monster LightSwitch: "A Random Walk Through The LightSwitch Data Model" Michael Washington Windows8: "TweetSearch – A Cross platform Metro UI WinRT and Silverlight ...
At the beginning I want to inform that I've already read the similar question here: Entity Framework 4.0: is it worthy now? but it does not answer my questions and doubts concerning EF 4.0. Here's the case: We are working on a quite big project written in WPF and WCF. The structure of the database contains about 60 tables, lots of stored procedures, views and some functions. We are not using any ORM at the moment. Some time ago when the first version of EF was release we did not go with it because ...
A few weeks ago I ran into an error while setting up our test farm. I was creating the service applications and when I got to PowerPivot, I got the following error: I was able to work around this error by using PowerShell to create the service application. Background First, some details of our installation: two web front ends, two application servers, and one SQL server. All are running Windows Server 2008 R2 x64 with Service Pack1. The SQL Server is 2008 R2 with SP1. The SharePoint servers are SharePoint ...
We recently implemented an email archiving solution at work. One of the requirements was that we configure automatic purging of messages older than 6 months in Exchange. One of our IT managers spent the better part of a month moving items out of the only copy of his PST into his mailbox so that they could be captured by the archive system and free him from his PST. For whatever reason none of these messages were captured by the archive system and were purged by Exchange as per the items older than ...
The Visual Studio 11 Developer Preview was released to MSDN subscribers yesterday, and will be available in general release tomorrow (9/16). There's way too many new features to list them all here (for all the product highlights go to http://msdn.microsoft.com/e... but here are a few that interest me the most: Enhanced multi-monitor support .NET Framework regular expression syntax in Find and Replace IntelliSense enhancements for JavaScript JavaScript breakpoints ...
In the BUILD event, Microsoft had just announced the latest Windows Azure SDK 1.5, Visual Studio Tool for Windows Azure SDK 1.5, and the Windows Azure AppFabric SDK 1.5. You can find them simply from the Web Platform Installer. One thing I found for now is that, the database had been changed for the local storage emulator in this version. That means you need to recreate the storage database by running the DSInit command from the folder (let’s say you installed the SDK in driver C) C:\Program Files\Windows ...
I was working locally and trying to restore a database backup from the server for development purposes. I was receiving this error when I tried to restore and overwrite an existing database: The tail of the log for the database "%ls" has not been backed up. Use BACKUP LOG WITH NORECOVERY to back up the log if it contains work that you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log. An easy fix is to click on the Options ...
I've been working lately on web application that uses Asp.Net MVC, WordPress and MySQL database. To communicate from .NET code to MySQL database using Entity Framework we installed MySql .NET Connector. It worked fine out of the box on developer's workstations but once deployed to hosted web server application started to throw following error: [NotSupportedException: Unable to determine the provider name for connection of type 'MySql.Data.MySqlClient.MyS... System.Data.Entity.ModelCon... ...
On the 9th Sep, the SQL Azure team announced that the new version of SQL Azure had just been release. In this version not only the SQL Azure engine had been upgraded, the SQL Azure Management Portal had been upgraded massively. Below are the features and improvements available in this release: Foundational updates for scalability and performance. Co-administrator support, which enables customers to specify multiple database administrators. Increased capability for using spatial data types, which ...
Today, We deployed the “David Blaine” version of the TB Module for our EMR solution here at IDI (http://idi.mak.ac.ug). This was mainly for bug fixes and usability improvements based on the feedback that we received from users in the past few weeks. Some of the improvements were related to performance. We had to fine-tune some of our Linq statements in some places to enable better queries to be generated by our ORM. We also added some lookup dialogs that present certain information that would be ...
The ability to write scale out applications for SQL Azure will soon become much easier, thanks to the upcoming SQL Azure Data Federation capabilities. In an earlier post, I outlined specific steps developers can take to prepare for this key enhancement. Some of the key capabilities of SQL Azure Data Federation is to distribute large data sets across multiple databases, hence providing a mechanism to avoid the current database size limitations of SQL Azure. While it may be tempting to look at this ...
On SQL Server Central there is a very good article at http://www.sqlservercentral... on least priviledge access to a database. The only thing I can add to such an excellent article is that where there is a series of applications each with its own database on a common database server, there should never be a common account across all the databases that the applications use ...
Recently I implemented a rather complex page allowing the user to input pairs of colors and quantities, with some relatively "odd" validation rules. I knew that I probably wanted to implement the page entirely with javascript and probably jquery templates, but for a demo I just needed a quick prototype of the page, so to get that done I threw together a quick and dirty webforms page using the telerik radgrid to display the data, but not save & validate. Took me maybe 2 hours including some basic ...
In this Issue: Michael Washington, Tony Champion, Ollie Riches, Gill Cleeren, Koen Zwikstra(-2-), Peter Kuhn, Xianzhong Zhu, Mike Taulty, Pete Brown, Sumit Dutta(-2-), Asim Sajjad, Dhananjay Kumar(-2-), Above the Fold: Silverlight: "Silverlight Spy September 2011 Update" Koen Zwikstra WP7: "Windows Phone 7 on-demand training available" Peter Kuhn LightSwitch: "Quick And Easy Data Management With LightSwitch" Michael Washington PivotViewer: "Extending your CXML Trading Cards in Silverlight 5" Tony ...
In this Issue: Tony Champion, Kevin Hoffman, Pete Brown(-2-), Mike Gold, Jeremy Likness, Xpert360, Den Delimarsky, Sumit Dutta, Asim Sajjad, Vikram Pendse, and Michael Crump. Above the Fold: Silverlight: "Silverlight 5: Remote control and MediaCommand Support" Pete Brown WP7: "Extracting a SQL CE DB from Isolated Storage in WP7 Mango" Michael Crump PivotViewer: "To CXML or not to CXML" Tony Champion Shoutouts: Michael Palermo's latest Desert Mountain Developers is up Michael Washington's latest Visual ...
If you are a developer, you will encounter countless problems in your career. As a developer, problem solving is what you do. Still, some may try to shy away from problems in order to make their lives easier. I say do not, especially if you are a new developer or are learning a new technology. Learn to embrace problems as they come along. I am not simply referring to basic business problems, but issues that you encounter that cause weird problems that you must solve in order to continue. I’ll give ...
Introduction By now, most of you have heard that Windows Phone 7 – Mango release will support Local Databases (SQL CE) using Linq to SQL. But what you probably haven’t heard much about is how to extract the .SDF that is created in isolated storage to your local computer and view the contents. I find this extremely important for debugging application and making sure my database is setup exactly like I want it. So, that is what we are going to do today. Getting Started with a sample application: For ...
I found a blog post by Davy Brion (one of my favorite bloggers on the ‘net) that spoke about the .NET world’s current state. He mentioned that Microsoft’s products (such as WebMatrix and LightSwitch) are mainly geared toward what he calls “low-end” developers. At the same time, Microsoft is backing off on other products that more experienced and seasoned programmers like, such as IronRuby, IronPython, and the DLR (Dynamic Language Runtime). I certainly agree with some of his points. Applications ...
To start, I love Red Gate Software’s Tools. I have loved them since the first time I started using SQL Backup and SQL Compare when I first started Geekswithblogs.net. I think they create quality products and have been a “Friend of Red Gate” for years. So know that this review is coming from a “fan boy” of sorts. What is SQL Compare? Well the name sort of says it all, this product compares SQL databases. But not just databases, but backups, snapshots, and source control using their product SQL Source ...
Recently I used Entity Framework 4.1 with Code First approach and step on a hidden rake. My application should create an SQL Server CE database file using supplied model classes. I created some model classes, one of the classes was declared as namespace MyProject.Models { public class Object { public int Id {get; set;} public String Name {get; set;} } } Then, I tried to declare property of DbSet<MyProject.Models.O... type in my class derived from DbContext: namespace MyProject.Models { public ...
To quickly look through your stored procedure objects for a text value in a database instance, do the following: use [Metro] go SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%whatyouarelookingfor%' AND ROUTINE_TYPE = 'PROCEDURE' Now, this is no replacement for a configuration management repository, but it will do in a pinch. BTW, remember this sql statement does NOT transcend all databases on the server, just a single db instance ...
I know I haven't been blogging like I should be. Been playing alot of PC games in my free time. I will dial down some of that for some upcoming projects. I will be doing mobile applications in both Android and Windows Phone. I will discuss my Android projects on my personal site blog, which you can access from the link on this post. I currently don't have a Developers account to distribute my applications on the market. My plan as of now is to get my account in January. I will be in a better financial ...
Requirement was to create Multi-tenant WCF Service for custom development using WCF and Dynamics CRM 2011. There is just one SVC file but multiple URLs to access it e.g. in Dyanamics Organization Org1 have URL http://CRMserver_name/Org1/... and Org2 have http://CRMserver_name/Org2/... I was trying this using URL Routing but problem is, it is creating REST services which we don’t want. We should be able to access these services just like ...
NHibernate has many ways to create and executes queries. With one of them* - the Named Queries we can execute our manually created stored procedures. This example is dedicated to SQL Server. This is important to notice, because this code is database specified. That means, for each database the query can look diffrent. E.g. in SQL Server we call the stored procedure by using the syntax: exec <procedure>. In Oracle it is: call <procedure>, so we must remember it. Let's assume we have a ...
I have been trying to put a staging environment together to upgrade from SharePoint 2007 SP1 to SharePoint 2007 SP2. Then we will run the preupgradecheck command to varify that the database wil upgrade properly. We ran into the infamous error: Issue : Content database with modified database schemas User modifications to the SharePoint content database, including but not limited to table schemas, index, stored procedures, are not supported and will cause upgrade to future versions of SharePoint to ...
Wijmo is an awesome tool from ComponentOne. The goal of this tool is to help us web developers rapidly develop MVC applications with interfaces richer than WebForms. Main Features: 1.Over 30 UI Widgets with everything from interactive menus to rich charts. 2.MVC scaffolding automation. This means that Wijmo generates rich interactive Views and Controllers for your entire Model. Free Trial DownLoad: http://www.componentone.com... In this review we'll take a look at Wijmo ...
One of the things that is important to learn when you are developing any application is how it will interact with the environment it lives in. I’m not talking about simply interacting with files or database but with major resources. With WP7 there are a number of things such as the photos, browser, maps and the phone itself that your application may be concerned with. The WP7 development API includes a number of access points to give your application greater reach. These APIs can be found here. They ...
In my previous posts I have shown how to get xml data from database and deserialize it. But sometimes we want to work with the xml and do some operations on it. To working with xml, in the .net framework there are two tools for it. One is to use the XmlDocument class and second is the linq to xml with the XDocument class. I personally prefer to work with linq to xml, so I must convert the XmlDocument object to XDocument which I have after I took the xml from database. To convert the XmlDocument to ...
I have a simple database table with only id and one xml column as shown below. In this column I have a list of available extensions saved as xml. public class FileExtensionsList { public FileExtensionsList() { Id = Guid.NewGuid(); } public virtual Guid Id { set; get; } public virtual XmlDocument Extensions { set; get; } } This xml I'm not creating manually. I have a custom entity which I serialize to xml: [XmlRoot("FileExtensionsLis... [Serializable] public class FileExtension { [XmlAttribute] public ...
The origin of the following is now lost in the mists of time but it bears repeating. A big party is being held to honor relational database systems & their impact on the modern society. Outside the venue, the host awaits the guests. The first limousine arrives and out steps Oracle followed by 4 people Host: Who have you brought along? Oracle: I have 4 DBA’s in tow. One to install me, one to design the databases, one to administer me and the other to justify the cost. A second limo arrives and ...
Recently i caught in a peculiar situation where i need to modify the check constraint expression to include more criteria to be validated through T-SQL. Although there is no declarative command or mechnism to modify the expression except dropping and recreating the check constraint. One exception is to use the Sql Management studio to modify it in design mode. But modifying using design mode was out of scope. The actual work was to alter or modify the defintion of a check constraint created with ...
Performing Composite Operations on Oracle Database is very similar to SQL Server Database. I just want to point out one mistake developers might easily make during the send port configuration. For any composite operation, the generated binding script doesn't include the composition operation tag in SOAP action header, therefore a new line needs to be manually added for each composite operation during the send port configuration. For WCF SQL Adapter, it looks like <Operation Name="CompositeOperationName" ...
As a part of continuous integration we are using deployment of database scripts, which makes very important to make the scripts re-runnable. Some checks for DDL elements are not obvious, and I decided to put hem in one place.Most answers were found on StackOverflow --Column does not exists if NOT Exists(select * from sys.columns where Name = N'CreatedDate' and Object_ID = Object_ID(N'MyTableName')) --Check if primary key does not exists IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CO... ...
I’ve written about Visual Studio LightSwitch several times in this blog and in my Redmond Review column, including this month’s piece, “LightSwitch: The Answer to the Right Question.” All throughout, I’ve been pretty clear in my support of the product. A little over two weeks ago LightSwitch shipped, and I think it’s off to a very good start. To help it along, I wrote a series of five whitepapers on LightSwitch for the product team, and they were just published by Microsoft. You can find them all ...
In this Issue: Morten Nielsen(-2-), Mike Gold, Jesse Liberty, Derik Whittaker, Den Delimarsky, Austin Andrews, and Oscar Agreda. Above the Fold: Silverlight: "Silverlight MVVM Code Smith Templates" Oscar Agreda WP7: "Working with a simple ViewModelLocator from MVVM-Light" Mike Gold From SilverlightCream.com: WPF vs. Silverlight - Part 4 - Animations Part 4 of Morten Nielsen's WPF and Silverlight comparison yeields this post on Animations... the launching thereof to be exact WPF vs. Silverlight - ...
No matter which ORM or data access technology you use, at some point you just need to do some CRUD, and you need to do it fast. In this post, I’m going to show you how to get your CRUD on with the latest version of Entity Framework in no time flat. In fact, I’d be surprised if the code to get your first CRUD operation done takes you more than a few minutes. The one thing the EF team did right with Code-First is make it really easy, but most of the “getting started” videos and documentation is packed ...
In this Issue: Oren Gal, Oscar Agreda(-2-), Michael Washington, Mike Gold, John Papa, Paul Sheriff, Jesse Liberty(-2-), András Velvárt, and Derik Whittaker. Above the Fold: Silverlight: "here is a Complete Silverlight Business Application using MVVM" Oscar Agreda WP7: "SurfCube on Mango Part 2– The SystemTray" András Velvárt LightSwitch: "WCF RIA Service: Combining Two Tables" Michael Washington Shoutouts: Michael Crump's articles on OData at Silverlight show have been pulled into an eBook: My eBook ...
This morning I got the information that the Windows Azure Tools for Visual Studio 2010 - August 2011 Upgrade had been released. The version of this new upgrade is 1.4.40727.1601 with the Windows Azure SDK v1.4.20407.2049. This upgrade includes some awesome features that I was looking forward for a long time, which are: Profiling the application running in Windows Azure. New ASP.NET MVC 3 web role template. Multi-configuration files in one cloud project. More validation in the service package and ...
After writing this post, I realized that it is obnoxiously long, and maybe includes a little bit too much hand-holding. Nevertheless, I decided to post this very detailed step-by-step walkthrough of implementing a simple AJAX form in MVC3 with Razor. I'm probably going also post a shortened version of this topic for those that don't need a complete walkthrogh. So I've been attempting to dive into ASP.NET MVC 3 lately, and have hit plenty of bumps along the way. This is my first encounter with any ...
l will show you what I am doing lately with jquery. I started out using the suckerfish menu for a customer app. All went fine for awhile but suddenly the menu started acting weird with problems indenting and such. I finally figured it must be interacting with other css stuff. So, I thought how the heck do I fix this? What if I could just use jquery and keep all of the action in jquery and put the style in in the menu class and just spit it out. Most of the properties would get put into attributes ...
In this Issue: Max Paulousky, Ollie Riches, Derik Whittaker, John Garland, WindowsPhoneGeek, Manas Patnaik, Xianzhong Zhu, John Papa, Dhananjay Kumar, Jesse Liberty, Peter Torr, Gill Cleeren, and Jonas Follesø. Above the Fold: Silverlight: "Multiple MonthView DatePicker Control in Silverlight" Manas Patnaik WP7: "Silverlight TV 79: Data Binding Debugging" John Papa From SilverlightCream.com: Windows Phone (Mango) DB Engines Performance Testing Max Paulousky's latest post is on performance testing ...
As of today, the official release of Lightswitch is now available. Visit: http://www.microsoft.com/vi... or you can download from your MSDN subscription. What is Lightswitch? It is basically a simple to use application generator that can be used to build applications within minutes in many cases. If you have an existing, well structured (primary keys, relationships) SQL Server database you are just a few clicks away from an administration tool and well on the way to a full ...
This blog will help you prepare for an upcoming release of SQL Azure that will offer support for Data Federation. While no date has been provided for this feature, I was able to test an early preview and compiled a few lessons learned that can be shared publicly. Note however that certain items could not be shared in this blog because they are considered NDA material; as a result, you should expect additional guidance in future posts when the public Beta will be made available. What is Data Federation? ...
I have a need for a highly responsive web page that must at least appear to be "pushed" information from the server as it happens, much like you'd see with an HTTP protocol based chat window. The client will utilize JavaScript, and will use JQuery and its UI plugins, and will use its AJAX support to call the requests that will only return when there is data to be "pushed". I know HTML 5 includes support for WebSockets, but I feel it is too soon to rely on them, as the spec is not yet finished and ...
I was looking through some code today and came across something like this. if (checkSomeValueInTheDatabase() && someValue == someOtherValue) // Do something... Now this is a completely legitimate conditional statement. But it's not very performant. You should always use boolean short circuits to your advantage when writing conditional statements. Start with the conditions that are the easiest to evaluate then work your way down to the ones that use a lot of resources, like hitting the database. ...
In this Issue: Rudi Grobler, Roy Dallal, Hannah Watkins, AfricanGeek, Kunal Chowdhury(-2-), Beth Massi, Mohamed Mosallem, Michael Crump, and Jesse Liberty. Above the Fold: Silverlight: "Communicating between two local Silverlight Applications" Michael Crump WP7: "Designing for Steam Achievements, a Windows Phone 7 app" Hannah Watkins LightSwitch: "Relating and Editing Data from Multiple Data Sources on the Same Screen" Beth Massi Shoutouts: My Friends at SilverlightShow have their top 5 posts from ...
Technorati Tags: Team Foundation Server 2010,Power Tools,TF254027 Error Recently moved from TFS 2010 server to another TFS 2010 server and trying to configure a backup plan using the Backup plan wizard that comes along with the TFS Power Tools. The tool allows you to set up Team Foundation Server backups - The tool can schedule backups for the following databases that your deployment of Team Foundation Server uses: the configuration database the database for each team project collection the databases ...