Blog Archives

Tip to optimize SQL Queries

Identification of the problem. Some days ago, a customer call me to try to solve a performance problem into an existing application connected to SQL Server. Using SQL Server Profile, we found some queries with unexpected times. For example, to

Posted in General, SQL Server, SqlDatabaseCommand, Tips and others

Retour d’expérience ‘TFS Online dans une solution industrielle’

frenSome days ago, I had the chance to present a session in the Microsoft Experiences of Paris (in french) to explain how we’ve created a complete industrial application using VSTS (Visual Studio Team Services… or TFS Online). In this presentation,

Posted in francais, General, Presentation, Team Foundation Server, Visual Studio

Configure a Visual Studio Online (VSO) Build Agent

When using Visual Studio Online (VSO) in your team or for your personal projects, it is very useful to integrate a compilation and a continuous deployment process. With MSDN subscriptions, you have about 240 minutes of hosted build. After this time, it’s

Posted in General, Team Foundation Server, Tips and others, Visual Studio

Simple Object Mapping Toolkit

A few days ago, I talked about an interesting topic when developing applications that require frequent access to databases (eg. SQL Server). Many frameworks are existing to connect your Business Layer to a Database : the best known is often Entity Framework.

Posted in General

Introduction to SqlDatabaseCommand

Since some years, I’ve tried to write some performing SQL Queries but also with easy way. In the .NET beginning, I’ve tried System.Data.SqlClient with DataAdapter and DataSets. Next, I’ve tried the Linq to SQL project. And next, I’ve tried Entity

Posted in General, SQL Server, SqlDatabaseCommand

Visual Studio Online: The Application LiveCycle Management (ALM)

Introduction An ALM solution allows companies to easily manage all of the life cycles of the applications developments. One of the big advantages is to reduce time cycles of designing applications, to integrate development and testers teams and more easily

Tagged with: , ,
Posted in General, Team Foundation Server

How to restore a SQL Server Database to a new location and name

This post explains how to restore a full database backup to a new location and with a new name. This procedure enables you to move a database or create a copy of a database on either the same server instance

Tagged with: , ,
Posted in General, SQL Server, Tips and others
Follow me
   RSS Feed    Twitter    Linked In

Write you email address to subscribe at this blog and to receive new posts by mail.

Join 611 other followers

Who I am?