2018-02-19

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 ...
Posted in SQL Server, Tips and othersLeave a Comment on Quick tip about SqlCmd.exe 13

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 ...
Posted in General, SQL Server, SqlDatabaseCommand, Tips and othersLeave a Comment on Tip to optimize SQL Queries

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 ...
Posted in francais, SQL Server, SqlDatabaseCommandLeave a Comment on Développer avec un Simple Object Mapping Toolkit pour SQL Server

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 ...
Posted in General, SQL Server, SqlDatabaseCommand2 Comments on Introduction to SqlDatabaseCommand

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 ...
Posted in SQL ServerTagged ,Leave a Comment on Backup all databases in Microsoft SQL Server

SQL View to search in all columns of all tables

Often, I need to search a column name in a database… but I’ve not the table name. If you are like me, this SQL View ...
Posted in SQL Server, Tips and othersTagged Leave a Comment on SQL View to search in all columns of all tables

SQL Server Nested Triggers

This is my first post in English… so 😉 In our current project, we developed many SQL Triggers (on each tables). We diagnosed than when ...
Posted in SQL Server, Tips and othersTagged ,4 Comments on SQL Server Nested Triggers