Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain.
Stairway to Always On Level 1: What is "SQL Server Always On"?
Level 1 of the stairway looks at exactly what the technologies "Always On", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.
Stairway to Always On Level 2: Storage 101
In this new level of the stairway, we examine the storage knowledge you need for an Always On configuration.
Stairway to Always On Level 3: Infrastructure 101
In this next level of the Stairway to Always On, we will look at the components required to implement a Windows Server Failover Cluster.
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.
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers