Apple WWDC 2020 Keynote

Posted on by admin

Apple WWDC 2020 Keynote

iOS 14

Key Highlights:

  • Widgets available on Home Screen to give more information just at a glance and it is also customizable in different size.
  • App Library allows you to organize your apps in various categories, sorted by more recent used.
  • Compact Calls and Siri eliminates the entire screen call design into subtle design.
  • Picture in picture support allows multitasking such as watching tv shows while browsing another app.
  • Translate App allows real-time translation.

Digital CarKey

With iOS 14/iOS 13 apple is releasing digital CarKey and CarPlay feature. This feature provides the ability to save car keys in apple wallet.
This will allow iphone or apple watch to unlock and lock NFC (Near Field Communication) compatible cars. BMW 2021 will be the first car with this CarKey buildin feature. Digital CarKey can also be shared using iMessage.

CarPlay will also support apps such as parking, electric vehicle charging and ordering food.

Apple Watch

  • Watch OS7
  • Sleep tracking feature
  • Track hand washing with 20-second countdown
  • Wind down feature

iPad

  • OS 14
  • Enhanced Widgets and UI
  • Universal Search
  • Scribble using your hand to populate text fields

iPod

  • Auto connect among apple device

TSQL – Last Time Table was Updated

Posted on by admin

TSQL – Last Time Table was Updated

If you looking for a script to find out when was the last time a particular table was updated then here it is:

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DATABASENAME')
AND OBJECT_ID=OBJECT_ID('TABLENAME')
SELECT
tbl.name
,ius.last_user_update
,ius.user_updates
,ius.last_user_seek
,ius.last_user_scan
,ius.last_user_lookup
,ius.user_seeks
,ius.user_scans
,ius.user_lookups
FROM
sys.dm_db_index_usage_stats ius INNER JOIN
sys.tables tbl ON (tbl.OBJECT_ID = ius.OBJECT_ID)
WHERE ius.database_id = DB_ID()

This normally happens when you don’t have columns such as DateCreated and UpdatedDate in the table.

Live as if you were to die tomorrow. Learn as if you were to live forever.. -Mahatma Gandhi

Windows 10 – Adjusting Search Box in File Explorer

Posted on by admin

Windows 10 – Adjusting Search Box in File Explorer

In windows 10 the search box area in file explorer is too wide, well for me personally. The good thing about windows 10 is that you have the ability to adjust the search box according to your personal needs.

Move your mouse in between address location box and search box unless you see your mouse cursor changed to Horizontal Move. Slide left or right according to your needs.

The search function will perform correctly with the specified search text even though your specified text is not completely visible in the search box.

File Explorer with horizontal cursor

Happy Learning…..