With 2020 coming to a close, it's time to look at the new year ahead. Join our final 2020 summit this December 10th, to discover how to implement a generative culture for successful IT teams and how database DevOps will drive growth and ROI in a remote world. Register to tune in live or watch the recordings.
Today Steve notes that we often don't have all the knowledge or information we need, but we can work to acquire it.
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 […]
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers