WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits
An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.
2019-09-27 (first published: 2017-10-10)
5,959 reads
Kenneth Igiri
- Interests: Strategy, Small Business, Creative Writing
- Skills: Database Management, Data Management, Leadership, Management, Design Thinking
- Twitter: @https://www.x.com/kenigiri/
- Website: https://kennethigiri.com
- LinkedIn: https://linkedin.com/in/kenigiri
Workplace Encounter: Effects of TLS 1.2
In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.
2019-01-03
2,188 reads
The Real World: Implementing Data Compression in SQL Server 2008 R2
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
2018-10-19 (first published: 2016-01-18)
4,490 reads
Configuring Backups Using Veritas Netbackup with AGs
A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.
2017-07-18
5,419 reads
Workplace Encounters: Using Volume Mount Points in SQL FCIs
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
1,062 reads
Installing SQL Server vNext on an AWS EC2 RHEL Instance
The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.
2017-03-16
991 reads
Five Useful SQL Server Management Practices
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,797 reads
SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed
EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.
2016-11-30
2,486 reads
The Real World: Rebuilding Index - 1 Instance, 106 Databases
The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.
2015-02-17
6,529 reads
The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,183 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers