PowerShell vs GUI Availability Group Rebuild
Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands
2013-06-17
3,155 reads
Paul Brewer
Data Mining SQLIO Results
Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.
2013-03-26
3,115 reads
T-SQL Restore Script Generator
A procedure that generates point in time restore database & log commands for your databases.
2013-01-24
22,876 reads
Transaction Replication Publisher failover to Mirror
Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.
2012-06-28
2,831 reads
Stop Food Waste - OS Open Data & SQL Azure
An attempt to use Ordanance Survey OS Open Data, SQL Server and SharePoint in the construction of a system for supermarkets to supply expiring food to nearby homeless shelters.
2012-06-14
2,838 reads
Transaction Replication Latency Diagnosis
Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats
2012-05-09
2,650 reads
SQL Server 2012 Active/Active Cluster in Hyper-V
Learn how to create a SQL Server 2012 Active/Active cluster in Hyper-V using an iSCSI SAN
2012-02-13
8,013 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers