Looking into SQL Server 2025's new PBKDF2 hashing algorithm In this post I explore the impact of SQL Server 2025's PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022.

Blog post from the past:
In which I explore the impact of SQL Server 2025’s #PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022
vladdba.com/2025/06/23/l...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Screenshot der Microsoft-Learn-Dokumentation zu „ABS (Transact-SQL)“ im Dark Mode. Links ist die Navigationsleiste mit mathematischen SQL-Funktionen zu sehen, darunter markierte Einträge wie „ABS (Antiblockiersystem)“, „ASIN“ und „Boden“. Ein roter Pfeil weist auf den falschen Navigationspunkt „ABS (Antiblockiersystem)“ hin. Rechts steht die eigentliche Dokumentationsseite zu „ABS (Transact-SQL)“ mit Beschreibung, Syntax und Argumenten.

#Microslop tut mal wieder Dinge in ihrer Dokumentation

Kennt ihr schon die ABS-(Antiblockiersystem), ASIN- (Amazon Standard-Identifikationsnummer) und Boden Funktion im #Microsoft #SQL #Server

#mssql #ai #copilot

How to Install Microsoft SQL Server on Ubuntu VPS (10 Minute Quick-Start Guide) This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS. What is Microsoft SQL Server? Mi...

#Guides #Cloud #VPS #adminer #apache #firewall […]

[Original post on blog.radwebhosting.com]

MSSQL Extension for VS Code: Query Profiler, ADS Migration Toolkit & More - Azure SQL Dev Corner Discover what's new in MSSQL Extension for VS Code v1.40: Query Profiler, ADS Migration Toolkit, Database Backup & Restore, Flat File Import, and more.

#MSSQL Extension for #VSCode: Query Profiler, ADS Migration Toolkit & More

devblogs.microsoft.com/azure-sql/vs...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Dangerous SET options stored procedure inherit from your session ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created

Blog post from the past:
In which I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
vladdba.com/2025/03/03/d...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Хочу все знать В проекте часто бывает некий data-flow который идет через ETL или даже отдельные серверы обогащени...

#postgresql #mongodb #mysql #mssql #cassandra #redis #rabbitmq #kafka #elasticsearch

Origin | Interest | Match

Хочу всё знать В проекте часто бывает некий data-flow, который идет через ETL или даже отдельные серверы обогащен...

#postgresql #mongodb #mysql #mssql #cassandra #redis #rabbitmq #kafka #elasticsearch

Origin | Interest | Match

Getting Started with SQL Database Project Power Tools SQL Database Project Power Tools is a free Visual Studio extension that makes working with SQL database projects easier and more productive. This guide will help you get started with the key features.

erikej.github.io/dotnet/dacfx... - #SQL #Database project power tools for #dotNET and #MSSQL developers looking to version their data schema.

Change the edition of a SQL Server on Linux instance In this post I cover the steps required to change (downgrade or upgrade) the edition of a SQL Server instance running on Linux.

New blog post:
Outlining the process of changing the edition of a SQL Server instance on Linux
vladdba.com/2026/02/03/c...
#linux #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Getting started with SQL Server 2025 on Ubuntu 24.04 Previously I've set up an Ubuntu 24.04 VM, so I figured I'd cover the process of setting up SQL Server 2025 on Ubuntu 24.04.

New blog post:
In which I cover the process of setting up SQL Server 2025 on Ubuntu 24.04, connecting and restoring a sample database.
vladdba.com/2026/02/02/s...
#linux #ubuntu #virtualbox #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Thinking about going to #SQLCON in Atlanta in March? Join intustry leaders including mysql, Bob Ward, @joeydantoni.com, @sqlespresso.bsky.social,
@sqlrus.bsky.social and many more.

Use code SQLCMTY200 to save $200 of registration. aka.ms/sqlcon
#sqlserver #mssql #sqlfamily #azuresql #dataplatform

T-SQL Tuesday #194 - learning from mistakes My first time participating in T-SQL Tuesday, and Louis Davidson's invitation "learning from mistakes" seemed like the perfect opportunity.

New blog post:
My first ever contribution to T-SQL Tuesday.
vladdba.com/2026/01/20/t...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #tsql2sday

Speeding up SELECT COUNT in SQL Server In this post I'll cover ways of speeding up SELECT COUNT as well as some myths about best practices when it comes to SELECT COUNT.

Blog post from the past:
In which I cover ways of speeding up SELECT COUNT in SQL Server as well as some myths about best practices when it comes to SELECT COUNT.
vladdba.com/2023/08/21/s...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

The hidden costs of heaps in SQL Server In this post I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables.

