Stairway to Always On Level 6: Analyse and Deploy an Always On Availability Group
In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.
Stairway to Always On Level 7: Combining FCIs with Availability Groups
In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.
Stairway to Always On Level 8: Segregate Mirror Traffic in AlwaysOn
this article details how to segregate the mirror traffic in an Always On group configuration
How to use Jupyter Notebook in VSCode
Learn how you can create and use a Jupyter Notebook in VS Code.
The Biggest Database Professional Challenges Today
What are the biggest challenges you face today? Steve asks the question and is hoping for a few answers from you.
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
Planes, Trains, and Automobiles
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
A Programmer's Attitude
The way we approach development can have a big impact on quality, as well as how smoothly our team works together.
Deleting Documents from a MongoDB Collection
So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection.
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers