Category: SQL Server

May 14, 2015
, , , , , , , , , , ,

Highlights from Microsoft BUILD 2015 and Microsoft Ignite 2015 Conferences!

by pug-admin in Office 365 , SQL Server , Windows 0 comments

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
April 2, 2015

SQL Server – What are Different Normalization Forms?

by pug-admin in SQL Server 0 comments

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
March 16, 2015

SQL Quiz – Why Error when Executing SELECT statements

by pug-admin in SQL Server 0 comments

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