In today's data-driven world, traditional databases struggle with the increasing volume of information. NoSQL databases like MongoDB offer the flexibility, scalability, and speed needed to manage diverse data effectively. With its versatile applications and a cloud solution, MongoDB stands out as a cost-effective, reliable option for modern data challenges.
Database Normalization and the Entity-Relationship (ER) Model: A Foundation for Effective Data Management Working at Nestle has provided me a lot of valuable experience in data management specially in our DEX tool which we use for endpoint management for collecting huge amounts of data and then using that data to create automations, including utilizing normalization... Continue Reading →
Hi everyone, Let's discuss the SQL update statement when using joins in SQL. Many of us try to make this complicated when we try to use update statement when dealing with two tables using joins. Please follow along for this short SQL lesson on UPDATE USING JOINS. For example: Suppose we have 2 tables that... Continue Reading →
Hi everyone , A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database . Select s.Netbios_Name0,ip.IP_Addresses0, s.Distinguished_Name0,s.operatingSystem0, s.Operating_System_Name_and0 from v_RA_System_IPAddresses AS IP inner join v_R_System AS S on ip.ResourceID=s.ResourceID where operatingSystem0 like '%Server%'; My requirement was for servers , but if... Continue Reading →
Hi There , Yesterday i had a requirement to go through the disk space utilization for all the servers in our environment to keep a track before year end . Now remember we are not looking for a report that shows low disk space which you can readily get through SCCM reports . This report... Continue Reading →
SukhdeepBlogs 