How to determine Azure SQL Database Tier

Recently, I got lot of questions on how to determine tier and performance level for Azure SQL Database. Therefore, I decided to write my next post about this topic. To determine correct tier for specific workload, you have to take into account multiple parameters. First, let us talk about Azure SQL database tiers. Azure SQL…

Install SQL on Linux VM

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…

Schedule MS SQL database backup to Azure storage

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…

P-Seller for SQL Server

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…

SQL Server Slow execution after migration to new server

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…

Error: 0xC0209303 in SSIS

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…