Sometimes you may have large amount of data you want to export to csv file without having to leave SSMS. For this you can use bcp but you will have to make sure that you have bcp installed. To check if you have BCP installed simple open command line and…

I often write, powershell scripts to either run in background or run via sql job. In either case, I sometimes like to have some sort of email notification send out either on success or failure. Powershell allows you to send email from within the code. Even thought it is usually…

I have only been a DBA (database administrator) for little over a year. One thing Brent Ozar recommends in his training’s is knowing your inventory. I didn’t realize how important it was until I started patching servers. What I realized it is very easy to get lost in amount of…

Pre Requisites Virtual Box (Optional) Ubuntu 16.04 MSSQL 2017 Developer Edition My environment setup For this installation I used virtual box. It is best to use virtual box if you are first time user or testing this for the first time. I am assuming you already know how to setup virtual box. …

Twenty20 was one hell of a year. A lot happened, I mean a whole lot of lot. Surrounded by uncertainty, setbacks, losses, and to mention the least, unwanted changes and circumstances we all had to adapt to, whether we wanted or not. Though, on one hand millions incurred financial, physical…