TSQLMaster

quinta-feira, 10 de abril de 2025

Here is a quick script to generate sp_updateextendedproperty dynamically from your existing metadata.

›
Here is a quick script to generate sp_updateextendedproperty dynamically from your existing metadata. DECLARE @TableName SYSNAME, @ColumnNam...
segunda-feira, 22 de agosto de 2022

List Compressed Tables on SQL SERVER

›
Here is simple query to list all compressed tables on SQL SERVER: select distinct t.name AS CompressedTables from sys.partitions p inner joi...
terça-feira, 9 de fevereiro de 2021

My experience with AWS Cloud Practitioner certification

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

Minha experiência com a certificação AWS Cloud Practicioner

›
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...
terça-feira, 19 de maio de 2020

First and Last Days of the previous week using MySQL

›
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_...
sexta-feira, 7 de fevereiro de 2020

Strange characters on HTML file uploade on Amazon S3

›
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...
sexta-feira, 24 de janeiro de 2020

Pentaho - statement did not return a result set

›
Using a TABLE INPUT with a Microsoft Sql Server procedure, I started getting this error message: "statement did not return a result s...
terça-feira, 17 de dezembro de 2019

[From Technet] Improvements to machine learning capabilities in SQL Server 2019

›
Many organizations seek to do more with their data than pump out dashboards and reports. Applying advanced analytical approaches such as mac...
quarta-feira, 11 de dezembro de 2019

[From Technet] Tools and commands for running SQL Server 2019 on Linux

›
Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019...
Um comentário:
quinta-feira, 5 de dezembro de 2019

[From Technet] Easier management of PolyBase and relational data through 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...
›
Página inicial
Ver versão para a web
Tecnologia do Blogger.