Blog Archives

Quick tip about SqlCmd.exe 13

Some days ago, I’ve installed Visual Studio 2017 and today, I’ve try to execute a simple SQL query with SQLCMD.EXE. What’s the problem ? No really one… except that I’ve received an “ODBC Driver 13 for SQL Server” error and “Login

Posted in SQL Server, Tips and others

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

Développer avec un Simple Object Mapping Toolkit pour SQL Server

La majorité des applications actuelles ont besoin d’enregistrer des informations dans une base de données locale ou serveur. Plusieurs outils existent dont Entity Framework, le plus fréquemment proposés par Microsoft, ou ADO.NET, le plus performant mais le plus complexe à

Posted in francais, SQL Server, SqlDatabaseCommand

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

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

Backup all databases in Microsoft SQL Server

Find here, a cool SQL script to backup all SQL Server databases. Of course, you can put it in a Scheduled Job to execute each night.

Tagged with: ,
Posted in SQL Server

Enable TCP/IP Remote Connection on SQL Server 2008

Introduction Whenever I use a physical or a virtual machine containing SQL Server, I do not know easily create a SQL remote access to the server. By default, SQL Server Express doesn’t allow remote connection, but sometimes, a classic SQL

Tagged with:
Posted in SQL Server
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?