Disable database triggers in Microsoft SQL databases

If you need to temporarily disable triggers in Microsoft SQL databases during database maintenance use the following script –Disable triggers on all tables DECLARE @enable BIT = 0; DECLARE @trigger SYSNAME; DECLARE @table SYSNAME; DECLARE @cmd NVARCHAR(MAX); DECLARE trigger_cursor CURSOR FOR SELECT trigger_object.name trigger_name, table_object.name table_name FROM sysobjects trigger_object JOIN sysobjects table_object ON trigger_object.parent_obj = […]

 Go to post page

April 29th, 2016 by Laszlo Pinter

Disable foreign key constraints in Microsoft SQL databases

Databases do not allow the deletion of rows if those are referenced in other tables with the foreign key constraint. You can turn off the validation of foreign keys in Microsoft SQL databases for the duration of the maintenance with the following script. –Disable foreign keys on all tables DECLARE @table_name SYSNAME; DECLARE @cmd NVARCHAR(MAX); […]

 Go to post page

April 29th, 2016 by Laszlo Pinter

Free Windows Virtual Machines for all major Internet Explorer versions by Microsoft

Microsoft published free Windows virtual machines for every major Internet Explorer version for multiple virtualization platforms. https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/windows/

 Go to post page

April 15th, 2016 by Laszlo Pinter

Display the branch structure and other important events in the Git command line interface

To set up the display of the branch structure, tags and pulls in the command line interface first create the following “alias” git config –global alias.lgb “log –graph –pretty=format:’%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset%n’ –abbrev-commit –date=relative –branches” To display the branch structure, execute the following “alias” git lgb This will execute the above defined “alias” […]

 Go to post page

January 1st, 2016 by Laszlo Pinter

Include PBD files in ClickOnce deployment to show the line numbers in the Stack Trace

If there is an error in an application, the line numbers are only included in the Stack Trace when the PBD files are also in the application directory. To include the PBD files in an application that was distributed with ClickOnce deployment you need to: Right click the main project and select Properties On the […]

 Go to post page

December 16th, 2015 by Laszlo Pinter

How to get rid of the boring unwanted picture in Skype

Since Microsoft purchased Skype there is an annoying, unwanted advertisement on the main page. If you are tired of seeing the same boring picture every time you turn on Skype In the Tools menu select Change language, At the bottom of the list click Edit Skype Language File, In the Language File Editor click Save as […]

 Go to post page

November 14th, 2015 by Laszlo Pinter

Branching and merging in Git

Branching and Merging are very powerful features in Git. There are may branching strategies, my favorite is well explained at http://nvie.com/posts/a-successful-git-branching-model/ Pick any model you like and stick to it for a while to better understand and evaluate it. If you do not like that try another one. In this model when we start to […]

 Go to post page

November 7th, 2015 by Laszlo Pinter

Merging in Git with four panels in Windows

Git is a great repository for small and large projects. It is easy to create and merge branches to separate code for the features you work on. To make merging easier you can use a free 4 panel merging tool, Perforce P4Merge. Download Download the Perforce P4Merge Visual Merge Tool from https://www.perforce.com/downloads/integrations Select the operating […]

 Go to post page

November 7th, 2015 by Laszlo Pinter

How to delete a folder from Git, but not from the local disk

I have accidentally included a folder in my Git repository, that I don’t want to include in source control. I wanted to remove it from the Git index, but not from the local hard drive. The solution is the following command git rm -r –cached myFolder If the folder name contains spaces enclose it in […]

 Go to post page

October 23rd, 2015 by Laszlo Pinter

Visual Studio 2015 is very slow on Windows 10

When I have upgraded Windows 7 my computer to Windows 10 I have also installed Visual Studio 2015 professional. From the first moment Visual Studio 2015 was very slow. My computer was freezing all the time. I have read many articles about the slowness of Visual Studio 2015, but I cold not find anything that […]

 Go to post page

October 16th, 2015 by Laszlo Pinter