When it comes to performance tuning or troubleshooting, for a standard SQL server many tools and techniques exist. For example query execution plans can be analysed, profiler exists, and a host of other dmvs which a DBA cannot live without. In an Azure Data warehouse there are similar dmvs. However some basic principles can be … Continue reading Azure Data warehouse Performance Tuning 101
Managed Service Identity (MSI) was introduced last year. Since then quite a few articles have been written about it: Use a Windows VM Managed Service Identity (MSI) to access Azure Key Vault: Azure SQL authentication with a Managed Service Identity MSI gives your code an automatically managed identity for authenticating to Azure services, so that you … Continue reading Azure MSI: Connect Using PowerShell Or .NET?
Microsoft’s Azure data warehouse is a cloud hosted PaaS offering. Which implies compute and storage resources are managed by Microsoft / Azure fabric. Scheduled and unscheduled maintenance activities occur which are supposed to be transparent, i.e. should not impact the platform. This is a false assumption. On some occasions maintenance will impact the platform. For … Continue reading Azure Parallel Data Warehouse (PDW) Errors #1: cancelled transactions
Been getting questions about her transactions (pls post them on my blog as comments) Thought I’d clarify that the transaction section is delayed. This means that there is a lag between the time the trade occurred and when it is printed, i.e. a few periods ago PrincessTenko dabbled in that stock. See her in action (and possibly here arch rival … Continue reading PrincessTenko’s delayed Stock transactions
Been thinking about the most accurate method for forecasting. More closely to my line of work, I’d like to forecast database growth over a specified period of time into the future? The common method I have seen used is to simple use excel and plot a trend line from previously collected data, while this can … Continue reading Forecasting Database Growth
… Next Stop full integration with Interactive brokers. View her latest performance: quant.peterirojah.com
Noticed that despite the fact that one of my VM’s (Win2k8, 64Bit) was configured with 2Gb Ram and 2 CPU cores the performance, even while idle, was not as expected. It was sluggish and so unresponsive that the snap-in loader timed out all the time. This was very frustrating, I increased the RAM, Pagefile, name it … Continue reading VMWare Server 2 Multicore Performance