SQL Server DBA, BI Analyst and Microsoft MVP

post.tags

Manutenção

tag.total

SQL Server - How to identify and compress tables and indexes without data compression

August 24, 2023 8 min read

Continue reading

SQL Server - How to create login auditing using instance logs

August 15, 2023 4 min read

Continue reading

SQL Server and Azure SQL Database - How to Return CPU and Memory Usage Using T-SQL

May 3, 2022 4 min read

Continue reading

SQL Server - Useful Day-to-Day DBA Queries You Always Have to Search for Online

July 15, 2019 73 min read

Continue reading

SQL Server - How to identify the version and edition of all server instances using xp_regread and PowerShell

March 4, 2018 10 min read

Continue reading

SQL Server - Understanding and Disabling Autocommit

April 3, 2017 5 min read

Continue reading

SQL Server - How to identify and monitor total, free, and used disk space by database datafiles

March 5, 2017 8 min read

Continue reading

SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole

February 28, 2017 7 min read

Continue reading

SQL Server - How to copy/replicate a user's permissions

February 19, 2017 11 min read

Continue reading

SQL Server - How to batch run all .sql scripts from a folder or directory with SQLCMD

June 14, 2016 3 min read

Continue reading