Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Microsoft BI (Business Intelligence) Tools

Microsoft BI (Business Intelligence) Tools

Trending Questions and Lessons

Follow 2,699 Followers

Ask a Question

Feed

All

All

Lessons

Discussion

Lesson Posted on 13/05/2017 IT Courses/Computer Software/DBA IT Courses/MS SQL IT Courses/MS SQL/MS SQL Administration +2 IT Courses/MS SQL/MS SQL Certification IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/SQL Server less

History of SQL server

Rahul J Rajesh

I have 7+ years in SQL server DBA and 6+ years in teaching field.

In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop a new version of SQL Server for the NT platform. While it was under development, Microsoft decided that... read more

In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop a new version of SQL Server for the NT platform. While it was under development, Microsoft decided that SQL Server should be tightly coupled with the NT operating system. In 1992, Microsoft assumed core responsibility for the future of SQL Server for NT. In 1993, Windows NT 3.1 and SQL Server 4.2 for NT were released. Microsoft's philosophy of combining a high-performance database with an easy-to-use interface proved to be very successful. Microsoft quickly became the second most popular vendor of high-end relational database software. In 1994, Microsoft and Sybase formally ended their partnership. In 1995, Microsoft released version 6.0 of SQL Server. This release was a major rewrite of SQL Server's core technology. Version 6.0 substantially improved performance, provided built-in replication, and delivered centralized administration. In 1996, Microsoft released version 6.5 of SQL Server. This version brought significant enhancements to the existing technology and provided several new features. In 1997, Microsoft released version 6.5 Enterprise Edition. In 1998, Microsoft released version 7.0 of SQL Server, which was a complete rewrite of the database engine. In 2000, Microsoft released SQL Server 2000. SQL Server version 2000 is Microsoft's most significant release of SQL Server to date. This version further builds upon the SQL Server 7.0 framework. According to the SQL Server development team, the changes to the database engine are designed to provide an architecture that will last for the next 10 years.

 

Prior to version 7.0 the code for MS SQL Server was sold by Sybase SQL Server to Microsoft, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM DB2, and, later, Sybase.

Rather than listing all the new features and enhancements found in 2000, I've decided to list my favorite changes. The remainder of this chapter is dedicated to discussing these new features found in version 2000.

Version

Year

Release name

Code name

Internal version

1.0 (OS/2)

1989

SQL Server 1.0 (16 bit)

Ashton-Tate / Microsoft SQL Server

-

1.1 (OS/2)

1991

SQL Server 1.1 (16 bit)

-

-

4.21 (WinNT)

1993

SQL Server 4.21

SQLNT

-

6

1995

SQL Server 6.0

SQL95

-

6.5

1996

SQL Server 6.5

Hydra

-

7

1998

SQL Server 7.0

Sphinx

515

-

1999

SQL Server 7.0 OLAP Tools

Palato mania

-

8

2000

SQL Server 2000

Shiloh

539

8

2003

SQL Server 2000 64-bit Edition

Liberty

539

9

2005

SQL Server 2005

Yukon

611/612

10

2008

SQL Server 2008

Katmai

661

10.25

2010

Azure SQL DB

Cloud Database or CloudDB

-

10.5

2010

SQL Server 2008 R2

Kilimanjaro (aka KJ)

665

11

2012

SQL Server 2012

Denali

706

12

2014

SQL Server 2014

SQL14

782

13

2016

SQL Server 2016

 

852

14.0

2017

SQL Server 2017

Helsinki

 

 

 

read less
Comments
Dislike Bookmark

Lesson Posted on 04/05/2017 IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft SharePoint

SharePoint Training

Bound Tech Solutions

Being the front running leader in IT Software Training sector Bound Tech Solutions holds the prestigious...

ABOUT SHAREPOINT: SharePoint is a web-based function that integrates with Microsoft Office. SharePoint is primarily sold as a document administration and storage organization but the produce is greatly configurable and custom varies significantly between organizations. SharePoint is a single point... read more

ABOUT SHAREPOINT:

SharePoint is a web-based function that integrates with Microsoft Office. SharePoint is primarily sold as a document administration and storage organization but the produce is greatly configurable and custom varies significantly between organizations.

SharePoint is a single point for generous out data between various users. It is a single gap for content management of data for a variety of companies. Depending on the business requirements Companies can design, create sites and give permissions to people. SharePoint can be used to arrange and manage data and documents in a extensive variety of ways. It can be used to make dashboards that report results commencing multiple sources.

SharePoint is exclusive amongst information management systems in that it is purchased with any specific purpose in mind. It is often bought bundled in with other products when IT departments negotiate an enterprise accord with Microsoft.

ABOUT SHAREPOINT TRAINING:

Build active career in SharePoint atmosphere with SharePoint Online training courses from our Origination. Our SharePoint curriculum can help you to improvement the knowledge to enhance your SharePoint implementation. Learn how to use SharePoint for specialized project management, build apps, create dashboards, and develop InfoPath forms. Enhance your efficiency with instructor-led Online training brought privately to you through live online. Our expert instructors bring quality training that meets your budget, program schedules, and business objectives. We also offer Comprehensive courseware covering all subjects in the course. Our Consultant are working Professional in Mnc’s they guide our students in the Project based Scenarios. We are the Best SharePoint Online training providers from India.

read less
Comments
Dislike Bookmark

Lesson Posted on 04/05/2017 IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft SharePoint

SharePoint Modal Dialogue : Freeze the header

Mallikarjuna

I have around 11 years of experience in IT industry, worked with multiple MNCs and multiple technical...

Recently working on a project got a requirement for freezing a header for modal dialog. To make it simple this is how you can achieve. ##########HTML##################### outer text.....<div id="mholder"> <div id="mheader">Header text</div> <div id="mbody">Lorem ipsum dolor... read more

Recently working on  a project got a requirement for freezing a header for modal dialog. To make it simple this is how you can achieve.

##########HTML#####################

outer text.....
<div id="mholder">
<div id="mheader">Header text</div>
<div id="mbody">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborumLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum</div>
<div id="mfooter">Footer text</div>
</div>

##########End HTML#####################
##########CSS #########################

#mholder{
padding: 10px 10px 10px 10px;
width: 65%;
height: 60%;
background-color: grey;
position: absolute;
top:0;
bottom:0;
left:0;
right:0;
margin: auto;
}

#mheader{
position: absolute;
height: 10%;
left:0;
top:0;
width: 100%;
}

#mbody{
width:96%;
height: 80%;
position: absolute;
top: 10%;
overflow: auto;
}

#mfooter{
height:10%;
width:100%;
position: absolute;
left: 0;
bottom: 0;
}

##########end CSS #########################

read less
Comments
Dislike Bookmark

Looking for Microsoft BI (Business Intelligence) Tools Training

Find best Microsoft BI (Business Intelligence) Tools Training in your locality on UrbanPro.

FIND NOW

Answered on 12/03/2017 IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft SharePoint IT Courses/ETL

Jithendar

SharePoint Trainer

If you are comfortable with. Net then choose SharePoint is the better option.
Answers 15 Comments
Dislike Bookmark

Lesson Posted on 09/02/2017 IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft SharePoint

Why learn SharePoint?

Lakky

Working as solution architect and having total 13 years of IT experience. 8 years of experience in...

SharePoint is easy to start learn and implement if any one know HTML concepts. SharePoint's core functions are 1) store documents in a more effective format and 2) bring an organisation together. Most of the organisations uses SharePoint for internal operations and require changes as per their requirements.... read more

SharePoint is easy to start learn and implement if any one know HTML concepts.

SharePoint's core functions are 1) store documents in a more effective format and 2) bring an organisation together.

Most of the organisations uses SharePoint for internal operations and require changes as per their requirements. So the demand is keep growing. 

At high level SharePoint is a platform where one can create sites which will have predefined designed pages.

Most of the time developers will be working with customizing the existing SharePoint pages, developing workflows and search configuration. Either Client side scripting or server side coding will be required to interact with SharePoint database.

These are few of the SharePoint features: Workflows, Alerts, Storage, Collaborate by sharing the information with other users or colleagues, Content management and Search

read less
Comments
Dislike Bookmark

Answered on 21/02/2017 IT Courses/Tableau IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools SAP Business Objects Training

Techandmate

TechandMate - The Techmnology Insight

Tableau is the best data visualization tool among all BI tools, you can go for it.
Answers 28 Comments
Dislike Bookmark

Looking for Microsoft BI (Business Intelligence) Tools Training

Find best Microsoft BI (Business Intelligence) Tools Training in your locality on UrbanPro.

FIND NOW

Answered on 12/03/2017 IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft SharePoint

Jithendar

SharePoint Trainer

What you are looking for SharePoint development or admin?
Answers 6 Comments
Dislike Bookmark

Lesson Posted on 31/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/Microsoft Training IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/MS Office Software Training/MS Access less

What is Big Data and Why Do Organizations Need It?

iTech Analytic Solutions

"iTech Analytic Solutions" (iTAS) is ranked as No. 1 Analytic Training Center in Bangalore by ThinkVidya.com "iTech...

Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s important. It’s what organizations do with the data that matters. Big data can be analyzed... read more

Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s important. It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.

While the term “big data” is relatively new, the act of gathering and storing large amounts of information for eventual analysis is ages old. The concept gained momentum in the early 2000s when industry analysts articulated the now-mainstream definition of big data as the three Vs:

Volume – Organizations collect data from a variety of sources, including business transactions, social media and information from sensor or machine-to-machine data. In the past, storing it would’ve been a problem – but new technologies (such as Hadoop) have eased the burden.

Velocity – Data streams in at an unprecedented speed and must be dealt with in a timely manner. RFID tags, sensors and smart metering are driving the need to deal with torrents of data in near-real time.

Variety – Data comes in all types of formats – from structured, numeric data in traditional databases to unstructured text documents, email, video, audio, stock ticker data and financial transactions.

read less
Comments
Dislike Bookmark

Lesson Posted on 31/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

What is PowerPoint?

iTech Analytic Solutions

"iTech Analytic Solutions" (iTAS) is ranked as No. 1 Analytic Training Center in Bangalore by ThinkVidya.com "iTech...

PowerPoint is a complete presentation graphics package. It gives you everything you need to produce a professional-looking presentation. PowerPoint offers word processing, outlining, drawing, graphing, and presentation management tools- all designed to be easy to use and learn. The following gives you... read more

PowerPoint is a complete presentation graphics package. It gives you everything you need to produce a professional-looking presentation. PowerPoint offers word processing, outlining, drawing, graphing, and presentation management tools- all designed to be easy to use and learn.

The following gives you a quick overview of what you can do in PowerPoint:

  • When you create a presentation using PowerPoint, the presentation is made up of a series of slides. The slides that you create using PowerPoint can also be presented as overhead transparencies or 35mm slides.

  • In addition to slides, you can print audience handouts, outlines, and speaker's notes.

  • You can format all the slides in a presentation using the powerful Slide Master which will be covered in the tutorial.

  • You can keep your entire presentation in a single file- all your slides, speaker's notes, and audience handouts.

  • You can import what you have created in other Microsoft products, such as Word and Excel into any of your slides.
read less
Comments
Dislike Bookmark

Looking for Microsoft BI (Business Intelligence) Tools Training

Find best Microsoft BI (Business Intelligence) Tools Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 31/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

Microsoft Excel

iTech Analytic Solutions

"iTech Analytic Solutions" (iTAS) is ranked as No. 1 Analytic Training Center in Bangalore by ThinkVidya.com "iTech...

Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered... read more

Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered in the suite of products. The first software program similar to Excel was released in 1982 and was called Multiplan.

read less
Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Microsoft BI (Business Intelligence) Tools Training in India. Post Your Requirement today and get connected.

Overview

Questions 16

Lessons 42

Total Shares  

Top Contributors

Connect with Expert Tutors & Institutes for Microsoft BI (Business Intelligence) Tools

x

Ask a Question

Please enter your Question

Please select a Tag