Tag | Database Posts

Overview Windows HPC Server 2008 is infrastructure for high-end applications that require high performance computing clusters – i.e. for scaling out parallelizable across many compute nodes in a grid. These compute nodes can be coordinated by a head node , which in turn can be proxied via a service broker node that exposes a SOA WCF interface for job scheduling. Additional functionality includes the ability to coordinate between job processes running on nodes via MPI (message passing interface). ...
Here is the official documentation on how to publish a LightSwitch application – How to: Deploy a LightSwitch Application. For this example, I’m going to show how to deploy a simple application that does not have any role-based security set up. I’ll show how we can configure that in a later post. So back over on my LightSwitch development machine the first thing we need to do is specify the type of 3-tier deployment we want. In the case of my application, I want it to be a Windows Desktop client ...
Using a simulated dialog window is a nice way to handle inline data editing. The jQuery UI has a UI widget for a dialog window that makes it easy to get up and running with it in your application. With the release of ASP.NET MVC 3, Microsoft included the jQuery UI scripts and files in the MVC 3 project templates for Visual Studio. With the release of the MVC 3 Tools Update, Microsoft implemented the inclusion of those with NuGet as packages. That means we can get up and running using the latest version ...
I was poking around today and found this great article on caching: http://www.cloudcomputingde... Caching is a great way to boost application performance and keep down overhead on a database or file system. Its also great when you have say 3 web roles as shown in this articles Figure 2 that can share the same cache. If one of the roles goes offline then the cache is still there and can be used. You can change out your asp.net caching to use this pretty ...
A little bit of everything... The heading above got changed a bunch during writing and I finally settled on that because this has become a 'stream of consciousness' post... or maybe a stream of UNconsciousness :) If you've noticed, my blogging has been a tad slow this fall. There's been a lot going on personally. But then again, I haven't skipped anybody either. Rather than go through ALL the blogs I have aggregated, and take a week to get to the bottom, at some point in the last year, I had moved ...
Goal: Rebuild indexes in SQL server. This can be done one at a time or with the example script below to rebuild all index for a specified table or for all tables in a given database. Why? The data in indexes gets fragmented over time. That means that as the index grows, the newly added rows to the index are physically stored in other sections of the allocated database storage space. Kind of like when you load your Christmas shopping into the trunk of your car and it is full you continue to load some ...
At http://weblogs.asp.net/scot... Scott Guthrie talks about data binding is ASP.NET 4.5.There is a key statement "Because our GetProducts() method is returning an IQueryable<Product>, users can easily page and sort through the data within our GridView. Only the 10 rows that are visible on any given page are returned from the database."Consider paging through a large dataset, this is going to give ...
SQL Server team has released the new SQL Server Data Tools CTP4. Congratulations and Thanks to Gert Drapers and his team with this great milestone. To lear more about this SSDT CTP4 Release, check: What’s new in SQL Server Data Tools CTP4?http://blogs.msdn.com/... Server Data Tools CTP4 vs. VS2010 Database Projectshttp://blogs.msdn.c... VSDB->SSDT ...
UPDATE: Thanks for the feedback and comments. I have adjusted my table below with your recommendations. I had missed a point or two. I wanted to do a series on creating an entire project using the EDMX XAF code generation and the SpecFlow BDD Easy Test tools discussed in my earlier posts, but I thought it would be appropriate to start with a simple comparison and reasoning on why I choose to use these tools. Let’s start by defining the term ORM, or Object-Relational Mapping. According to Wikipedia ...
Updated 29th June 2013: Microsoft is now previewing Load Test Service in TFS Service. Please check out more on the official offering by navigating to http://aka.ms/loadtfs Azure is fascinating, but even more fascinating is the marriage of Azure and TFS! Introduction Recently a client I worked for had 2 major businesses critical applications being delivered, with very little time budgeted for Performance testing, we immediately hit a bottleneck when the performance testing phase started, and the in ...
So I was asked today how to do cross joins in SQL Azure using Linq. Well the simple answer is you cant do it. It is not supported but there are ways around that. The solution is actually very simple and easy to implement. So here is what I did and how I did it. I created two SQL Azure Databases. The first Database is called AccountDb and has a single table named Account, which has an ID, CompanyId and Name in it. The second database I called CompanyDb and it contains two tables. The first table I ...
© 2011 By: Dov Trietsch. All rights reserved finding a person in the forest or Limiting the AD result in SharePoint People Picker There are times when we need to limit the SharePoint audience of certain farms or servers or site collections to a particular audience. One of my experiences involved limiting access to US citizens, another to a particular location. Now, most of us – your humble servant included – are not Active Directory experts – but we must be able to handle the “audience restrictions” ...

This blog post has moved:

http://gruffcode.com/2011/11/15/time-warp/

UPDATED March 24th 2016: Test Data Retention is now added to TFS 2015 Update 1, see this post for more information.UPDATED Apr 15th 2013: Corrected to VS2012 Update 2 UPDATED Mar 23rd 2012: Added information about VS 11 UPDATED Mar 21st 2012: Added info and link to VS/TFS 11 tool for getting the Test Attachment Cleaner, now included with the TFS Power Tools UPDATED Mar 17th 2012: Added sql queries for TFS 11 Beta. Changed structure after Adam’s advices. Updated information. UPDATED Jan 9th 2012: ...
Welcome back once again, in Part 1 of Load and Web Performance Testing using Visual Studio 2010 I talked about why Performance Testing the application is important, the test tools available in Visual Studio Ultimate 2010 and various test rig topologies, in Part 2 of Load and Web Performance Testing using Visual Studio 2010 I discussed the details of web performance & load tests as well as why it’s important to follow a goal based pattern while performance testing your application. In part 3 I’ll ...
This is the third of a three part series that deals with the issue of faking test data in the context of a legacy app that was built with Microsoft's Entity Framework (EF) on top of an MS SQL Server database – a scenario that can be found very often. Please read the first part for a description of the sample application, a discussion of some general aspects of unit testing in a database context, and of some more specific aspects of the here discussed EF/MSSQL combination. Lately, I wondered how you ...
In this Issue: Brian Noyes, Michael Crump, WindowsPhoneGeek, Erno de Weerd, Jesse Liberty, Derik Whittaker, Sumit Dutta, Asim Sajjad, Dhananjay Kumar, Kunal Chowdhury, and Beth Massi. Above the Fold: Silverlight: "Working with Prism 4 Part 1: Getting Started" Brian Noyes WP7: "Getting Started with the Coding4Fun toolkit Tile Control" WindowsPhoneGeek LightSwitch: "How to Connect to and Diagram your SQL Express Database in Visual Studio LightSwitch" Beth Massi Shoutouts: Michael Palermo's latest Desert ...
Performance testing is almost always conducted to address one or more risks related to expense, opportunity costs, continuity, and/or corporate reputation. But not everyone thinks their application requires investment in performance testing. We presented few of our clients who were heavily focussed on functional requirements but did not care too much about the Non-functional requirements with a short questionnaire, User’s will be happy if the website loaded in <= ___ seconds. How many extra seconds ...
Normal 0 false false false 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-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:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} My friend asked me where to ...
This is the second of a three part series that deals with the issue of faking test data in the context of a legacy app that was built with Microsoft's Entity Framework (EF) on top of an MS SQL Server database – a scenario that can be found very often. Please read the first part for a description of the sample application, a discussion of some general aspects of unit testing in a database context, and of some more specific aspects of the here discussed EF/MSSQL combination. Lately, I wondered how ...
For good or bad, Microsoft’s Entity Framework (EF) has become one of the most widely used ORM tools out there. While some may state that it's not among the better ones (or that it's not even a real ORM), it’s definitely the most convenient one: its Visual Studio integration and consequently its integration with the MS SQL Server database is unparalleled. This is especially relevant to people who haven’t used the concept of object-relational mapping before - there's almost no initial learning curve ...
The Distinguished Field is often seen as the weaker of the two types of Fields when handling Fields in BizTalk. After all, the Distinguished Field can’t be used as a filter on a message, and it’s slower than its big brother the Promoted Field. Well, today I’m here to dispel the myth of the wimpy Distinguished Field and place in the pantheon of power that equals, and in some ways exceeds the Promoted Field. MYTH: Getting the value of a Distinguished Field requires loading the entire message into memory. ...
Sometimes you just wish Exchange would not act as a total baby! I worked on a case today which had 2 Exchange 2010 servers in a DAG with about 6 mailboxes, all in healthy status. All but one that is. This DataBaseCopy just would not come back into sync and was stuck in the eternal Resynchronizing loop from hell. So our client cried for help. First thing you would want to do is to get a status of the database by running get-mailboxdatabasecopystatus -id "databasename\servername" | fl. This should ...
Once the installer for the AdventureWorks Community Sample Database has finished, we then need to complete the process (not mandatory, but nice to do to play with the OLAP content). The first thing we need to do is make sure we note the location of the script files and samples. The path if you are working with SQL Server 2008 R2 is as follows: “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\Ad... 2008R2 Analysis Services Project\enterprise” I am working with the developer edition, ...
If you develop applications in SQL Azure, you may end up in a situation where your code needs to know if it is operating in the root database or in a Federation Member, or if it is connected to a regular user database. Two ways can be used to make this determination: using system tables, or using the USE FEDERATION command. Using System Tables This approach is the easiest to implement since it relies a SQL call only, without much logic in your application code. Assuming your code is currently connected ...
Structurally, I have 3 projects, the site, the EF database and the randomizer. The randomizer uses entities from the EF database, so all is good on that front. So, first cut, add a method to my Controller called Randomize, which takes in one of the EF entities: public ActionResult Randomize(TableB tableB) { /*...*/ } I’ve even given it an [HttpPost] attribute, now, I’m not anyway sure this is right, time will tell right? Anyhews, simple method: [HttpPost] public ActionResult Randomize(TableB tableB) ...
I recently had a need to create a send port that could output a flat file but I could not determine which flat file schema to use at design time. Or at least I didn’t want to. I wanted to process multiple flat file formats with the same orchestration process and output with the same send port. I have my orchestration dynamically mapping the document to the appropriate flat file document schema. The generated orchestration message type is set to System.XmlDocument so the orchestration can handle the ...
The following is my experience with SSIS building: Make sure you understand the 3 modes of Lookup. General, I would only do full cache if the lookup table only return less than 200 rows Never use the table or view select unless you really need every field on that table or view. select * from a data source will break in the future if more columns are added to the table select * in a lookup brings back unnecessary fields and impact performance Never use "Sort" in SSIS unless it's absolutely necessary. ...
In order to refresh your OLAP Cubes (SQL Server Analysis Services), you need to create XMLA files. These XMLA files can be used in a SQL Server Agent Job, so that the Cubes are refreshed and re-processed. To accomplish this, you need to follow the next steps: 1) Deploy your Cube to your SQL Server 2) Right click on the database, and choose “Script database as” –> “Alter To” 3) Add the following node to the top of the XML: <Batch xmlns="http://schemas.micro... ...
Goal: Rename a database table or column name using a t-sql stored procedure. How to: Rename a table: EXEC sp_rename 'TableToBeRename', 'NewTableName' Rename a column: EXEC sp_rename @objname = 'TableNameColumnToBeRenamed, @newname = 'NewColumnName', @objtype = 'COLUMN' ...
“Because everyone wants to kick their database, but sometimes kicking your database is a good thing!” Many would not argue that you should version your code, and few would argue against versioning your code in a way that can lead back to a specific point in source control history. However, most people don’t really think of doing the same thing with your database. That’s where RoundhousE (RH) comes in. I have been working on RH for over two years now and people always wander what it is, why and what ...
Every ones in a while you want to know the record count of all objects in your database. If you have 10 objects or less in your database, you can choose to type out the statements yourself, but once it’s more then that it gets quite annoying. Because I needed this for a production issue (make sure that all objects contain records after import) I wrote a cursor to query all the database objects, and count the content of it: USE Sandbox --=========================... ...
Here I will explain how to get the column names and corresponding datatypes in particular table using SQL Server. Description: I have one table with lot columns in database at that time I tried to know the column names and corresponding datatypes and their maximum sizes in particular table for that I written the following query in SQL server to get column names and datatypes in particular table. USE MySampleDB GO SELECT column_name 'Column Name', data_type 'Data Type', character_maximum_length 'Maximum ...
Next month is Prairie Dev Con Winnipeg. This is the first time the conference has come to Winnipeg and I'm really excited to be a part of it again. I've spoken at both of the previous PrDC's in Regina, and have 2 slots at the Winnipeg conference. The conference is Nov 21-22 and there are still registrations available, so if you haven't registered yet I encourage you to do so: http://www.prairiedevcon.com/ Here's some details on the 2 sessions I'm hosting: Evolve Your Code: Fundamental Design Principles ...
BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls A recent project that I was working on required that I take an incoming flat file, containing multiple transaction records, and load these transactions into a database. Within the source file were multiple instances of any of seven transaction types. The database had a separate table for each transaction type, each with its own stored procedure for inserting a record. So thats seven transaction types and seven ...
I have been developing an MVC3 application with the intention of deploying to the Cloud. It was configured to use Forms Authentication with SQL Membership on SQL Azure. Everything seemed to be working perfectly locally, but after I deployed the Membership.ValidateUser no longer seemed to work. I could use the Providers to get information from the database (e.g. Membership.GetUser would return an existing account) which meant the database connection was fine and user existed, just the validation failed. ...
If you are planning to deploy your application with SQL CE as your application backend then here are the steps you need to perform. If you’re planning to deploy your application with SQL Server, than please read this post, How to Deploy an ASP.NET MVC 3 App to Web Hosting with "\bin Deployment" I assume that you have your ASP.NET MVC 3 application ready to be deployed with SQL CE 4.0 and EF 4.1. But make sure you have add assembly and for SQL CE 4.0 using NuGet. I recommend you to use NuGet here ...
Today post will show you how to build an Ajax form with JQuery validate supporting (unobtrusive) client and server side validation using ASP.NET MVC 3. If you want to see an examples, you can visit this post about Ajax in ASP.NET MVC 3. To enable (unobtrusive) client side Ajax and validation support include the following JavaScript files (in Views/Shared/_Layout.cshtml): javascript" src="@Url.Content("~/Script... <script type="text/javascript" src="@Url.Content("~/Script... ...
Ok, I think this is the coolest contest I have seen. Red-Gate is sending a DBA to Space! If you have mad SQL skills, you should definitely look into this contest. More Information: Red Gate, a U.K.-based software company, has launched a campaign that will reward a database administrator (DBA) with the ultimate getaway: a seat on a commercial flight into space, courtesy of Space Adventures, Ltd But first, DBAs must unravel a Gordian knot of a plot involving morphing Martians, pets in peril, alien ...
I got this error today while trying to access my new SharePoint 2010 environment via PowerShell: Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again. If I would have just read the error message a little more carefully, I would have realized that I should start by looking at my permissions in SQL – which my account didn’t. This happened because I installed SQL ...
Goal: Find the business days; i.e. exclude weekends How to: Here is some code to get the first business day after or before the weekend. It is surprisingly simple but thought the code may help save folks some time. Just a note that there is no built-in .Net feature to give you public US or other holiday calendar dates, you need to build your own using a table to keep track of public holidays in most situations. Simple enough to do, extend the methods below to query a database or xml or JSON, etc, ...
Normal 0 false false false EN-GB X-NONE 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-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; ...
In the recently concluded WebCamps, Delhi, I was demonstrating Facebook Authentication implementation for your website using WebMatrix 2 Beta. You can read about my earlier post on WebMatrix 2 Beta from here Using the new WebMatrix 2 Beta, we can create a decent looking starter site with a few clicks as explained in my above post. Once we have the site up and running, we would want to implement authentication. Now, like ASP.NET 4, ASP.NET MVC 3 etc., WebMatrix comes with default Membership infrastructure. ...
Introduction To save on hosting costs and simplify maintenance, Software as a Service (SaaS) providers typically rely on schema separation to host multiple customers' records. This implementation relies on a specific SQL Server and SQL Azure feature called a schema object. A schema object behaves like a container, or a namespace in programmatic terms, allowing multiple tables (and other objects) to be stored with the same name in a single database. However schema separation comes with its own set ...
In this Issue: AfricanGeek, Andrea Boschin, Colin Eberhardt, Anoop Madhusudanan, Lee, Laurent Bugnion, Rudi Grobler, Xianzhong Zhu, Jesse Liberty, Asim Sajjad, Dhananjay Kumar, XAMLNinja, and Kunal Chowdhury. Above the Fold: Silverlight: "Develop a Flexible 2.5D Scene Editor Targeting Silverlight RPG Games - Part 2" Xianzhong Zhu WP7: "A Windows Phone 7.1 (Mango) MVVM Tombstoning Example" Colin Eberhardt Metro/WinRT/Windows 8: "Consuming WCF Service in Windows 8 XAML/C# metro application" AfricanGeek ...
I was experiencing the below error message. While searching the internet and poking around on my SharePoint farm for a possible solution to the error i was able to find the below solution. Error: The mount operation for the gatherer application [GUID] -crawl-0 has failed because the schema version of the search gatherer database is less than the minimum backwards compatibility schema version supported for this gatherer application. The database might not have been upgraded. Solution: Go to the Central ...
This example is not covered in the ESB Toolkit samples and I bumped my forehead a few times while making it work. I thought it’d be helpful to save other fellow BizTalk'ers from headaches by publishing findings. I have been fun of dynamic generic messaging for quite a while and went long ways to avoid working with typed messages and static bindings when it made sense. Nowadays, with the ESB Toolkit one does not have to spend much effort to achieve this goal. But one has to learn intricacies of configuration ...
If you're working with large chunks of data, eventually you'll probably use a foreach loop to iterate through an enumerable data source and execute the same actions on each item (for example, do something to every DataRow in a DataSet). With the new Task Parallel Library (TPL) in .Net 4 you can execute these loops in parallel for a noticeable improvement in speed. .Net has had support for parallel programming since the 1.0 version, but the developer had to do (sometimes...) extensive work to create ...
In this Issue: Peter Kuhn, Scott Hanselman, David Anson, Kunal Chowdhury, Beth Massi, Rajat Jaiswal, MIke Ormond, WindowsPhoneGeek, Xianzhong Zhu, Jesse Liberty, Derik Whittaker, Morten Nielsen, Sumit Dutta, Asim Sajjad, and Dhananjay Kumar. Above the Fold: Silverlight: "How To Use DataTriggers In Silverlight DataGrid" Dhananjay Kumar WP7: "Windows Phone eBook 1st Edition Published" MIke Ormond LightSwitch: "Filtering Lookup Lists with Large Amounts of Data on Data Entry Screens" Beth Massi Windows ...
I had written earlier about the WebMatrix v2 Beta release that happened recently at the BUILD Conference As I had mentioned earlier, WebMatrix is a light weight tool for Web Development, Profiling, Database management, Optimization and also deployment. Its an end to end tool for web developers. Web Matrix is different from Visual Studio in the sense, it doesn’t require web developers to master C#, ASP.NET and other programming techniques. Web Matrix uses a simple Razor syntax and HTML markup for ...