FedSearch
Vlad :verified: · @VladDBA
51 followers · 96 posts · Server mastodon.cloud
VladDBA - Get access to SQL Server when you don't have the SA password - VladDBA

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.
vladdba.com/2023/08/07/get-acc

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
48 followers · 85 posts · Server mastodon.cloud

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

vladdba.com/2023/07/29/fix-cer

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
47 followers · 84 posts · Server mastodon.cloud

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.

vladdba.com/2023/07/24/securin

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
47 followers · 84 posts · Server mastodon.cloud

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

vladdba.com/2023/07/10/securin

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
45 followers · 83 posts · Server mastodon.cloud

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.

vladdba.com/2023/06/29/securin

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 82 posts · Server mastodon.cloud

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.

vladdba.com/2023/06/22/testing

#sqlserver #dba #mssqlserver #mssql #sqlserverdba

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 82 posts · Server mastodon.cloud

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.
github.com/VladDBA/PSBlitz

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 80 posts · Server mastodon.cloud

In this post I'm addressing a possible cause and fix for SQL Server connection errors 64 and 233.
vladdba.com/2023/04/26/fixing-

#sqlserver #dba #mssqlserver #mssql #sqlserverdba

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 78 posts · Server mastodon.cloud

PSBlitz has been updated with the latest versions of sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, from Brent Ozar's April release of the First Responder Kit
github.com/VladDBA/PSBlitz

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 78 posts · Server mastodon.cloud
Open media

#sqlserver #mssqlserver #dba #sqlserverdba

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 72 posts · Server mastodon.cloud
GitHub - GitHub - VladDBA/PSBlitz: a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to Excel and saves execution plans and deadlock graphs as .sqlplan and .xdl files.

The latest release of PSBlitz:
- adds the possibility of exporting the output report in HTML format instead of Excel, making Excel/Office no longer a hard requirement for running PSBlitz.
- adds the option to also create a zip archive of the output files
github.com/VladDBA/PSBlitz

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
44 followers · 71 posts · Server mastodon.cloud

PSBlitz has been updated with the latest versions of sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, from Brent Ozar's February release of the First Responder Kit
github.com/VladDBA/PSBlitz

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

Last updated 1 year ago
Original post

Vlad :verified: · @VladDBA
34 followers · 35 posts · Server mastodon.cloud

#sqlserver #dba #chatgpt #mssqlserver #tsql #sqlserverdba #ai

Last updated 2 years ago
Original post