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
Odd installation of SSDT BI on x64 bit system
Visual Studio 2008 full installation had always included Business Intelligence Development Studio (BIDS) with it. But for whatever reasons MSFT decided to skip that part in VS 2010(may be because there was no major release SQL Server during that time) and it was missing for very long time till release of next major SQL Server
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
My own RSS synching Server using Tiny Tiny RSS
After demise of my favorite RSS Synching Service … Google Reader back in July 2013, I was little lost in quest for ultimate alternative since like many IT guys, I don’t stick to just one device and read my feed always from there. Plus me “experimenting” on different things on same system means loosing all
Odd Database Project issue with VS 2010
Recently I stumbled upon really weird issue with VS 2010. We have bunch of database projects created in VS 2010 which are part of our regular development build. As part of my task, I was trying to automate deployment of these database projects using PowerShell and came across really really strange issue that I have
Monitoring SQL Server using Alerts
There are many after market tools available to monitor health of SQL Server. But with help of built-in tools you can actually create some pretty neat solution by yourself too. And one of the most handy tool is “Alerts” in SQL Server. With help of Alerts you can monitor SQL Server Events, Various Performance Conditions