Tag | Database Posts

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-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...
For the past 4 weeks I have been assigned on a project with lot of performance issues. It’s an asp .net 3.5 project based on DNN 4.9 framework. The project is quite complex and the team has already put in almost 50 man years in the project and as usual most of the efforts were towards getting functional part working as per requirements. At first I tried to verify the server configurations and other parameters to make sure that there was no issue with any of that. After couple of days of research ...
In my last post I showed gems being used for .NET. Now let’s talk about How. Most of this stuff I’ve learned over the past two days, so if I have a mistake here or you have a better idea, please don’t hesitate to offer a better solution. The GemSpec The Gem::Specification reference is your friend. In order to create a gem, you need to define a gem specification, commonly called a “gemspec”. A gemspec consists of several attributes. Some of these are required; most of them are optional. From here ...
Normal 0 false false false EN-US JA X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... ...
When we look at how our database deployments are happening, we identify an ever growing number of servers and instances all servicing important services or why not? Custom applications. What is it? It is a combination of elements, those elements will allow for us as administrators interested in keeping a view of the health of the environment to connect to the system and check resource utilization. The elements that come into play are: Utility Control Point Health Policies Utility Explorer Each one ...
This week, Scott Guthrie, Corporate Vice President at Microsoft’s Developer Division, announced, via blog post, the early Beta release of a new tool called WebMatrix. WebMatrix is a free developer tool that enables Web development geared toward what might I might call Markup-and-Script developers (more on that in a minute). And although WebMatrix draws upon technologies already, or soon to be, present in the fuller ASP.NET Web development platform and the Visual Studio integrated development environment ...
When publishing SharePoint 2010 Portal you encounter the following error “The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator. “ This issue is caused by lack of Session State Service which usually is a result of farm being configured manually. To fix the issue power up your PowerShell on the SharePoint Server and run the following commands, these commands will create a State Service ...
Recruit Officer: Have you given any thought to your future, son? Forrest Gump: "Thought"? Well, it appears that Microsoft has given some though to theirs with the new WebMatrix Beta. What is WebMatrix? WebMatrix gives you everything that you need to build Web sites using Windows. You download a small installer and then you can select which tools to install. I already have Expression Blend 4 and VS2010 Pro, so I’m only going to take WebMatrix and a DB (MSSQL SRV 08 R2 Express and leave defaults for ...

The microsoft sql server product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 GB. So if you have any  SQL Server Express database that is close to the 4 GB Limit
Its time to upgrade to R2 Express.

Enjoy for free!!!!!!!!!

In this Issue: Damian Schenkelman, Phil Middlemiss, Jag Reehal, Senthil Kumar, Andrew Marshall, Chris Koenig, Jimmy, Lee, Pete Brown, Brian, Mike Taulty, and Jeremy Likness(-2-). From SilverlightCream.com: Prism Training Kit: Beta Version Available Damian Schenkelman announced the release of a Prism Training Kit he and Matias Bonaventura have put together. Read his description on the post, then go download the kit. Create a Custom Control - Inheriting from TextBox Phil Middlemiss has another great ...
The Managed Extensibility framework or MEF is a framework released as part of .NET 4 and Silverlight that provides a mechanism to dynamically compose an application at runtime out of loosely coupled parts and provides a variety of mechanisms to discovering these parts. You can think of this as an implementation of a plugin framework that enables plugging in functionality into a container, based on information available at runtime. The most notable example of a MEF client is the Visual Studio 2010 ...
Just started working with the Entity Designer Database Generation Power Pack and I must say it is a very solid first offering. Model first design is something new in EF4/VS 2010 and it's great to see a tool available that has evolved alongside VS 2010. I was very happy to see that it comes with the ability to synchronize with a database project right out of the box. In my opinion, this is the most valuable feature. In the past, the actual production database was considered to be the "truth". As our ...
In this Issue: Ben Hodson, Marcel du Preez, Karl Shifflett(-2-), Rishi, Chris Koenig, Adam Kinney, Xianzhong Zhu, Jeremy Likness, and CrocusGirl. Shoutouts: Victor Gaudioso posted an inteview: Checkout my Interview with Bytes on MSDN (Microsoft) The Silverlight Web Services Team poses this question: How can we make WCF support in Silverlight better? ... read and give feedback in the comments. Timmy Kokke has announced the opening of a new XAML resource site to bookmark: XamlResource.com Chris Bowen ...
After I blogged about Andy Wigley's port of the Perst database last night, I got email from the folks at McObject.com who are the developers of Perst. Needless to say, they are all pretty pumped about the port, and have actually rolled Andy's port into their distributed codebase, so I would think Andy and APPA Mundi are also pretty pumped. They sent me a press release that pretty much matches this page on their site. Ratting around, I found a note about writing them to ask about a commercial license ...
In this Issue: Joseph Cooney, Matthias Shapiro, Ramani Sandeep, Andy Wigley(-2-), Chris Rouw, Michael Washington, Brian Noyes, Roger Peters, Sergey Barskiy, Timmy Kokke, and Phil Middlemiss. Shoutout: Koen Zwikstra announced Document Toolkit 2 Beta 2 available Rob Eisenberg announced Caliburn v1.1 Released! I missed this post by Andy Wigley of his material from TechEd: Programming Silverlight for Windows Embedded from .NET I hope you didn't miss the release of the Silverlight PivotViewer Control ...
Since the new issue of Code Magazine is hitting the stands any day now, I'll go ahead and post my article on Give Camps from the previous issue. GiveCamps Chris Williams This month I’m going to take a brief departure and talk about the growing phenomenon in the developer community known as GiveCamps. If you’ve never heard of these, keep reading (you better keep reading either way, bub). What Exactly Is a GiveCamp? GiveCamps are the brainchild of Microsoft Central Region Developer Evangelist Chris ...
Shards (defined as a collection of databases acting as one) are starting to take serious traction in the database development world because they offer something that was unavailable previously: asynchronous data fetching. It is fair to say that developing multi-threaded applications can be difficult. Shard technologies remove many of the complexities required to fetch data from multiple databases asynchronously. In this blog I will discuss a specific case in which performance was improved significantly ...
Some time ago, I found myself in the difficult situation of trying to explain why business logic shouldn't be placed in the database, but instead in the code (preferably in a Business Logic layer or Object Model layer). The situation seemed so clear to me. It was striking how differently others in the team saw it. You may find yourself in a situation similar to this one, where you are working on a database that contains *many* business rules. Perhaps it started out as a set of tables that very closely ...
As we have pieced together the components of a web application we have explored how best to structure the markup, and how to pull business logic out of the UI by following the Model View Presenter Pattern. Now let's turn our attention to the Model as we pull all the pieces together and explore what a well behaved model might look like. The Model will be the piece that handles storing and retrieving our data. Just as we did with the markup and view, we want to provide a separation of concerns and ...
An interesting ‘rant’ by my fellow Solidsoft buddy Russell Smith: Thought you chaps would be interested in this after hearing my rantings yesterday about the WCF-SQL adapter and notification issues. I got to the bottom of the issue, it wasn’t the adapter in the end it was the database and not the adapter at all. This was a database supplied by PICT that was restored onto my image. Apparently in order for the notification mechanism to work there are some strict requirements on the database SET options ...
Normal 0 false false false EN-US ZH-CN 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-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...
5 Stored Procedures Optimization Tips 1. Use stored procedures instead of heavy-duty queries. This can reduce network traffic as your client will send to the server only the stored procedure name (perhaps with some parameters) instead of all the text from a large heavy-duty query. Stored procedures can be used to enhance security as well. For example, you can give the users permission to execute the stored procedure to work with restricted sets of columns and data. 2. Call stored procedures using ...
June 21st, 2010 The Importance of Open Government Data To all those present, good afternoon. My name is Andrew Brust. I help run a consulting firm, twentysix New York, here in Manhattan. I am also a technology columnist and blogger, and serve on the New York Technology Council’s Advisory Board. As I have explained in previous testimony, I am a lifelong New Yorker, and began my IT career in the employ of the government of the City of New York. I’ve testified to this Committee before, voicing my support ...
Let’s develop a SharePoint WebPart for executing BAM SSIS Packages. The SharePoint site can be on remote server other than the BizTalk Database Server. This won’t be a fancy UI WebPart, just a basic dropdown to select a BAM SSIS Package and execute it. ;-) The approach I am used is of using a asp.net User Control hosted as a sharepoint webpart. There are bunch of different ways you can develop Sharepoint webpart. This is just one of them and easier one. Less error prone and easily debug able. · Create ...
Some of the new Features in EF v4 are : context.ContextOptions.Lazy... is “true” by default. What this means is that if you access a Navigation Property (which returns either a EntityCollection or a EntityReference) of an Entity and if that Navigated Entity (or Entity collection) is not found in the ObjectContext then the ObjectContext automatically loads it when the NavigationProperty is accessed. This means additional round trip to the database for each Navigated entity. If you need ...
It seems like typed datasets provide the same type of object layout as the entity framework. What's the difference and why should I use one or the other? We'll start at the fundamental difference: DataSets give you a basic in-memory database that you can query and fill from a data source such as a database. Queries against datasets are executed against in-memory data. Entity Framework gives you a translation layer that translates LINQ queries to your database's SQL dialect. Queries against the EF ...
A couple of days ago I was playing around with Silverlight 4. Amazing platform, especially since they now support multi-touch events. But before you can run, you’ve got to learn how to walk, right? So, in order to learn some of the new capabilities of the platform I decided to make an application to keep track of all my contacts. I know, there are numerous applications out there that can peform that task much better, but I didn’t want to create a usefull program, I just wanted to have a ‘real’ project ...
From their website … Web Edition: Up to 1 GB relational database = $9.99 / month Up to 5 GB relational database = $49.95 / month** Business Edition: Up to 10 GB relational database = $99.99 / month Up to 20 GB relational database = $199.98 / month** Up to 30 GB relational database = $299.97 / month** Up to 40 GB relational database = $399.96 / month** Up to 50 GB relational database = $499.95 / month** Data transfers = $0.10 in / $0.15 out / GB - ($0.30 in / $0.45 out / GB in Asia)* * No charge for ...
I have recently been having discussions with some of the guys from our Ops Team about the GAC and BizTalk. One of the things they had observed was that when we upgraded some of our BizTalk applications using the technique where you are able to drain the system and fully remove then replace the application the uninstallation and reinstallation process left the assemblies from the previous version in the GAC. I explained the relationship between the management database in BizTalk and the storage of ...
Note: I've translated this article from my Portugues blog: http://pontonetpt.com/blogs... I'm sorry for the bad english, but i'll try to translatet it better as possible with a little help of Google Translatter. I've writed this article because i coulnd't found one article about NHibernate 2.0 that was simple to understand in Portuguese. In the coming weeks I will spend some free time studying NHibernate. I've heard very good reviews ...
In this tutorial, we are going to configure the application/user settings in a WPF application the easy way. Most example that I’ve seen on the net involve the ConfigurationManager class and involve creating your own XML file from scratch. I am going to show you a easier way to do it. (in my humble opinion) First, the definitions: User Setting – is designed to be something specific to the user. For example, one user may have a requirement to see certain stocks, news articles or local weather. This ...
I was recently working on a BizTalk 2004 project where I encountered an issue with capturing exceptions (inside my orchestration) occurring from an external source. Like database server down, non-existing stored procedure, … I thought I might write-up this in case it might help someone … To reproduce an issue, I just rename the database to something different. The orchestration was failing at the point where I make a SQL request via a Response-Request Port. The exception handlers were bypassed but ...
This is (almost) a straight copy and paste but represents an important announcement worthy of a little more “exposure” :-) Starting August 1, 2010, we will release a new SQL Azure Development Accelerator Core promotional offer. This new offer will give you the flexibility to purchase commitment quantities of SQL Azure Business Edition databases independent of other Windows Azure platform services at a deeply discounted monthly price. The offer is valid only for a six month term. You may purchase ...
Like many others signed up to the Windows Azure Platform, I received an email overnight detailing the upcoming database size changes for SQL Azure. I know from our work with early adopters over the last 12 months that the 1GB and 10GB limits were sometimes seen as blockers, especially when migrating existing application to SQL Azure. On June 28th 2010, we will be increasing the size limits: SQL Azure Web Edition database from 1 GB to 5 GB SQL Azure Business Edition database will go from 10 GB to ...
With Dynamic SQL, one stored proc can do the work of many... Over the years, I have worked with a variety of different clients. It seems that every client has unique and different needs. In some situations, you may find that dynamic sql fills the void better than other solutions available to you. One scenario I have encountered in the past is one where the client wants the capability to run aggregate information at run time, but for any start month and number of time periods. There are many ways ...
I'm in the process of evaluating how my team will upgrade our product from .NET 3.5 SP1 to .NET 4. I expected the upgrade to be pretty smooth with very few, if any, upgrade issues. To my delight, the upgrade wizard said that everything upgraded without a problem. I thought I was home free, until I decided to build and run the application. A big problem was staring me in the face -- I couldn't log on. Our product is using a custom ASP.NET Membership Provider, but essentially it's a modified SqlMembershipProvider ...
While i was trying to setup some reports on a SPF 2010 site. After trying to add a Sql Reporting Webpart i get the error: Session state has been disabled for ASP.NET. The Report Viewer control requires that session state be enabled in local mode I never came across that error before when using RSWebaprts in Sharepoint 2007:) But i think is related to ASP.NET sessions state:( Any to fix it you would have to start to make sure the SharePoint Server ASP.NET Session State Service is enabled. Unfortunately ...
It is nice to start blogging again! I am working on new project in a small company now. We do not have a full time database admin. I have to cover multiple roles: getting requirements, writing docs and creating diagrams, designing app, writing code, testing and DBA role. I am not a DBA. But, I have to do day to day database changes: adding new new columns and tables. Check out 2 min video about the SQL_Compare. This tool saves time by automatically comparing and synchronizing database schemas; eliminate ...
I've spent what seems like weeks attempting to set up remote access for SQL Server 2008. Up to recently my database access was alway against a local instance but I now have two servers and I want to work from my local machine using databases on my remote server. I finally got it working. If you need to know how I've done a big page at: http://videotutors.net/SQLS... Check it out and let me know if you have any suggestions or questions ...
The saga of the Change Log A recent conversation reminded me of the need for change logs within a database, to record when various change scripts were run. Creating such the required table is simple. A typical table for this consists of: Id - identity Integer primary key ChangeFileName - NVARCHAR(128) to hold the name of the file run. DateAdded - DateTime non-null with default value of getutcdate() Purpose - NVARCHAR(128) Rerunnable - Bit non-null default 0. By good design of the table only two data ...
Normal 0 false false false EN-US ZH-CN 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-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...
RoundhousE, the database migration software that is based on sql scripts has added support for Oracle and SQL 2000. There have also been numerous other little things, including better logging and a script run errors table. The script errors table captures what went wrong when/if your scripts are not quite up to par or there is some other issue. A special thanks goes out to http://twitter.com/PascalMe... and http://twitter.com/jochenjonc. They worked hard on this and all I did was provide guidance ...
Thanks to all the comments and feedback from the last post I think I have a better understanding now of the benefits of CQRS (separate from the benefits of Event Sourcing). I’m going to try and sum it up here, and point out some areas where I could still use some advice: CQRS Benefits Sounds like the primary benefit of CQRS as an architecture is it allows you to create a simpler domain model by sucking out everything related to queries. I can definitely see the benefit to this, in general the domain ...
Much data is unstructured, such as text documents, images, and videos. This unstructured data is often stored outside the database, separate from its structured data. This separation can cause data management complexities. Or, if the data is associated with structured storage, the file streaming capabilities and performance can be limited. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. ...
I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas. But what about creating a receive location? An ODBC receive location will periodically poll the configured database using the stored procedure or SQL string defined in your request schema. If you need to, begin by adding a new receive port to your BizTalk configuration. Create a new receive location and select to use the ODBC adapter and click Address. You will now be ...
Having previously detailed the installation of the Community ODBC Adapter for BizTalk 2009, the next thing I will be looking at is the generation of schemas using this ODBC adapter. Within your BizTalk 2009 project, right click the project and select Add Generated Items. In the resultant window choose Add Adapter Metadata and click Add to open the Add Adapter Wizard. Check that the BizTalk Server and Database names are correct, select the ODBC adapter and click next. You must now set the connection ...
In this Issue: Miroslav Miroslavov, Chris Klug, Beau, Christian Schormann(-2-), Dan Wahlin, Pete Brown, Michael S. Scherotter, Philipp Sumi, Andy Wigley, and Phil Middlemiss. Shoutouts: Mark Tucker set about learning Caliburn, and in the process is writing a Caliburn Book: Chapters 1-3 Jesse Liberty has a great link-laden post up about why we should all be learning/using Blend: Why Developers Should, Must, Do Care About The New Expression Blend be sure to read what he says about WP7 development, ...
For Immediate Release Iron Speed, Inc. Kelly Fisher +1 (408) 228-3436 kfisher@ironspeed.com http://www.ironspeed.com Iron Speed Version 7.0 Generates SharePoint Applications New! Support for Microsoft SharePoint speeds application generation and deployment San Jose, CA – June 8, 2010. Software development tools-maker Iron Speed, Inc. released Iron Speed Designer Version 7.0, the latest version of its popular Web 2.0 application generator. Iron Speed Designer generates rich, interactive database and ...
On Monday at Tech?Ed 2010 we announced new stuff (I like new stuff) that “showcases our continued commitment to deliver value, flexibility and control of data through data cloud services to our customers”. Ok, that does sound like marketing speak (and it is) but the good news is there is some meat behind it. We have some decent new features coming and we also have some clarity on when we will be able to get our hands on those features. SQL Azure Business Edition Extends to 50 GB – June 28th SQL Azure ...
short answer: Quite probably, as SQL Azure is very similar to SQL Server longer answer: Object Relational Mappers (ORMs) that work with SQL Server are likely but not guaranteed to work with SQL Azure. The differences between the RDBMS versions are small – but may cause problems, for example in tools used to create the mapping between objects and tables or in generated SQL from the ORM which expects “certain things” :-) More specifically: ADO.NET Entity Framework / LINQ to Entities can be used with ...