IT Minds

The Dynamic Host Configuration Protocol (DHCP) is a network service that enables host computers to be automatically assigned settings from a server as opposed to manually configuring each network host. Computers configured to be DHCP clients have no control over the settings they receive from the DHCP server, and the configuration is transparent to the computer's user. The most common settings provided by a DHCP server to DHCP clients include: IP address and netmask IP address of the default-gateway to use IP adresses of the DNS servers to use However, a DHCP server can also supply configuration properties such as: Host Name Domain Name Time Server Print Server The advantage of using DHCP is that changes to the network, for example a change in the address of the DNS server, need only be changed at the DHCP server, and all network hosts will be reconfigured the next time their DHCP clients poll the DHCP server. As an added advantage, it is also

The Skype Team forced us all to update to the latest version of Skype for one reason and one reason only:  Money They want us to see their new advertisements so they make more profit; they don't care how bad they are at programming and how bad they are at developing Skype. Luckily, there is a solution to get rid of these advertisements and make Skype better (although it still has too many problems than the older versions). 1. Open-up the control panel. 2. Open-up "Network & Internet" then "Internet Options". 3. Go to the "Security" tab. 4. Click on the "Restricted Sites" icon, then the "Sites" button below it. 5. Type " https://apps.skype.com/"  (without the quotes) into the text box and click "Add" 6. Close and apply the changes. 7. Restart Skype. 8. ??? 9. Profit!

HOW TO MODIFY A COLUMN SIZE, IF WE HAVE MULTIPLE TABLES WITH DIFFERENT SUFFIX AND THAY ALL CONTAINS SAME COLUMN DEFINITIONS, I NEED TO MODIFY A SPECIFIC COLUMN'S SIZE OF ALL TABLES USING ONE SCRIPT.  AS LIKE MENTIONED BELOW: UPDATE  INFORMATION_SCHEMA.COLUMNS SET  CHARACTER_MAXIMUM_LENGTH = 100, CHARACTER_OCTET_LENGTH = 100 WHERE  TABLE_NAME LIKE '__MYTABLENAME' AND  COLUMN_NAME = 'MYCOLUMNNAME' AND  CHARACTER_MAXIMUM_LENGTH < 100 ---------------------------------------------------------------------------------------------------------------------------------- Using OPENROWSET to read large files into SQL Server Problem OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server's BULK import capability. One of the useful features of the BULK provider is its ability to read individual files from the file system into SQL Server, such as load

The steps are as follows: Start with  understanding the process followed by the org. / company  for which you’re thinking of creating a Datawarehouse. Decide whether you need just a Database or a Data Federation or a complete Datawarehouse. Create a list of questions that you want to answer for the business  (that’ll help the business analyse data better & make better decisions using the data) through the datawarehouse. Find out the Data Source Points  & the kind of systems that the data resides in (For example, some data might be in files whereas some might be in Websites like twitter / facebook or databases such as Oracle / SQL Server / MySQL). Build a  Requirement Specification Document  & get it approved / reviewed by the Business Owners. Perform Data Modelling  to create a set of tables that you’d need in the Datawarehouse / Database. Also define the kind of dimensions (Slowly Changing, Degenerated, Conformed, Static, etc) & facts (Early Arriving) in case

Microsoft’s  Windows 10 November update  brings with it a handy “find my device” feature, but it’s not just for tablets or phones. Any Windows 10 device can take advantage of the new feature, including desktops and laptops. Find My Device in Windows 10 doesn’t do a whole lot right now. There isn’t a way to have your tablet make a sound, lock itself, erase data, or anything like that. Instead, you can only find out where its last known general location was. Nevertheless, if you want to try this feature out here’s how to turn it on. Find My Device is buried under  Settings > Update & Security . To active this feature go to  Start > Update & Security > Find My Device . On this screen you’ll see a big  Change  button under the heading “Find My Device is off.” Turn this slider to  On  and you’re done. Once you click  Change  you’ll see a pop-up panel that says “Save my device’s location periodically.” Turn the slider to  On  and you’re done. Fin

Paytm founder, Vijay Shekhar Sharma’s incredible life story! Vijay Shekhar Sharma owns a company whose current value is a little over $3 billion in the market in 2016, a dream dreamt when he was struggling to make ends meet with Rs 10 in pocket. "To the winners, who won because they didn't give up."-  Vijay Shekhar Sharma , founder of  Paytm . The man, who always wears a welcoming smile, stands true to every word he wrote during the most difficult times of his life. Vijay Shekhar Sharma owns a company whose current value is a little over $3 billion in the market in 2016, a dream dreamt when he was struggling to make ends meet with Rs 10 in pocket. But he tasted victory the hard way. Nothing came easy for him. The tears he hides behind the chirpy self that he puts up in front of the world could not be hidden for long while recollecting his journey. Interestingly, it was not talking about his failures that brought tears in his eyes; it was his hard earned victory