Jump to content
Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble
Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble

All Activity

This stream auto-updates     

  1. Yesterday
  2. The USB drive is an essential part of daily life for carrying data anywhere. The USB drive/SD card is so small that it can carry thousands of photos, music videos in your single small chip. what will you do if your USB flash drive /SD card gets corrupted? continue reading
  3. Last week
  4. ksanjeevp

    How to Secure my wireless network

    Enable ACL (Access Control List) with MAC.
  5. How to Take backup of All of the Databases available on instance ? Sometimes Its required to take all of the Databases to be backed up periodically for more reliable backup process. If You require to get backup of any critical server's Database then You shouldn't do manually always, It will be better to automate the Process.SQL Query to take backup for All the Databases:- DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name-- specify database backup directorySET @path = 'D:\BKP\' -- specify filename formatSELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR READ_ONLY FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude these databasesOPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @path + @name + '_' + @fileDate + '.BAK' BACKUP DATABASE @name TO DISK = @fileName FETCH NEXT FROM db_cursor INTO @name END CLOSE db_cursor DEALLOCATE db_cursor copy the above query and save it with file name i.e- sqlbackupquery. The above query will give the Database backed up file (.bak) on the location You will set.You can run it over SQL server Management Studio (SSMS) or on sqlcmd.Query will give you the database backup in the described format below.DBName_YYYMMDD.BAKYou can run it from SQL CMD, with the required parameters. for Example see below.sqlcmd -S .\InstanceName -i C:\SQLBackup\SQLBackupQuery.sql (backup query file location and file name) If you require it to schedule the Process for backup of all SQL databases on the path where you want You can schedule it from Task Scheduler.To create a task go to Run (windows +R) - taskschd.msc and create a task. schedule it as per the requirement. Here define the action. Note- User should have the Admin right,Logon as batch Job Right. You also can automate on SQL Server Express from above query and Process.Enjoy, Now You will be able to take the databases backup in one go and schedule it as per your requirement for convenience and saving the time.Thanks,SanjeevPS- Please write to me or comment if you have any question/Feedback.
  6. Here I am sharing about UCC SSL certificate Installation. Prior to start its required to understand what is an SSL certificate. and why we require it, I have tried an easy way to understand and sharing easy steps of Installation.UCC SSL certificate- also called multidomain SSL certificate. UCC- Unified Communication Certificate is an SSL certificate that secures multiple domains(SAN- subject alternative names), Host names(FQDN) within a Domain.UCC lets you secure your Primary Domain and after SANs or any hostname which you use Publically for any hosted services. It can support upto 99, and Ideal for MS exchange, Communication servers or any application hosted on IIS which you require publically. It will be compatible with shared hosting as well. Understand why SSL certificates required- SSL certificates give you secured and encrypted communication between websites and your Browser, SSL( secure Socket layer) which provides encryption, SSL certificate required to installed on the Pages where user required to fill/send sensitive and Personal/confidential Information. such as payment pages, Login page, Online forms etc. data transfered in Plain-text or in non-encrypted can be easily intercepted,compromise or stolen. Here I will share how we may use same SSL certificate for both, also on shared hosting with a differen platform/Application hosting.First you require to purchage UCC SSL certificate as per your requirement.You may get from service providers for example- in.godaddy.com, instassl.com symantec globalsign..etc.on shared hosting we had got an SSL from service provider but they didnt able to support us and want us to charge for installation, So we have done it on our own. It will be very helpful follow the steps and you will be able to do it easily.. Purchage a UCC SSL certificate from Service provider for your xyz.com Domain. Now you want to use the certificate on xyz.com +abc.xyz.com + India.xyz.com+ Delhi.xyz.com for different different services for different purposes on different platform, so to use this you should have Certificates with same serialnumber should install on required Hosts/Servers/SANs. Example:- https://yourdomainname.com https://www.yourdomainname.com https://abc.yourdomainname.com https://delhi.yourdomainname.com:443 (orother port) it should all working. even if application are hosted on different platform or shared hosting.XYZ.com is domain and abc.xyz.com or other prefixes will be SANs. In our scenario we have got SSL from godaddy and we were using it only on IIS(microsoft) but we want to use for other services as suggested by the support Team, we have rekey and certificate has stopped working for previous but as we purchased and we have Certs available it should work, but support was not able to give us required steps then they said it will be on chargeable basis if we required, then we have done from our own.If you have installed Cert on IIS hosted application and you want same cert with same serial number to use on Linux apache hosted application/website.Here is an outline of the process that may used to generate and install the UCC certificate for use in multiple places at xyz.com Using IIS Manager on our server, create a certificate request. Then take the certificate request blob to the GoDaddy site and enter it as my Certificate Signing Request (CSR) to get them to issues me a UCC certificate to specification (SAN’s etc.) Once they issue UCC certificate, take that certificate back to the IIS Manager on server to complete the certificate request by installing the certificate on the server where the original certificate request was made. Then, I export the certificate from the server(IIS manager), which creates a .pfx file that we then use to install the UCC certificate on all the other sites that are named in the certificate.Export the certificate from IIS: Go to IIS manager on your windows server.Select your server in the left pane, then double click the Server Certificates icon in the middle pane: Select the certificate that you want to export in the middle pane, then click the Export… link in the right pane: enter the file name and pass to export. Your file will be exported as you want on location UCC cert.pfx created on desired location.[/caption] Now use the file to install on the services or application where you want. Remember when creating CSR(certificate signing request), You need to add the SANs for which you have to use the SSLcerts with same serial.You will be able to do on IIS easily but if you use shared host or if its on another OS or application as Linux apache, then you required to extract Pvt key again and paste pvt key separately. then you may use it perfectly.Use your credntial to login on shared host, If its on Linux apache go to Cpanel and click on SSL/TLS option. after clicking on SSL/TLS go to manage SSL If you want to unintsall a certificate which is not working or required a new cert to upload. to install first you need to upload. or you may choose to install an uploaded cert. If you face issues with Private key, after uploading certs pvt key not getting uploaded then you need to extract Pvtkey from the certificate(.pfx or .crt file)You need to use Open ssl (http://gnuwin32.sourceforge.net/packages/openssl.htm) (Open SSL Tool) to extract the pvt key and use on the above tab with certificate. Now you will get above screen, you have installed successfully.after finishing browse your URL which will be working after few hours and match the both certs it will have same serialnumber and validity.To check go to Internet explorer- click on view certificate. Click on Details You will find same as on your IIS host and on your shared host or Except IIS different Application.Enjoy.. You have done now. Hi Guys please let me know if you have questions, and I welcome your comments.Thanks,Sanjeev complete Post - https://ksanjeevpandey.blogspot.com/2017/12/ucc-ssl-certificate-installation-on.html
  7. rajababa

    Need a Suggestion about a WP Theme?

    Hi there, If you want wonder full theme on WP so download SAHIFA it is amazing theme. If you need any outsource service regarding blog comment so go to fiver, i also purchased from this guy, it was amazing. Thanks.
  8. rajababa

    What is Black Hat Seo? 

    Black hat SEO is a practice against search engine guidelines, used to get a site ranking higher in search results. These unethical tactics don't solve for the searcher and often end in a penalty from search engines. Black hat techniques include keyword stuffing, cloaking, and using private link networks. Personally i recommend you use only web directory, profile link, forum link, and blog comment, if you need any outsource service regarding blog comment so go to fiver, i also purchased from this guy, it was amazing. Thanks.
  9. Boris

    CCleaner

    v5.60.7307 (16 Jul 2019) Browser Cleaning - Improved the Flash cleaning rules in Chrome, Opera & CCleaner Browser CCleaner Browser - Added Smart Cleaning & Easy Clean support Software Updater - Fixed a disappearing text bug - Fixed a navigational bug
  10. Boris

    Hello Everyone

    Welcome, always nice to see new members (especially those who contribute posts to the forum)
  11. grecze

    Hello Everyone

    Hi everyone! I am also new on the windowsforum.
  12. Earlier
  13. Boris

    How to Secure my wireless network

    Simply use a non-guessable wireless password or in your router settings, specify the MAC addresses of those you want to have connections and bar the rest.
  14. I would like to secure my wireless network so that only the computers I want can have access to the internet and my network. How can I do that? sincerely, pallas
  15. As you two lads are geographicaly so close (Gurgaon, Haryana, 122002, India) you really should get together to talk over this ☺️
  16. lokeshjoshi1993

    C Vs C++ Which is good?

    Hi Amit, Hope you are doing well, Here I am sharing a small difference between C & C++. C C++ It is a Procedural Languages It is a supports oriented Languages It has the lowest level of abstractions It has a low level of abstraction Manual Memory Management It is also Manual Management It is very lightweight and compiled it is lightweight and compiled It is fast and top-notch performance Comparable to C Can code for any platform also can code for any platform Allows coding almost anything Allows coding almost anything Good for embedded devices and system level code Good for server-side applications, networking, gaming and device drivers For a more detailed difference, you can read our blog post and ping me here for any help.
  17. Hello All, Anyone is C++ developer which help me out which one is better C or C++? and which is good for carrier point of view?
  18. -pops-

    Windows 10 nightmare.

    I doubt it. There are a number of operating systems available, some have general uses, some have more specialised applications but the day when all computers come under the control of one conglomerate will not happen.
  19. marketingzet

    Windows 10 nightmare.

    Supporting a whole range of operating systems costs a lot! Windows 10 is the last and final Microsoft OS; after a while, everybody in the whole world will be on Windows 10.
  20. Akshay_M

    Which graphics card is best under $300?

    Nvidia’s GeForce GTX 1060 is a powerful higher mid-range graphics card that offers excellent performance and is priced under 300 dollars. This is one of the best affordable graphics cards that you can buy for high-end gaming at 1080p and 1440p. GeForce GTX 1060 is powerful than the GTX 1050 Ti by a good margin both in real world gaming and synthetic benchmarks. GeForce GTX 1060 is built on the latest Nvidia Pascal Architecture that ensures maximum performance with lower power consumption. It also offers the best Virtual Reality (VR) gaming performance as compared to other older mid-range cards in this range. GeForce GTX 1060 comes into two memory variants, one comes with 3GB GDDR5 and other one comes with 6GB GDDR5. The number of CUDA Cores in both these variants is different. 3GB one has 1152 CUDA Cores and 6GB one has 1280 Cores. The difference in 128 CUDA cores and 3GB memory does make a bit of difference in games making the 6GB one a better choice. The recommended power supply for GTX 1060 is 400W which is decent considering the power these cards possess. Regards, Akshay
  21. There is no such tool, you can load the pst to outlook and archive the mails in individual, smaller pst's. Regards, Akshay
  22. Akshay_M

    Internet Explorer

    Edge is soon gonna get the Chrome Engine and It will be Named a Edge Chromium. It will be having features almost similar to that of Google Chrome. IE is no where in the Race now. Regards, Akshay
  23. Boris

    CCleaner

    v5.59.7230 (25 Jun 2019)
  24. Try setting your Page File to a 4GB Custom Size - as example below
  25. Hi All, I'm having a strange problem I've never encountered before. When I first boot my Win10 machine, I have about 17-18GB of disk storage space. After about 2 hours (often less), my page file has grown considerably to the point where my storage is out of space and my system crashes. A reset is the only option at this point. I'm not running anything too RAM intensive (Chrome always takes up the most memory and I'm only doing desktop work), so I'm not sure what's happening. I suspect there may be a memory leak, but am not sure how to detect it or what would be causing it. I don't suspect malware or such as I have done scans recently. I have the option, "Automatically manage paging file size for all drives" check in the System properties. This happens everytime I use my machine. I have 8GB of DDR4 RAM and and 240GB SSD. Any help would be appreciated, thanks!
  26. Yuvi

    Best Pc games According to you....?

    Assassin 's Creed: Black Flag Skyrim The Witcher 3: Wild Hunt GTA 5 NFS: Most Wanted Yuvi
  27. For easy and quick result, we have compiled over 230 Comprehensive Excel Keyboard Shortcuts for Windows. Many times, people wonder and call their colleagues wizard following how proficient they are in using Microsoft Office Excel. There’s no magic in excel like using shortcut keys to manipulate records swiftly without breaking your back. The excel shortcut keys make us work 10 times faster than using the normal conventional way to solve office challenges. The post: 230 Excel Shortcut Keys You Can't Live Without appeared first on Excel How Tos, Tutorials, Tips & Tricks, Shortcuts.
  28. Yuvi

    Which graphics card is best under $300?

    You can either opt for RTX 2060 if you can extend your budget a little bit or you can go for 1660 ti or for best budget card go for AMD RX 580 Yuvi
  1. Load more activity
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy