#MSSQLServer
New blog post:
Are blogs still relevant?
I asked my analytics dashboard, but it declined to comment.

vladdba.com/2026/11/10/t...

#sqlserver #tsql2sday #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
T-SQL Tuesday #204 - Yes, maybe, I don't know
This month’s T-SQL Tuesday invitation comes from Jeff Iannucci, and it’s titled “Are blogs still relevant?”.
vladdba.com
November 10, 2026 at 8:10 AM
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
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
vladdba.com
November 4, 2026 at 7:05 PM
New blog post & my 4th contribution to T-SQL Tuesday:
About a two week long outage caused by the Ryuk ransomware.
60+ instances restored, reinfections fought, and how I used Ryuk's own file filtering logic to protect local backups.
#sqlserver #mssqlserver #infosec #tsql2sday #cybersecurity #mvpbuzz
T-SQL Tuesday #202 - Two weeks of ransomware and my most memorable outage
This month’s T-SQL Tuesday invitation comes from Marlon Ribunal, and it's titled "That One SQL Server Outage You’ll Never Forget".
vladdba.com
September 8, 2026 at 8:46 PM
MS SQL Server 2025 Preview Ready? Manage it with Valentina Studio. Free version available now. #sqlserver #mssqlserver bit.ly/44bqsN8
June 23, 2025 at 1:58 PM
I would say it depends on the complexity of the query

If I have lots of where's then A but B if it was the only clause.

#eloquent #sql #laravel #php #database #postgres #mysql #mssqlserver #sqlite
June 4, 2026 at 6:00 AM
Just hammering my database a little bit

#WindowsServerDataCenterEdition
#SSMS
#MSSQLServer
April 22, 2026 at 6:46 AM
Having another crack at a DB talk later this week.

I got some feedback from the last one so, will be tweaking it for this next presentation.

What this really means is more preparation less winging ;)

#msSqlServer #laravel #WhatDoDatabasesDoForUs
#DiggingIntoDatabases #techsky #toastmasters
April 7, 2026 at 11:41 PM
環境再構築してから久しぶりにMSSQLServer再構築。
再構築自体は簡単なんだけど、ODBCとAccessを接続するのにいつも大騒ぎに成る。
June 27, 2024 at 2:32 AM
#ubuntu の #docker で動かしていた #mssqlserver を #synology のNASに移動。2022にする予定だったのだが、色々上手く行かなかったので2019にしたのだわ。
November 25, 2024 at 5:51 PM
December 2, 2024 at 6:09 PM
It’s “enterprise-grade” more comparable to MSSQLServer or Oracle.
November 30, 2024 at 4:05 AM
I need a complete list what needs to be done when upgrading a #MSSQLServer 2000 to e.g. the new 2008 R2 - any sql-syntax changed etc.
February 26, 2025 at 3:07 PM
IMHO, Microsoft deleting third-party packages that depend on a vulnerable version of Microsoft.Identity.Client is very irresponsible. github.com/serilog-mssq...
Version 8.2.1 not listed on nuget.org · Issue #625 · serilog-mssql/serilog-sinks-mssqlserver
One of my projects was updated from Dependabot on 7/8/25 to reference Serilog.Sinks.MSSqlServer v8.2.1, and as of today this version is not available via nuget.org.
github.com
July 10, 2025 at 6:25 PM
The latest release of PSBlitz:
- Adds more security checks related to xp_cmdshell, sp_invoke_external_rest_endpoint, and additional high privilege roles and permissions
github.com/VladDBA/PSBl...

#sqlserver #sqldba #powershell #mssqlserver #mssql #mssqldba #PSBlitz #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...
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
August 9, 2026 at 9:49 PM
Recently updated blog post:
Documenting my SQL Server Management Studio configuration.
vladdba.com/2025/11/16/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
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.
vladdba.com
August 6, 2026 at 4:31 PM
New blog post:
In which I cover the process of spinning up an Azure SQL Database container using #QNAP Container Station.
vladdba.com/2026/08/02/a...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
Setting up an Azure SQL DB container in QNAP Container Station
In this post I cover the process of setting up, connecting to and interacting with an Azure SQL DB container in QNAP's Container Station.
vladdba.com
August 4, 2026 at 3:30 PM
New blog post:
In which I cover the process of spinning up an Azure SQL Database container in Podman.
vladdba.com/2026/08/02/a...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
Setting up an Azure SQL DB container in Podman
In this post I cover the process of setting up, connecting to and interacting with an Azure SQL DB container in Podman.
vladdba.com
August 3, 2026 at 7:03 PM
New blog post:
Querying Shodan's REST API directly from SQL Server using SQL Server 2025's sp_invoke_external_rest_endpoint stored procedure.
vladdba.com/2026/07/19/s...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz #cybersecurity #security #infosec
Querying Shodan with SQL Server's sp_invoke_external_rest_endpoint
In this post I'm querying Shodan's REST API directly from SQL Server using SQL Server 2025's sp_invoke_external_rest_endpoint.
vladdba.com
July 21, 2026 at 12:25 PM
New blog post:
My third contribution to T-SQL Tuesday, about things that make me instantly think a query is bad.
vladdba.com/2026/07/07/t...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #tsql2sday #azure #azuresql #mvpbuzz
T-SQL Tuesday #200 – things that make me instantly think a query is bad
This month's T-SQL Tuesday invitation comes from Brent Ozar, and it's titled "When I’m looking at a query, I bet it’s bad if I see __.".
vladdba.com
July 7, 2026 at 2:55 PM
New blog post:
On my experience as a first time speaker at a Data Saturday conference at Data Saturday Croatia 2026.
vladdba.com/2026/06/23/a...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
From Attendee to Speaker: My first Data Saturday session
In this post I cover my experience as a first time speaker at a Data Saturday conference at Data Saturday Croatia 2026.
vladdba.com
June 23, 2026 at 1:55 PM