uilol.blogspot.com

szunyog.blogspot.com

Szunyog's Blog: Killing other processes connected to an MSSQL database

http://szunyog.blogspot.com/2013/12/killing-other-processes-connected-to.html

Small tips and tricks from the IT world. Killing other processes connected to an MSSQL database. Declare @db name varchar(100) = 'dbname';. Declare @kill commands varchar(max) = ' ;. Kill commands=@kill commands 'kill ' convert(varchar(5),spid) ';'. SPID - avoid to kill the current process. And dbid=db id(@db name). Print 'Executing: ' @kill commands;. Exec (@kill commands);. Https:/ gist.github.com/szunyog/7941990. Friday, December 13, 2013. Subscribe to: Post Comments (Atom). Diary of a Developer.

szunyog.blogspot.com

Szunyog's Blog: October 2010

http://szunyog.blogspot.com/2010_10_01_archive.html

Small tips and tricks from the IT world. Howto Setup Passwordless Atuhentication on GDM using PAM. You can modify GDM authentication method not to ask for password at login. From security perspective this is not really advised, but when you share your workstation with your children or other family member it could be useful. This howto modifies GDM and gnome-screensaver PAM modules to allow authenticate specified users without password. Sudo adduser user1 home. Sudo adduser user2 home. For f in *.rar;...

szunyog.blogspot.com

Szunyog's Blog: Dajngo app unicode JSON repsonse

http://szunyog.blogspot.com/2011/07/dajngo-app-unicode-json-repsonse.html

Small tips and tricks from the IT world. Dajngo app unicode JSON repsonse. If your django application has unicode data, and your view uses jquery and JSON response, do not forget to specify the encoding for the mimetype:. Return HttpResponse(simplejson.dumps(your data),. Wednesday, July 06, 2011. Subscribe to: Post Comments (Atom). Diary of a Developer. My profile on Bitbucket. My profile on Github. UI - LOL - Curious user interfaces, funny screenshots, unexpected behaviors and messages.

szunyog.blogspot.com

Szunyog's Blog: Lists all foreign keys (source and ref columns) in a MSSQL database

http://szunyog.blogspot.com/2013/12/lists-all-foreign-keys-source-and-ref.html

Small tips and tricks from the IT world. Lists all foreign keys (source and ref columns) in a MSSQL database. This script lists all foreign key references in a MSSQL database, using system tables:. Tname AS TableWithForeignKey,. Cname AS ForeignKeyColumn,. Rname AS ReferencedTable,. FROM sys.foreign key columns AS fk. Inner join sys.tables AS t. On fkparent object id = t.object id. Inner join sys.columns AS c. On (tobject id = c.object id. AND fk.parent column id = c.column id). Tuesday, December 10, 2013.

szunyog.blogspot.com

Szunyog's Blog: July 2011

http://szunyog.blogspot.com/2011_07_01_archive.html

Small tips and tricks from the IT world. Django email setup on Hostgator. It is possible to run Django applications with FastCgi. But it has only sendmail as email back-end which is not included in Django. Hopefully there is a snipets. To resolve this limitation. You just needed to change the path of the sendmail file and it was ready to run. The location of sendmail is "/usr/sbin/sendmail" on our Hostgator server. EMAIL BACKEND = 'sendmail.EmailBackend'. Tuesday, July 12, 2011. Wednesday, July 06, 2011.

szunyog.blogspot.com

Szunyog's Blog: March 2011

http://szunyog.blogspot.com/2011_03_01_archive.html

Small tips and tricks from the IT world. Resize files using one command. It is easy to resize multiple images by the following command:. For i in `ls *.JPG`; do convert -resize 1024 $i $i; done. A bit detailed version of this script can be found in my bitbucket repository: resizer.sh. Friday, March 04, 2011. Subscribe to: Posts (Atom). Diary of a Developer. My profile on Bitbucket. My profile on Github. UI - LOL - Curious user interfaces, funny screenshots, unexpected behaviors and messages.

szunyog.blogspot.com

Szunyog's Blog: December 2010

http://szunyog.blogspot.com/2010_12_01_archive.html

Small tips and tricks from the IT world. IKEv2 VPN Client Setup on Debian Squeeze. Recently my company was set up a Windows 2008 VPN server. It is configured to accept only SSTP. I did not find any working clients for Linux that uses SSTP protocol, but for IKEv2 strongSwan. Provides a quite easily configurable and working solution. To set up the VPN client I did the following:. 1 Installed the strongswan-ikev2 package. 2 Configured the /etc/ipsec.conf file (changed the bold values):. Diary of a Developer.

fn4u.blogspot.com

Fun 4 U: Goldfish Passing

http://fn4u.blogspot.com/2013/02/goldfish-passing.html

Thursday, February 14, 2013. Little Nancy was in the garden filling in a hole when her neighbor peered over the fence. Interested in what the cheeky-faced youngster was up to, he politely asked, "What are you doing there, Nancy? My goldfish died," replied Nancy tearfully without looking up, "and I've just buried him.". The neighbor was very concerned. "That's an awfully big hole for a goldfish, isn't it? Top Sports Cars 4U.

fn4u.blogspot.com

Fun 4 U: July 2011

http://fn4u.blogspot.com/2011_07_01_archive.html

Wednesday, July 13, 2011. A man asked his doctor if he thought he'd live to be a hundred. The doctor asked the man, "Do you smoke or drink? No," he replied. "I've never done either.". Do you gamble, drive fast cars, or fool around with women? No, I've never done any of those things either.". Well, then," said the doctor, "what do you want to live to be a hundred for? So the third hunter says, "I'm just gonna shoot at anything I see.". A Pastor Visiting His Church Members. A pastor went out one Saturday t...

fn4u.blogspot.com

Fun 4 U: January 2012

http://fn4u.blogspot.com/2012_01_01_archive.html

Wednesday, January 25, 2012. If you are obsessive-compulsive, please press 1 repeatedly. If you are co-dependent, please ask someone to press 2. If you have multiple personalities, please press 3, 4, 5, and 6. If you are paranoid-delusional, we know who you are and what you want. Just stay on the line so we can trace the call. If you are schizophrenic, listen carefully and a little voice will tell you which number to press. Tuesday, January 3, 2012. Top Sports Cars 4U.