Introduction to ColdFusion Course at Pluralsight. In this course, you will learn the basics of how to use the ColdFusion platform.
SQL SERVER – Details About SQL Jobs and Job Schedules
SQL Expert Dominic Wirth has written a very interesting script about SQL Jobs and Job Schedules. Let us learn about that in this blog post.
SQL SERVER – Query to List All Jobs with Owners
During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.
SQL SERVER – Number of Tables Memory Optimized in TempDB in SQL Server 2019
Let us learn about Memory Optimized in TempDB, which I had earlier discussed with my client Comprehensive Database Performance Health Check.
SQL SERVER – Enable Additional Logging for SQL Server Agent
When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs.
SQL SERVER – Display Rupee Symbol in SSMS
Just instead of US Dollar Sign ($), they wanted to display it with Indian Rupee Sign (₹). Let us learn today how we can Display Rupee Symbol in SSMS.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
SQL SERVER – Heaps, Scans and RID Lookup
The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
SQL SERVER Tools I Use and Recommend (Updated: January 2020)
Here is the updated list for January 2020 of all the tools which I recommend. Do let me know if you use any of the above tools.
SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.