Maintenance — Dirceu Resende

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

August 24, 2023 8 min read

SQL Server - How to identify the date when the trial / evaluation license will expire

August 18, 2023 1 min read

SQL Server - How to create login auditing using instance logs

August 15, 2023 4 min read

SQL Server - How to reset and recover the SSIS catalog password (SQL Server master key)

August 14, 2023 2 min read

SQL Server - How to generate a script with all database indexes

August 14, 2023 8 min read

SQL Server - How to Synchronize Table Data Between Different Databases Using Trigger

August 13, 2022 4 min read

SQL Server - How to unlock a login without changing/resetting the password

May 21, 2022 2 min read

SQL Server - How to increase query speed by changing the server power plan

May 17, 2022 6 min read

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

May 3, 2022 4 min read

SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache

April 14, 2022 7 min read

SQL Server - How to identify all missing indexes in a database

April 8, 2022 8 min read

SQL Server - How to list the largest tables and indexes in the database and show the size of each

October 1, 2021 5 min read

SQL Server - How to Know How Long a Specific Database Has Been Online

October 30, 2020 2 min read

SQL Server - I set Max Server Memory to 0 and now I cannot connect to the instance

December 23, 2019 3 min read

SQL Server - TCP Dynamic Ports vs TCP Port: Dynamic vs Static Port

December 13, 2019 5 min read

SQL Server - Power BI Gateway Problem When Using External IP or Hostname to Access the Database

November 3, 2019 5 min read

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

July 15, 2019 73 min read

SQL Server - How to connect using the DAC (Dedicated Admin Connection) without SQL Browser

May 10, 2019 6 min read

SQL Server 2014 - How to estimate progress and remaining time for index creation

January 26, 2019 4 min read

SQL Server - How to identify and change the default schema of database users

January 26, 2019 10 min read

SQL Server - How to identify instance startup parameters using T-SQL

January 11, 2019 3 min read

SQL Server - How to identify the data type of columns and parameters of tables, views, stored procedures, and functions

December 29, 2018 5 min read

SQL Server - How to identify locks, blocks, and blocking sessions

December 6, 2018 7 min read

FREE database check-up + security analysis: Do you need it?

December 2, 2018 3 min read

Is your SQL Server up to date? Returning the latest Service Pack (SP) or Cumulative Update (CU) version for your instance

December 1, 2018 9 min read

SQL Server 2016 - How to archive historical tables in Azure with Stretch Database

November 11, 2018 17 min read

SQL Server - How to change the owner of all jobs for a user in SQL Agent

October 15, 2018 3 min read

SQL Server - Using Trace Flag 3226 to Avoid Recording Informational Messages Generated by Backups in the SQL Server Log

September 22, 2018 3 min read

SQL Server - How to create code versioning for your Stored Procedures in HTML with change comments

July 16, 2018 10 min read

SQL Server - How to identify a slow or "heavy" query in your database

July 8, 2018 26 min read

SQL Server - How to recover the source code of deleted objects (View, Stored Procedure, Function and Trigger)

July 8, 2018 9 min read

SQL Server - How to identify deprecated features being used on the instance (Extended Events - XE)

May 26, 2018 4 min read

SQL Server - How to find how long the instance has been online or when it was started

May 9, 2018 6 min read

SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters

May 2, 2018 3 min read

SQL Server - How to standardize the collation of all database columns

March 15, 2018 22 min read

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

March 4, 2018 10 min read

SQL Server 2017 - How to pause an index rebuild using Resumable Online Index Rebuilds

February 14, 2018 7 min read

SQL Server - Using Resource Governor for Greater Control of Server Resources

February 14, 2018 15 min read

SQL Server - How to create an email alert for locks and blocked sessions in the instance using DMV's

October 17, 2017 8 min read

SQL Server - How to generate deadlock history monitoring for routine failure analysis

September 30, 2017 12 min read

SQL Server - Query to Return Active Sessions with sp_WhoIsActive Without Consuming TempDB

July 25, 2017 13 min read

SQL Server - Understanding and Disabling Autocommit

April 3, 2017 5 min read

Analysis Services (SSAS) - How to Query Information and Process Commands via XMLA Command Line from SQL Server

April 2, 2017 4 min read

SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function

March 24, 2017 14 min read

