Microsoft SQL Server Business Intelligence (BI) Edition is a database management and BI software solution designed for companies of all sizes. The system offers relational database management, which allows users to access enterprise data using structured query language. The solution allows users to perform complex analysis on the database. The product also features a BI Semantic model that allows users to extract and analyze data from heterogeneous sources.
Microsoft SQL Server features “in-memory analytics,” which allows users to perform queries and analytics while the data is in the RAM, thereby improving the speed of access. The software has scalable and corporate reporting features that help management to make decisions that are more informed. Organizations can improve the data quality by using the organizational knowledge and third-party reference data providers to profile, clean, and match the data.
The IT department can manage data through a BI Semantic Model, which provides a consistent view across multiple data sources.
Quentin G. Branche: Computer-Software Mitarbeiteranzahl: 2-10 Mitarbeiter
Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance and usability was ironed out for us already. We could focus on building our application rather than learning something new about cloud security or how to use a new type of database or database language variation. We have been pleased with the ability to research performance and include other features such as SSIS to accomplish our business requirements easily. Knowing that manual tasks are being completed automatically is a sigh of relief. We also will know immediately if there are any issues. We have had a great experience with SQL Server.
It is an industry standard that continues to improve to make the lives of developers easier. We are able to produce software solutions more efficiently because Microsoft continues to improve SQL Server. We rely heavily on this as critical to our business. Developers tell me how flexible SQL Server is also. SQL is more compatible with software packages than other competing databases.
Parts can be not intuitive unless you've been using it for awhile. It is a technical piece of software that requires time and training. If you need the Enterprise edition for specific features, it is expensive.
Verifizierter Rezensent Branche: Finanzdienstleistungen Mitarbeiteranzahl: 1.001-5.000 Mitarbeiter
I have using this more than 5 years , by comparing with other server platforms sql server te best of easy use for developers as well as Administrators
It was easy of access to manage SQL server agent can manage most required part with automate rather than doing manual
And also design with more user friendly compare with others
While queries of data some times have to convert it to tostring, but I hope its possible to identify and convert automatically, then developers will reduse their codings
Surender B. Branche: Informationstechnologie & -dienste Mitarbeiteranzahl: 13-50 Mitarbeiter
My overall experience is 100% satisfactory because of its robust feature.
I recommend this to all either its a large or small scale compan y because SQL server can handle large quantities of data and process it smoothly. Just loving it.
Microsoft SQL server is one of the best database management system that provide top rated performance optimisation with SQL queries, below is the list of top highlights:
1. Richness of user interface that provides ease of use with cool features like dock able windows.
2. Intelligence window is prominent feature that saves a lot of development time up to large extent.
3. Code debugging and performance tuning with query flow maps is the best features that assures about code optimisation.
4. Microsoft SQL Server Agent is provided with this software and that runs the automatic jobs in very secure way and later we can track the statements executed.
5. We can filter out the records in SQL Server Agent interface based on our interest.
6. Code snippet manager makes it easy to write high standard code that is perfact for code convention.
7. Most prominent feature is that it can handle large quantities of data, runs automatic jobs with concurrent transactions.
8. At last it's a Microsoft product that provides a belief to users.
I have been using SQL server from version 2012 to 2014 and never troubled with SQL server's performance in any way.
However I feel that error details must long descriptive when statement have some syntax error. Sometime its pathetic when we wants to know the exact error line but is hints the whole block of code instead of exact line number.
Otherwise Its a great product and happy with it.
Verifizierter Rezensent Branche: Informationstechnologie & -dienste Mitarbeiteranzahl: 51-200 Mitarbeiter
Have used SQL Server as a a Relational Database (RDBMS) for the past 15 years, primarily to support SAP based enterprise workloads. Microsoft's development of SQL Server has been fuelled by its largest customer - SAP, in order to provide better functionality to rival its competition (Oracle, DB2, Informix (who remembers this one?). I started with MSSQL 2000 and boy has it come a long way. MSSQL versions are denoted via the year and is still a practice till today, similar to how Microsoft denotes its Windows versions. To date, the latest version of MSSQL 2017 is also supported on SAP, and I am sure once MSSQL 2019 is released later this year it would also be certified by SAP.
The review is based on my experience of using SQL Server as a database with SAP.
What I like about MSSQL :
- ACID compliant like any enterprise based RDBMS (Oracle, IBM DB2, SAP HANA)
- Runs well and scales well with commodity x86 hardware
- Various editions to suit customer needs and requirements. For example Express Edition for small workloads and is free, or all the way to Enterprise Edition for state-of-the-art functionality (High-Availability, Disaster Recovery etc. to prevent Single-Points-of-Failure). Its current functionality definitely rivals the existing enterprise RDBMS's
- Straightforward learning curve as it is Windows based. Unlike other RDBMS's (e.g. Oracle or DB2), administering a MSSQL DB is very easy GUI (SQL Server Management Studio) is very easy to use especially if coming from Oracle/DB2, or if you're learning from scratch
- Supports Linux (finally!) - MSSQL is no longer limited to the Windows platform, and Microsoft has released version on Linux to compete with the likes of Oracle, DB2, etc.
Over my years of using MSSQL have encountered numerous bugs (performance issues, corrupted data, etc.) but these are normal with other RDBMS's (Oracle, DB2, SAP HANA, etc.) given the enterprise nature of the workloads. Can't really think of any other disadvantages.
Griffin B. Branche: Gastgewerbe Mitarbeiteranzahl: 1.001-5.000 Mitarbeiter
Overall, my experience with SQL Server is amazing! I am able to store all of our Las Vegas luxury casino data (gaming, hotel, food & beverage, entertainment, etc.) and query that for information that we then turn into automated or ad-hoc reports. These then go to the operators of the business as well as the executives who analyze the reports and make better decisions daily, weekly, and monthly. The goal is simple: just become better over time...better than you were last year, last month, last week. And SQL Server is the vehicle to empower your organization to find those valuable insights hiding in plain sight to do just that!
I absolutely LOVE SQL Server. It is my favorite software to use because the possibilities for query-writing are endless. I would say this is the most reliable and flexible of all the database software I have ever used. SQL Server allows you to write in T-SQL (T = transact, SQL = structured query language), which means that you can create variables, use temp tables, and write code in a procedural format that runs akin to a module in other programming languages. We use SQL Server 2008 at work, though I am really loving the new features in the latest version (as of today) SQL Server 2016.
Overall, SQL Server is a platform for creating table schema, storing information, and then writing scripts (queries) to manipulate that data--to find insights that are useful to making better business decisions. The interface is easy to understand, the error-checking is strong (and actually tells you what is wrong). It doesn't hold your hand like other simplified coding languages, but it becomes very reliable and easy to use once you obtain a solid foundation in relational database theory and SQL language.
Hmm...if I had to speak ill of SQL Server...I would probably say that it is a bit tricky to get up to speed quickly with. There's a lot to it, so to speak, so it's taken me the better part of five years working in the data analytics industry to finally say that I feel I am completely proficient in utilizing the software to its full potential. Topics such as query optimization remain my areas of biggest weakness. I can write a query to pull any kind of desired information; however, the art lies in being able to pull it quickly and with reasonable efficiency. If your query takes more than 15 minutes (or even hours!) to run, it's probably not written correctly and likely poses a major threat to the server you are connecting to (and tying up!) in the process. I would like more information in the software (GUIs, warnings, etc.) regarding poorly-written queries from an execution standpoint.