Easy way to convert a generic objet to xml string and xml string to generic object.

public static string Serialize<t>(T xml);

public static void Deserialize<t>(ref T obj, string xml);

Lire la suite de C# Generic Convert XML to Object

How can we send email by sql script ?

To enable Database Mail XP

USE msdb;
GO
EXEC sp_configure 'Database Mail XPs'
GO
RECONFIGURE
GO
EXEC sp_configure 'Database Mail XPs', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Database Mail XPs'
GO

To configure database mail

USE msdb
GO

DECLARE @ProfileName VARCHAR(255)
DECLARE @AccountName VARCHAR(255)
DECLARE @SMTPAddress VARCHAR(255)
DECLARE @EmailAddress VARCHAR(128)
DECLARE @DisplayUser VARCHAR(128)

SET @ProfileName = 'DBMailProfile';
SET @AccountName = 'DBMailAccount';
SET @SMTPAddress = 'smtp.server.com';
SET @EmailAddress = 'myemail@email.com';
SET @DisplayUser = 'Myname Noname';

EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = @AccountName, @email_address = @EmailAddress, @display_name = @DisplayUser, @mailserver_name = @SMTPAddress

EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = @ProfileName

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp @profile_name = @ProfileName, @account_name = @AccountName, @sequence_number = 1;

--Now that everything is setup, I will send a test e-mail.
EXEC msdb.dbo.sp_send_dbmail @recipients = N'myemail@email.com', @body = 'Test Email Body', @subject = 'Test Email Subject from SQL', @profile_name = 'DBMailProfile'

On a besoin *parfois* de connaitre ou avoir la liste de toutes les tables et les colonnes

Ce script crée une table avec toutes définitions.

ex:

select * from _text_table_dictionary
where Datatype = 'datetime'

Lire la suite de Table dictionary

How convert a text to a Title text with TSQL. It's "easy" solution.

Lire la suite de Convert a text to a Title

Golden rule of computer security: If a hacker has physical access to a computer, nothing can stop him!

“With great power comes great responsibility” ― it was not me!

Lire la suite de A tutorial on how to get into an admin account on Windows 7.