SQL Server - Your Instance Constantly Shows "Starting Up Database" and "Databases in Recovery" Messages: Learn About AUTO_CLOSE

March 23, 2017 5 min read

Analysis Services - How to Use XMLA for Backup and Restore of Cubes via T-SQL Command Line

March 5, 2017 3 min read

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

March 5, 2017 8 min read

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

February 28, 2017 7 min read

SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions

February 27, 2017 15 min read

SQL Server - How to identify and monitor disks, total, free, and used disk space

February 26, 2017 10 min read

SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell)

February 22, 2017 9 min read

SQL Server - How to delete a user from an instance

February 21, 2017 3 min read

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

February 19, 2017 11 min read

SQL Server - How to identify, monitor, and prevent overflow in IDENTITY and SEQUENCE columns of tables with many rows

February 8, 2017 6 min read

SQL Server - How to rename the server / instance in the database when the machine name is changed in the OS

February 2, 2017 1 min read

SQL Server - How to identify weak, empty, or user-name passwords

November 24, 2016 4 min read

SQL Server - Session Running for a Long Time with the SpreadRequest / DatabaseMail Command

October 31, 2016 3 min read

How to Install and Configure Microsoft SQL Server 2016 on Windows Server 2016

October 31, 2016 11 min read

SQL Server - How to audit permission errors on objects using SQL Profiler (Trace)

September 10, 2016 5 min read

SQL Server - How to Check if a Server is Responding Using Ping and CLR (C#)

August 6, 2016 1 min read

SQL Server - Using sp_WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries and Much More

June 26, 2016 15 min read

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

June 14, 2016 3 min read

SQL Server - How to install the Microsoft.ACE.OLEDB.12.0 and Microsoft.Jet.OLEDB.4.0 drivers

June 5, 2016 7 min read

How to List Jobs (schedules, commands, steps) via Query in SQL Server

March 28, 2016 5 min read

How to reset and recover the SQL Server Administrator (sa) password

November 29, 2015 4 min read

Identifying tables with IDENTITY columns in SQL Server

November 16, 2015 1 min read

Mapping Dependencies Between Objects in SQL Server

October 24, 2015 10 min read

Auditing in SQL Server (Server Audit)

October 22, 2015 11 min read

Understanding how indexes work in SQL Server

October 11, 2015 18 min read

How to identify, delete and recreate Foreign Keys (FK) of a table in SQL Server

October 6, 2015 2 min read

Enabling and using dedicated remote administrator connection (DAC) in SQL Server

October 4, 2015 4 min read

Checking Permissions, Privileges and Accesses of a Database User in SQL Server

September 7, 2015 21 min read

Enabling OLE Automation via T-SQL in SQL Server

September 7, 2015 1 min read

How to identify the port used by the SQL Server instance

August 30, 2015 3 min read

SQL Server undocumented extended procedures

August 28, 2015 6 min read

How to Query SQL Agent Startup History in SQL Server

August 23, 2015 2 min read

How to Identify Inactive Sessions with Open Transactions in SQL Server

August 22, 2015 2 min read

How to identify connected users in SQL Server

August 22, 2015 1 min read

How to identify running jobs via Query in SQL Server

August 22, 2015 6 min read

How to kill all connections to a database in SQL Server

July 19, 2015 3 min read

SQL Server - How to Implement Login Audit and Control (Logon Trigger)

July 19, 2015 9 min read

How to create an audit trigger to log object manipulation in SQL Server

July 18, 2015 6 min read

How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server

June 5, 2015 4 min read

SQL Server - Timeout When Executing a Query on a Linked Server

May 8, 2015 1 min read

How to estimate the remaining time for a backup in SQL Server

May 6, 2015 1 min read

SQL Server - How to enable and configure Database Mail to send and monitor emails through the database (sp_send_dbmail)

March 19, 2015 12 min read

Compressing all tables in a database in SQL Server

March 17, 2015 8 min read

Running a Command in All Databases of the SQL Server Instance

March 8, 2015 3 min read

Identifying and resolving orphaned users in SQL Server with sp_change_users_login

February 8, 2015 9 min read

SQLCMD - The SQL Server command-line utility

November 30, 2014 5 min read

Installing and configuring SQL Server 2014 on Windows Server 2012 R2

November 29, 2014 9 min read

Searching for a string in a job (or step) in SQL Server

June 14, 2014 3 min read