1d ago 路 5 min read 路 SQL Server has been a cornerstone of enterprise data systems for years. It has powered reporting, analytics, and operational workloads reliably across industries. But modern data demands real-time ana
Join discussionAug 29, 2025 路 5 min read 路 Data science has become a cornerstone of modern business decision-making, enabling organizations to generate insights from large and complex datasets. While open-source tools remain popular in research and innovation, enterprises often rely on commer...
Join discussionAug 18, 2025 路 1 min read 路 Microsoft SQL Server, a leading database management system, is critical in many businesses. As a result, users frequently need to connect to SQL Server databases and be authenticated before interacting with the data. This article explores SQL Serve...
Join discussion
Jul 27, 2025 路 4 min read 路 It鈥檚 week 3. Now I was supposed to start with Excel this week parallelly alongside practicing SQL but instead got sidetracked by my own mind馃. Man, need to control the mind these days. Anyways, here鈥檚 my progress for this week. Started with the Wea...
Join discussionJul 21, 2025 路 4 min read 路 Well, it鈥檚 been a long week & I鈥檓 supposed to be posting this yesterday but hey, here we go. I have been going through concepts like JOIN which is used to combine tables in order to get the desired output. Since I鈥檓 using RDBMS, using JOIN command i...
Join discussionJun 25, 2025 路 1 min read 路 This has bitten me so many times, I鈥檓 putting this here where I can find it in the future. You might want to bookmark this page :) I rely heavily on stored procedures for interaction both internally and externally. The improve performance and efficie...
Join discussion
Jun 2, 2025 路 1 min read 路 Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta...
Join discussion
Oct 5, 2024 路 4 min read 路 Have you ever wondered - how you can you be absolutely sure that no one has tampered with your data after it's been stored? Or how you can create a database that provides an unchangeable history of every update, insert, or delete operation? With SQL ...
Join discussionAug 7, 2024 路 5 min read 路 Overview Compute Engine lets you create and run virtual machines on Google infrastructure. There is a catalog of public application images available, including a variety of Microsoft SQL Server and Windows versions. In this lab, you will learn how to...
Join discussion
