In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner's guide for people who have no experience to do that, please read this article closely with Mircosoft's guide: […]
Grant takes a few lessons for database DR from a nuclear accident in the US.
Here's why you should NEVER use the FORMAT() function in SQL Server.
Microsoft reads your feedback, but doesn't always build it. However, your votes can sway them at times. Today Steve asks what you'd like to see added to SQL Server.
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
One place where Artificial Intelligence systems might shine is the medical field.
One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, however, is that any sysadmin can make changes (or db_owner […]
Learn how to find and remove a large SQL Server Error Log file when it consumes a lot of space on your drive
If you save a metadata 'model' for every new version of a database created by Flyway, you can compare the current model to the previous one to see what changed. In turn, you can then generate a database E-R diagram that highlights the changed objects, instantly making those changes visible to other team members
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I have 1 table which has a partition on Date column. However this table...
Hi All, I have to find the special characters in email address apart from...
Comments posted to this topic are about the item Three Mile Island And Your...
Ask SSC