In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Information is stored somewhere. Sometimes it’s not suited for its original location. If you’re running low on disk space, added a new drive array, or just curious; this is a simple procedure to move ...

I've installed Horizon View, VMware's Virtual Desktop Infrastructure (VDI) product, dozens of times over the past decade. With each release, for the most part, the installation process gets easier and ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

Many customers choose to run their Microsoft SQL Server workloads on Amazon RDS for SQL Server to take advantage of its fully-managed services, high performance, and straight forward homogeneous ...

The successful migration from purely private to public and hybrid cloud arrangements has substantially increased the level of confidence IT administrators have in the cloud. And among the top cloud ...

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

When trying to install SolidWorks on a Windows computer, you may encounter an issue when the installation is trying to install Microsoft SQL Server. So, the installation works fine until it reaches ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...