Jan 9Easiest way to move SQL Agent Job to another serverI have learned that it is not always about “doing it yourself” rather it is about — “has anyone already solved the problem” or is there an easier of doing things. In most cases there always is someone who has done it before. While, I was working on automating a…1 min read1 min read
Dec 26, 2022Exporting SQL Query Results from SSMS to CSVSometimes 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…2 min read2 min read
Dec 22, 2022Powershell function to send emailsI 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…1 min read1 min read
Feb 10, 2021Knowing your SQL ServerI 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…Sql2 min readSql2 min read
Feb 10, 2021How To Install MSSQL on Ubuntu 16.04Pre 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. …Sql2 min readSql2 min read
Jan 19, 2021Need a mindset switch ? Add this book to your listTwenty20 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…Books2 min readBooks2 min read