SQL Server Network Related Performance Monitor Counters
In this article we cover which performance monitor counters to use to baseline and troubleshoot SQL Server network issues that may be causing performance issues.
2021-11-01
Additional Articles
Cybersecurity threats
Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats in today’s world.
2021-10-29
5 things to look for in a monitoring tool
A key finding from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals was that 79% of respondents reported using either a third-party or in-house monitoring tool. It’s notable because it’s an increase of 10 percentage points from the same survey last year. But when should you use an in-house tool, and when should you take the plunge and invest in a third-party monitoring tool like SQL Monitor?
2021-10-27
How to successfully deploy databases with external references
Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian Meine demonstrate a solution.
2021-10-27
Dealing with Failed SQL Migrations in MariaDB or MySQL
Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
2021-10-25
SQL String functions in SQL Server, Oracle and PostgreSQL
In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
2021-10-25
Flyway with MariaDB for Those of a Nervous Disposition
This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
2021-10-22
Working with SQL Server identity columns
SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.
2021-10-22
How to Enable and Disable Full Text Search for SQL Server Databases
Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.
2021-10-20
Troy Hunt talks Security and compliance in estate monitoring
Troy Hunt joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance.
2021-10-20
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers