DBA 9/10

top of page

Feb 19, 20182 min read

The king is dead, long live the king!

Feb 15, 20181 min read

Extremely easy tricks to list table columns’ names and replace SELECT *

Feb 1, 20181 min read

How to Troubleshoot Waiting Tasks Without Requests in SQL Server?

Jan 9, 20182 min read

How to Size Your Database Files?

Jan 8, 20182 min read

What is Graph Processing in SQL Server 2017?

Jan 8, 20183 min read

What Do You Do When Performance Sucks?

Jan 3, 20184 min read

How to fix Orphaned Users easily

Dec 25, 20171 min read

How to troubleshoot database mail?

Dec 23, 20172 min read

SQL Saturday Nepal 2017

Dec 7, 20173 min read

How to Update @@SERVERNAME to Actual Machine Name?

Dec 2, 20171 min read

Why is the job duration a negative number?

Nov 19, 20172 min read

How to Calculate Running Totals in SQL Server

Nov 18, 20173 min read

What is the Role of the UPDATE Lock in SQL Server?

Oct 23, 20175 min read

Why I Believe in the Data Architecture Review

Aug 29, 20172 min read

The 10 Basic Concepts of T-SQL

Jul 26, 20171 min read

Working with Very Large Tables

Jun 19, 20172 min read

Great Minds Think Alike!

May 10, 20172 min read

My Session about SQL Server Parameterization

May 3, 20171 min read

Video: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query Execution

May 2, 20171 min read

SQL Server 2016 for Performance Tuning Lovers

bottom of page