cviorel.com | Page 3

DTExec: The package execution returned DTSER_FAILURE (1)

Posted by cviorel on September 11, 2014 No comments | This post has 1,303 views.

What to do when a SQL backup job created with SQL server Maintenance Plans fails with this error?

DTExec: The package execution returned DTSER_FAILURE (1).

1	DTExec: The package execution returned DTSER_FAILURE (1).

Investigate! No useful information in the logs.
Previously that day I dropped a few unneeded databases so maybe the Maintenance Plan was still […] Continue Reading…

T-SQL to generate backup and restore commands

Posted by cviorel on August 29, 2014 No comments | This post has 773 views.

Hi guys,

Since my day to day job is a DBA, I figured I will share stuff that others might find useful.
For the first time I will share a small script which will help you generate T-SQL commands in order […] Continue Reading…

DriveDroid

Posted by cviorel on June 23, 2014 No comments | This post has 711 views.

DriveDroid is an Android application that allows you to boot your PC from ISO/IMG files stored on your phone.
Install it on your android phone and use it to boot any computer.
You can store any number of ISO/IMG files on […] Continue Reading…

Disable recent documents in Gtk2/Gtk3

Posted by cviorel on March 7, 2012 No comments | This post has 655 views.

Use the following to disable recent documents in Gtk2/Gtk3:

echo 'gtk-recent-files-max-age=0' | tee -a $HOME/.gtkrc-2.0
echo 'gtk-recent-files-max-age=0' | tee -a $HOME/.config/gtk-3.0/settings.ini

1 2	echo 'gtk-recent-files-max-age=0' \| tee -a $HOME/.gtkrc-2.0 echo 'gtk-recent-files-max-age=0' \| tee -a $HOME/.config/gtk-3.0/settings.ini

The ugly part is that there is no way one can disable ‘Recently Used’ in the GtkFileChooser dialog box.

Quick way to convert Mbox mailboxes to Maildir format

Posted by cviorel on December 17, 2011 No comments | This post has 735 views.

A quick way to convert Mbox mailboxes to Mbox format […] Continue Reading…

Bash script to backup my configs (dotfiles)

Posted by cviorel on June 17, 2011 1 comment | This post has 1,122 views.

I needed some script to take care of my config files and put them in a single directory. So here it is.

#!/bin/bash

# Display All Hidden Dot Files In a Directory
# ls -a | egrep "^\." > backup_dotfiles.sh

DESTINATION="/storage/dotfiles"  # do not use a trailing slash (/)

# Colors
blue="\e[0;34m"
green="\e[1;32m"
red="\e[0;31m"
bold="\e[1;30m"
reset="\e[0m"

# file list (use trailing slash for directories)
FILES="
.bash_aliases
.bash_logout
.bash_profile
.bashrc
.colours/
.config/openbox/
.config/terminator/
.config/tint2/
.config/zathura/
.devilspie/
.fehbg
.fonts.conf
.gtk-bookmarks
.gtkrc-2.0
.gtkrc-2.0.mine
.inputrc
.mplayer/
.nanorc
.rtorrent.rc
.screenrc
.synergy.conf
.vim/colors/
.vimrc
.xbindkeysrc
.Xdefaults
.xinitrc
.xmod
.Xmodmap
.xsession
.xxkb/
.xxkbrc
"
for file in $FILES
do
   if [ -d $file ]; then
      mkdir -p $DESTINATION/$file
      cp -f $HOME/$file* $DESTINATION/$file
   elif [ -f $file ]; then
      cp -f $HOME/$file $DESTINATION
   else
      echo -e "$red:: $file is not a file/directory! $reset"
   fi     
done

echo -e "$green:: Done! $reset"
exit 0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

#!/bin/bash

# Display All Hidden Dot Files In a Directory

# ls -a | egrep "^\." > backup_dotfiles.sh

DESTINATION="/storage/dotfiles" # do not use a trailing slash (/)

# Colors

blue="\e[0;34m"

green="\e[1;32m"

red="\e[0;31m"

bold="\e[1;30m"

reset="\e[0m"

# file list (use trailing slash for directories)

FILES="

.bash_aliases

.bash_logout

.bash_profile

.bashrc

.colours/

.config/openbox/

.config/terminator/

.config/tint2/

.config/zathura/

.devilspie/

.fehbg

.fonts.conf

.gtk-bookmarks

.gtkrc-2.0

.gtkrc-2.0.mine

.inputrc

.mplayer/

.nanorc

.rtorrent.rc

.screenrc

.synergy.conf

.vim/colors/

.vimrc

.xbindkeysrc

.Xdefaults

.xinitrc

.xmod

.Xmodmap

.xsession

.xxkb/

.xxkbrc

"

for file in $FILES

do

if [ -d $file ]; then

mkdir -p $DESTINATION/$file

cp -f $HOME/$file* $DESTINATION/$file

elif [ -f $file ]; then

cp -f $HOME/$file $DESTINATION

else

echo -e "$red:: $file is not a file/directory! $reset"

fi

done

echo -e "$green:: Done! $reset"

exit 0

Moved to ArchLinux!

Posted by cviorel on June 16, 2011 No comments | This post has 1,182 views.

Moved my ThinkPad T61 to ArchLinux! (Still using Ubuntu on many other machines.)

Screenshot:

I will post some install script I used to configure my system.

Liferea custom stylesheet

Posted by cviorel on June 16, 2011 1 comment | This post has 872 views.

I don’t like very much the default font used by Liferea, so I decided to use my custom font. Here is how:
1. Copy the default stylesheet to liferea folder in my $HOME:

cp /usr/share/liferea/css/liferea.css $HOME/.liferea_1.6

1	cp /usr/share/liferea/css/liferea.css $HOME/.liferea_1.6

2. Add this:

{
	font-family: Aurulent Sans;
}

1

2

3

{

font-family: Aurulent Sans;

}

at the begining of liferea.css file.

This […] Continue Reading…

Ubuntu Kindle eBooks

Posted by cviorel on March 21, 2011 No comments | This post has 599 views.

Need some great Ubuntu eBooks to read on your Kindle? Look no further. Keir Thomas has some excellent guides for you.

Beautify SQL code

Posted by cviorel on March 15, 2011 No comments | This post has 700 views.

Recently I had the oportunity to test SQL Pretty Printer (Add-In for SSMS). I don’t have to waste time formatting long sql queries. In no time, SQL Pretty Printer does the job
for me. It can also translate the sql […] Continue Reading…

Social

Categories

Tags