Home » 2020 » April

Monthly Archives: April 2020

Understand SQL Server Editions and Components

SQL Server editions:-

· Enterprise – Enterprise edition is the topmost edition with all available features. This is best suited for mission-critical Tier 1 applications. Enterprise edition is the capabilities of tremendous hardware scaleup.

· Standard – Standard edition is mostly used in economic edition with limitations of hardware support and advance features. In case your application database is not using any advanced features, you are good to use this edition.

· Developer – Developer edition is similar to enterprise edition will all features. The developer edition is FREE and introduced by Microsoft for development, testing, and demo. You can upgrade it to Enterprise edition anytime without reinstallation.

· Express – Express edition is free of cost setup with very limited hardware and features support. Express edition is best suited for web and mobile applications. You can sustain up to 10GB of database only.

· Enterprise Evaluation – Enterprise evaluation is similar to the Enterprise edition. This is free of cost edition and a great way to test and develop your application against enterprise edition features. You can upgrade it to enterprise edition anytime using an edition upgrade option with a valid key. This edition comes up with an expiry of 6 months and you should ensure to upgrade it before expiry to keep your system running.

SQL Server Components:-

SQL Server components can be divided into client \ workstation and server types.

· Client components are installed in a client machine or machine from which you want to connect and access SQL Server. Client Components are:-

  • SSMS: SQL Server Management Studio gives you a GUI interface to connect available SQL instances.
  • Profiler: SQL Profiler is a client tool to monitor transactions running on the server. This is one useful tool for auditing and performance checks.
  • DTA: Database Tuning Advisor is a DBA tool that helps you to analyze query performance and it can suggest possible indexes and other changes.
  • BIDS: BIDS is a Bussiness Intelligence Development Studio, a powerful BI tool. You can develop SSRS reports, SSAS Cubes, and SSIS ETL packages using BIDS.
  • Etc.

· Server components are installed on the primary server. Server Components are:-

  • SQL Server: SQL Server is the primary server to run SQL instance and using SQLServer.exe in the background.
  • SQL Server Agent: SQL Server agent is the dependent server of SQL Server. It’s used for scheduling activities and uses sqlagent.exe in the background.
  • SQL Server Browser: SQL Server browser is important to service from security and accessibility points. When enabled, It helps incoming connections to map SQL Server running port. It used sqlbrowser.exe in the background.
  • SQL Server Full-Text Search: Full Text is one of cool search feature which gives possibilities to search for the test from mentioned columns. It uses fdlauncher.exe in the background.
  • SQL Server Analysis Services (SSAS): SSAS is an OLAP feature which helps in data mining and analytics. It uses msmdsrv.exe.
  • SQL Server Reporting Services (SSRS): SSRS issued to develop reports and report subscriptions. It uses ReportingServicesService.exe executable.
  • SQL Server Integration Services (SSIS): SSIS is ETL (Extract Transform and Load) tool. You can develop in-house ETL using BIDS and execute them using SSIS.

Find this on our YouTube Channel Decode ITES: https://youtu.be/Eq_5yu8_Ms4

Reference: Rohit Garg (http://mssqlfun.com/)

You can find and follow MSSQLFUN:-

Subscribe YouTube Channel Decode ITES

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

Other Linked Profiles:-

http://social.msdn.microsoft.com/Profile/rohitgarg

https://www.linkedin.com/in/rohitgarg1986/

Explain RDBMS and History of SQL Server?

RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format with rows and columns relations.

Types of DBMS:-

  1. Hierarchical DBMS
  2. Network DBMS
  3. Relational DBMS
  4. Object-Oriented DBMS

We have multiple RDBMS available products in the market

  1. Oracle
  2. SQL Server
  3. PostgresSQL
  4. MySQL
  5. Sybase
  6. Etc.

Microsoft SQL Server is RDBMS developed by Microsoft, It’s a 30 years old product and drives through an endless list of changes and features. Microsoft releases SQL Server V1.0 in the 1989 16-bit server for OS/2 and keeps upgrading SQL Server with upcoming technologies and market requirements.

Major Milestones in SQL Server Deployment:-

  1. 1989 – SQL Server 1.0 – Result of Microsoft and Sybase to develop RDBMS product on OS/2
  2. 1993 – SQL Server 4.2 – First release of SQL Server over Windows NT
  3. 1995 – SQL Server 6.0 – End of Microsoft and Sybase Collaboration, both are free to develop their product
  4. 1998 – SQL Server 7.0 – First release after code conversion from C to C++
  5. 2005 – SQL Server 2005 – First release with 100% Microsoft code and Bye Bye to Sybase Code
  6. 2014 – SQL Server Azure – Launch SQL Server Cloud Database
  7. 2017 – SQL Server 2017 – Addition of Linux Platform support
SQLServerYearWiseGrowth

SQLServerYearWiseGrowth

I am fortunate enough to be working from SQL Server 7.0 and witness of all changes and efforts of Microsoft in this area.

Find this on our YouTube Channel Decode ITES: https://youtu.be/qbgT7yBY-Uw

Reference: Rohit Garg (http://mssqlfun.com/)

You can find and follow MSSQLFUN:-

Subscribe YouTube Channel Decode ITES

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

Other Linked Profiles:-

http://social.msdn.microsoft.com/Profile/rohitgarg

http://www.sqlservercentral.com/blogs/mssqlfun/

http://www.toadworld.com/members/rohit-garg/blogs/default.aspx

http://beyondrelational.com/members/RohitGarg/default.asp

Launch of YouTube Video Channel

Dear Friends

We are launching the YouTube Channel Decode ITES. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public Cloud, VM Ware, Backup, Network, Storage, etc..

Decode ITES is a continual part of successful Web blog “https://mssqlfun.com/” from the last 5+ years with thousands of subscribers.

Please subscribe, comment, and share our YouTube Channel.

Reference: Rohit Garg (http://mssqlfun.com/)

You can find and follow MSSQLFUN:-

Subscribe YouTube Channel Decode ITES

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

Other Linked Profiles:-

http://social.msdn.microsoft.com/Profile/rohitgarg

http://www.sqlservercentral.com/blogs/mssqlfun/

http://www.toadworld.com/members/rohit-garg/blogs/default.aspx

http://beyondrelational.com/members/RohitGarg/default.asp

SQL Server Learning Series

Dear Friends

Apologies for less knowledge sharing articles for a long time and Big thanks for stay connected with me.

I will be coming up with the “SQL Server Learning Series” to cover a list of topics from beginner to Expert level based on my core 13+ years of experience.

Stay Connected and keep sharing your feedback and any topics for articles.

Reference: Rohit Garg (http://mssqlfun.com/)

You can find and follow MSSQLFUN:-

Subscribe YouTube Channel Decode ITES

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

Other Linked Profiles:-

http://social.msdn.microsoft.com/Profile/rohitgarg

http://www.sqlservercentral.com/blogs/mssqlfun/

http://www.toadworld.com/members/rohit-garg/blogs/default.aspx

http://beyondrelational.com/members/RohitGarg/default.asp

%d bloggers like this: