November 22, 2017

Computer memory measurement details

Following are the Computer memory measurement details

0 or 1=1bit

8 bits = 1Byte

1024 Bytes =1 Kilobyte

1024 Kilobytes =1Megabyte
1024 Megabytes = 1 Gigabyte
1024 Gigabytes = 1 Terabyte
1024 Terabytes =1 Petabyte
1024 Petabytes =1 Exabyte
1024 Exabytes =1 Zettabyte
1024 Zettabytes=1 Yottabyte

1024 Yottabytes=1 Brontobyte
1024 Brontobytes=1 Geopbyte


Geopbyte is the current highest memory measurement.

September 22, 2017

Observing Tables sizes Records and Free space on SQL server database

I want to share one clip which will show you how to check each Table size for all tables, Total Number of records, Disk usage on tables, free spaces for tables in SQL Database.

You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables.

Just visit this clip to get all details.


September 4, 2017

IT Security:Information Technology Security tips and trick


Protect what matters

Prioritize your most sensitive accounts.
  • Email
  • Online banking and other payment websites
  • Amazon and other eCommerce website you use for shopping like flipkart
  • Any account where you’ve put in your card details
  • Any account that has sensitive info (social security number, address, phone no., etc.).
  • Secure them with strong passwords + two-factor authentication.

                                                                                                          
Always check for the website before sharing your personal data

Before you rush into filling in any sensitive data, such as personal information or credit cards details, make sure that you’re on a secure connection. Otherwise, your data can be accessible to anyone who knows how to get it.

How can you check that? It’s easy:
Look at the address bar. Does the link start with “https” instead of “http”? The extra “s” means that the website has a valid Secure Sockets Layer installed (short for “SSL“). This is a method to ensure that the data sent and received is encrypted and the online transaction isn’t intercepted in transit. It’s not something compulsory, but most legit websites will obtain SSL digital certificates. 
Another method is to look for the icon of a closed padlock. It’s usually located on the left of the web address, but it depends on the browser you’re using. Some browsers will also highlight the address bar in green. These are indicators that you are visiting an encrypted site and the connection is secure.


Online shopping safety  


  • Never do it from a device that isn’t yours or on a network you don’t own.
  • Your data could be copied and harvested by cyber criminals.
  • Make sure you’re spending your money by using safe network
  • Employing strong passwords 
  • Be careful about which websites you shop at
  • Never save your card details in an online account
  • Verify your transactions weekly to make sure there’s nothing fishy going on.


August 8, 2017

Security Awareness for your laptop,PC ,Mobile devices

1. Do NOT open any Email attachments from unknown sources like exe files , whether on your your own personal email accounts such as Yahoo, Gmail, etc. 

2. Do NOT click on any Links , sent from unknown sources, either via Emails or accessing your Facebook account.  Also, please refrain from accessing unknown Web Sites.  These can be infected with Ransom ware virus

3. Do NOT Disable your Anti-Virus under any circumstances .

4. Take regular  Backup of all your important Data and files .

5. Update all Patches - Antivirus, Operating System ,soft wares,Internet explorer etc MS Office, etc.

6. If you are unable to open any of your files that you use, please follow the instructions 
 If you notice any suspicious activity on your pc / laptop / laptop is running too slow, immediately disconnect your laptop from the network, shut off your pc / laptop

7. If you use / share any External Drives such as USB Thumb drives ,USB Hard Disks,CD,DVD etc please SCAN them with the Antivirus before using them.

June 2, 2017

Famous things to buy for KSA Visiting

Famous things to buy in  Saudi Arabia ,Places and Useful Information

1.Souks is The traditional open air markets, its an old markets of Jeddah along the Red Sea.You can buy  at Al-Basha Market for gold and precious jewels . in Jeddah,The Souk Al Nada is one of the oldest shopping streets  to buy gold, textiles, clothing, jewelry etc.

2. Bateel is good and modern dates and chocolate shops.

3. You can also buy carpet, some antiques ,traditional dress for women  in Saudi Arabia.

4. You can also buy local traditional perfume stores where Abdulsamad Atarjee is famous one.

5. You can also buy gold from Al faisaliah mall, kingdom tower mall and Al nemr mall etc.  But for reasonably priced gold jewelry, try to go to Batha, Filipino market,Deira ec.

6.If you are looking diamonds, then you can visits good jewelry stores in olaya.

7. If you want to buy tobacco,cigarette,paan etc in Jeddah then you can go to Al-Sharafiya market, Jeddah there you can get some shops.

8. If you are veg and visiting Jeddah then you can visit metro hotel ,village,jum jum hotel,India gate hotel in Jeddah there you can take good veg food.

9.Al-Balad Market, Jeddah is A beautiful historic place in Jeddah.If you are looking for deals and discounts then l-Balad Market is best place.You can find good watches, electronics, prayer mats, textiles,perfume ,dates and chocolate etc

10.Grand Al Saha,at Madina road, Saudi business center is good hotel to stay 270 SAR for single person room if you are 2 person then its 360 SAR charges for double bed single room.

May 14, 2017

TOP 10 facts You need to Know about India

TOP 10 facts to Know about India

Famous and Historic Places to visit In India

1. The Red Fort, Delhi
2. The Taj Mahal, Agra
3. Pangong Lake, Ladakh
4. Valley of Flowers, Nainital
5. Jaisalmer Fort, Jaisalmer
6. Ruins of Hampi, Karnataka
7. Ghats at Varanasi, Uttar Pradesh
8. Backwaters, Kerala
9. Old Goa, Goa
10. Umaid Bhavan Palace, Jodhpur
11. Jama Masjid, Delhi
12. Akshardham Temple, Delhi
13. Old Bombay, Mumbai
14. Ajanta and Ellora Caves, Aurangabad
15. The Golden Temple, Amritsar
16. Charminar, Hyderabad
17. Amber Fort, Jaipur
18. Rashtrapati Bhavan, Delhi
19. Mahabodhi Temple, Bodh Gaya
20. Meenakshi Amman Temple, Madurai
21. Khajuraho Temples, Chattarpur
22. Elephanta Caves, Mumbai
23. City Palace, Udaipur
24. Havelock Island, Andamans
25. Tirupati, Chittoor
26. Tawang Monastery, Tawang
27. Kaziranga National Park, Assam
28. Kesaria Stupa, Kesaria
29. Palitana Temples, Bhavnagar
30. City Palace, Jaipur
31. Sun Temple, Konark
32. Rani Ki Vav, Patan
33. Chaturbhuj Temple, Orchha
34. Cellular Jail, Port Blair
35. Borra Caves, Vishakhapatnam
36. The Ridge, Shimla
37. Tso Moriri Lake, Ladakh
38. Mysore Palace, Mysore
39. Bangalore Palace and Grounds, Bangalore
40. Gwalior Fort, Gwalior
41. Bhimbetka Rock Shelters, Raisen
42. Victoria Terminus (Chattrapati Shivaji Terminus), Mumbai
43. Jagannath Temple, Puri
44. Lingaraja Temple Complex, Khurda
45. Udayagiri Caves, Bhopal
46. Qila Mubarak, Bhatinda
47. Jallianwala Bagh, Amritsar
48. Chhatrapati Shivaji Maharaj Vastu Sangrahalay, Mumbai
49. Lake Palace, Udaipur
50. Ghats and Old City of Pushkar, Pushkar
51. Ranakpur Jain Temple, Ranakpur
52. Bada Imambara, Lucknow
53. Fatehpur Sikri, Agra
54. Humayun’s Tomb, Delhi
55. The Great Stupa, Sanchi
56. Jantar Mantar Observatory, Jaipur
57. The Great Living Chola Temples, Thanjavur
58. Mahabalipuram, Kanchipuram
59. Agra Fort, Uttar Pradesh
60. Cave Temples, Badami
61. Nalanda University, Bihar Sharif
62. Junagarh Fort, Bikaner
63. Cooch Behar Palace, Cooch Behar
64. Nizamat Imambara, Murshidabad
65. Belur Math, Belur
66. St. Paul’s Cathedral, Kolkata
67. Akbar’s Tomb, Agra
68. Chota Imambara, Lucknow
69. Sundarbans National Park, South 24 Parganas
70. Makkah Masjid, Hyderabad
71. Ramanathaswamy Temple, Rameswaram
72. Basilica of Our Lady of Good Health, Velankanni
73. Marina Beach, Chennai
74. Gagron Fort, Jhalawar
75. Sariska Tiger Reserve, Alwar
76. Gateway of India, Mumbai
77. Kumbhalgarh Fort, Rajsamand
78. Ranthambore National Park, Sawai Madhopur
79. Mehrangarh Fort, Jodhpur
80. Munnar Hills, Idukki
81. Loktak Lake, Moirang
82. Kodaikanal Lake, Kodaikanal
83. Nainital Lake, Nainital
84. Jaigarh Fort, Jaipur
85. Jim Corbett National Park, Nainital
86. Dharamshala, Kangra
87. Laxmi Vilas Palace, Vadodara
88. Gir National Park, Junagarh
89. Marine National Park, Gulf of Kutch
90. Tughlaqabad Fort, Delhi
91. Pattadakal, Bagalkot
92. Bishnupur Temples, Bankura
93. Monuments at Mandu, Dhar
94. Shalimar Bagh, Jammu and Kashmir
95. Lotus Temple, Delhi
96. Kakatiya Temple, Warangal
97. Silent Valley National Park, Palakkad
98. Srirangapatna, Mandya
99. Purana Qila, Delhi
100. Chittorgarh Fort, Chittaur

