SQL Server – O perigo de utilizar JOIN entre colunas de tipos de dados diferentes April 29, 2016 2 Performance Tuning Databases SQL Server
Utilizando sequences em user defined functions no SQL Server April 28, 2016 0 Query development Hacks Databases SQL Server
SQL Server 2012 – Trabalhando com Sequences e comparações com IDENTITY April 28, 2016 5 Databases SQL Server Query development
SQL Server – Consultando informações da instância no Windows Registry utilizando sys.dm_server_registry e xp_instance_regread April 23, 2016 0 Little known features Databases SQL Server Hacks DMVs e Catalog views
Using the standard SQL Server trace to audit events (fn_trace_gettable) April 23, 2016 4 Little known features Auditing Databases SQL Server Security
SQL Server – The database owner SID recorded in the master database differs from the database owner SID recorded in database April 21, 2016 0 CLR Errors Databases SQL Server
Monitoring DDL and DCL operations using SQL Server's fn_trace_gettable April 4, 2016 0 Security Databases SQL Server Monitoring Little known features Auditing
Monitorando os eventos de crescimento automático de espaço (Autogrowth) em databases no SQL Server April 4, 2016 1 Little known features Databases SQL Server Monitoring
Como recuperar o maior valor entre múltiplas colunas em uma tabela do SQL Server April 2, 2016 5 Databases SQL Server Query development Hacks