Microsoft SQL Server Features

SQL Server is the enterprise system database, and its toolset is provided as standard. Many departments in the company use it as a database when creating a small system. Its graphical user interface is easy to use even for beginners, and its data can be queried seamlessly from other Microsoft products such as Access.

The application has very few bugs and offers stable operation. The core elements of the product's usability remain the same despite repeated changes. Both the cost and feature set of Oracle is superior to NetSuite.

Is quite secure, it guarantees the security of the databases, it is very easy to configure unlike other database management programs, the installation and configuration is easier. And it also has data recovery support.

Cost, there is a free version that can be used, however for more advanced data-driven applications and functions, you will need to make a considerable investment in higher versions of the software. Also, additional investments in Microsoft software may be necessary if your company uses some or no Microsoft infrastructure.

Can be integrated with a lot of MS and 3rd party tools.The query window is well formed.The speed of the DB is excellent, but bases heavily on your custom codes.Reports, ad-hoc table, integrations with other reporting tools, intranet websites are great.

Less training options available comparing it to other MS tools.Intergration, access management can be difficult.Sometimes not easy to track changes in your codes, mostly in big databases.Installation could be easier.It not recommended, but for IT personnel with solid knowledge.

Microsoft has always tried over the years to improve its flagship product, achieving good stability and robustness. For administrators, the management interface is particularly useful and easy to use. SQL Server has allowed us to manage several databases at the same time from our applications without problems giving the possibility to colleagues to have, for example, always updated sales data.

Unfortunately I must also report the defects and in this case in my opinion the interface for administrators has become too slow in terms of starting in the latest versions. Sometimes product updates do not install correctly, even if this rarely happens it can create a general disservice almost always in time of need.

It is undoubtedly one of the best database in the world and Microsoft has just given quite a lot of features to help query out data from this tool

The cost is something which is on the expensive. Alternative options is MySQL.

Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers. The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient. With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.

Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality. Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.

We love SQL Server's versatility. Every single application we purchase for insurance has support for SQL Server. We have not come across any situation where SQL Server didn't meet our needs.

License models are a bit confusing. Some years Microsoft make it easy to understand. Other years Microsoft makes it even more confusing. Can we run SQL Server in our data centers? Can we run it on the cloud? Do we need to change licensing to run in the cloud? Those questions sound easy to answer but the answers we get from Microsoft or resellers confuse us more. It just seems like the confusion is intentional.

One of my favorite things about Microsoft SQL Server is the scalability. Whether you are using the free version for a small program running on a local machine or running an entire factory it is the same basic concept of programming and administration. I really appreciated being able to work to have a database software that could grow and expand when I need it too. Additionally the reporting and automation packages that come with it are super powerful. I would absolutely recommend using Microsoft SQL Server as anyone’s data as software

The biggest con in my opinion is that some of the more advanced features for big data analysis and high availability are in the top tier pricing which can be hard for smaller companies to afford. Other than that I have never not been able to solve a problem with Microsoft SQL.

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

Is powerfull Easy Complete Customer Support Features interoperatibity

Have some errors You need to reset de SQL 1 time at week Consumes a lot of ram it needs a Windows Server

I love the ability to create SQL databases separate from Visual Studio. Although you can create databases in VS, I like how SQL Server Management Studio is designed specifically for database creation. Plus, it has advanced features for database admins which Visual Studio does not. After creating a database, the admin can migrate the SQL Server database in Visual Studio.

It is difficult to learn if someone at a beginning level is using it. They will need to utilize the many tutorials provided within EDX.org, youtube or Udemy (to name a few) to learn it. It makes sense if you know how to create SQL databases and the SQL language prior to using it. If not, I suggest to learn SQL first prior to jumping into SQL Server to do database management.

SQL server is packed with features. It was a very fun job to implement it and using it is even better. Runs well, built-in tools are useful and plenty.

It takes up quite a bit of resources. Sometimes, tech support isn't very helpful. Otherwise, it's good.

In my current role as an Application Manager, it is vital to have a means of benchmarking and assessing application performance. The tools within SQL Server, particularly Activity Monitor, make it very easy to determine when performance bottlenecks arise.

I believe the default alerting functionality could be improved. For example, I believe it would make more sense to alert the user to any failed SQL Agent jobs when launching SSMS. Currently, either alerts need to be set up individually or the user would need to view the job history.

Installation and upgrading of the software is excellent. The additions of Query Store and other Analytics have drastically changed our ability to monitor the performance of all metrics of our Databases.

Turn around time from issuing the Purchase Order until the license is released into our Microsoft account was rather slow, when we needed the software, we had to find an alternative solution until our license was released to us.

The express edition, which is free, is more than powerful enough to serve as a back-end for most small/medium sized web sites which is great for small businesses to start and grow.

Installation of all the features can be a pain. Making sure you have the engine, agent, management studio can be confusing and often come in separate download packages.

SQL Server is just so incredibly powerful, most users probably do not know how much it can do, or how much it can handle. In our type of organization, we deal with people and animals. We rely on donors and members for funding, we track everything about our animals from health issues, to medications, to physical exercise. Every one of our systems relies on, as the backbone, SQL Server. This software...

Read more

You need a lot of training to make the most of it. Or it could cost you a lot if you have to pay a developer to help you get the most out of your systems. Luckily a couple of us are really into databases, and we both have a lot of experience with SQL, we can do most things in-house. But still the amount of training we go through to keep current, or to keep learning is probably the biggest "problem" with this software. Most software packages, you can buy, setup, receive a few hours or a few days of training, and you'll be good to go. With SQL, if you intend to use it, to get the most of out it, you will need more extensive training, or to hire people to put in the work. It's not cheap. But it can help you accomplish so much if you put in the time.

As a Systems Administrator, MS SQL Server is one of the easiest DBMS you can use from a management perspective. SQL Server Management Studio is a very robust client, and it allows you to configure everything from either the GUI or SQL scripts. No digging into config files, calling apps from command line, etc. User management in SQL server is easy and straight-forward while being EXTREMELY granular....

Read more

Like a lot of other Microsoft software, the installer is pretty bloated with prerequisites, components, etc. But that's a fairly small nitpick. I will also say that RAM management in SQL Server isn't perfect. SQL will, as long as it is regularly used, consume all of the RAM you have allocated it. By default, that setting is 2 petabytes of RAM, so it will slow your system to an absolute crawl, consuming everything it can to the detriment of the OS itself. This means you need to manually allocated a reasonable amount of RAM to SQL knowing full-well that it will likely consume this RAM at all times. That's fine for dedicated database servers, but it's not ideal for people running SQL on laptops. Aside from that, I have very few complaints about SQL Server.

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...

Read more

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...

Read more

Microsoft SQL Server is a reliable database management tool that provides a secure and structured environment for data storage and retrieval. It offers robust features for data manipulation, including advanced query optimization, transaction processing and performance monitoring. The user interface is easy to use and the coding language is intuitive, making it suitable for both experienced and novice developers.

Microsoft SQL Server can be tricky to configure and maintain, as it requires an in-depth knowledge of database design and administration. Additionally, certain features are only available with the enterprise edition, which can be costly for smaller businesses.

Personally, I like that the application is easy to use, obviously if you already have time using it and you are familiar with the concepts and terms used, the tools to create backups or schedule tasks to run on specific dates and times is quite good, the price is affordable not too expensive unlike oracle.

to install it is a bit time consuming, since you have to configure it on the fly, it does not bring any preconfigured default settings, this takes a little time to the user, to migrate to other operating systems other than windows, you have to make other extra configurations.

I've been using Microsoft SQL Server since version 2000 and I must say that every year the team behind it adds tons of improvements and great new features that keep this software a fantastic competitor in the market. The database engine is very clever in optimising your queries, giving insights on improvements and dealing with your complex queries. Microsoft's TSQL is very easy to understand and very easy to grasp even though in recent years the team have introduced more complex query templates but still it stands out impressively amongst the others. I also love that they have released the full version as a Developer version where you can try all the software's great features without any cost at all!

The huge cost difference between the Standard and the Enterprise version is a put off as certain features like table partitioning should be part of the Standard version.

At our firm, we have a completely Microsoft tech stack; from servers, databases, middleware, peripheral applications, etc. When using all Microsoft products, it is extremely easy to connect and integrate between applications, servers, and databases. I am less sure about integrating with other providers (such as oracle), but I know its possible with a little more effort. Maintenance, backups, restores,...

Read more

When you run into an issue, it can be hard to resolve. An example would be when Microsoft data connectors aren't working. Understanding and getting the right supporting software installed is important; like OLE DB and ODBC connectors. Another difficulty can be performance. As data sets get larger, this is more important. While there are enough tools to investigate and troubleshoot, sometimes it's just a big effort to try to query tune, index, or adjust server settings to get the results in performance that you want. Queries seem to only get more complex, and data sets larger. I am pretty sure other databases will perform better with Big Data.

First and foremost, it has all the features and functionality from the basics to advanced users for relational database management. Can be integrated well with other Microsft software especially Visual Studio code for a smooth development experience. Along with data storage management, professional performance analysis can be performed through GUI server management studio tools like Database Tuning Advisor. Data Analysts will find data extraction and filtration as well as visual & interactive report generation quite beneficial in their routine tasks. Backup and restore from one SQL server to another is fairly simple. Pricing is very reasonable according to the DBMS system and tools that are provided.

One of the main issues is that licensing price packages are difficult to choose due to confing choices for common users. One other limitation is that a backup made in a newer version of MS SQL server is not compatible with an older version of SQL Server. For large volumes of data records and for complex data it becomes slower to process queries. Taking backup of a very large number of records also takes time. Sometimes difficult to debug syntax errors.

Microsoft SQL is quite simple to install and configurations are also easy. As it is a relational database management system, it is a perfect tool for data analysts. As it enable users to filter and extract required data in a few seconds. The product comes with a lot of features like Query analyzer, Integration services, Job scheduler and Reporting services as well. Restoration and backup of multiple databases is a great advantage and I found this feature very useful because it helps a lot in restoring databases in case of any disaster. Also, one can easily schedule tasks in job tools section which is also a very helpful feature of this tool.

Well, it occupies more data storage in order to install database engine as compared to other SQL databases. Also, support is pretty much expensive and requires a lot of maintenance. It consumes too much resources to load and start.