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...

More
  • December 26, 2022

I 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...

More
  • January 9, 2023

I have only been a DBA (database administrator) for a while now. 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 information...

More
  • January 1, 2023

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...

More
  • December 22, 2022