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