To create a password, stay paranoid and trust no one. This page you can copy it and run offline to create new strong password. You can check your password. This source to create password is nice, but they force you to use their web site, you can “not” copy it. http://passwordsgenerator.net/
Script pour créer un script de création et manutention de messages d’erreur. Il y a de scripts sur l’internet qui peut vous aider, mais ces scripts ne sont pas “Safe to run”. Sources : https://msdn.microsoft.com/en-us/library/ms178649.aspx http://sqlmag.com/blog/migrating-custom-error-messages-between-servers 1 2PRINT...
Save this script on batch file, update server list, and run. 1 2echo off 3cls 4echo computerName1 > computers.txt 5echo computerName2 > computers.txt 6echo computerName3 > computers.txt 7echo computerName4 > computers.txt 8FOR /F %%A IN (computers.txt) DO ( 9 10 echo ------------------------------------------ 11 echo...
We have same SQL Scripts to try to find out about what it happens when we have or had deadlocks. Get current running commands. Create event to find blocked processes and deadlocks. Sources : Deadlocking https://technet.microsoft.com/en-us/library/ms177433%28v=sql.105%29.aspx How to isolate the current running commands...
Migrer une base de données vers un nouveau serveur est assez simple… si… Il y a seulement une base de données; Il n’y a pas des objets à migrer; Il n’y a pas de dépendances physiques; Alors, le SQL script proposé fait une partie du processus : Ferme toutes les connexions vers la base de données à migrer; Restreins...
This page is created from HTTP status code information found at ietf.org and Wikipedia. Click on the category heading or the status code link to read more. 1xx Informational# This class of status code indicates a provisional response, consisting only of the Status-Line and optional headers, and is terminated by an...
Alors, cela peut être pratique quand l’on peut avoir un lab. Créer de virtuelles machines sans avoir le souci d’activer ou non les logiciels Microsoft. Downloads: 2.6 BETA 5 EXE MD5: EA54A3ED8C40AA405B9645C166137318 EXE SHA-1: C4DE105BC0D4DEBF2EAB7563FC3127F6677A43C3 Torrent: Download Site d’origine :...
source : https://raw.githubusercontent.com/coodict/javascript-in-one-pic/master/js%20in%20one%20pic.png
This article is nice ( we have a little bug ) , and the SQL script is not execute-safe (if you run twice, you have errors ). It is for a specific database, when you need to save all SQL Server, you must run for each database. 1 2PRINT '-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --' 3PRINT '-- SQL Security...
Script to create script to copy data from two datatable when tables are equal. This code is very useful when partially we save data.We can delete data after some date but we must have a column date. Read the conditions to run this script. 1 2------------------------------- 3-- Script to create script to copy datatable...
A minimalist, opensource online pastebin-like where the server has zero knowledge of pasted data. Data is encrypted/decrypted in the browser using 256 bits AES… http://sebsauvage.net/wiki/doku.php?id=php:zerobin with so many features BUT without QR Code. We can be sometime lazy to type URL on “Smartphone”, but the...
Transform table definition to XML select, it can be useful when we need to create many XML select or re-create it. Result: 1 2SELECT 3 [Message].value('(msg_Customers/Customers/CustomerID)[1]', 'nchar(5)') as [CustomerID] 4, [Message].value('(msg_Customers/Customers/CompanyName)[1]', 'nvarchar(40)') as [CompanyName] 5,...
We have many ways to obtain the size of all tables using SQL Server. This is a nice solution but we do not really need to use temporary table. http://therightstuff.de/2007/11/19/How-To-Obtain-The-Size-Of-All-Tables-In-A-SQL-Server-Database.aspx If we run the script twice, we have an error. Well, this version uses a...
REST is an architectural style for designing networked applications. It is an alternate to using complex mechanisms like COBRA, RPC, and SOAP to connect between client and server. REST makes communication between remote computers easy by using the simple HTTP protocol which support for CRUD (Create, Read, Update, and...
Ce code vous permet d’ajouter une référence à une bibliothèque spécifique en temps d’exécution. C’est très utile quand on partage les classeurs entre différentes versions d’Excel. J’ai vu cette page : http://www.vbaexpress.com/kb/getarticle.php?kb_id=267 On a toujours les «MAIS ». Mais, comment peut-on trouver le GUID?...
Créer le même code à adapter à chaque table selon les champs et le type. Cela peut être une activité assez plate. On peut créer un code qui crée notre code. Peut-on appeler une métacreation, ou métacodification, mais, peut-être, il n’existe pas ce mot en français. Alors, ce SQL script nous liste les champs de tables,...
SQL Server does not help to easily determine the dependencies between tables. This research presents the parent table and the child tables and columns used. https://msdn.microsoft.com/en-us/library/ms179610.aspx http://stackoverflow.com/questions/925738/how-to-find-foreign-key-dependencies-in-sql-server well, however,...
Existe enumeras maneiras de baixar musicas do youtube. Metodo zero instalação: Não precisa instalar nada. O processo se resume em copiar o endereço do video e usar um site que converte o video para ser baixado. http://www.youtube-mp3.org/ Estes outros sites funcionam basicamente da mesma maneira. http://savedeo.com/...
Après restaure la base de données MS SQL, il est possible que certains utilisateurs de la base de données soient orphelins. Alors, voici les SQL scripts pour les réparer. Répare tous les utilisateurs orphelins de toutes bases de données: 1 2DECLARE @sql as nvarchar(max); 3SET @sql = ' 4USE[?];PRINT''Database:...
Sometimes I want to have control over a SQL Server database, but always some connection blocks. We can use this 1 2USE MASTER; 3ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE; BUT, sometime, we cannot do it! Well, we have this solution… 1 2SET NOCOUNT ON; 3DECLARE @ToKill AS NVARCHAR(max); 4SET...