#microsoftsqlserver
LightNews LightNews
amitdiwan.bsky.social
Top 25 SQL Interview Questions and Answers: youtu.be/lvcT1LepmjI?...

#sql #DataAnalytics #sqlserver #studyopedia #MicrosoftSQLServer
SQL Interview Questions and Answers
September 22, 2025 at 5:21 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
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
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:
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
msftmechanics.bsky.social
Run NoSQL in SQL. Store and manage large JSON documents directly in SQL Server 2025. Insert, update, and query JSON data with native tools. Get started. youtu.be/PvA3Ah3JJxg #SQLServer2025 #microsoftsqlserver #microsoft #sql #sqlservermanagementstudio #sqlserver2022
June 3, 2025 at 2:25 AM
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
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
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
msftmechanics.bsky.social
New Change Event Streaming in SQL Server 2025 improves real-time workflow automation. It's event-based, uses native transaction logs, and reduces OI overhead. See it in action. youtu.be/PvA3Ah3JJxg #SQLServer2025 #microsoftsqlserver #microsoft #sql #sqlservermanagementstudio #sqlserver2022
June 3, 2025 at 12:20 AM
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
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
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:
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
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
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
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
vladdba.com
New blog post:
In which I demo a query that lists object dependencies in SQL Server for either a specific object or for the entire database.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Find object dependencies in SQL Server
This is a brief post containing a query that lists object dependencies in SQL Server for a specific object or for the entire database.
vladdba.com
April 15, 2025 at 4:49 PM
vladdba.com
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
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.
vladdba.com
November 24, 2025 at 4:30 PM
vladdba.com
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
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
November 18, 2025 at 4:38 PM
vladdba.com
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
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
vladdba.com
November 3, 2025 at 4:37 PM
vladdba.com
New blog post:
In which I go over some useful information that you should be aware of when working with SQL Server’s IDENTITY columns.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
vladdba.com/2025/07/23/i...
SQL Server IDENTITY columns - an info-dump
In this post I go over some useful information that you should be aware of when working with SQL Server's IDENTITY columns.
vladdba.com
July 23, 2025 at 5:27 PM
msftmechanics.bsky.social
Create Lakehouse shortcuts to connect mirrored databases instantly. Query combined data sets as one logical database using Microsoft Fabric. Watch here.
 https://youtu.be/PvA3Ah3JJxg #SQLServer2025 #microsoftsqlserver #microsoft #sql #sqlservermanagementstudio #sqlserver2022
June 3, 2025 at 8:15 PM
vladdba.com
New blog post:
In which I address a weird misconception floating around LinkedIn and reddit that SQL Server CTEs somehow store results in either memory or tempdb.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
vladdba.com/2025/07/27/s...
No, SQL Server CTEs do not store results
There's this weird misconception floating around LinkedIn and reddit that SQL Server CTEs somehow store results in either memory or tempdb.
vladdba.com
July 28, 2025 at 5:14 PM
msftmechanics.bsky.social
Add multilingual search with open-source or Azure OpenAI embeddings. No code changes required for accurate results. Get started with SQL Server 2025.
 https://youtu.be/PvA3Ah3JJxg #SQLServer2025 #microsoftsqlserver #microsoft #sql #sqlservermanagementstudio #sqlserver2022
June 3, 2025 at 3:05 PM