New blog post:
In which I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables.
vladdba.com/2025/12/30/t...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Most popular blog posts in 2025 It's time for my annual roundup of the most popular blog posts in 2025 by views, likes, and comments.

New blog post:
My most popular blog posts in 2025 by views, likes, and comments.
vladdba.com/2025/12/27/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Import and query HTML table data in SQL Server In this post I cover a way to import and query HTML table data in SQL Server using only T-SQL and no external tools.

Blog post from the past:
In which I demo how to import and query HTML table data in SQL Server using only T-SQL.
vladdba.com/2023/11/03/i...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Page compression on heaps implies some extra work I recently ran into SQL Server's page compression being applied to a heap, and I figured I'd cover why that won't work how some folks expect.

New blog post:
In which I cover a sometimes overlooked gotcha when using page compression on heaps.
vladdba.com/2025/12/09/p...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

GitHub - Azure/data-api-builder: Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores. Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores. - Azure/data-api-builder

There's 3 "#SQL #MCP Servers" for #MSSQL:
- Data only: github.com/Azure/data-a...
- Developer: learn.microsoft.com/en-us/sql/to...
- A demo in #dotNET and #Node: devblogs.microsoft.com/azure-sql/in...

GitHub - Azure/data-api-builder: Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores. Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores. - Azure/data-api-builder

github.com/Azure/data-a... - #Data #API Builder can create a #REST #API, #GraphQL, and/or #MCP for #MSSQL, #Postgres, #MariaDB data #CRUD: github.com/Azure/data-a...

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... 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 PSBlitz:
- Updated with the non-sp versions of sp_Blitz* from Brent Ozar's Nov. release of the First Responder Kit
- Adds buttons to copy query text from the HTML report
- Overview of findings/issues in HTML report's main page
#sqlserver #sqldba #powershell #mssqlserver #mssql #powershell

Import saved connections from SSMS 21 to SSMS 22 This blog post is a guide for migrating saved connection details from SQL Server Management Studio 21 to SSMS 22

Updated blog post:
Added information about limitations and a workaround for transferring SSMS 21 connection history data to SSMS 22 when using the classic Connection Dialog.
vladdba.com/2025/11/17/i...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

Getting Started with MSSQL Dashboards - SquaredUp In this article we demonstrate how you can visualize the results of queries running on your MSSQL databases.

Microsoft's SQL Server is one of the most popular database platforms in the world. Whether you are running SQL Server on-prem or in the cloud, you can use SquaredUp to connect to your MSSQL databases and query and visualise your data:

squaredup.com/blog/getting...

#dashboards #mssql

PowerShell script to extract SSMS 21 and 22 saved connection data In this post I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information.

New blog post:
In which I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information.
vladdba.com/2025/11/22/p...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

Import saved connections from SSMS 21 to SSMS 22 This blog post is a guide for migrating saved connection details from SQL Server Management Studio 21 to SSMS 22

New blog post:
In which I show you how to easily migrate saved connection details from SQL Server Management Studio 21 to SSMS 22.
vladdba.com/2025/11/17/i...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

My SQL Server Management Studio 22 configuration SQL Server Management Studio 22 just went GA this week, so I figured I'd document my new configuration in a blog post.

New blog post:
In which I share my SQL Server Management Studio 22 configuration.
vladdba.com/2025/11/16/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms

Replicating SQL Server 2025's PBKDF2 hashing algorithm using T-SQL In this post I talk some more about SQL Server 2025's new PBKDF2 and demo a method to replicate it using T-SQL

New blog post:
In which I demo a pure T-SQL implementation of SQL Server 2025's new PBKDF2 hashing algorithm

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security

Question for #Perl folks using #DBIxClass and #SQLTranslator with #PostgreSQL #Postgres and/or #SQLServer #MSSQL

Is it expected that the producer for SQL server will use the data type survivor in your schema verbatim even if it’s not supported?

I’m working in an app that has a Postgres DB with […]

How can I reset mssql express permissions when I can't even login to a single user mode? ("Account is disabled")
#askfedi #mssql

SQL Server Management Studio 22 Preview 3 - first impressions SQL Server Management Studio 22 Preview 3 was released 2 days ago, so I took it out for a spin and here are my first impressions so far.

New blog post:
SSMS 22 Preview 3 comes with some promissing features and improvements.
And the startup speed has finally been noticeably improved
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
vladdba.com/2025/10/16/s...

Explore how WinForms is still relevant in 2025 with a seamless MSSQL monitoring app! Learn about its robust features, enhanced UI, and efficient data management. #WinForms #MSSQL