This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression type, number of nonclustered indexes and their total size.

https://vladdba.com/2023/08/24/script-to-get-table-sizes-in-sql-server/

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #tsql

Am I the only one to really prefer #sqlserver #mssql compared to #postgresql and #mysql ? 😆

I love the features, quality of the tooling and backup management.

Just a shame than this one is not open source, and still waiting for ARM support (until that there is Azure SQL edge that is kind of equivalent).

And you what is your favorite and why ?

#developer #sre #devops #dba #database #dotnet #python

#database #dba question for you wise people:

I have a large (~ 1 billion rows) dataset that I'm trying to pick a database for. The dataset is unique in that after an initial loading period, the data itself will be static.

Are there any databases or types of dbs I should look into that are optimized for this sort of write-once, read-often paradigm?

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

C'est quand même génial, comme juste d'ajouter deux index à #PostgreSQL fait passer une tâche cron de trois jours à un quart d'heure.

#DBA

Le #DBA « J’ai un petit truc à faire, y’a un moment où la base ne serait pas sollicitée? »

Moi « Ok je bloque les scripts de 19h à 20h »

19h10 le DBA « ok c’est lancé, ça devrait durer 3 heures »

Bon ok, on n’a pas la même notion de « petit truc »😩😭

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

Madre mía, WakandaDB 🤪 , base de datos orientada a objetos, multiplataforma y opensource. Integrado en un servidor que proporciona una REST API y un motor JS del lado del servidor para acceder a los datos.

Se nota de que es un gran fan de Marvel, entiendo que de allí tomo el nombre.

http://wakanda.github.io/

#database #DBA

Happy #DBA #Appreciation Day! If you don't know who to thank today, thank your #Database #Administrators. They keep stuff running 24/7!

https://dbaday.org/

#DBADay #administration #administrator #databases #DatabaseAdministration #PostgreSQL #postgres #MySQL #oracle #SQLServer #DB2 #MariaDB

Thank you every #DBA keeping essential database services running 24×7×365 your dedication, strategic planning, optimisation, scaling and the hard work that goes unseen, your efforts are appreciated. #PostgreSQL
https://dbaday.org/

DBA a life in the shadows
Database administration is weird. The job is a strange combination of theory and practice, strictness and loose rules mixed together in a magic blend.

The DBA is probably one of the most obscure and one of the less appreciated roles within the IT organisations.

Today is the day to say thank you to your DBA!

https://dbaday.org/

#dba #dbaday #databaseadministration #postgresql #mysql #oracle #sqlserver #firebird

This Friday there will be the #dbaday 2023.

The 7th July 2023 say thank you to your #dba for keeping your data safe and sound. #thankyou#data#database#administrators#appreciation#day

https://dbaday.org/

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 #sqlserverdba

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

Oh you silly DBA Padawan!

#StarWars #databases #dba

Hahaha ça casse un (petit) sucre sur le dos des developpeurs #DBA #pgdayFrance

@dansup @darnell @gabek @syuilo @Gargron @owncast

One thing I would love to see more projects do is label some of the low priority but simple issues as a good first issue. You can see that here on the #dbatools repo. That gives people curious about contributing a good place to start and get their feet wet.

I'm a #sqlserver #DBA, I don't know #php. When looking at the issues list, I don't even know where I'd begin. A label would help with that.

https://github.com/dataplat/dbatools/labels/good%20first%20issue

Shoutout to the #sqlserver #dba crowd. If my ring buffer keeps telling me RESOURCE_MEMPHYSICAL_LOW I'm quite sure that there's a memory problem *somewhere*. But what is the root cause if it's constantly attributed to IndicatorsPool=2 ?