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,130 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,093 reads
T-SQL Restore Script Generator
A procedure that generates point in time restore database & log commands for your databases.
2013-01-24
22,408 reads
Script to construct a restore/recovery script
Constructs a restore script for all databases on the server from backup history.
2012-11-12 (first published: 2012-09-26)
1,223 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,804 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,824 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,626 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
7,917 reads
Blogs
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Forums
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Database DevOps Metrics
Comments posted to this topic are about the item Database DevOps Metrics
Replacing a NULL II
Comments posted to this topic are about the item Replacing a NULL II
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers