Microsoft Does it again the Windows7 way

Microsoft , Apple and Google not necessarily in the specific order but have never failed to amaze us in our life time more than once. 

Well we have seen a lot of history from Disk keeping data in MB's and size of Huge Cabinets to keeping data in Cloud and from from typing in huge mechanical keyboards to typing on glass. We have come thus far and trust me the journey is gonna be much more interesting than we can image.

Well we all had our fun time with how everything has evolved and remember the days when we used to make fun on windows way back after say Windows 98 where everything crashed and felt really buggy and then most of us (me included) made comments like this is what happens when you copy the code from some one. 

Well, Microsoft slapped everyone back with Windows 7 and everyone mark my words everyone was delighted to work on Windows 7. Now what did MS do that hit us all on the face and why was the OS so amazing. Along with the hard work that MS did we need to understand we smoothly had transitioned from 32bit to 64bit in the background. 

Now let's address the Elephant in the Room shall we. 

Who is leading the search since inception(let's just say we all started to google). Google was not the first search engine it was not a new idea but the idea was to get relevant results according to your query. And over last 3 decades the quality of the queries have changed. People ask more specific questions and that cannot be a single page or website result. Now everyone knew this but no one was working on it. 

I mean when was the last time you were doing something and you found all your results in the same page. I have to go back and forth on a lot of content to get some information be it code or history or farming. Now Microsoft spilled the Beans at the right time when people started getting taste of ChatGPT for drawing and writing code and creating websites and some trying to instil a word of fear that people in IT will loose jobs MS built the new search with AI assisted chat. 

And that's not even the beginning to what they did they integrated it with everything possible and with just one finishing touch MS did it again what they did more than a decade ago and Status Quo is back to MS and for the first time in history for search. 

I am not sure that is gonna short lived or gonna introduce a new jargon 'Bing it' but Google for sure does not have the answer to it yet. And please do not get started on Bard powered by Lambda and this is gonna be a huge news for really long. 

Well, whatever it was we are gonna get dumber in remembering and reading things as we know the information is a step away but our answers and approach to a problem are gonna get really interesting. 

And we may for first time in history of search start paying for search. Yea you got that right ChatGPT is charging $20 for monthly so I think the new trend has already been set and with the ind of results provided it will not be possible to stay away from it. 

Thanks,

Tushar 

New Colours for Hayabusa

Hey you lovely people out there.

Hope you all are doing well and rocking like me. Well it has been a phenomenal year in terms of a lot of things for me but today I am not gonna speak about me. It is about the new colours announced for every one's dream bike. 

Yes we are taking about Suzuki GX1300R or better names as Hayabusa. Well we have seen three colours of the Mighty Hayabusa in the 3rd Generation and they have been earned a lot of accolades for that.

Pearl Brilliant White Metallic Matte Stellar

                    

Metallic Matte Sword Silver Candy Daring Red

                    

Glass Sparkle Black Candy Brunt Gold

But now in 2023 Suzuki is going to release three new colours for th Gen3 Hayabusa and it looks stunning. 

The first one is Pearl Vigour Blue/Pearl Brilliant White colour

The second one is  Metallic Matt Black/Glass Sparkle Black

                                        

The 3rd new colour which is my favourite and I think I am gonna book this one is 

Metallic Thunder Gray / Candy Daring Red

Now there is an option in Japan that you can order rims and accent colour of your choice. 

 

Which means you can choose your own base colour Matt Black and your choice of accent colour like daring candy red which is the best combination of all the colours. 

Let me know what do you think and which one will be your favourite colour. 

Thanks,

Tushar 

Planting Trees for retirement?? Something's you should know

 Hi Peeps,

So you must have heard that planting trees for retirement is one of the best investments you can do. However there may be some confusion around it that you need to know about the forest department as well. 

So, basically you can purchase the tree saplings from any private nursery or from forest department. The forest department does give saplings for free during sometimes of the year. But irrespective you can plant trees and no one can have any issues till the saplings are planted in a property owned by you. 

Now, the real question is when you want to harvest the trees to encash you cannot do that without prior information to forest department. So, prior notice in written or any application form needs to be submitted to forest department with legal documentation of the land in your name and the amount of trees that you wana harvest. That will be followed by a visit from forest department and they will charge very nominally and give you a written documentation stating your legal right to harvest and sell the trees. 

Well, that was simple considering how many people did try to scare me away from doing this project. 

I think the ways of working in Government Organizations have improved and been organized over last couple of decades. 

Happy Farming!! 

Thanks,

Tushar Kanti

Wana Query all tables in SQL DB

 Hey Sqeeps,

I was running an upgrade today and had to jump a major version while upgrade (from 2008R2 to 2019). I know not yet on 2022. It takes time for old joints to move. :) 

Well there was a small hiccup that there were a lot of tables in the db and I need to run some sanity check before I could hand over the database to the development team. 

So thought of putting together a small cursor which should help anyone with read permissions to run a sanity check on all tables in the databases. 

Well that runs like a monster and takes for ever so modified the query to take just 1000 rows from each table. 

Hope this helps SQeeps. 

Untill Next time,

Cheers,

Tushar

Creating PDF from iPhone

 Well hello,

First post in 2022. As usual this is related to one of the requirements I had recently. I wanted to convert an image to pdf. 

There are a lot of paid apps which can do the same. Unless you want to take a screen shot automatically and then convert them to pdf, somewhat like iscanner app. You just need to open the pages native app and copy the image you want to convert to pdf. Then just click on the ellipsis and use the export option to convert to pdf. 

Sometimes I feel there should be a microblog where we just put a couple of lines in a short blog to the point what it can be used for. What do you think let mw know in comments below.

Thanks,

Tushar

Dark Theme for Windows Outlook and SSMS

 Well Black is the new Red... What can I say.. I think it clears a lot of clutter and you feel focused on the right things. 

Right to the meat. 

nnn

For Switching Dark Mode in Windows 10. Just search for "Dark Theme" in Cortana and you should get the below option 

Just change the present setting to Dark and you should be golden. 

Next Outlook . Goto File->Options->General

Here you will find a setting Personalize your copy of Microsoft Office 

Next SSMS ->

First open a notepad with  "Run as Admin". Then open the file ssms.pkgundef and find the line "Remove Dark Theme". 

You should find the file in C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE. I have version 18 hence this path you can do a search for the file in "program files (x86) folder". Once you find the line just comment the line with "//" without the quotes as shown in the image below. 

Once done save the file and then open the SSMS. Goto

Tools->Options->Environment->General->Colour Theme-> Dark

So these are the three essential things I needed the black theme for.                                                        

Let know what application you need black theme for.                                                                              

Thanks,                                                                                                                                                        

Tushar                                                                                                                                                                

AutoScroll using Python

 So there are times when you want your screen to autoscroll. Well I just have a function where I need to play a guitar and the song is too long for me to remember all the chords and I cannot scroll when I am playing the guitar. Hence the requirement. The solution was too naïve than what I thought it would. 

You pop up your favourite Python IDE and add import the package pyautogui  this is the Hero of our solution. 

For most of us using Windows with Powershell you should have python installed. So just goto your powershell and type py.exe 

Now install the pyautogui module. 

py -m pip install pyautogui

Now go to your python shell and write the below code. 

Hope this helps. 

Thanks,

Tushar