SQL Server Initial Setup
RK
Ranjeet Kumar
Senior General Manager at Worly Plumbing Supply, Inc.
The solution’s initial setup is easy.
View full review »HS
HarkamalSingh
Works at a manufacturing company with 10,001+ employees
It is straightforward. There is no complexity. It is all automated, and we do un-attended install. We are not sitting and doing it. We just include it with the server build itself. When the server is built, we provide them the un-attended scripts to run, and everything is configured. They can use the media provided by Microsoft. Everything is done in one step. We just need to do auditing. We need to check at the right place, and we just keep checking it.
PJ
PeterJones
Professional Services Manager at Business Intelligence DA
If you know what you're doing then setting up SQL Server as a data warehouse is trivial. If you're setting it up properly, and know how to do so, it takes about a week to complete the deployment. The bit that takes the time is the creation of the partitions.
View full review »Buyer's Guide
SQL Server
April 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.
SQL Server is easy to deploy. A five-member technical team maintains it.
View full review »PE
Phil Ernst
Chief Technology Officer at Wolff Logics
The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on. It could be complex, but any database platform will have some complexity.
View full review »JA
Jem Ahmed
Software Engineer at Intelligent Systems
The product's initial setup phase is easy.
The solution can be deployed in ten to fifteen minutes.
MJ
seniorda483732
Senior Database Administrator at a comms service provider with 10,001+ employees
The initial setup is very straightforward and the deployment is quick. You can have it up and running in three minutes. It's not a problem to get it set up.
You only need one person to handle any maintenance tasks on it.
View full review »SQL Server is very user-friendly and very simple. It is very comfortable for us. We have been using it for a long time, so it is not a problem at all.
The deployment of our production server took less than 15 days.
View full review »HB
reviewer1264416
Domain architect at a financial services firm with 10,001+ employees
Initially, the installation took a while. We have started deploying configurations that are now standardized. We have automated it, but it can still be problematic. For the most part, the installation is now quite easy. Additionally, The way they have many configurable parameters that influence performance is in a way problematic.
The initial setup is straightforward. It is not lengthy. It's a simple flow chart. There is no complexity in the application. It will take half an hour to deploy if you have the right hardware resources.
The first step is gathering the developers’ prerequisites, which depend on the application. We consider the projected data volume for the last ten years, which informs our capacity planning. Based on that, we recommend virtualization.
The deployment process was fairly simple, especially with SQL Server and other modern products. The interfaces are easy to understand, and the configuration is straightforward. Typically, you need to configure a node endpoint for the JDBC driver if you're connecting from a client.
View full review »The product's initial setup phase was simple.
The initial setup is easy, and integrating the system is okay. The only issue is regarding the customization of the business process of the organization, it might take some time. Ultimately, it depends on the client's specific needs.
NC
Nick S.
System Design Manager at a manufacturing company with 10,001+ employees
SQL Server is quick to install < an hour. Additional features increase the installation time.
MH
Mohammed Habeeb
System Administrator at ARTIc
The installation is very easy. We did not have any challenges.
View full review »The initial setup is easy and takes around 15-20 minutes.
We use data instances to deploy SQL Server in some cases. We had the static deployment.
The product's initial setup phase is very straightforward and nothing complex. Anybody who has a basic knowledge of SQL and Azure should be able to deploy the product.
SQL Server has a clear set of procedures to help users deploy the product. Initially, to identify your sizing or capacity requirements, after which you pick up the right setup from the cloud and then configure it with the right level of storage and the right level of CPU and memory before choosing the version of SQL you want to deploy, post which you will be ready to use the tool.
XZ
Xiaoqing Zou
Integration developer at Blackwoods
The tool's deployment is easy.
View full review »SE
Simon Evans
IT Analysis at Kirkby (Tyres) Ltd
The initial setup is cumbersome as it's very menu-driven. The deployment takes half a day's time. We run it on a virtual machine or virtual service. We build a virtual server. We downloaded the ISO from Microsoft's licensing website.
I rate the setup an eight out of ten.
View full review »MM
Mpho Morake
Group CEO at Mmusi Group
The initial setup is easy. It takes 30 minutes at the most. What limits you is just your infrastructure in terms of:
- Do you have enough room on those servers to process that stuff?
- Do you have enough RAM resources?
- Do you have enough storage?
AK
Anandan Kanagarajan
Sr. Supervisor - Enterprises Application DBA at a manufacturing company with 10,001+ employees
The GUI-based step-by-step initial setup is easier for the initial setup and even the Jr.DBAs can handle it with minimal training. The automated installation is possible with PowerShell Scripts and the Infrastructure Provisioning and Configurations tools like Ansible. We managed to automate the SQL installation using Ansible Playbooks and Gitlab to deploy Continous Integration and Continous Deployment.
View full review »YM
YahyaMahdy
Senior Data Engeer at Qbros
The initial setup is straightforward. The connection to the database is not straightforward. There are many ways to connect to the database. It may be tricky to choose which way to connect.
I rate it seven or eight out of ten, where one is difficult and ten is easy.
View full review »RN
reviewer1695144
President at a consultancy with 1-10 employees
In terms of the initial setup, you probably need to know what you're doing. I haven't seen any real laypeople get into the tables. I know it's possible to learn. Things like Power BI have made it easier, but if you don't know what the tables are you have to be a very methodical person to be able to do that stuff. We use a company called ArcherPoint for dynamics. They're one of the largest dynamics dealers in the country, and they have their stuff together. This woman I use there knows her stuff. She knows SQL very well, and my IT company also has a senior guy who they often talk to, and it always seems pretty straightforward, whatever they do. It's never a big install.
Usually a few hours and it's over.
View full review »The initial setup is straightforward. You need to install technical agents and create databases.
There are a lot of different deployment options. The default options will work pretty well. We have to change a few things for our setup. Deployment is not at all long. It takes a couple of minutes. It took a long time for the first time because I had to go back and redo it and change the configuration, but it runs pretty smoothly now.
The deployment process follows: mount the ISO and run a script. That script retrieves some entries from a table and creates several instances based on that table using active directory SQL Server accounts, which is an out-of-the-box option. There are a lot of features that you can add to the setup to make it quieter. We've automated it so we can spin up an instance as needed for development processes.
BL
reviewer1389651
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
The initial setup isn't complex. It's certainly straightforward. The downloads and the installs don't all fall apart. It succeeds. The constraint is in the context of the students enabling a SQL Server to run on a laptop. That's a constraint rather than on an actual problem with the hardware server itself.
Deployment takes, on average, about four hours. After that, you have a somewhat bare-bones server with the capability of running SQL datum to create the data itself or to import it from another database.
Since the solution is only really used for training purposes for classes and isn't meant to exist permanently, there's no one who needs to really maintain it.
View full review »DV
Dany Van Den Steen
Database Administrator at Court of Audit Belgium
The initial setup of SQL Server is straightforward and user-friendly and I would rate it at around an eight out of ten for ease of use. While the basic setup is simple, additional considerations for security may require some tweaking.
Deploying a SQL Server for testing purposes typically takes around ten minutes, while for production, it can take an entire day due to the additional tweaking required for optimal performance and security.
JM
JasminaMarkovic
BI Developer at a tech services company with 51-200 employees
The installation process is not complex, but it requires attention to detail in terms of selecting the necessary services and configuring the Cisco server.
This ensures a proper setup and a tangible model for effective management. While it may not be complicated, it is important to choose the appropriate features during installation.
Working with ID was not my primary focus; however, I have had the opportunity to work with it for several companies.
View full review »FR
Francisco Racionero
CEO Owner at ALESON ITC
The initial setup is relatively easy but it depends on the situation, and sometimes requires some planning. You can configure SQL after you've deployed on cloud. Implementation can take some time because it's not just the installation of the SQL server which can be done in less than an hour. The implementation of the database systems can take several days or weeks depending on the organization. Our consultants have more than 12 years of experience working as DBAs, so we carry out the installation.
View full review »The initial setup is straightforward. I wouldn't describe it as difficult or complex. It's actually very simple. A company shouldn't have too much trouble with the implementation.
The deployment was fast and barely took two days.
We have five people on staff who can handle the deployment and maintenance for us. They are administrators and engineers.
View full review »MP
Marcelo Pissinati
IT Cybersecurity and Compliance Coordinator at Plaenge
The initial setup is not a problem.
View full review »MB
MichaelBarnett
Sr. Training Manager with 201-500 employees
I can bring up a SQL Server in an hour or so and set it up.
In terms of maintenance, the number of people required depends on the need.
We have a team of DBAs, developers, and UA analysts. We probably have 40 people in our IT area who are maintaining our solution. I'm just the developer. I'm the guy who makes the magic happen, but without other people collecting the information that I need to make the magic happen, I'm stuck. Without the guy who is an expert in permissions, partitioning, and performance tuning, I'm stuck. So, it's definitely a team effort. You can do it all, but you don't want to do it all because then you're running your head off, and you don't really get good at anything. It would be a jack of all trades, master of none type of scenario.
The initial setup is very easy. It's even easier than before, in fact. A company shouldn't have any problems with the implementation.
View full review »SS
Shivanshu Srivastav
IT Manager : HOD at Condot Systems
Initial setup was a bit complex, but it's doable because it has improved a lot. Previously, it was very hard to install MS SQL. If I had the 2016 version already installed, it allowed me to install 2018 as well. The report features were distributed between two services, and that's where it causes problems.
View full review »MA
Maurice Aelion
Senior DBA & IT Consultant at MA Consulting
RN
reviewer1572765
Manager at a pharma/biotech company with 10,001+ employees
I am not a patient person with installations, but there are no issues with the installation of this solution.
We have a database team to maintain this solution along with an engineering team, an operational team and we have eternal resources.
View full review »PC
Prajith Chowthee
Independent Consultant at Unaikui
The initial setup is straightforward. Depending on the complexity, setting up the infrastructure can take a while. You can work on MVP. To deploy on AWS, select SQL Server along with several calls and CPU.
View full review »The setup is straightforward. The deployment does not take very long.
View full review »AR
Abdelkader Raway
Works at a financial services firm with 51-200 employees
The initial setup is straightforward. I did not encounter any issues.
We have 12 technical teams with four admins to maintain the solutions in our companies.
View full review »SS
Satyam Saxena
Senior Software Developer at a manufacturing company with 5,001-10,000 employees
Setting up an individual SQL Server is pretty straightforward, but when you are implementing multiple tools, it's more complicated. In terms of maintenance, for the DBA part, there are two based in my company because I am on a master device, so they don't allow me to maintain the server part. So one person is from South Korea, and the other is from China. They are handling my SQL Server. So maybe there are multiple teams, but I am contacting these two guys, the DBA. And I'm MDS, so I'm a single person. There are two people on my team, and I have one junior staff member. So I have a three-person team, and there are two DBA sites because I'm discussing my master team. I am deployed on the business side, and there are more than 80 people who are end-users of SQL.
View full review »AM
reviewer1635153
VP Global Information Technology at a insurance company with 10,001+ employees
TP
Tim Platson
Solutions Architect at One Click
The initial setup was straightforward.
View full review »MP
reviewer1570953
Database Administrator at a computer software company with 10,001+ employees
If you know how to set it up, it is easy, but you have to learn that over time. For a new user, it is detailed. You need to have the right things in place at the right time before you actually install the software.
To create an instance, it takes about an hour overall. This includes deploying the basic system, applying the latest service pack, and then applying the latest cumulative update.
View full review »The initial setup is very easy. It is easy to understand.
View full review »The initial setup is easy. The deployment services cost around $2000 to $3000.
View full review »TL
Tim Lenz
SQL Database Administrator at Aurora Mental Health Center
The initial setup is pretty straightforward.
It can be complex depending on what you're trying to do, however, it has a good user base and user support groups, so there's lots of information. If you're trying to do something, likely somebody else has already done it, and you can usually find that information through a user group or a forum, or even on YouTube or Google.
TN
ThembaNhlapo
System engineer at a financial services firm with 51-200 employees
The installation is straightforward and not complex. However, it depends on some of the features that you may want to use. I think it is simply because you only need to tick whatever functionalities you want to use and the ones that you don't need to use, you don't select them.
View full review »BC
BruceCollins
Senior Developer at a government with 51-200 employees
The setup is pretty straightforward. The only thing that sometimes gets weird is if you have somebody that's needing an ODBC driver from another type of application back to the SQL server. It's usually that other application trying to figure out what it needs to connect to SQL. It's not really SQL's fault.
RU
reviewer1524594
Senior Solutions Architect at a manufacturing company with 51-200 employees
The initial setup of the solution is very easy and the time it takes depends on the architecture required. If the deployment of a cluster is required then the setup may take up to three hours, whereas standard environment deployment needs half an hour.
View full review »SM
Sanjeeb Mohanty
Global Head ICT (CITP & MIE) at The Aga Khan Academies
Its initial setup is very straightforward. In case there is an issue, Microsoft's tech support people come online and help you.
The initial setup isn't too complex or difficult. It's pretty straightforward. It's less complex of a process as compared to other solutions.
View full review »RM
RogerMorera
Digital Transformation Architect at Comdata
Its initial setup is easy. It takes a week. One of the things that you need to pay attention to is the collection.
The initial setup is very easy.
View full review »The initial setup is simple and the deployment took one day.
View full review »SA
Scott Albritton
Applications Business Intelligence Analyst at a aerospace/defense firm with 10,001+ employees
Creating a SQL Server instance using the pre-installed GUI setup screen available in either Visual Studio or Enterprise Manager can be very simple to create and maintain database “instances” making it a prime choice for small startup businesses.
In addition, Microsoft has added loads of training videos on their website along with step-by-step instructions for creating and maintaining servers. The user can get as complex as desired in SQL Server by learning all the behind-the-scenes commands the GUI is using. You will start researching commands quickly once the first SQL Server error occurs and the GUI doesn’t know how to resolve it.
View full review »MM
reviewer2112948
Consultant at a transportation company with 10,001+ employees
The initial setup is easy. Fifteen twenty minutes required for deployment.
View full review »BL
Bjarne Lindquist
Owner at 2 Bit
For me, the initial implementation is easy, however, I know a lot of people can't set it up and believe everything is hard. It's difficult if you didn't know how to do it. You have to know, in the beginning, how to define what hardware you need and how many disks, for example. You need to understand if it should be a cluster disk or not. Long ago, it used to be hard disk access only. Things have changed.
FZ
reviewer1641576
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees
When it comes to the initial setup, most of them can be automated. For example, most setup settings for progressions, management, disaster and recovery, failover, and failback. Most of those things can be automated and provisioned into one kind of pipeline. Connecting that data to an application and even provisioning from the code repository through Jenkins. Those things are really easy to automate.
View full review »DG
reviewer1001628
Information Systems Manager at a aerospace/defense firm with 51-200 employees
It was pretty straightforward. It basically walks you through the process. It took a couple of hours.
View full review »It's easy for anyone to install. For me, it was good and easy to install. A company shouldn't have any issues tacking the process.
The deployment is quick. It takes about 15 to 20 minutes. That's it.
View full review »The initial setup is very straightforward. You do not have to worry about the management of the SQL Server instance.
View full review »US
Uchechi Sylvanus
Team Lead, Process Improvement at Fidelity Bank Plc
The initial setup is very simple, very straightforward. It's not too complex.
The time it takes to set up isn't long. The time of installation is determined by the local system or the server where you are installing it to. That said, it's a light solution. For me, it took maybe ten minutes.
We have eight people who are technical and can handle deployment or maintenance tasks.
View full review »SL
reviewer1385976
Enterprise Architect at a educational organization with 10,001+ employees
Initially, it is easy to set up.
View full review »I rate the tool's deployment a seven out of ten. Deployment time depends on the customer's environment.
View full review »The initial setup of SQL Server is not complicated.
View full review »AS
Amir Saudi
Business Intelligence Manager at a consumer goods company with 10,001+ employees
It is mostly straightforward. There were no issues. It takes about two or three months to prepare. Development takes another three months. It takes almost one year to just kick off the project with live production.
For deployment and maintenance, we used seven or eight people. Most of them were developers and DBAs, and some of them were business analysts.
View full review »GK
reviewer1671969
Data Architect at a computer software company with 1,001-5,000 employees
The complexity of the initial setup really depends. Obviously, you're going to need to know a few things and there are different ways to do deployments. I like the BACPAC, which is one of the features that come with SQL Server. It's a nice feature to deploy. BACPAC really handles all of the configuration for you. If you use that, I don't think you really need to know too much. If we're talking about a small database that holds a few thousand records, it doesn't matter what you're doing. You can't make a mistake because it's just not big enough.
We do a lot of Azure-based on-demand type systems where we host the system or we host it in Azure. We do the work for them. So we don't really do a lot of those installs.
View full review »SK
Santosh Kurakula
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
The installation difficulty level depends on the use case and environment. For example, if you need to deploy it on multiple nodes or have large amounts of storage it could increase the difficulty level.
View full review »OK
OmidKoushki
Solution Architect at KIAN company
The installation is not very complex. However, the process could take a long time because you have to follow the step-by-step instructions for the installation. The time it takes to do the installation is approximately two days.
View full review »It's a straightforward installation. I installed SQL Server 2012, 2013 and 2016.
View full review »LA
Lional Angelo
Manager Digital Technologies at a real estate/law firm with 51-200 employees
The solution is very straightforward. It's not too complex. A company shouldn't have an issue implementing it. Once you install everything and get it configured as per your requirements if you are an SQL professional and an administrator, it's very straightforward.
It's doesn't take too long to set up. Within a week you can get it deployed. If you do a standalone module, a week likely is not required. If it is in a cluster module, of course, within a week you can set up a cluster and then get things done.
View full review »The initial setup was very easy - much, much easier than Oracle - and took about a day to complete. Microsoft is less demanding because everything is GUI, unlike Oracle, where you need to use command lines.
View full review »I work on the development and performance-tuning side, so I don't do the installation but my guess would be that it is pretty straightforward by now.
View full review »GS
Gheorghe SANDRU
Managing Partner at Bizz Advisers SRL
The initial setup was not complicated. You can do it without any external support.
It is easy to install. It might take 20 or 30 minutes to install.
View full review »Straightforward - no complexity.
View full review »IG
Irwin Gibson
Chief ICT Officer at Barbados Public Workers Cooperative Credit Union Ltd
The tool is easy to install.
View full review »SQL Server's initial setup is simple. However, you must be a specialist to do it. That's the unfriendliness that I see about the solution. It has to be done by an engineer and not any engineer can do it, you have to be a specific Microsoft engineer.
View full review »AS
Azeezulla Sheriff
General Manager IT at a manufacturing company with 10,001+ employees
The initial setup was straightforward.
View full review »It is very easy.
View full review »I can't say it is easy to deploy as it depends on the admin, however, it is doable. Most of the databases, in general, require configuration. Therefore, if the admin knows what he's doing, then it's super easy.
A full deployment, depending on what is needed, might take anywhere from 15 to 30 minutes. It's fast.
View full review »RV
reviewer1624716
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
The deployment could be easier.
While the deployment only takes about 15 minutes, you have to follow up with a lot of configuration.
View full review »MS
reviewer1428423
Head of Technical Support at a real estate/law firm with 51-200 employees
The installation is straightforward and takes approximately 30 minutes. If you were to add more features the installation could take longer. For example, there are many features such as table partitioning allowing you to do queries faster, transferring data from one table to another, and performing quicker backups.
View full review »The initial setup is not complex or difficult. It's easy. It's very straightforward and the setup guide is available if you Google it. Anyone can search for the installation guide on whichever version you're installing.
The deployment is quick. It only takes about 30 minutes or so.
We have a technical team of five engineers. If any maintenance is needed, we can handle it.
View full review »DI
Dimitris Iracleous
Lead Technical Instructor at codehub
The initial setup is not without certain problems. Many users prefer to use Docker in lieu of the original selection. This is more convenient for them owing to certain configurations it possesses. However, if one is incapable of doing this initially he will find it difficult to do at a later date. An example would involve the inclusion of TCP/IP support, which is quite cumbersome. While it is not very difficult, it does require a certain amount of expertise.
We have prepared many virtual machines. Each month we prepare these systems so that they may be ready to meet our needs. This task consumes three to four days per month.
ST
reviewer1022898
Director at a tech services company with 10,001+ employees
The initial setup was straightforward.
We have experience and did find it to be challenging.
We do multiple deployments which require three or four teams.
View full review »AS
Aditya Sawant
Assistant Manager at ECU
The initial setup is very straightforward, just like any typical software where you just click next, next, next, next. You just need to know your environment properly and which exact features you need to install. Deployment takes max one to two hours to install on-premises. Depending on the environment and whether or not you're installing any cluster environment, it will take a couple of hours. To deploy a stand-alone SQL server doesn't take much time.
SB
Shanti Sahu
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
The initial setup is straightforward. Again, it's a mature solution, so it is very straightforward. You don't need to worry about that.
View full review »PS
Prakash Somasundaran
Project Advisor at A private sector Company
It was straightforward.
View full review »NY
reviewer2265342
Consultant at a tech company with self employed
I have generally found implementing the solution easy. But when it comes to the time we took to implement the solution, the problem's always been the application and not the database. The solution is usually easy to implement because we use standard facilities. If you need something special, you run into all sorts of trouble because SQL Server gives you an awful lot of ability to change the settings.
View full review »KG
reviewer1488372
Associate Manager at a consultancy with 501-1,000 employees
The initial setup is straightforward, you can install with basic knowledge. Installation doesn't take long at all, I did it myself.
JJ
JohannesJoubert
Business Solutions Architect at a real estate/law firm with 501-1,000 employees
It is relatively simple to run. We spent a good amount of time preparing the requirements for a high-availability cluster that paved the way for a reasonably straightforward implementation.
View full review »NS
Navee Srichaiyanont
IT manager at IRPC PCL
The initial setup wasn't complex. It was pretty straightforward. We didn't have any issues with the implementation process at all.
View full review »In older versions, the setup was rather onerous. However, in the latest several releases, it has been extremely simple to install and set up.
View full review »I don't recall, it's been many years since we implemented this product.
View full review »The initial setup is simple it takes approximately 10 minutes. You only need to run the setup and you have SQL installed.
View full review »This solution is pretty easy to deploy.
View full review »The installation is straightforward. I was able to handle deployment and maintenance by myself.
View full review »MF
Mohamed_Farouk
Information Technology Manager at OrchidaSoft
The installation is straightforward. It is easy, you continuously click the next button until you are done.
It takes 20 to 25 minutes to install. There are no issues with the installation, it is very basic.
View full review »BM
Biswajit Mohanty
Senior Manager - RPA & Transition at a financial services firm with 10,001+ employees
The initial setup does take some time. It depends upon how you are establishing the server in your environment and depends upon the firewall of your organization. It is a lengthy process, however, it is not that grueling. Depending upon the firewall of your organization, it does take time. That influences the time.
View full review »Due to the fact that Postgres is a fully integrated package installation, done from a single installer, with SQL Server you can do an advanced complex installation which requires a lot of IT administration background knowledge. Alternatively, you can do a stand-alone use case installation system, if you're just using it for a backup system. They've got a backup package that you install and that's the standard installation you use. Due to SQL's user-friendly approach, it's got a lot of pre-made installation packages that you can install based on the needs or necessities of the company.
The length of time that SQL Server standard installation takes obviously depends on network speed, and UT package downloads. It could take anywhere from five minutes to half an hour. This is all dependent on the network speed that you're running the server installation on. If you've got a fast enough network speed, it should take no longer than five minutes. With a home-based network speed, say a fiber line with 10 megs, it should take you about 15 to 30 minutes just for a standard installation.
MN
Michael Ndwiga
IT Officer at a manufacturing company with 201-500 employees
The initial setup was straightforward.
View full review »JM
reviewer1715886
SQL Server Senior Architect at a computer software company with 1,001-5,000 employees
In the latest version of SQL Server, Microsoft has split the product. For example, if you want to start with the engine or the reporting server you have to download it separately. I think that the installation is easier on the new versions. There are other kinds of options that you can set up in the installation progress. For example, the number of 10 DV files or the limit of maximum use of memory.
The installation process takes approximately 10 minutes.
View full review »MO
reviewer1613988
Senior Manager at a financial services firm with 201-500 employees
The initial implementation is easy and straightforward. It's not overly complex or difficult to set up.
However, it's not just the server we have to set up. We have a cluster environment. Mostly it's just, click, click, click and you are done, however, the configuration process is a bit more difficult. Adjusting performance levels, in particular, can be a real challenge.
View full review »YT
reviewer1478394
Information Security Manager at a financial services firm with 501-1,000 employees
When it comes to the installation of the operating system, we have found it to be easy and user-friendly.
Our greatest praise for the solution we reserve for its ease of installation and usage. These provide definite advantages. Perhaps this can be attributed to the fact that we have always made use of the solution for nearly every relevant company in South Africa.
While I cannot recall exactly how long the installation lasted, I did recently install endpoint Windows 10 Operating System and this took an hour and a half.
We were able to handle the installation on our own, as we are well versed in this process when it comes to Windows OS.
On an individual basis, we solely make use of Windows OS. There are between 300 and 400 people in our organization who do so.
Generally speaking, we do not make use of a technical team for deployment and maintenance purposes and do so internally. There are a maximum of seven or eight people in our organization who are responsible for this. We are talking about technical people who are responsible for the direct installation and configuration of Windows OS and they do not include managers.
View full review »FA
Florent ADODO
IT Assistant at Hotel 2 Fevrier
The initial setup is time-efficient and can be done independently.
There is no need for developers or managers to deploy and maintain the solution. One or two systems' administrators are sufficient for its deployment.
The deployment is on-premises. We installed the solution on a server and this on the Windows server. The user is provided an application for connecting to it.
View full review »HP
hugodpereira
Computer engineering student at a educational organization with 501-1,000 employees
The initial setup was pretty straightforward. It's very similar to other software products. The Visual Studio is easier, however, it's still mostly straightforward. It could be better integrated with this SQL Server Studio tool. You have to install it separately. If they could be installed together, that would be an improvement in my opinion. While not everyone would use it, the developer would find it a helpful item to have.
It can sometimes be confusing to install by yourself since it does have many options that you need to decide on.
View full review »MM
reviewer1187943
Director of Data Analytics at a insurance company with 1,001-5,000 employees
The initial setup was straightforward because we had help from Microsoft.
View full review »SP
SashisekharPanda
General Manager/MVP at Yotta Infrastructure Solutions LLP
The initial setup was straightforward.
View full review »НЕ
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
It depends how many features you want to implement. Basic stuff is very easy to install, but if you want to implement all the features or deploy a high-load or a clustered environment, it might be tricky. That is why you need a good architect and skilled DBA for something really complicated.
View full review »BG
Gh0ce
Systems Analyst/DBA at Vecima Networks
The initial setup was straightforward, but configuration post-install can be complex. Complexity comes from attempting to optimize it and implementing some of the new features that come in new versions.
View full review »SA
Albeez
IT Director at DAR AL ARKAN
The basic installation is simple, whereas rest of the clustering requires an expert skill level for the configuration and deployment.
View full review »I don't do the installation, but it appears straightforward according to those who carried out the implementation. These days deployment takes about an hour. We have 1,200 or so users. With the onboarding of more customers, we'll be increasing our use of SQL Server. For now, we have one person dealing with maintenance.
The initial setup of SQL Server is straightforward.
View full review »The installation is straightforward.
View full review »EM
reviewer1703928
Enterprise Solutions Architect at a comms service provider with 501-1,000 employees
VG
reviewer1322280
Regional Head Customer Experience at a financial services firm with 10,001+ employees
The installation and configuration are straightforward.
View full review »ID
Irad Dukad
IT Manager at ducart
Installation is relatively easy, although I do not recall how long it took.
View full review »AM
reviewer1359642
Sr. DBA/Developer at a financial services firm with 5,001-10,000 employees
I'm not sure how to answer as to if the solution is straightforward or complex in terms of setup. I didn't handle the deployment, so I'm not the person who would be best equipped to answer these types of questions.
View full review »NM
NipunaMaliga
Systems Specialist at Zillione Technology
Which initial setup are you referring too? It has multiple solutions and installations, some of which are very simple. Clustering is very difficult to setup.
Setup time depends on the customer's environment, including database size, the number of databases, and the amount of data. Last week I did a PLC with two databases and one availability crew. It took two days because one day I did clustering. It can be done in one day but the customer provides another day for that.
Also, because the customers haven't kept some downtime, we request some kind of downtime for the primary server. So sometimes we plan downtime when we need some days for the complete environment.
Not too complex. We had spent a number of months on the design and planning stages, deciding how we would go about the setup, security, and accessibility aspects, so that when it came time for the actual setup, the process looked pretty straightforward. Don't get me wrong, it still took a number of days to finalise, but we had a concrete plan of action, the steps needed, and the work was delegated accordingly.
View full review »The process for the deployment is straightforward. It takes approximately four hours to complete.
View full review »IH
reviewer1159494
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
Setup is very easy, especially compared to Oracle.
View full review »RC
Ryan Cerney
Principal JDE Business Analyst at a manufacturing company with 201-500 employees
Everything is pretty much scripted out, so it is pretty straightforward for us.
KJ
reviewer1233759
Deputy Manager at a computer software company with 10,001+ employees
The installation took a few days to complete.
We have a team of three or four admins to maintain this solution.
View full review »PR
reviewer1569966
Technical Specialist at a media company with 10,001+ employees
The initial setup was not overly difficult or complex. It was quite straightforward. It's a pretty simple process.
Our team is capable of handling the maintenance internally.
View full review »SJ
reviewer1407519
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees
It is easy to install.
AW
reviewer1566654
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees
The installation is not difficult, it is quick. It took approximately 15 minutes to complete.
View full review »There is no installation. Everything is done by Microsoft and all you have to do is deploy it. The process takes less than five minutes.
View full review »We did not implement the solution. We had it delivered to us.
I've done an installation in the past, however, not at this company. It's straightforward. It's simple due to the fact that it's going to be installed on the Microsoft operating system, not like MySQL that's used on a Linux server.
Deployment may take about 15 minutes or so.
We have a technical team of about eight people that can handle maintenance as necessary.
View full review »MM
reviewer1522923
Head of IT, CTO at a insurance company with 51-200 employees
It was installed by an outsourcing company. It is another sister company.
View full review »MA
MartinAnderson
Owner at BNS
The initial setup was straightforward. It was very easy to do.
View full review »RL
Rmegio Lawag
Technical Department Manager at Direcbusiness Technologies, Inc.
Setup required two engineers to deploy it. It was pretty straightforward and took one to two days.
View full review »HT
Hoang Ta
System Engineer at CMC CSI saigon
The initial setup is not complex.
We have an in-house IT team that can deploy this solution.
View full review »VA
reviewer1162596
Data Analyst at a healthcare company with 10,001+ employees
I was satisfied with the implementation of the solution.
View full review »SQL Server is easy to implement, especially because it's a very common system that we use in the workplace.
View full review »FN
Florent NOPOUDEM
Senior Database Administrator at ITGStore
While I find the setup and installation to be easy, others may find it difficult.
View full review »MC
reviewer1642500
Engineer at a manufacturing company with 10,001+ employees
I was not involved in the installation.
We have an IT team to complete the installation.
View full review »MP
Mohammed-Pasha
CEO at SkyNet
The initial setup was straightforward.
View full review »ST
MD.SIHAB TALUKDAR
System Engineer at asa
Setting up the database clustering is too complex.
Our current deployment has been ongoing for three years and it is not yet complete because our application is still being developed.
View full review »The initial setup is very clear and friendly. It has improved from the previous version.
View full review »PN
Paul Nockolds
Data Analyst at a media company with 1,001-5,000 employees
A lot of initial reading was required to carefully manage the process of setting everything up correctly.
View full review »It's straightforward to install a new instance, but more complex if new features are added to an existing instance. Deployment of SQL code is efficient through Visual Studio database project development methodologies.
View full review »EO
Edgar Orare
Senior Systems Engineer at Dimension Data
It was straightforward. It took two to three hours.
View full review »TU
TonderayiUsada
Managing Director at D3
The solution is straightforward to install.
View full review »MR
reviewer909060
IT Developer at a financial services firm with 10,001+ employees
We don't deal with the setup because we are developers. The system or admin team does all those things. So I don't have any idea.
IC
reviewer1646865
ICT Consultant at a tech services company with 11-50 employees
The solution is very easy to deploy. It's not a problem.
The amount of time it takes to deploy depends on what you want the solution to do for your company.
View full review »OB
Ossama Benaziz
Operations Director at ALTERSIS Performance
The installation is quite straightforward. It's not overly difficult or complicated. I found it to be quite simple.
The deployment is rather quick. It took us about one hour, from what I can recall.
We just need one technical person to handle the implementation and maintenance processes.
View full review »DB
reviewer1473555
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
I was not involved in the installation of the solution. I'm more on the side of creating metadata. Therefore, it would be difficult for me to comment on if the solution was easy or difficult to implement or how our team deployed it. I don't have any exact details on that front.
View full review »If prior to the setup you do the proper training, there are no issues with setup, but the learning curve is wide and tall.
You could get started fast and sure if you stick to the many Wizards included with the tools, but the scope of said Wizards is limited.
View full review »If you do the proper training prior to the setup, there will be no issues. However, the learning curve is wide and tall.
You could get started fast and sure if you stick to the many wizards included with the tools. However, the scope of those said wizards is limited.
View full review »SB
Sipho Ngubonde
Admin at IEC (Electoral Commission of South Africa)
The initial setup was ok, it met our requirements.
View full review »VC
reviewer938061
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
The team needed for implementing the solution depends on the project size and functionalities needed. But as far as the DB administrator, generally, we use a single resource for each project. One database engineer is sufficient for optimizing the query or indexes or building any database scripts.
View full review »MK
Mazen Kassem
Senior Digital Services Engineer at a pharma/biotech company with 1,001-5,000 employees
I wasn't a part of the installation process, however, it's my understanding that the company handled the installation themselves.
The administration team has three or four team members. They can handle maintenance tasks and rotate tasks between themselves.
View full review »HV
Helder Valente
Infrastructure and Networks at a financial services firm with 10,001+ employees
The initial setup was straightforward.
It took a couple of hours to install, no more than that.
View full review »VP
reviewer1501629
Chief Information Officer at a financial services firm with 501-1,000 employees
The initial setup was moderate. It was not easy but it was not difficult.
View full review »KV
Karel Van Der Walt
Data Architect at ACPAS Loan Management Software
The initial setup isn't too complex. It's pretty straightforward, especially if you are setting up the cloud. It's very easy to provision. It requires fairly typical knowledge. If you are familiar with Windows software, you'll find that there isn't much of a challenge to the setup. I'd say it's not overly technical.
Deployment is fast. You can have it up and running in an hour or sometimes less.
You need about two people to handle the deployment of the solution.
View full review »JP
reviewer1470330
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
I can't recall how the initial setup was. It was a while ago. We've had the solution for a very long time.
View full review »KG
reviewer1413750
Lead Data Architect at a financial services firm with 1,001-5,000 employees
The initial setup was not easy but not complex. Rather, it was somewhere in between.
View full review »JM
Johan Malan
System administrator at a mining and metals company with 10,001+ employees
The initial setup is mostly straightforward. The time it takes to deploy depends on the circumstances. It takes around three or four hours.
View full review »磊刘
Lei Liu
DBA,data architectuire at LG CNS Co.
initial setup straightforward
View full review »Initial setup is real simple. Just install it. Though, I recommend for new users to at least look online for training or a manual.
View full review »
Setting up Microsoft SQL server performance alerts and jobs on a single server or in a Cluster is very straightforward. I typically start off looking at the following:
- Batch Request/Sec
- Buffer cache hit ratio < 96%
- CPU Utilization > 80 % sustained
- Compilation/Sec
- Re-compilation/Sec
- Page Life Expectancy (PLE)
- User Connections
- Lock Waits / Sec: _Total
- Process Lock/Block By
My objectives are to provide a baseline to determine database growth pattern to ensure capacity planning, stability, bottlenecks, etc., etc.
View full review »HG
reviewer1595568
Technical Content Writer at a computer software company with 51-200 employees
The installation is easy, especially since the new version has come up. Now, with the latest versions, installation is easy.
I cannot remember the time it took to complete the installation.
MO
Manjunatha OK
Marketo Consultant at Webtech software servies
The installation is straightforward.
View full review »AG
Alberto Geminiani
Technical Director at Progetti e Soluzioni
The initial setup is not overly difficult. It's pretty straightforward. A company shouldn't have any issues with the process.
We have 12 technical people on our team that can handle the implementation.
View full review »AK
reviewer977976
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees
The implementation was done by our IT department.
View full review »It was straightforward for most of the installation, thanks to the wizards.
View full review »DK
reviewer1314546
Senior Systems Engineer at a energy/utilities company with 201-500 employees
It was easy.
View full review »SY
cto267069
CTO at a tech services company with 11-50 employees
We have a special database team that is running. Except for the initial installation of the hardware, they are doing everything as it's an in-house solution.
It took a day or two to implement. It might have even taken less time.
View full review »PS
reviewer1643577
Project Manager at a comms service provider with 51-200 employees
The initial setup is very simple.
View full review »YA
reviewer1519596
Chief of Information Technology at a manufacturing company with 201-500 employees
The initial setup is simple.
View full review »It's more and more complex. The 2005 version was very nice and neat, but now it's more and more complicated.
View full review »Complex design, easy configuration.
View full review »It's pretty straightforward, and usually everything goes smoothly. Everything was user-friendly and took me a minimum amount of time to understand how everything works.
View full review »
SQL is very easy to setup.
View full review »
JP
reviewer1561038
Chief Technology Officer at a financial services firm with 11-50 employees
The initial setup was straightforward.
View full review »EK
reviewer1601793
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
The initial setup is straightforward and is comparable to that of PostgreSQL.
View full review »DS
reviewer1430925
Technical Director at a security firm with 51-200 employees
Its installation is straightforward. It took half an hour to one hour.
View full review »SW
Stephan Warreyn
GF at Innopact GmbH
The installation is not overly complex or difficult for the most part. The initial setup's level of straightforwardness, however, depends. If you only need an SQL Server, it's easy. If you need a cluster, it's more difficult. If you need a great cluster all over the world, it's more difficult.
View full review »GV
reviewer1476273
Manager with 501-1,000 employees
Its initial setup is easy.
View full review »RS
Rahul Kumar Singh
Software Developer at OATI
It was straightforward.
View full review »DM
DenisMunger
Chief of Engineering at a comms service provider with 11-50 employees
MS SQL is the easiest of the three I tried.
View full review »It was very straightforward. There was no complexity which I couldn’t handle.
View full review »JI
reviewer1707912
System Analyst and Team Lead at a tech services company with 11-50 employees
If you follow the restoration policy, the installation is not a problem. If you want connectivity in the application then you have to open the ports and configure them. Otherwise, I'm very pleased it is very simple.
View full review »RP
reviewer1362969
IT Specialist at a government with 1,001-5,000 employees
I've tried to do the initial setup, and I don't think it's that easy. But I think the configuration is normal.
View full review »OY
reviewer1503438
Specialist Systems Engineer at a tech services company with 51-200 employees
For the initial installation process, I did an installation for database testing using SQL Server Express. Sometimes, the trials for the samplers are not allowing the SQL Server Express. So, when I was doing the installation, I just selected database management because it isn't the default and it has helped me not to fill out the same details for future use.
View full review »The initial setup is one of the good things about MS SQL. It is very easy to do and start the development that you need to use after the installation.
View full review »FK
Faruk Kutlu
Managing Partner at Veribir Ltd
The installation is easy.
View full review »The initial setup is straightforward, it took approximately one hour.
View full review »CM
reviewer1489908
Systems Engineer at a tech services company with 11-50 employees
We have found the solution to be straightforward. It's not overly difficult or complex. A company shouldn't have any issue with implementation.
The product implementation process depends on the needs of the client. For us, deployment was around 30 minutes to one hour. It's pretty quick.
View full review »The installation is really easy.
View full review »easy.
View full review »AA
reviewer1556808
ASM at a healthcare company with 51-200 employees
The initial setup is very easy.
View full review »RP
reviewer1288086
Project manager at a tech services company with 11-50 employees
Its initial setup is quite straightforward. A major upgrade is a bit more complicated. We had some issues with the upgrade.
View full review »Setup is easy as what we want the database to do for our problems, compared to Oracle latest versions you need to spend more time on the initial setting up where these cannot go wrong with partitioning and indexing and it needs to be perfect.
View full review »It's straightforward to do providing you've read the manual.
View full review »YW
Yasin Bin Wasim
Information Security Engineer at a security firm with 11-50 employees
The initial setup was straightforward. The installation was easy.
It took two hours to deploy.
View full review »SK
reviewer1491816
Senior Architect at a computer software company with 10,001+ employees
The installation is easy, and performance-wise it's okay now.
View full review »WL
reviewer1484775
Senior Programmer at a tech services company with 51-200 employees
The initial setup is not complex. It's pretty straightforward. It takes an hour or less to set everything up. Some people may need a few hours, however, for me, less than an hour was enough. That said, the Windows Server would also take an hour or two to set up as well.
View full review »The installation and configuration was very straightforward. The full setup typically takes less than one day.
View full review »SA
Shafeeq Ahamed
Enterprise Solutions Department Manager at Smart Vision
Installation was very easy. We had it installed within one hour.
SS
reviewer1085256
Software Engineer at a tech services company with 10,001+ employees
The initial setup is definitely straightforward and can be completed within a couple of minutes.
View full review »Straightforward.
View full review »The migration was, as always, a hard job, but we were able to migrate successfully.
View full review »
Pretty straightforward.
View full review »
SA
reviewer1680246
Chief Engineer at a tech services company with 51-200 employees
The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete.
View full review »A strong knowledge of AD is a must as well as the ability to decipher MSFT blog posts.
View full review »CL
reviewer1410678
Data Analyst at a tech company with 51-200 employees
The installation is not easy, it could be easier.
It can take many hours to configure it.
View full review »KH
reviewer1517148
Program Solution Architect at a tech services company with 11-50 employees
The installation is simple.
View full review »We’ve been using AlwaysOn availability groups for three years. It took a while to model the structure, but now it is stabilized, and safe with disaster recovery and failover configurations.
View full review »Buyer's Guide
SQL Server
April 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.