With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
Today Steve looks at legacy systems and the challenges they pose as we try to adapt them to new requirements.
Ever wonder about index column order; this piece should give some insight.
SSMS is, well, it's what we mostly have from Microsoft. It's been around a long time, but it is getting regularly released. There are new versions about every quarter, and there are bug fixes and minor enhancements. Azure Data Studio appears to be where Microsoft would like most of us to move, but I, and […]
How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?
Can you catch minor code changes that might cause issues? Steve advocates for more testing to ensure you can.
We sometimes need to perform a different/alternative actions during database queries. We need it for data protection or data abstraction. The PostgreSQL rule system allows to define an alternative action on insert, update or delete. A rule generates an extra query. As a result, rule execution impacts the performance of the system. Creating Rules A […]
The database is often left behind as organisations embrace DevOps. In this article, Robert Sheldon explains how to successfully bring databases into DevOps, especially when dealing with legacy databases.
As 2020 draws to a close, managers in many organizations are considering what the next 12 months IT strategy should look like, and how this underpins business objectives. Given the current business climate where the pandemic has prompted many companies to change the way they work, it’s even more important right now – and it’s an opportunity to get ahead.
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Comments posted to this topic are about the item A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers