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
207 reads
All About SQL
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
86 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
31 reads
Azure SQL vCore vs DTU
If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision to make. That being should...
2021-01-19
198 reads
SQL Server Linux
If you have come from a windows background you may be curious about the world of SQL Server Linux. Yes, the operating system and the implementation of it differs...
2021-01-15
422 reads
Azure SQL Database Connectivity
Have you ever wondered how your connection from outside of Azure to your database is handled? It is important to understand that there is a difference between route(s) from...
2020-12-10
19 reads
[Video] Azure SQL Database – Import a Database
Quick Video showing you have to use a BACPAC to “import” a database into Azure (Via Storage container),
2020-12-03
53 reads
Azure SQL Database – Greatest and Least TSQL
Being in the cloud does have many benefits, from lower administration to fast scaling but another “side effect” of operating in Azure SQL Database is the cloud first nature...
2020-11-26
243 reads
Azure SQL Database and Memory
There are many factors to consider when you are thinking about the move to Azure SQL Database (PaaS) – this could be single databases (provisioned compute or serverless) to...
2020-11-22
71 reads
[Video] Azure SQL Database – Failing Over (Failover Groups)
Quick video showing you how to failover your Azure SQL Database between your primary and secondary location.
2020-11-18
66 reads
Blogs
Daily Coping 24 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure...
How to Design Backups in SQL Server?
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Forums
Volunteer For Something
Comments posted to this topic are about the item Volunteer For Something
Linked Server location?
I have inherited a SQL Server that makes a call to a Linked Server...
Merge issue
I have a merge stored procedure that may be conflicting with the structure of...
Ask SSC