Lightnews — Scholar-powered news

How apps cause ASYNC_NETWORK_IO waits in SQL Server

1 3 4

Vlad Drumea @vladdba.com · 5d

The latest PSBlitz:
- Updated with non-sp versions of sp_Blitz(Cache/First/Index/Lock/Who), from Brent Ozar's October First Responder Kit
- Adds more memory & instance info
- Improves HTML table layout

#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #Azure

PSBlitz.ps1 execution flow in PowerShell

PSBlitz HTML report Instance Overview page

PSBlitz HTML report Extended Index Diagnosis page

1 3

Vlad Drumea @vladdba.com · 18d

I'm reposting this blog post every time I have to troubleshoot a performance issue caused by this scenario where applications cause ASYNC_NETWORK_IO waits in SQL Server.
vladdba.com/2024/01/22/h...
#sqlserver #mssqldba #sql #dba #mssql #sqldba

In this post I cover what the ASYNC_NETWORK_IO wait type is, when it occurs, and applications cause ASYNC_NETWORK_IO waits in SQL Server.

GitHub - VladDBA/PSBlitz: a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and...

Reposted by Vlad Drumea

Marcus Hutchins @malwaretech.com · 26d

Putting the Secret Service's nonsense framing aside, it's a pretty cool discovery. Those black boxes are SIM gateways which you plug sim cards into and they act like virtual cell phones. They then route the access over the internet so people can use the sim cards from anywhere in the world.🧵
1/3

6 54 210

Vlad Drumea @vladdba.com · 27d

The latest release of PSBlitz:
- Fixes a bug in the HTML report that was breaking hyperlinks to articles (MS Learn, blog posts, etc.)
- Addresses a data type overflow that occurred when retrieving instance information
#sqlserver #sqldba #powershell #mssqlserver #mssql
github.com/VladDBA/PSBl...

a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files. - VladDBA/...

github.com

Vlad Drumea @vladdba.com · Sep 12

Ah, yes, the mythical SQL Server 2018 that only Copilot and probably Satya know about.😅

Copilot Search returning information about Maximum Partitions in SQL Server 2018

Securing SQL Server linked servers

Vlad Drumea @vladdba.com · Sep 11

Blog post from the past:
In which I address improper linked server configurations and their potential impact, as well as recommendations for securing SQL Server linked servers.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2023/07/10/s...

In this post I address improper security configurations and their impact, as well as recommendations for securing SQL Server linked servers.

GitHub - VladDBA/PSBlitz: a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and...

Vlad Drumea @vladdba.com · Sep 11

The latest release of PSBlitz:
- Fixes some bugs related to the HTML report
#sqlserver #sqldba #powershell #mssqlserver #mssql
github.com/VladDBA/PSBl...

a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files. - VladDBA/...

github.com

Vlad Drumea @vladdba.com · Sep 1

This reminds me that I should probably write a blog post on my experience at Data Saturday Croatia

3

Reposted by Vlad Drumea

Reitse Eskens @2meterdba.bsky.social · Sep 1

I’m working on a blog post on why people should attend in-person events. I can think of many reasons but I’d love the input of the broader community. If you have a few seconds to spare, please fill in this link. Thanks! #DataSaturday #SqlSaturday #Meetup

forms.office.com/Pages/Respon...

Microsoft Forms

forms.office.com

4 6 8

Reposted by Vlad Drumea

Darth Putin @darthputinkgb.bsky.social · Aug 30

Talking Ukraine war with Xi
Me: "Any peace plan must require Zelensky to stop fighting"
Xi: "What will happen if he doesn't?"
Me: "Russia will lose"

I remain a master strategist

8 99 770

Vlad Drumea @vladdba.com · Aug 30

subskying?

PoCs for two SQL Injection vulnerabilities fixed in SQL Server 2022 GDR KB5063814

Vlad Drumea @vladdba.com · Aug 29

New blog post:
In which I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814.
vladdba.com/2025/08/29/p...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security #sqli #sqlinjection

In this post I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814

Fix implicit conversion when you can't change the query

Vlad Drumea @vladdba.com · Aug 27

In some weird uno reverse type of way a company has offered to pay me in "exposure" on my own blog for reviewing their product.
Thanks, vendor of [#database corruption recovery tool], but, as tempting as being paid with the opportunity to write a review for your product sounds, I'll have to pass.

This collaboration can be mutually beneficial. Your readers will gain access to insightful, high-quality technical content, while we will increase visibility for our product. It’s a win-win opportunity worth exploring.

Vlad Drumea @vladdba.com · Aug 21

Blog post from the past:
In which I cover how to fix performance problems caused by implicit conversion when the query cannot be modified.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/09/15/i...

In this post I cover ways to fix implicit conversion related performance problems when the query cannot be modified.

Vlad Drumea @vladdba.com · Aug 18

To add to the confusion, while "rein" and "reign" differ by a "g" in the middle of the word, but are pronounced the same, there are words like "baked" and "naked" which somehow manage to sound nothing alike (beɪkt and neɪkɪd, instead of beɪkt and neɪkt or beɪkɪd and neɪkɪd).

2 1 4

Vlad Drumea @vladdba.com · Aug 18

Also "could/should/would have" not "could/should/would of".
These problems wouldn't exist if English wouldn't have such a difference between how a word is written and how it's pronounced.
Imagine having the words "rein" and "reign" and somehow pronouncing them the same way (ɹeɪn).

1 1 11

Reposted by Vlad Drumea

Zack Labe @zacklabe.com · Aug 17

100 years of July temperature anomalies over land areas through 2025...

Data from NOAAGlobalTemp v6.0.0: www.ncei.noaa.gov/products/lan...

60 530 1.3K

Vlad Drumea @vladdba.com · Aug 17

So, are people migrating from GitHub to Codeberg?

Aspect Ratios with Sinners Director Ryan Coogler

Vlad Drumea @vladdba.com · Aug 17

The clip of Ryan Coogler nerding out over aspect ratios and filming techniques is what convinced me to go see it in theater.
www.youtube.com/watch?v=78Ru...

YouTube video by Kodak

www.youtube.com

What are implicit conversions in SQL Server?

Reposted by Vlad Drumea

Darth Putin @darthputinkgb.bsky.social · Aug 15

Preparing for summit with Donald.

23 170 950

Vlad Drumea @vladdba.com · Aug 15

Blog post from the past:
In which I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/09/11/i...

In this post I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance.