TSQLMaster

Here is a quick script to generate sp_updateextendedproperty dynamically from your existing metadata. DECLARE @TableName SYSNAME, @ColumnNam...

Here is simple query to list all compressed tables on SQL SERVER: select distinct t.name AS CompressedTables from sys.partitions p inner joi...

I completed on December 21, 2020 the test for the AWS Cloud Practicioner certification successfully. I had been planning to obtain this cert...

Concluí no dia 21 de dezembro de 2020 a prova para a certificação  AWS Cloud Practicioner  com sucesso. Já estava planejando obter esta cert...

A bit of a challenge here, trying to get the first and last day of the previous week (Sunday and Saturday). SELECT          Date_add ( Date_...

I got some strange characters on a HTML file that was uploaded do S3. I managed to solve that by setting the metadata content type field wit...

Using a TABLE INPUT with a Microsoft Sql Server procedure, I started getting this error message: "statement did not return a result s...

Many organizations seek to do more with their data than pump out dashboards and reports. Applying advanced analytical approaches such as mac...

Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019...

The days when a database administrator (DBA) could specialize solely in a single database technology are rapidly ending. Today, we're mu...