New blog post:
In which I demo a query to get connection information in SQL Server aggregated by database, host, client and login name.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #AzureSQLDB #Azure
https://vladdba.com/2025/04/13/query-connection-information-in-sql-server/

The latest release of PSBlitz:
- Comes with multiple quality of life improvements for HTML reports: large tables can now be filtered by object or database name, and can also be sorted
- Index Fragmentation Info now contains partition numbers and forwarded records count
+ minor bug fixes and enhancements

You can download it from the repository's Releases section.
https://github.com/VladDBA/PSBlitz

#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #PSBlitz #Azure #AzureSQLDB

The latest release of PSBlitz:
- has been updated with Brent Ozar's May release of the First Responder Kit
- now includes the deadlock graph file names in the report
- adds information about TDE status
- provides command suggestions to update stale stats
- has better error handling and debugging info
- includes other minor bug fixes and enhancements

https://github.com/VladDBA/PSBlitz

#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #PSBlitz #Azure #AzureSQLDB

The latest release of PSBlitz:
- has been updated with the latest versions of sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, sp_BlitzWho, and sp_BlitzQueryStore, from Brent Ozar's February release of the First Responder Kit
- includes other minor bug fixes and improvements

You can download it from the repository's Releases section.
https://github.com/VladDBA/PSBlitz

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

The latest release of PSBlitz:
- Adds Azure SQL MI compatibility
- Has improved handling of Azure SQL DB
- Includes other minor improvements and bug fixes
#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #azure #azuresqldb #azuresqlmi

https://github.com/VladDBA/PSBlitz

New blog!

Another one about #Azure #AzureDataFactory and one way to work with deltaloads using an #AzureSqlDb for metadatastorage.

https://sqlreitse.com/2023/04/04/learning-adf-part-6/

New post: "Interesting Stuff - Week 47, 2022".

This week is a mix of the last two weeks' interesting "stuff":

* What are partitions in Kafka.
* Tim Bray writes about AWS and Blockchain.
* SQL Server 2022 released.
* Netflix and anomaly detection.

Read all about it:

https://nielsberglund.com/2022/11/27/interesting-stuff---week-47-2022/

#apachekafka #kafka #ai #ml #azure #sqlserver #azuresqldb