Is Your Availability Group ‘REALLY’ Ready To Failover?
You know what it’s like, you need to fail your AG over but is it safe to fail over? Even if your AG says it is, there are other thing to consider...
2019-05-03
499 reads
Administration
Minimal Logging with INSERT…SELECT into Heap Tables
Achieving minimal logging with INSERT...SELECT can be a complicated business.
2019-05-02
No, This is not a Bug in T-SQL
Gail Shaw keeps seeing this in all sorts of places. People getting an unexpected result when working with a subquery, typically an IN subquery, and assuming that they’ve found...
2019-05-02
Generate script to recreate indexes
For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment.
For example, the default replication setting is to exclude the...
The...
2019-04-26
Slow inserts across a linked server?
Linked Servers offer a great way to connect two SQL Servers together, allowing remote querying and DML operations. Frequently, this is used to copy data from production to reporting....
2019-04-25
Proposed SQL Server defaults: optimize for ad hoc workloads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling...
2019-04-24
Enable a Named Instance to Connect on 1433
My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I...
The...
2019-04-22
Shrinking a large database with limited outage windows
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
The post Shrinking a large database with...
2019-04-22
SQL Server Diagnostic Information Queries for April 2019
This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have been trying to fix the broken...
2019-04-11
Database Recovery Monitoring with XE
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
The...
2019-04-10
Blogs
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Azure – HorizonDB
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
A New Chapter: Why I Made the Move from Dayforce to ESO
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
Forums
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
A Security and AI Fail
Comments posted to this topic are about the item A Security and AI Fail
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers