Tag | server Posts

A very intriguing issue came to me to debug .Net code called from X++ code in AX 2012. This was indeed a challenge to be nailed down. Luckily the tools and some concepts helped me to achieve this task. Here it goes... We need to do a seamless debugging from AX debugger to Visual Studio back and forth. To enable this we need to first see if the dll to be debug is present in GAC then we might need to uninstall it from it due to the order of preference .NET loads the assemblies. The assemblies are first ...
If you are on a desktop version of Ubuntu, you can right-click on the file icon, click the permissions tab and click on "allow execution". If you are on a server copy without the desktop bells and whistles (or you would rather work with a command line in a terminal window), then do the following: sudo chmod +x myProgram.bin after you enter your password and get the prompt back type: ./myProgram.bin ...
I was listening to .NET Rocks episode #713 and it got me thinking about a number of SharePoint related topics. I have been working with SharePoint since the 2001 product came out and have watched it evolve over the years. Today SharePoint is one of the most powerful and flexible products in the market. Of course that doesn’t mean there isn’t room for improvement (a lot of improvement in fact) and with much power comes much responsibility. My main gripe these days is that you have to develop on a ...
Problem Normally I try to have my continuous integration as most a possible toolset free to ensure that no local stuff could have an impact to my build. My Silverlight app references a special compile target in a folder outside my developer tree: <Import Project="$(MSBuildExtension... /> So I copied the stuff from this folder to a local one and changed the call to this target in my csproj: <Import Project="..\..\..\tools\Web... ...
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 ...
The problem: Images and other static files will not be cached unless you tell it to. In IIS7 it is remarkably easy to do this. Web pages are becoming increasingly complex with more scripts, style sheets, images, and Flash on them. A first-time visit to a page may require several HTTP requests to load all the components. By using Expires headers these components become cacheable, which avoids unnecessary HTTP requests on subsequent page views. Expires headers are most often associated with images, ...
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 ...
Problem Normally PostSharp runs fine on unattended build servers. So on our global Jenkins continuous integration server PostSharp does the job. But on my local TeamCity continuous integration server I got the following error: POSTSHARP error PS0127: The aspect 'EsriDE.Commons.Logging.Aop... uses non-licensed features (Basic Features). Please visit http://www.sharpcrafters.com/ to acquire a license of PostSharp. POSTSHARP error PS0154: Information regarding the previous ...
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 ...
The first of the build guides just got published! And you can find it in the "Build Guide" section or by following link: Click here... Exerp: In this first part of the build guide series we look at building a Microsoft Windows 2008 R2 server. Whilst installing the basic operating system on a server is fairly straightforward it is as good a place as any to start as we lay the foundations for the rest of our infrastructure. In future parts of this series we will look at automating this install as much ...
Problem Our global Jenkins continuous integration server throws this error during compile step. My local TeamCity continuous integration server runs fine. What is the difference. Background I integrate some static code analysis steps via MSBuild-targets in the csproj files. To allow a fast developing without a code analysis for ever compiling I bound these targets only to RELEASE-configuration. With the MSBuild element <ImportGroup> only one condition must be specified. So my construct was: ...
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 ...
Problem A continuous integration server should only have a minimal toolset installed. This ensures that no unwanted libraries could affect the build and other steps. Clearly that with this slogan also StyleCop should not be installed to the CI server. But we wanna have this analysis as an part of the whole build. Solution Prerequisites First at all we need the necessary files from StyleCop (the core assemblies and the target). The easiest way is to download the MSI of StyleCop, install the software ...
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 updates are installed, all you want to do now is get connected, authenticated and get going. The first step needed here is to open Visual Studio 2010, once opened then you need to get to Team Explorer. Once there, you will click on the Connect to Team Project button on the toolbar. If you had a connection defined to another TFS environment, this will be adding one more, so you click on Servers… On the next dialog, you will click on Add… Then you will proceed to provide the details of your Team ...
Once you have configured your online preview, then you can proceed to connect to it using Visual Studio 2010. In order to get Live ID authentication working and such, there is an update you need to apply. This is something that can be accessed through the Administration page, and then clicking on download software. Clicking on that link will take you to the Visual Studio ALM + Team Foundation Server Blog. From this page, you will be able to download the needed component to connect and authenticate ...
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. ...
Normal 0 false false false EN-US 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: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... mso-ascii-font-family:Calibri; ...
If you want to debug your custom pipeline component you can make use of the Pipeline.exe utility to do this: Set the breakpoint in your Custom Pipeline Component code in Visual Studio. On the properties page of the project containing your Custom Pipeline select the Debug tab. Set the “Start Action” property to "Start external program" and then type or browse to: {Installation Location}\Microsoft BizTalk Server 2010\SDK\Utilities\Pipeline... For the "Start Options > Command line ...
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 ...
In SQL Server 2008 you can use table valued parameters which can be pretty useful. In the example I use a very simple one to overcome SQL Server’s lack of having a parameter as an array. The example goes through creating the new type, using it in a stored procedure and calling it from an application (VB.Net in this example). You start off with creating the new type. Under Programmability/Types/User-... Table Types create a new table. Here I created a table with a single column to hold an integer. ...
One of the cool things about HTML5 is the ability to play audio/video files out of the box without the dependency on plugins. Earlier I had written about HTML5 Video and the fallback using Silverlight for non-supported scenarios Visual Studio 2010 SP1 has decent support for HTML5, in terms of intellisense, validation etc., But, one issue that is constantly faced when using the HTML5 Video tag in an ASP.NET Application (Web/MVC) built using Visual Studio is that, the videos doesn’t play when running ...
Normal 0 false false false EN-US 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: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... mso-ascii-font-family:Calibri; ...
In this all-submittal post-"GoLive" 3 week marathon Issue: Vikas, Rene Schulte, Ollie Riches, Alex van Beek, Kevin Dockx, Michael Crump(-2-), Michael Washington, Antoni Dol, Colin Eberhardt(-2-, -3-), and Lazar Nikolov. Above the Fold: Silverlight: "Paging Data from the Server with Silverlight" Colin Eberhardt WP7: "Tessellating shapes on top of Bing Maps in a WP7 app" Ollie Riches LightSwitch: "Creating a Minimal LightSwitch Shell" Michael Washington Metro/WinRT: "Photoshop in METRO style" Antoni ...
I wanted to have a VM that I could access remotely and thought why not take advantage of the VM role. So I just documented my steps, for those of you might be interested, but more importantly for myself, if I have to do this again. the server image that is used for the VM role in windows Azure consists of a base VHD and may or may not have differencing VHD. to create the base VHD you can use Hyper-V Manager. Creating the Base VM image In Hyper-V manager connect to your server , right-click the server ...
If you work with SQL Server you will eventually encounter a JOIN statement. This JOIN statement can be stated as an ordinary JOIN, or as a sub select. In most cases I try to use JOINS (even though it’s just for readability), but in some cases it’s quicker to do it in a sub select (for example with production code, in which you don’t want to change the output but filter output). Curious about the performance differences between the two, I tried to create a test. I created 2 tables with country information: ...
For a full explanation and step-by-step guide to setup a linked server through Sql Management Studio (SMS), check out this reference: http://www.databasejournal.... Here it is in a nutshell: If you are setting up a linked server for another sql server 2005/2008 box, just remember to (1) name the Linked server the same name as its network name, (2) select and provide under the security option ,"Be made ...
On CodePlex there is a new project at http://nsession.codeplex.com for sharing session state between classic ASP and ASP.NET "The objective of this project is to allow ASP Classic to access ASP.NET out-of-process session stores in the same way that ASP.NET accesses them, and thus share the session state with ASP.NET. In the initial release, we only support the ASP.NET state server as it is a popular choice and it offers better performance than the SQL Server session store. Please see the Documentation ...
Sometime ago, say around mid April, 2011 I posted about Installing SharePoint 2010 on Windows 7 by going in a different path than using the standalone installation. This post is about what happens after the installation and initial configuration of your Windows 7 “development farm” gets the bits, and goes through the Central Admin and management perspective to get you to the first screen that says “Hi, SharePoint here, would you like to play a game of chess” (yeah, it does not really say that, but ...
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, ...
For a while now, if we have been around SQL Server we got used to the different sample databases that were provided. From Pubs to Northwind to AdventureWorks. In order to get the AdventureWorks samples we need to go to CodePlex and download the one that corresponds to the version of SQL Server we are working with. The link to the download site here : http://msftdbprodsamples.co... Now, on to the installation. Once you download the appropriate file, double click and launch ...
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... ...
UPDATED Jul 3rd 2013: Added Art of Unit Testing Version 2 UPDATED Apr 11th 2013: Added Instant TFS 2012 and Project Server 2012 Integration How-to UPDATED Jan 12th 2013: Added Prof TFS Server 2012, TFS 2012 Starter, Pro ALM with VS 2012 and VS 2012 Cookbook UPDATED Dec 8th 2011: Added Kanban book by David Anderson “Send me a list of books to read” – that is what I am often asked. No more, as this list is an answer to those request! I have divided it into different subject areas, and each area hold ...


This post has been moved to my new blog.

The new URL is: http://dwdii.github.io/2011/10/23/Using-HTML5-Canvas-tag-for-Simple-Video-Animation.html.

Unfortunately, I am unable to redirect you automatically due to limitations of this blogging engine. :-(
DropkicK (DK) has been in development for over two years and has been used for production deployments for over a year. Dru Sellers originally posted about DK back in 2009. While DK isn’t yet as super easy to grok as some of the other ChuckNorrisFramework tools and offers little in the idea of conventions, it is still a stellar framework to use for deployments. DK works well in environments where you know all of the environments you will deploy to ahead of time (although not required due to the ability ...
SSRS is a wonderful tool for quickly retrieving data from many different data sources and presenting the data to the user at a run-time decided format. One area where SSRS often falls short is when the underlying data needs to come from several different sources. Perhaps we want to retrieve data from the General Ledger which is in Oracle, and join that against a list of departments and employees which are stored in SQL Server for us to display in one table. When this happens, we are unable to join ...
“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 ...
Recently I looked at a performance problem when transferring image data from a custom HttpListener to web browser clients. In the end it came down to one change I had done which was writing the image data to a memory stream first – this was required so I could add the right content-length header to the output based on the actual image size which some of my clients required. Before this change I had directly written the image to the output stream when it was generated but the modified code looked ...
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 ...
NuGet is a topic that I have been hearing about for a while, especially from Clark Sell. I figured it was about time to take a dive into it and see what it was all about. The description of NuGet makes it seem like magic to add dependencies to your code projects. Of course there is always an explanation for how the trick works. In this case it is by using a package and a definition of how resources should be added to your project. One of the interesting aspects of using NuGet is the UI. The fact ...
For (almost) all developers, there’s no greater feeling, then knowing your source code is (relatively) safe. The same counts for T-SQL script. Especially if you know that you need the same code next year (argh). So first thing I did after the initial release of scripts, was looking for a way to check-in T-SQL from SQL Server Management Studio (SSMS). So a colleague of mine, Dries (Blog | Twitter), dropped by with a solution: TFS MSSCCI Provider 2010 from the Visual Studio Gallery. It’s a free plugin ...
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 ...
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... ...
Last week, at the PASS (Professional Association for SQL Server) Summit in Seattle, Microsoft held a coming out party, not only for SQL Server 2012 (formerly “Denali”), but also for the company’s “Big Data” initiative. Microsoft’s banner headline announcement: it is developing of a version of Apache Hadoop that will run on Windows Server and Windows Azure. Hadoop is the open source implementation of Google’s proprietary MapReduce parallel computation engine and environment, and it's used (quite widely ...
ASP.NET view state, in a nutshell, is the technique used by an ASP.NET Web page to persist changes to the state of a Web Form across postbacks. View state has caused the most confusion among ASP.NET developers. When creating custom server controls or doing more advanced page techniques, not having a solid grasp of what view state is and how it works can come back to bite you. Web designers who are focused on creating low-bandwidth, streamlined pages oftentimes find themselves frustrated with view ...
I've wrote this article a few months ago but in Portuguese: http://pontonetpt.org/blogs... I've decided to translate it to engish. The sample project is hostead at GitHub but it's in Portuguese (the same as my first article). Link Github: https://github.com/guilherm... I've been progamming with unit testing and test-driven developement in use for server-side for 2 years. On the last months i've been working ...
Yesterday, I just posted about How to Fix error: 26 - Error Locating Server/Instance Specified Well, this is an error message that we can find too "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)" I struggle to find what is the problem. ...
I'm a big fan of automated testing which actually proves something. Unit tests may prove all the components in a solution work independently, but that doesn't mean you have a working solution. Integration tests give you confidence in the whole solution, but the cost of having a test suite with a lot of external dependencies is the risk of false build failures and long-running test suites. To get something in between, we have acceptance tests written in SpecFlow which run tests at the highest layer ...