#sqlserverdba — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlserverdba, aggregated by home.social.
-
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/
-
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
-
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
-
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
-
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
-
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
-
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'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 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 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 -
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 -
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 #sqlserverdbahttps://vladdba.com/2023/06/22/testing-large-insert-speeds-in-sql-server
-
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 #sqlserverdbahttps://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
-
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
-
In this post I'm addressing a possible cause and fix for SQL Server connection errors 64 and 233.
https://vladdba.com/2023/04/26/fixing-sql-server-connection-errors-64-233 -
In this post I'm addressing a possible cause and fix for SQL Server connection errors 64 and 233.
https://vladdba.com/2023/04/26/fixing-sql-server-connection-errors-64-233 -
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
https://github.com/VladDBA/PSBlitz#sqlserver #PowerShell #dba #mssqlserver #mssql #sqlserverdba
-
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
https://github.com/VladDBA/PSBlitz#sqlserver #PowerShell #dba #mssqlserver #mssql #sqlserverdba
-
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
https://github.com/VladDBA/PSBlitz#sqlserver #PowerShell #dba #mssqlserver #mssql #sqlserverdba
-
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
https://github.com/VladDBA/PSBlitz#sqlserver #PowerShell #dba #mssqlserver #mssql #sqlserverdba
-
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
https://github.com/VladDBA/PSBlitz#sqlserver #PowerShell #dba #mssqlserver #mssql #sqlserverdba
-
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
https://github.com/VladDBA/PSBlitz#sqlserver #PowerShell #dba #mssqlserver #mssql #sqlserverdba