I have been using this amazing PowerShell module called dbatools (can be downloaded from https://dbatools.io/) for a while. This is basically a module that has bunch of very very handy commands that can be used to do lot of SQL Server administrative operations very easily… for example, migrate database to another instance\server, restore collection of
Category: Tips
pfSense – my new choice of router
After my not so great experience with prosumer grade router UDM, I got more curious and tried to look for alternative of that. And I found that there are more than few options available… some of which are open source and free. Among them pfSense was seem to be popular and offered similar feature with
Headless installation of Raspbian
Do you happen to have a situation where you have spare Raspberry Pi laying around and get some project in mind… but don’t have spare monitor/keyboard/mouse? Or you are simply lazy like me to get off desk to put things together ? I found out that it is really simple to actually do headless installation
Creating LIVE CD out of existing Linux installation
If you have been working with Linux for long enough time, you must have came across this question… “I have setup my Linux exactly the way I need it, now how do I replicate same setup in someone else’s computer?” or even better, “It would be great if somehow I can make LIVE CD out
TNS Protocol Adapter Error in Oracle
I like to spend time with Oracle DB just as much time I spend with SQL Server, but we exclusively use SQL Server at our work so I am not getting enough time with Oracle anymore. And another reason is it with Oracle there are way too many variable to consider when you are troubleshooting
Weird Snipping tool error
I rely on great windows utility called Snipping tool both at work and at home to take screenshots of different things to write and keep things in records. And in past I have tried other screenshot replacement tools like Green Shot and Snag It but they are too much for my simple needs to take
Moving Outlook .PST file
With SSDs getting cheaper everyday, I finally decided to upgrade myself to newer SSD few months back. SSD gives really nice IOPS pertaining to reads and writes of data but one very major flaw of this technology is it has limited number of read / write life span and you still need tweak your system