Author Archive
Set mailbox permissions in Exchange 2010
Out of the box Exchange 2010 doesn’t give admins mailbox access. Many places that I have worked do want their administrators and helpdesk teams to be able to open any mailbox so they can help diagnose problems. This blog demonstrates a few of the possible ways you can change mailbox permissions.
In: Exchange 2010 · Tagged with: Exchange, Exchange 2010, get-adpermission, mailbox permissions, remove-adpermission, set-adpermission
Find the distinguished name of an AD object (DSQUERY)
This post got me out of a hole today so i have reproduced it here for posterity –
In: AD · Tagged with: AD, dsquery, LDAP
Excel Tips & Tricks
I use Excel a lot. Though not in the way that most people will use it. Excel is a very powerful tool when it comes to text manipulation and working in IT I often have to wade through, process, manipulate, squeeze, expand or turn upside various huge text or csv files. So here are a few Excel […]
In: Excel · Tagged with: convert, excel, replace, search, time
Add a new disk to a Linux system
This is the procedure I use to add a disk to any of my fedora / centos / redhat systems.
In: Linux · Tagged with: centos, disk, fdisk, fedora, linux, partition, redhat
T-SQL Example code: Select, Insert, Update, Delete
Various examples and snippets of Select, Insert, Update, Delete T-SQL
In: SQL · Tagged with: delete, insert, select, update
T-SQL Example code: Table Management
T-SQL table management tips, tricks and code snippets
In: SQL · Tagged with: alter table, column, drop, management, select into, table, truncate
T-SQL Example code: useful stores procedures and snippets
Here are some useful one liners that I find very useful
In: SQL · Tagged with: alter database, attach, dbcc, detach, exec, restore, sp, sp_, stored procedure, update
T-SQL Example code: User Management
Some useful commands for dealing with users (in a non violent way), and a very useful couple of lines for finding and then fixing orphaned users which often happens after moving a database to a differnet SQL server.
In: SQL · Tagged with: orphan, orphan user, sp_password
T-SQL Example code: Database Management
Here is some code that Iv’e found useful for managing databases:
In: SQL · Tagged with: database, drop, exec, rename, shrink, size, sp_database, table, truncate
T-SQL Example code: SQL Fixes
Here are a few lines of code that have got me out of troubel in the past:
