the services did not start at all. Let us learn today how to Adjust Memory with a Dedicated Administrator Connection (DAC).
SQL SERVER – Renaming distributor_admin Bad Idea
A client of Health Check, recently send me an email after reading best practices. Why Renaming distributor_admin Bad Idea.
SQL Express Size Limit for Data File
A client of mine. who is using SQL Server Express recently reached out to me to know SQL Express Size Limit for Data File?
SQL SERVER – Identify Table Creation Date from Traces
I often discuss this during Comprehensive Database Performance Health Check. Let us learn about how to Identify Table Creation Date from Traces.
SQL Extensibility Features with Snowflake
I have recently built the course on Snowflake at Pluralsight where I get you going with the SQL Extensibility Features with Snowflake.
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.
Snowflake – Stored Procedure Template in JavaScript
Many SQL developers do not know it well. For everyone to use, I am going to share the Stored Procedure Template in JavaScript for Snowflake.