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 […]Read More
Category: SQL Server
azure, Cloud, Datacenter, Developer, Identity, IT Professional, Linux, Open Source, Operations Insights, Security, System Center, Windows Server
Highlights from Microsoft BUILD 2015 and Microsoft Ignite 2015 Conferences!
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 […]Read More
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 […]Read More