Alert Filtering in SQL Monitor
SQL Monitor has improved a lot over the last couple of years. We have multiple teams building features and addressing issues, and each month when we have a readout...
2022-06-27
47 reads
SharePoint List only returns 100 items in Azure Logic App
I was reading a SharePoint List using the “Get Items” activity in an Azure Logic App. I explain how you can create such a Logic App in the blog...
2022-07-15 (first published: 2022-06-27)
119 reads
Daily Coping 27 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-27
19 reads
The First 30 Days at a New Database Job
Over the last four years, ok it seems longer than that, I’ve started four jobs. A couple just weren’t good fits. One I was at for three years. I...
2022-07-11 (first published: 2022-06-27)
686 reads
Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL Server virtual machine performance tuning tips with our friends at Sanity Solutions on July 21st...
2022-07-13 (first published: 2022-06-25)
404 reads
The Effectiveness of Solar Estimation
We added a solar system to the ranch as a way to hedge against future costs as well as require less energy from the utility. I don’t plan to,...
2022-07-08 (first published: 2022-06-24)
236 reads
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
529 reads
Daily Coping 24 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-24
20 reads
When is a mouse not a mouse?
This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...
2022-07-08 (first published: 2022-06-24)
343 reads
Shutting down nodes in Azure Kubernetes Service
A while back I wrote a post on Adjusting Pod Eviction Timings in Kubernetes. To test the changes made in that post I had to shut down nodes in...
2022-07-04 (first published: 2022-06-24)
214 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers