Highlights from Microsoft BUILD 2015 and Microsoft Ignite 2015 Conferences!

Hi Everyone, Today, I would like to share some of the key highlights from our recent Microsoft conferences targeted towards developers and IT Professionals. Last few weeks were filled with so many awesome announcements from Microsoft. We have covered different areas including personal computing to public cloud, IoT to Machine Learning and much more. Here…

Continue reading →

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 →