SQL Server, T-SQL

  • how to enabled and use implicit and explicit transactions in sql server src
  • DMVs that show open transactions in sql server src
  • how to run sql server on docker src

User Defined Functions

  • Multi-statement Table Valued Function vs Inline Table Valued Function src

Execution Plans

  • overview src
  • comparing plans src

indexes

  • clustered vs non clustered indexes src

Parameter Sniffing

  • How Do You Identify Parameter Sniffing src1 src2
  • Dealing With Parameter Sniffing  src1 src2

Comments

Post a Comment

Popular posts from this blog

Azure

How to send Entra diagnostic logs to a Log Analytics workspace src How to send Subscription diagnostic logs to a Log Analytics workspace  src How to turn on application logging to the filesystem in a webapp  src how to collect operating system logs  src you will need to make use of Data Collection Rules how to send Windows event logs to Log Analytics  src how to collection metrics for a virtual machine  src you will need to install a diagnostic extension and provision a storage account overview of azure privileged identity management  src overview of Azure Web Application Firewall (WAF) ( 0:52 ) overview of Azure DDoS Protection ( 2:45 ) Entra by default, Entra roles are only given to users. to assign Entra roles to a group, you have to enable it by enabling 'Microsoft Entra roles can be assigned to the group' src overview of administrative units and restricted management administrative units src how to create a custom role src You can take role assignments...
Read more

.NET

 how to install and configure swagger src configure swagger to work with api keys src tools for static code analysis src EF Core effect of enabling nullable on EF Core src IIS demo of installing site on IIS src Nuget allowed versions src XML Generate c# class from xsd src Connection Strings specifying app name in connection string ( 2:00 ) specifying max pool size ( 3:08 )
Read more

Angular

Architecture angular server side rendering with hydration introduced in angular 16 src how to create an angular application with server side rendering src how to add angular server side rendering to existing application src static site generation with angular src create a feature module and lazy load it src convert feature module to stand alone and lazy load it src Change Detection how change detection works under the hood  src uses zone.js how to debug and find code triggering change detection src uses NgZone Running code outside the Angular zone prevents unnecessary change detection cycles, which can improve application performance using onpush change detection   src with signals src Routing setting up routing src Subjects subject as observer (make a cold observable multicast) ( 28:26 ) Reactive Forms using a FormArray src Debugging ng variable that Angular exposes in the development mode, can be used in dev console in Chrome ( 6:00 ) Internationalization configuring in...
Read more