Skip to main content

Blog @ Codonomics

Democratizing Knowledge & Experience

Search This Blog

My Footprints On Internet

Open Source
Android Play Store
LinkedIn
Medium
GoodReads
StackOverflow
Testimonial
My Quotes
About Me

Showing posts with the label SQL Server

Posts

Buy @ Amazon

Scale Challenge 10 - Unshackling the SQL Server DB Bottleneck

on February 26, 2025

Engineering Leadership Engineering Management high scalability Scaling challenges SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

SQL Dev Interview - Optimize SQL Server Table With Many Indexes For Performance

on November 22, 2021

Interview Question Performance Tuning SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Partitioning in SQL Server

on November 12, 2021

Partitioning SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Bulk Copy in SQL Server

on November 08, 2021

Bulk Copy SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

User Defined Functions in SQL Server

on November 05, 2021

SQL Server User Defined Functions

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Sample Data Generation Script For SQL Server

on October 31, 2021

+

Get link
Facebook
X
Pinterest
Email
Other Apps

All That You Need To Know About SQL Server Indexes

on October 24, 2021

Indexes Indices SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Clustered Vs Non-Clustered Index In SQL Server

on October 23, 2021

Indexes SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Pro Tips For SQL Server DB Indexes

on October 22, 2021

Indexes ProTips SQL Server

+

Get link
Facebook
X
Pinterest
Email
Other Apps

NOLOCK in SQL Server ain't your friend

on June 02, 2021

NoLock SQL Server Table Hints

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Subscribe

Posts

Posts

All Comments

All Comments

Followers

Archives

2025 26

2024 22
- October 6
- September 3
- July 1
- June 4
- May 1
- March 1
- February 1
- January 5
2023 22
- December 1
- September 3
- August 4
- July 6
- May 3
- April 3
- March 1
- January 1
2022 9
- September 1
- August 2
- July 1
- June 2
- March 1
- January 2
2021 28
- December 3
- November 5
- October 8
- September 1
- August 2
- July 3
- June 1
- May 1
- April 1
- March 1
- February 2
2020 45
- December 2
- November 2
- October 7
- September 5
- August 10
- July 6
- June 2
- May 3
- April 2
- March 2
- February 1
- January 3
2019 31
- December 1
- October 1
- September 4
- August 2
- July 1
- June 1
- May 1
- April 2
- March 5
- February 6
- January 7
2018 22
- December 7
- November 2
- August 5
- April 3
- March 5
2017 20
- December 2
- November 1
- October 1
- September 4
- August 7
- July 3
- June 1
- March 1
2016 12
- August 3
- July 1
- April 2
- March 3
- February 2
- January 1
2015 5
2014 33
- September 4
- August 6
- May 3
- March 5
- February 7
- January 8
2013 9
- December 3
- July 1
- May 5
2012 7
- December 1
- October 1
- August 2
- May 3
2011 26
- November 4
- October 5
- September 3
- June 4
- May 1
- April 3
- March 2
- February 2
- January 2
2010 12
- December 1
- November 2
- October 2
- September 3
- August 3
- July 1

Show more Show less

Labels

10 commandments
12 Factor App Principles
Aadhar
AB Testing
Acer Predator Triton 300
achievement
Adopt AWS Rightly
Advice
Agile
agile adoption

Show more Show less

Stack Exchange User Flair

Popular Posts

Ollama Cheatsheet

I have been using Ollama for a good while now to run LLMs locally on my laptop for better testing and development of my AI Agents. This post shows a number of things that you can do with Ollama in a glimpse and so I call this a cheatsheet. -- -- If you haven't tried your hands on Ollama, you should give it a try and this cheatsheet should come handy to you. And you may want to star it and fork it from my github-gist , for your quick reference and fiddling.

Essential Vim For CKAD Or CKA Exam

If you are preparing for CKAD or CKA exam and are new to Vim/Vi, this post will help you know everything that is essential to being productive with Vim during your exam. Vim has 3 modes as depicted in picture below: In Command Mode , you do things like navigating your cursor from one point to another in your text file, or delete text or replace text or select text or things like that. When you open Vim, you will be in this mode to begin with. In Insert Mode , you insert text and delete text with [backspace] key :) In Execution Mode , you do things like search text in file, set tab length, set line numbers in editor and stuff like that.

Should I buy refurbished laptop from Amazon?

This post is based on my experience with amazon.in and guess it to be true on all other platforms as well. At least you can check out and verify for these pointers before you make that decision to buy renewed/refurbished laptop on Amazon with your hard earned money. I see this question propping up in several forums and on many different occasions. In the recent past, I had my 5 year old dell laptop that gave up because its motherboard failed. One of the options that I had in my mind was to re-use the HDD and the 16GB DDR4 RAM of that old laptop in the one that I purchase next as secondary. I had come to a conclusion that it is not worth buying a refurbished/renewed laptop at all. Why? For the following reasons, most of which I see as BIG #RedFlags: You got to remember that Amazon provides a platform for 3rd party sellers to sell their products as well. So in your search for refurbished laptops you wouldn’t want to choose some random 3rd party seller who Amazon doesn’t endorse. You...

Niggles with HuggingFace

Working with Hugging Face (HF) can be incredibly rewarding, but like any platform, it comes with its own set of constraints and limitations that can catch developers off guard. Here are some common friction points I encountered which you are better off knowing beforehand to make better decisions with regard to your engineering practices. Gradio apps work well in public spaces, but when you make your space private it's UI breaks real bad. For more on this, check out my earlier post titled, "Gradio App Breaks in Hugging Face's Private Spaces" . HF discourages the use of .env file for externalizing your configurations and recommends the use of its settings tab in the console to set your environment variables. At least as of now, this is only a recommendation and I see it working for my demo apps. This might change in future, and it may reject the commit having .env file as unsafe, in future. This recommendation is understandable and recommendable for production grade a...

Connecting to Expo Dev Server in WSL 2 over LAN

This post drafts things I did to connect my Android device to Expo dev server running in WSL 2 on Windows 10 over LAN connection (in my case using Wi-Fi). The set-up looks like below: Note: Expo-Client is installed on my android device. Note: Expo-CLI npm version used is 3.27.14 Assumption: IPv4 address is used over IPv4. When you run ` ip address ` in your WSL 2 terminal, you will your ip-address of your VM as something like 172.x.x.x . When you check the ip address of your Windows 10 host, by running ` Get-NetIPConfiguration ` in your PowerShell terminal you will find your host ip to be something like 192.168.x.x . When you connect your Android device to the same LAN over Wi-Fi, your ip address would be similar (something like 192.168.x.x). The fact that WSL 2 isn't sharing the same ip address as its host is an issue to be resolved. This needs to be fixed as first thing, because otherwise how do we even reach the server running in WSL over LAN? The easy fix to this is t...

My Past Speaking Engagements

Powered by Blogger

Copyright 2021