May 3, 2017

SQL Server Tips for Memory usage,replication,CU updates etc

1. To check which user is taking maximum memory usage in SQL 2014 You can try below command

select * from sys.sysprocesses

sp_who2active

2. How to rename a column in subscription table in replication

You have to remove from replication: Rename. and then re-add to replication


3. Clear cache in SQL for TempDb.

RUN THIS COMMAND ON TEMPDB  DATABASE ONLY

DBCC FREEPROCACHE


 4. How to install the Service pack 3 on server,This is my recommendations .

Server: SQL server 2012 standard edition having sp1 and you want to install the SP3 and CU 7 at a time ?

Then you can install SP3 and check if that covers CU 7 as well, if not then you can install CU 7 after the SP3 Successfully installed.

But make sure to take the DB Backups prior to proceed

5. Resolve Authentication Error for Mailbox in SQL

Error is Mailbox unavailable. The server response was: Authentication is required for relay
in SMTP server

If You are providing the server address like Server ip without login details that means It is Anonymous authentication type.

The issue mentioned in this post as the SMTP doesn't allow anonymous authentication.

You need to  provide the credentials to authenticate to SMTP Server.

April 30, 2017

Difference between 11.0.3368.0 and 11.0.3128.0 for SQL Server 2012


1. 11.0.3368.0 
Full version name 
Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64) 
May 22 2013 17:10:44 
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

2.11.0.3128.0
Full version name 
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
Dec 28 2012 20:23:12 
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

Remarks:-

Version 11.0.3368.0 include Hot Fix for Microsoft Knowledge Base article number(s) 2833645 for Microsoft SQL Server 2012 (SP1) 64 bit server-pack 1

This hotfix is also known as CU4 for SQL. You can search on google with name KB2833645 to find download for this.

11.0.3128.0  this version is standard installation excluding CU4.

April 25, 2017

Some Important Information for Power BI Tool

If you are search for some information about Power BI then Important points I am mentioning here for Power BI. Its just idea.

Power BI

1.Power BI can connect to your cube and create report and view.
2.Power BI free but  pro edition(included refresh data option in pro license)
3.Power BI can connect by any device mobile ,laptop etc
4.Power BI can connect to real time data for dashboard.
5.Power BI can connect to premises data like axapta,your excel ,sql ,oracle data etc
6.Tools is POWER BI Desktop
7.Cost is 10 $ per user per month probable it may increase or decrease time to time.
8.Enterprise gateway used to linked data to organization.

April 24, 2017

Management Reporter 2012 Configuration Console Publish connection

Management Reporter 2012 Configuration Console.

If you are facing issue in MR Url for particular user then you can publish MR server connection from configuration console using below steps.

Choose the relevant ERP integration:
Management Reporter 2012 Configuration Console

From the menu in the right window, choose the Publish server connection:

Publish connection

You are probably prompted to enter the login credentials for the service user, enter them and all should go well:
updated


The server address should now be updated!

IMAP and POP setting for Office 365 on mail sending


If you are trying to configure to send mail by code or any application through office 365 then setting of port is as below.


Office365 setting