SQL Server – Importando e Exportando dados de planilhas do Excel June 14, 2016 2 Query development File Manipulation JSON, XML, CSV e Excel Databases SQL Server
SQL Server – Como executar em batch todos os scripts .sql de uma pasta ou diretório pelo SQLCMD June 13, 2016 12 Powershell / CMD Databases Manutenção Query development
SQL Server – Como instalar os drivers Microsoft.ACE.OLEDB.12.0 e Microsoft.Jet.OLEDB.4.0 June 5, 2016 8 Little known features Databases SQL Server Manutenção
SQL Server – Como exportar dados do banco para arquivo texto (CLR, OLE, BCP) June 2, 2016 9 CLR Query development OLE Automation Databases File Manipulation SQL Server
SQL Server – Como importar arquivos de texto para o banco (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET) May 29, 2016 0 Query development OLE Automation Databases File Manipulation SQL Server CLR
SQL Server – Erro ao utilizar OPENROWSET: Access to the remote server is denied because no login-mapping exists May 28, 2016 0 Databases SQL Server Errors
SQL Server – Cannot resolve the collation conflict between … in the equal to operation. May 25, 2016 0 Errors Databases SQL Server
SQL Server – Como resolver o Warning Null value is eliminated by an aggregate or other SET operation May 22, 2016 0 Query development Databases SQL Server
SQL Server – Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection May 22, 2016 1 Databases SQL Server Errors
Analysis Services – Falha na desserialização: O elemento ‘AllowedRowsExpression’ no namespace May 9, 2016 0 Analysis Services (SSAS) Business Intelligence (BI)
Portuguese 
English