Blog post from the past:

In which I go through my SQL Server Management Studio configuration. 

https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration/

#sql #sqlserver #dba #mssqlserver #mssql #sqlserverdba

My SQL Server Management Studio configuration

SQL Server Management Studio 19 has just been released last week so I've made this post to go through my usual configuration for SSMS.

VladDBA

I found the bar where developers who dislike set theory like to hang out. 😅

Context for anyone not getting the reference: https://en.m.wiktionary.org/wiki/RBAR

#sqlserver #dba #mssqlserver #mssql #sqlserverdba

RBAR - Wiktionary, the free dictionary

Wiktionary

BLOG POST!

In my previous blog posts, I have blogged about the step by step guide on how to enable the Azure AD Authentication to on-prem SQL Servers. In this post, you will learn how to enable Azure AD Authentication for the SQL Server 2022 hosted on Azure VM.

#sqlserver2022 #sqlserverdba #azuresql #AzureArc

https://dbanuggets.com/2023/09/19/sql-server-2022-enable-azure-ad-authentication-for-sql-server-on-vm/

SQL Server 2022: Enable Azure AD Authentication for SQL Server on VM

To enable the SQL Server 2022 on a virtual machine to use Azure AD, we need below things: Managed identity and its permissions to query Microsoft Graph: When you enable the AD on the SQL Server 202…

Deepthi Goguri's SQL Server Blog

In this post I'll cover a quick way to get access to SQL Server when you don't have a login and don't know the password for the SA account.
This is perfect for when you "inherit" an instance from another team.
https://vladdba.com/2023/08/07/get-access-to-sql-server-when-you-dont-have-the-sa-password/

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #powershell

Get access to SQL Server when you don't have the SA password

In this post I'll cover a quick way to get access to SQL Server when you don't have a login and don't know the password for the SA account.

VladDBA

This is a brief post about how to fix "The certificate chain was issued by an authority that is not trusted" error when using @dbatools

https://vladdba.com/2023/07/29/fix-certificate-authority-that-is-not-trusted-when-using-dbatools

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #powershell #dbatools

Fix "certificate chain was issued by an authority that is not trusted" when using dbatools - VladDBA

How to fix "The certificate chain was issued by an authority that is not trusted" error when using dbatools.

VladDBA

In this post I'm covering the risks brought on by not securing SQL Server's service account and setting it to run under a privileged account, and demo how an attacker can leverage it to gain access to the instance's host.
It was fun using Burp Suite Pro to demo data exfiltration through HTTP, as well as HoaxShell to demo initiating a reverse shell connection, all from SQL Server.

https://vladdba.com/2023/07/24/securing-sql-servers-service-account/

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #windows #security #hoaxshell #burpsuite

Securing SQL Server's service account - VladDBA

In this post I'll be covering the risks brought on by not securing SQL Server's service account and setting it as a privileged account.

VladDBA

In this post I address improper configurations and their impact, as well as recommendations for securing SQL Server linked servers.

https://vladdba.com/2023/07/10/securing-sql-server-linked-servers

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #windows #security

Securing SQL Server linked servers

In this post I address improper security configurations and their impact, as well as recommendations for securing SQL Server linked servers.

VladDBA
In this post I cover two ways of properly securing xp_cmdshell in SQL Server 2022 to avoid unrestricted access to the underlying Windows OS.
#sqlserver #dba #mssqlserver #mssql #sqlserverdba #windows
https://vladdba.com/2023/06/29/securing-xp_cmdshell-in-sql-server-2022
Securing xp_cmdshell in SQL Server

In this post I cover two ways of properly securing xp_cmdshell in SQL Server to avoid unrestricted access to the underlying Windows OS.

VladDBA

In this post I'm going over some large insert speed tests in SQL Server using various table types as targets, combinations of TABLOCK and MAXDOP 0, compression, and recovery models.
#sqlserver #dba #mssqlserver #mssql #sqlserverdba

https://vladdba.com/2023/06/22/testing-large-insert-speeds-in-sql-server

Testing large insert speeds in SQL Server

Testing large insert speeds in SQL Server using various table types as targets, combinations of TABLOCK and MAXDOP 0, compression, and recovery models.

VladDBA

The latest release of PSBlitz brings improvements to the layout and navigation of the HTML report along with fixing a few bugs introduced in the previous release.
https://github.com/VladDBA/PSBlitz

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #PowerShell

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/...

GitHub