Configure Distribution failed with SQL Server replication requires the actual server name to make a connection. Here is why and how to fix it.
SQL SERVER – Notes about scheduler with Operating Systems
Understand the SQL Server scheduler, Windows threads and runnable tasks. Use a read-only query to inspect visible online schedulers.
SQL SERVER 2016: Updating Non-Clustered ColumnStore Index Enhancement
A reader said my old columnstore script did not fail as expected. The reason: SQL Server 2016 lets you update a non-clustered columnstore index.
Putting a Database Under Source Control
Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.
SQL SERVER – ERROR: Autogrow of file ‘MyDB_log’ in database ‘MyDB’ was cancelled by user or timed out after 30121 milliseconds
Found Autogrow of file was cancelled by user or timed out in your ERRORLOG? Here is what this message means for performance and why a smaller FILEGROWTH helps.
SQL SERVER – Who Dropped Table or Database?
Who dropped table or database objects on your server? I show how the default trace, which runs in every SQL Server install, can answer these who questions.
Volunteering in the Data Community
Volunteering in the data community can mean welcoming people, reviewing talks, answering questions, or organizing events within a clear time budget.