#SqlDBA
LightNews LightNews
eitanblumin.bsky.social
Honest question for #SqlFamily ... Am I the only one who noticed that my computer gets all slow and stuttery every time I open the new #SSMS v21?

#SqlHelp #SqlDBA #SQLServer
July 2, 2025 at 7:24 AM
vladdba.com
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
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
November 17, 2025 at 3:49 PM
vladdba.com
Exfiltrating data from SQL Server 2025 using sp_invoke_external_rest_endpoint.
No xp_cmdshell, no fancy external tools.
Exfiltrating login hashes, text & PNG files using WordPress comments as the target REST API endpoint.
#sqlserver #sqldba #sql #mvpbuzz #cybersecurity #security #infosec #powershell
Exfiltrate data from SQL Server 2025 with sp_invoke_external_rest_endpoint
How an attacker can take advantage of SQL Server 2025's sp_invoke_external_rest_endpoint to exfiltrate data from a compromised instance.
vladdba.com
July 22, 2026 at 3:42 PM
vladdba.com
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
madesimplemssql.bsky.social
Optimizing query performance requires maintaining current SQL Server statistics. Let's Explore Deeply:

madesimplemssql.com/update-stati...

Please follow us on FB: www.facebook.com/profile.php?...

#administration #DBA #Admin #data #madesimplemssql #code #azure #mssql #coder #sqldba #developer
April 3, 2025 at 5:07 PM
vladdba.com
SQL Server Management Studio 21.2.5 is out.

Fans of maintenance plans and SSIS will be happy to know the two features have been reinstated as part of this update.

Release notes: learn.microsoft.com/en-us/ssms/r...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms
SSMS 21.2.5 update notice
June 10, 2025 at 5:55 PM
vladdba.com
In this blog post I go over my reasons for always recommending SQL Server Developer Edition over Express Edition for learning SQL Server
#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/11/12/d...
6 reasons for using Developer Edition over Express for learning SQL Server
In this blog post I go over my reasons for always recommending SQL Server Developer Edition over Express Edition for learning SQL Server
vladdba.com
November 12, 2024 at 6:13 PM
vladdba.com
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...
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.
vladdba.com
October 17, 2025 at 8:01 PM
vladdba.com
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
vladdba.com
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
eitanblumin.bsky.social
Announcing the release of SQL Server Management Studio 22.1
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #SqlDba #MadeiraData
SSMS 22.1 Release
SSMS 22.1 is now available and includes improvements and updates for GitHub Copilot in SSMS, and a set of fixes for SSMS.
techcommunity.microsoft.com
January 5, 2026 at 11:00 AM
madesimplemssql.bsky.social
SQL Server deadlocks are common, particularly in multi-user environments where concurrency is essential. Let's Explore Deeply:
madesimplemssql.com/deadlocks-in...

#database #data #Admin #madesimplemssql #canada #germany #australia #poland #azure #russia #india #dbms #sqldba #DBA #DBAProgram #SQLDBA
SQL Server deadlocks
June 11, 2025 at 6:36 PM
vladdba.com
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 main/index page PSBlitz HTML report Instance Overview page PSBlitz HTML report Extended Index Diagnosis page
October 14, 2025 at 4:16 PM
eitanblumin.bsky.social
Breaking Changes & Migration Risks in #SQLServer2025 - by Rebecca Lewis
www.sqlfingers.com/2025/10/brea...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Breaking Changes & Migration Risks in SQL Server 2025
Breaking Changes & Migration Risks in SQL Server 2025 Every new SQL Server release comes with shiny features — but SQL Server 2025...
www.sqlfingers.com
November 5, 2025 at 11:02 AM
vladdba.com
Blog post from the past:
I which I demo creating and managing aliases via @dbatools.io, cliconfig, SQL Server Configuration Manager, and registry keys.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #powershell
vladdba.com/2023/09/29/c...
Configuring and using SQL Server client aliases
In this post I cover SQL Server client aliases, what they are and when they're useful, as well as how to configure, update, and use them.
vladdba.com
February 24, 2025 at 8:59 PM
vladdba.com
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
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
vladdba.com
December 3, 2025 at 5:33 PM
vladdba.com
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
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.
vladdba.com
January 13, 2026 at 4:23 PM
vladdba.com
New blog post:
In which I explore the impact of SQL Server 2025’s PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security #pbkdf2
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.
vladdba.com
June 23, 2025 at 5:29 PM
eitanblumin.bsky.social
Fundamentals of #Azure #DevOps with SQL projects
devblogs.microsoft.com/azure-sql/fu...

#Microsoft #SQLServer #SqlDBA #SSDT #MadeiraData
Fundamentals of Azure DevOps with SQL projects - Azure SQL Dev Corner
Building automated pipelines with your SQL database projects enables you to build a rich CI/CD ecosystem to ensure that your application is being deployed
devblogs.microsoft.com
July 13, 2026 at 10:03 AM
madesimplemssql.bsky.social
DQS: A Deep Dive

madesimplemssql.com/dqs-in-sql-s...

#databaseadministration #databasetrusted #DataBaseManagement #PowerBI #PowerBITraining #madesimplemssql #datacollection #uae #sequel #dataharvest #dataextraction #technology #sqldatabase #sqlserverdba #usa #uk #eu #azure #sqlserverdba #sqldba
DQS in SQL Server: Top 5 Benefits - MadeSimpleMSSQL
Uncover the secrets behind impeccable data management with our comprehensive guide to Data Quality Services (DQS) in SQL Server.
madesimplemssql.com
September 20, 2025 at 3:50 PM
vladdba.com
New blog post:
Containing a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Script to reseed out-of-sync sequences used for default constraints
This is a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints.
vladdba.com
July 21, 2025 at 3:55 PM
eitanblumin.bsky.social
Recently released: Updates to #SQLprojects in #SSMS, #VSCode, and #SqlPackage
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #DevOps #SqlDBA #MadeiraData
Recently released: Updates to SQL projects in SSMS, VS Code, and SqlPackage | Microsoft Community Hub
Your database should be part of the same development process as the rest of your application, with source control and automation for validation and...
techcommunity.microsoft.com
August 9, 2026 at 10:00 AM
madesimplemssql.bsky.social
The SQL IN operator is a powerful comparison tool used in WHERE clauses to filter results based on a list of values. Let’s Explore Deeply.

madesimplemssql.com/sql-in-opera...

#dbms #Database #sqldatabase #sqldba #DBA #DBAProgram #madesimplemssql #SQLDBA #coding #backend #sqlquery #sql_help
SQL IN Operator: Top 5 Benefits - MadeSimpleMSSQL
Explore SQL IN Operator in details. This article offers a complete guide to help developers, and users.
madesimplemssql.com
July 3, 2025 at 5:47 PM
vladdba.com
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
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.
vladdba.com
December 9, 2025 at 5:46 PM
vickyharp.com
Windows and Linux, yes. Physical and virtual. RT @SQLDBA: @vickyharp That's Windows Server backups, not SQL Server, right? #Idera
November 18, 2024 at 4:49 AM