Virtual Pass

SQL Saturday 792 – Brasilia

Mais um evento de alto nível e desta vez em Brasilia! No dia 25/08/2018, na UniProjeção – Campus II (Taguatinga Norte) …

Continuar lendo

Permissão de usuários

Dois script simples (#sqn) para levantamento de permissão de usuários a nível de base de dados. Script01: Script02:  

Traduzir o Management Studio

Em um dos muitos grupos que participo, surgiu uma dúvida de se alterar o Management Studio de Inglês para Português …

Continuar lendo

Dica rápida – Checar ultimo backup realizado

Dica rápida do dia. Sintaxe simples que checa quando foi realizado o último backup, tipo de backup, local do backup …

Continuar lendo

Resetar senha “sa”

Dica rápida de hoje: habilitar o usuário “sa” da instância. Mas porque fariamos isso: Motivo 1) Instancia legada de um …

Continuar lendo

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/. As a logical continuation from the blog post Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”), this blogpost will focus on the SQL…

Presentations & Blogging of 2017 in Review

And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life, this time focusing on the past year of 2017. Like in the previous years (2016, 2015, for example), I am…

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/ An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of…

Columnstore Indexes – part 116 (“Partitioning Specifics”)

Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/ After delaying for a couple of years (yes, strangely there is other priority in my life, besides this blog post series) – I am finally putting…

Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)

Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is dedicated to the Bulk Load API and the sudden changes that might take place and affect it during the loading process into…
Go to Top