Snowflake in Azure
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that is Azure SQL Database or Azure Database for MySQL for your relational database, it does not matter...
2021-04-12
23 reads
All About SQL
Error creating Azure SQL Database
A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”, “message”: “Operation on server x and database y is in progress. Please wait a few minutes before trying again.” What is going on here? Well for this example (and maybe yours) I created a database...
2021-04-16 (first published: 2021-04-09)
414 reads
Azure SQL – Saving Costs
When moving to a cloud model for your database stack no doubt you will be involved in a costing exercise. The good news is if you have Software Assurance...
2021-04-01
27 reads
SQL server BIGINT
It has been a while since I wrote a blog post for TSQL Tuesday and there is no better time then now following on from Brent Ozar’s Invite about...
2021-03-09
158 reads
Azure SQL Database – Contained user Model
I always follow a contained user model when setting up users within my Azure SQL Database. I do this so the user in question has access to only specific...
2021-03-12 (first published: 2021-03-09)
341 reads
Azure SQL Database F and M series
Taking a screen shot from my Azure Portal, you will see the available hardware configurations available for Azure SQL Database. I wrote about Generation 4 and 5 in the...
2021-02-18
49 reads
Azure SQL Database Gen4 to Gen 5
For the past year Microsoft have said that Generation 4 hardware is soon coming to its end of life. I know many installations that have used Generation 4 over...
2021-02-16
948 reads
Azure SQL DB – Troubleshooting CPU issues
When you have the need to find out real time what is causing high CPU issues within your Azure SQL Database, there is nothing better than using TSQL and...
2021-02-10
219 reads
Azure SQL Database and Long-Term Backups
There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server. As...
2021-02-02
95 reads
SQL server Linux and SQLCMD
Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common requirement will be the need to connect to it to issue queries, typically via SQLCMD)....
2021-01-25
74 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat Kantor BCA KCU KALIMALANG Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren Sawit, Kota...
BCA KCU PANGERAN JAYAKARTA Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta...
BCA KCP Sampoerna Strategic Square Telpon/wa.0853.7373.7699
BCA KCP Sampoerna Strategic Square Telpon/wa.0853.7373.7699.Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers