<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-1391695206712094920</id><updated>2024-10-08T19:09:27.991-07:00</updated><category term="Interview"/><category term="Basics of SQL Server"/><category term="Administration"/><category term="Script"/><category term=".Net"/><category term="Azure"/><category term="Query"/><category term="ADO.Net"/><category term="C#"/><category term="Oracle"/><category term="SQL"/><category term="linked server with oracle"/><category term="Angular2"/><category term="Backup"/><category term="CLR"/><category term="Certifications"/><category term="Connection String"/><category term="Excel"/><category term="Function"/><category term="IIS"/><category term="JQuery"/><category term="MS Access"/><category term="MVC4"/><category term="OOPs.Net"/><category term="SQL Server 2014 Features"/><category term="WebApi2"/><category term="XML"/><category term="partitioning"/><title type='text'>Learning Microsoft Technologies.......</title><subtitle type='html'>Learn Mirosoft SQL Server,Script,Administration,Database Development,MCSA,MCSE,dot net,.net,Interview,software engineer interview,database developer interview,SQL Server FAQs,.Net Faqs,Linked server setup with oracle, Azure, Web API, Angular2, JQuery</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://queryingsql.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default?max-results=3&amp;redirect=false'/><link rel='alternate' type='text/html' href='http://queryingsql.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default?start-index=4&amp;max-results=3&amp;redirect=false'/><author><name>Uma Shankar Patel</name><uri>http://www.blogger.com/profile/02287010306811895923</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4_qfoSN37BdSLfo6XdSOq08zH3ivZoMZEtP3NoyndsbOvvP0bcRLPvriiqXgaOJfIlu8flu45u1sFUjD8ELagmFKqGef4EvcDs2Pm9lQEl9CGmit4Tm36RPZjg5f6Pg/s118/*'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>72</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>3</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-1391695206712094920.post-2189416493182886539</id><published>2020-04-11T04:19:00.000-07:00</published><updated>2020-04-11T04:20:34.861-07:00</updated><title type='text'>Design patterns (short description)</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.&lt;br /&gt;
&lt;br /&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Adapter Pattern:&amp;nbsp;&lt;/h2&gt;
Convert the interface of a class into some other classes that client expects. Adapter lets classes work together that couldn&#39;t otherwise because of incompatible interfaces.&lt;br /&gt;
&lt;br /&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Decorator Pattern: (alternate of sub classing)&lt;/h2&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
Attach additional responsibilities to an object at run-time. It follow closed for modification but open for extension SOLID rule.&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Strategy Pattern: (Reduce IFs)&lt;/h2&gt;
&lt;div&gt;
Define a family of algorithms, encapsulate each one, and make them interchangeable. Strategy lets the algorithm vary independently from client that use it.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Template method pattern:&lt;/h2&gt;
&lt;div&gt;
Define the skeleton of an algorithm in an operation, differing same steps to sub classes. Template method lets sub classes redefine certain steps of an algorithm without changing the algorithm structure.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Visitor Pattern&lt;/h2&gt;
&lt;div&gt;
Represent an operation to be performed on the elements of an object structure. Visitor lets you define a new operation without changing the classes of the elements on which it operates.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Ex :calculate IsAboveEighteen by introducing same new property in same class.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Observer Pattern:&lt;/h2&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
Define a one to one dependency between objects so that when one object changes state, all its dependents are notified and updated automatically.&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Builder pattern:&lt;/h2&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
Separate the construction of complex object from its representation so that the same construction process can create different representation. Ex: different configuration computer assembling by robots&amp;nbsp;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Chain of responsibility:&lt;/h2&gt;
&lt;div&gt;
Avoid coupling of the sender of a request to its receiver by giving more than one object a chance to handle the request.&lt;/div&gt;
&lt;div&gt;
&amp;nbsp;Ex: Logic logic =new Logic();&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; logic.Receiver=new Logger(new Email(null));&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; logic.HandleMessage();&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Abstract Factory pattern:&lt;/h2&gt;
&lt;div&gt;
Provides an interface for creating families of related dependent object without specifying their concrete classes. Ex: DbProviderFactory&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;text-align: left;&quot;&gt;
Factory Pattern:&lt;/h2&gt;
&lt;div&gt;
Define an interface for creating an object but let classes decide which class to instantiate. Factory method lets a class defer instantiation to sub classes.&amp;nbsp;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://queryingsql.blogspot.com/feeds/2189416493182886539/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://queryingsql.blogspot.com/2020/04/design-patterns-short-description.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default/2189416493182886539'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default/2189416493182886539'/><link rel='alternate' type='text/html' href='http://queryingsql.blogspot.com/2020/04/design-patterns-short-description.html' title='Design patterns (short description)'/><author><name>Uma Shankar Patel</name><uri>http://www.blogger.com/profile/02287010306811895923</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4_qfoSN37BdSLfo6XdSOq08zH3ivZoMZEtP3NoyndsbOvvP0bcRLPvriiqXgaOJfIlu8flu45u1sFUjD8ELagmFKqGef4EvcDs2Pm9lQEl9CGmit4Tm36RPZjg5f6Pg/s118/*'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1391695206712094920.post-130551225086296357</id><published>2018-10-15T09:25:00.002-07:00</published><updated>2018-10-15T09:28:17.515-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".Net"/><category scheme="http://www.blogger.com/atom/ns#" term="C#"/><title type='text'>Generic Modifier In &amp; Out C#</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;h3 style=&quot;text-align: left;&quot;&gt;
In [Contravariant]&lt;/h3&gt;
The image is self-explanatory.&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5xYueCb3dSW6zgjLFp4XsnM1EyVmpLVqE9Rtscjz4i9KsAYOaPTHDW8HI5WFwSQuZ7xc0tZPMgeX6XQdgqYHR05TR8zsSEHYGD_EEeCjr9VTdBo1RKZsbAUruEYsrizc9uOZ_v-CHBUE/s1600/generic+modifeir+contravariant.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;865&quot; data-original-width=&quot;1600&quot; height=&quot;344&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5xYueCb3dSW6zgjLFp4XsnM1EyVmpLVqE9Rtscjz4i9KsAYOaPTHDW8HI5WFwSQuZ7xc0tZPMgeX6XQdgqYHR05TR8zsSEHYGD_EEeCjr9VTdBo1RKZsbAUruEYsrizc9uOZ_v-CHBUE/s640/generic+modifeir+contravariant.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;h3 style=&quot;text-align: left;&quot;&gt;
Out [Covarient]&lt;/h3&gt;
The image is self-explanatory.&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhc6aD6zeI6vnJNl9jmbtERVogMeCRWuPqOSgwEJiK99CWnDa_t6qW095IUNMPpGjTM7V5dsGH6X3YADMzduWlfAO7Z92ADsDqklfKh4-pMgxDwZgZEtwI4nJlwJXGwjwbX9mbwFADmw5k/s1600/generic+modifeir+covariant.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;865&quot; data-original-width=&quot;1600&quot; height=&quot;344&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhc6aD6zeI6vnJNl9jmbtERVogMeCRWuPqOSgwEJiK99CWnDa_t6qW095IUNMPpGjTM7V5dsGH6X3YADMzduWlfAO7Z92ADsDqklfKh4-pMgxDwZgZEtwI4nJlwJXGwjwbX9mbwFADmw5k/s640/generic+modifeir+covariant.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://queryingsql.blogspot.com/feeds/130551225086296357/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://queryingsql.blogspot.com/2018/10/generic-modifier-in-out-c.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default/130551225086296357'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default/130551225086296357'/><link rel='alternate' type='text/html' href='http://queryingsql.blogspot.com/2018/10/generic-modifier-in-out-c.html' title='Generic Modifier In &amp; Out C#'/><author><name>Uma Shankar Patel</name><uri>http://www.blogger.com/profile/02287010306811895923</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4_qfoSN37BdSLfo6XdSOq08zH3ivZoMZEtP3NoyndsbOvvP0bcRLPvriiqXgaOJfIlu8flu45u1sFUjD8ELagmFKqGef4EvcDs2Pm9lQEl9CGmit4Tm36RPZjg5f6Pg/s118/*'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5xYueCb3dSW6zgjLFp4XsnM1EyVmpLVqE9Rtscjz4i9KsAYOaPTHDW8HI5WFwSQuZ7xc0tZPMgeX6XQdgqYHR05TR8zsSEHYGD_EEeCjr9VTdBo1RKZsbAUruEYsrizc9uOZ_v-CHBUE/s72-c/generic+modifeir+contravariant.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1391695206712094920.post-4445992981492400930</id><published>2018-09-11T11:14:00.003-07:00</published><updated>2018-09-11T11:15:24.904-07:00</updated><title type='text'>Reduce your Azure Development Subscription Cost</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;br /&gt;
&lt;h1&gt;
Azure VMs&lt;o:p&gt;&lt;/o:p&gt;&lt;/h1&gt;
Usually you should convey to developers and testers to shut down the VMs manually when they are not using non production virtual machines. Also there some ways to automatic shutdown the VMs like you can create and schedule a script to start and shutdown VMs based on use timings or you can use Dev Test labs.&lt;br /&gt;
&lt;h1&gt;
Azure App Services&lt;o:p&gt;&lt;/o:p&gt;&lt;/h1&gt;
As app service plan allocate compute resources for which you pay so if you run multiple applications in same app service plan, that will definitely reduce your cost. If your app service plan tier is not fulfilling your new app requirements like it requires high computation resources or your exiting app service plan is already exceeding the resource utilization, than its better to create new one.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://queryingsql.blogspot.com/feeds/4445992981492400930/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://queryingsql.blogspot.com/2018/09/reduce-your-development-subscription.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default/4445992981492400930'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1391695206712094920/posts/default/4445992981492400930'/><link rel='alternate' type='text/html' href='http://queryingsql.blogspot.com/2018/09/reduce-your-development-subscription.html' title='Reduce your Azure Development Subscription Cost'/><author><name>Uma Shankar Patel</name><uri>http://www.blogger.com/profile/02287010306811895923</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='31' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4_qfoSN37BdSLfo6XdSOq08zH3ivZoMZEtP3NoyndsbOvvP0bcRLPvriiqXgaOJfIlu8flu45u1sFUjD8ELagmFKqGef4EvcDs2Pm9lQEl9CGmit4Tm36RPZjg5f6Pg/s118/*'/></author><thr:total>0</thr:total></entry></feed>