For SQL Server IaaS VMs, Microsoft provides Azure Backup for SQL Server – a PaaS service allowing you to leverage the Azure Backup service to back up SQL Server databases easily and in a centralised manner.
In this post, we’ll discuss a recent pitfall we came across with backup concurrency, and..
There are still many organisations today which rely on paper forms as a means of collecting data and record keeping. Not only is this an inefficient way of storing the information, but a large quantity of documents can be both challenging and expensive to maintain.
Power Apps can help solve this..
As a follow up to my recent post, we’ll be discussing Microsoft’s DP-201 exam (“Designing an Azure Data Solution”); the second exam and final step required in gaining the Azure Data Engineer Associate certification.
At Coeo, we are actively encouraged to take exams and broaden our understanding in new areas. Not only do these exams help focus our learning, they help to build a breadth of qualifications throughout the company.
In this post, we’ll be discussing Microsoft’s DP-200 exam; the first of two exams..
To find out when the last successful DBCC CHECKDB for a given database was, we can use the DBCC DBINFO() command and look for the dbi_dbccLastKnownGood value. Alternatively, Microsoft introduced this information in the form of a DATABASEPROPERTYEX value, starting from SQL Server 2016 SP2: