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,138 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,101 reads
T-SQL Restore Script Generator
A procedure that generates point in time restore database & log commands for your databases.
2013-01-24
22,597 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,813 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,829 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,634 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,957 reads
Blogs
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Secure Your SQL Estate: Best Practices for Azure SQL Security
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Forums
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Concerns over AI Chat Privacy
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1
Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale:...
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers