SQL Server – What are Different Normalization Forms?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational databases. In relational database design, the process of organizing data to minimize redundancy is called normalization. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective…

Continue reading →

SQL Quiz – Why Error when Executing SELECT statements

Let us start our very first blog post with a quiz. Thanks Pune User Group for inviting me for the guest blog post. Run following T-SQL Code in SSMS. There are total of five lines. Three T-SQL statements separated by two horizontal lines. SELECT MAX(OBJECT_ID) FROM sys.objects ______________________________________ SELECT MIN(OBJECT_ID) FROM sys.objects ______________________________________ SELECT COUNT(OBJECT_ID) FROM sys.objects Now when you execute individual lines only…

Continue reading →

Sensors! Sensors Everywhere!!!

Sensors play very important role in mobile and tablet devices. These days, we can’t imagine a device without some basic sensors. For example, ‘Proximity Sensor’ helps to disable touch-screen (and its input) when the device is in pocket. This avoids unnecessary touch inputs. ‘Light Sensor’ can automatically adjust the brightness of the screen. Every Windows…

Continue reading →

Welcome to PUG Blog!

Hello everyone I am Mahesh Mitkari, Founder Volunteer and now User Group Lead for Pune User Group. Today I am excited to announce new initiative by PUG Team, a brand new online platform to connect with you. We’re pleased to welcome you to “PUG Blog”. The purpose of this blog is to share knowledge and…

Continue reading →