We have covered multiple times in this blog that we can import CSV to Database very easily. However, recently I received a very interesting question where the user wants to export data with the help of SQLCMD.
Personal Technology – A Quick Note on Good Elevator Etiquette
I have been traveling a lot for different conferences and meetings lately, and that means a lot of air flights, taxi drives, and elevator rides! There are plenty of rules out there, both written and unwritten, for air flights and taxis, and we all more or less follow these rules…
Read MoreSQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS
This is a follow up of the blog post I have posted on error 3154 few years ago. I have received quite a few emails that how we can fix the same error with the help of SQL Server Management Studio. In this blog post, I will explain how we can…
Read More
SQL – Everything about Data Magazine – FREE to Subscribe
Print media is gradually fading out as we are moving to the new exciting world of digital gadgets. I have seen quite a lot of friends who used to tell me that they will never buy kindle or ebook reader as they do not like reading electronically. However, the same set of people I have seen now a days sporting kindle or flipping electronics magazine in their smart phones.
SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
[Note from Pinal]: This is a third episode of Notes from the Field series. Lots of organizations do Virtualization. The purpose of the Virtualization is often consolidation, performance or just easy to use configuration. Looking at the various advantages of the Virtualization, nowadays I find lots of organization have implemented…
Read MoreSQL SERVER – How to export data from SQL Server to Excel or any other Format?
Note: If you want to practice the code and the example along with here, you can download dbForget Studio from here. Everyone, who is involved in work with databases, eventually faces with data export/import tasks. Unlike data import tasks, data export has to be performed in various formats, depending on the business…
Read MoreSQL SERVER – 3 Quick Videos on Careers, Certifications and Information
SQL in Sixty Seconds has been a very popular channel on YouTube. Here are three of the videos which are based on the Careers, Certifications and Information. Let me know what you think of the same. Additionally, if you like the SQL in Sixty Channel, please subscribe over here. In…
Read More