SQL Server Extended Events Filtering by Database Name
In this article we look at how to properly filter out events using a database name pattern in an Extended Events Session.
What's the Quarantine state in Windows Failover Clusters
In this article we cover why Windows Failover Cluster nodes can go into a quarantined state, how to resolve this as well as how to set threshold values for this cluster node state.
Let it go
I’ve been digging through the 18 years’ worth of articles, editorials, blogs, contests, interviews, promotions, and announcements over at Simple Talk. There are over 5000 posts, and many are quite outdated, especially those announcing beta versions of software or other time-sensitive content. Some articles haven’t seen the light of day for 10 years, yet some […]
Guide to Quickly Creating an Azure Data Lake Storage
Read a step by step guide to setting up an Azure Data Lake Storage account.
Tough Interview Questions
Steve ran across a list of interview questions and wonders if it's a good test for an experienced database developer.
Your SQL Servers Are Misconfigured...
It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
Do it. Try it. Fix it.
Building better software requires some experimentation, but also some learning. Building better software as an organization requires even more.
sp_who4
Introduction The analysis of blocking in SQL Server can be hard if the SQL Server instance has a high number of active connections. This analysis becomes complicated because busy instances could have more than one blocking connection, meaning that we could have more than just one blocking chain. For every group of blocked connections, we […]
Blogs
Denver Dev Day Oct 2024 Slides
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
Should I Learn PostgreSQL
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
A New Word: Hickering
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Forums
New article
Comments posted to this topic are about the item New article
Monitoring Azure Blob Storage
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers