Karen Lopez ππ©βπ»πAre you feeling fuzzy today? That might be just right.
https://datamodel.com/vector-search-in-sql-server-2025-what-it-is-and-why-it-matters/
#SQLServer #AzureSQLDB
Vlad 
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/
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
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 .xdl files.
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/...
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
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 .xdl files.
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/...
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
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 .xdl files.
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/...
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
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 .xdl files.
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/...
2meterdba | Reitse EskensNew blog!
Another one about #Azure #AzureDataFactory and one way to work with deltaloads using an #AzureSqlDb for metadatastorage.
nielsbNew 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/