Short Coding Snippet

SQL Server still to this day deploys pessimistic concurrency out of the box. Anyone not aware of this “feature” starts out very disadvantaged on performance. This person will soon get an internet history filled with locking/blocking/deadlocking links. Postgres defaults to optimistic concurrency via its MVCC feature and is a joy to work with. Compression out of the box. With SQL Server, compression is an “Enterprise Edition and Up” feature which means you are spending the cost of at least 1 dev in order to get the ability to use compression. Once you have paid for that ability, you still have to figure out how to implement it. Postgres does this for you out of the box, automatically and for free. Concurrent Index Creation. You are going to find a recurring theme there…this is yet another feature that SQL Server is capable of doing, but only if you are able to afford the elite and affluent company of Enterprise Edition. Postgres has your back on this even if you left your wallet at home....

Download source code from GitHub   Table of Content What is distributed caching and its benefit IDistributedCache interface Framework provided to implement Distributed Redis cache Setting up Redis on Windows 10 Redis CLI commands Steps to integrate Redis cache in ASP.NET core Summary What is distributed caching and its benefit   Distributed caching is when you want to handle caching outside of your application. This also can be shared by one or more applications/servers. Distributed cache is application-specific; i.e., multiple cache providers support distributed caches. To implement distributed cache, we can use Redis and NCache. We will see about Redis cache in detail.   A distributed cache can improve the performance and scalability of an ASP.NET Core app, especially when the app is hosted by a cloud service or a server farm.   Benefits Data is consistent throughout multiple servers. This is more suitable for microservice architecture In case of loading balancing,...

  How to get different date formats in SQL Server Use the SELECT statement with CONVERT function and date format option for the date values needed To get YYYY-MM-DD use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 23) To get MM/DD/YY use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 1) Check out the chart to get a list of all format options Below is a list of SQL date formats and an example of the output.  The date used for all of these examples is "2006-12-30 00:38:54.840". DATE ONLY FORMATS Format # Query Format Sample 1 select convert(varchar, getdate(), 1) mm/dd/yy 12/30/06 2 select convert(varchar, getdate(), 2) yy.mm.dd 06.12.30 3 select convert(varchar, getdate(), 3) dd/mm/yy 30/12/06 4 select convert(varchar, getdate(), 4) dd.mm.yy 30.12.06 5 select convert(varchar, getdate(), 5) dd-mm-yy 30-12-06 6 select convert(varchar, getdate(), 6) dd-Mon-yy 30 Dec 06 7 select convert(varchar, getdate(), 7) Mon dd, yy Dec 30, 06 10 select convert(varchar, getdate()...

  Loading on Desktop < link rel = "stylesheet" media = "screen and (min-width: 601px)" href = "desktop.css" /> Loading on Mobile Screen < link rel = "stylesheet" media = "screen and (max-width: 600px)" href = "mobile.css" />

  A great project manager is a difference-maker. I owe much of the success of my various ventures (one a turn-around, the other an intrapreneurial initiative inside one of the world’s great firms), to a few remarkable professionals who rescued us from ourselves and helped us seize success from the jaws of near certain defeat. These individuals taught us how to perform, guided us through the sticky spots and ultimately kept us from beating ourselves. In other words, they led. In a world of work now dependent upon projects for everything from new product and service development, to process improvement initiatives, to infrastructure development and implementation, and even strategy execution, cultivating project management competence is no longer optional in our organizations. As the stakes for project success loom larger, the role of the project manager is less about managing the mechanics of the initiative and more about leading others and forming and framing the environment necessa...