Category: How-to
Delete unused SMTP servers in OS X
I had numerous unused SMTP servers in my Apple Mail list, so I decided to tidy up and found the following steps do it (yeah!): Access the Finder menu and navigate to Go to Folder and type /Library/Scripts/Mail Scripts/. Look for Manage SMTP Servers.scpt and open it. (This should open the Script Editor.) Hit the…
Read a file with bash
I had to test our download servers at work right away, i.e., HTTP vs HTTPS, which required downloading a large number of files. A file list was given to me to work with, like so: /download/integrations/file1.exe/download/us/update/patch/file1.exe/download/us/cab/file1.exe So I decided to use the bash shell to read each line and run wget quick and dirty. Here’s the…
Note taking the mind mapping way in meetings
Here’s a great article on mind maps, specifically, how you can make use of it in meetings. Enjoy!
How to find the service pack version installed on SQL Server
Run and execute the following query; it doesn’t matter what database and/or table you’re in: select @@VERSION If executed successfully, you should get something like below, which shows that SP2 is installed. Microsoft SQL Server 2005 – 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build…
Resetting Primary Key counter in SQL Server
To reseed/reset the IDENTITY column of an SQL Server table, run the following in Query Analyzer or SQL Server Management Studio: DBCC CHECKIDENT (Table_Name, RESEED, 1) Peace!
VI global search and replace
In case you need to search and replace text globally within vi, here’s the command to do so: :1,$s/old/new vi is a free software screen-oriented text editor computer program written by Bill Joy in 1976 for an early BSD release. Peace! \m/