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