Hi. I'm having my first foray into SQL Server in the cloud and I'm not having any fun at all. I really need some hand holding until I get going. I've years of experience of locally hosted SQL Servers (that live in actual metal boxes that you can touch), accessed through SSMS - all nice and easy, but this is new and uncomfortable and I honestly don't understand it.
We've got this CRM system and I've been asked to make the data accessible, useable, warehoused etc. Trouble is that the data is 'in the cloud' but I don't know if its in Azure or something else.
I've been given an ODBC connection to our data. I've built an SSIS package that uses the ODBC connection and can at least access the data and pull it into a local SQL Server and from there I'm back in my comfort zone.
My issue is that its so bloody slow. This SSIS package is taking around 30 minutes to connect to the database, and import the data from just one single table. There's only 14k rows.
There's also the issue of the database itself having been designed by an idiot so the tables have stupid numbers of columns and I'll bet that nothing's indexed. I don't know why they bother having a database developer on site (me) and then let Dave from IT build the database but that's a rant for another day.
If data in the cloud is supposed to be the new big thing, then I can't be doing it right. So here are my questions:
Is ODBC the right way to connect?
How can I make it quicker?
How can I check things like indexing etc.?
If my questions seem stupid, then I apologise. Feel free to insult me at your leisure.
Thanks for reading, and (hopefully) giving me some pointers.