You can read about all the new role based qualifications from Microsoft here – https://www.microsoft.com/en-us/learning/certification-overview.aspx
Have you realised the changes Microsoft have made to the firewall and networking section of Azure SQL Database? I found this quite stealthy and took me by surprise. I did encounter an edge case scenario where it lead to issues once I made some tweaks but that was a rare thing.
A quick post today about moving across database tiers. As you can see below I have a General Purpose Serverless Gen 5 1 vCore database (currently paused). Can I move this back to a DTU based model?
This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings available.
It has been a while since I posted an entry for TSQL Tuesday, which, for today is hosted by Kenneth . The subject being a non SQL Server tip. For a while now I have been using other technologies besides SQL Server and recently Azure Databricks and I have a handy tip for when starting this journey. It is not ground breaking but useful!
So you have many databases in Azure, you accidentally deleted one which can happen and has happened to me because in my situation they had very similar naming conventions with a number different at the end of the database name.
Question is, how can you protect yourself from this? Answer. Locks.
Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then output it back to a different mount point ( based on Azure Storage) as a parquet file, I decided that I actually wanted to move this data into Azure SQL DB, which you may want to do one day.
Moving to public cloud such as Azure, AWS or even private cloud services you need to be tracking costs and seeing if you are “effective”. What is the best way of doing this with Microsoft Azure?
Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below:
- Windows 2016 +
- Red Hat 7.3-7.6
- SUSE v12 SP2+
- Ubuntu 1.8
So, I am going to use my clicking skills and spin a Machine up in Azure utilizing the market place, so I can get an image of SQL Server installed on the VM already.
Ok, so Azure SQL doesn’t really have its own error log based somewhere on a machine within \\MSSQL\Log directory but the closest thing you will get is a system catalog view called sys.event_log which is very useful. It will get you information about all sort of event types such as:
- Successful connections
- Failed connections
- Throttling issues
- Blocked by firewall attempts
- Connection termination