Databases were always big part of my work and I did use MySQL in Azure before. However, I did not have time to try MySQL In-app until last week. It was nice surprise that it works quite fine (once you figure where to go) and it makes management easier as it is under same blade…
One of most interesting things last year was release of MS SQL Server for Linux. Like I said in some of my posts before, I wouldn’t have dreamt of it 5-6 years ago. But things changed very much in last few years and this is another big step Microsoft took toward OpenSource community. In this post I will…
As I promised in one of previous posts, I’ll write about scheduling MS SQL database to Azure Storage Account. We’ll start with creating new Storage Account. Go to Azure Portal and click ‘New’. Select ‘Storage’ and ‘Storage account’. Enter parameters for your Storage account. Enter name, deployment model must be ‘Classic'(as ARM will not be visible…
One of most used Azure service is backup. Storage is very cheap in Azure and it gives us option of creating backup very far away from our on-prem environment. In this post I will cover basics on how to create MS SQL database backup to Azure Storage. Note that for using this option you need…
Next few posts will be about one of my favorite subjects – SQL. When we talk about databases in Azure there is lot of options, depending on what you need. If you need more services that traditional MS SQL Server offered on premise, best way is to use IaaS, VM with MS SQL Server installed….
It’s official now, I’ve been nominated and accepted as Microsoft P-Seller for SQL Server. It’s been official for couple of weeks but I didn’t get to write about it because of other commitments, work and preparing for new certification. Anyway, I’m greatly honored to be presented with such opportunity and to be selected among MS community…
So my last post got me thinking what was also big problem that I spent days trying to resolve. And then I remembered. We were doing migration of database and application from old server to new one. Everything went smoothly, everything was up and running untill couple of days later. One of procedures was taking forever to…
Today I was working on importing some data to DWH with SSIS packages. So I remembered problem that was giving me big headache back in days. I spent few days then resolving error: Error: 0xC0209303 at Package, Connection manager “mdbfilename“: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered — perhaps no 64-bit provider…