Viewing 15 posts - 1,846 through 1,860 (of 39,720 total)
Hm, Ok, I'll file a bug to have someone check. This shouldn't be an issue
July 14, 2021 at 6:48 pm
Oh, but Steve, you really must experience the joy of trying to import "sometimes-quoted" fields using BULK INSERT!
BULK INSERT Fun_With_Quotes
FROM 'C:\Import\venmo.csv'
WITH ( FORMAT='CSV');
I'll pass. At least...
July 14, 2021 at 4:13 pm
Hence why I wrote this. Maybe someeone at MS will pay attention
Microsoft is only interested in Azure now. It is the favoured child while on-premises software has been...
July 14, 2021 at 3:37 pm
For one-off issues, there are several free CSV to SQL tools on the net which build the insert/update/delete/merge/select script from the CSV data (i.e. bfotool.com/csv-to-sql). That generated script can...
July 14, 2021 at 3:36 pm
Compared with Power Query from Excel or Power BI it really seems hard to handle csv. SSIS is older. But meanwhile you can use a Power Query Data Source...
July 14, 2021 at 3:35 pm
Still wondering why something likely as importing a csv is still so hard using the sql server tools
Hence why I wrote this. Maybe someeone at MS will pay attention
July 14, 2021 at 3:00 pm
Am I a dinosaur for defaulting to BULK INSERT for tasks like this? I know it is a manual process, including defining the table in the first place, but...
July 14, 2021 at 2:58 pm
I assume you're logged in. What browser/OS?
The briefcase seems to work for me.
July 13, 2021 at 3:23 pm
I'm not sure what you mean. Email is a specific way of sending something. This doesn't produce a file, but sends an email through an SMTP email system.
July 13, 2021 at 3:22 pm
For a Windows shop, is there any practical benefit, like in terms of licensing costs or performance, for running SQL Server on a non-containerized Linux instance? For example, could...
July 12, 2021 at 6:18 pm
I'm surprised to see that Microsoft has stopped development of containers for SQL Server on Windows. I'm not clear if it's because it's too complicated of a task or...
July 12, 2021 at 2:18 pm
A couple Linux resources for you.
you can add WSL to your Windows 10 install, use...
July 12, 2021 at 2:15 pm
I neglected to add a note about Windocks, but I've added one in the post. They do support Windows containers. However, not having Microsoft do so for SQL Server is...
July 10, 2021 at 11:25 pm
Great tips, Brian. The type of thing I've done as well. Any data changes mean we make a copy and waste space for a few days until we are sure...
July 7, 2021 at 3:58 pm
Viewing 15 posts - 1,846 through 1,860 (of 39,720 total)