SQL Server Training Path This is the training path that you should take if you want to become an expert in SQL Server. Getting Started in SQL Server You should learn the basics of SQL Server and how to download and install SQL Server. This is important because it will give you a basic understanding …
From June 30 2020, you will not be able to take a certification in SQL Server 2019 according to the Microsoft blog post This because the following courses are ending Microsoft Certified Solutions Associate (MCSA) Microsoft Certified Solutions Developer (MCSD) Microsoft Certified Solutions Expert (MCSE) There will be no further exams in SQL Server 2019. …
SQL Server Information from a script. SQL Server has a lot of useful information that you need to administrate or develop solutions. Here is a great SQL Script to find out information about your SQL Server Instance and operating system. — Get selected server properties SELECT SERVERPROPERTY(‘MachineName’) AS [MachineName], SERVERPROPERTY(‘ServerName’) AS [ServerName], SERVERPROPERTY(‘InstanceName’) AS [Instance], SERVERPROPERTY(‘IsClustered’) …
SQL Server 2017 Installation Guide If you have downloaded SQL Server 2017 and you want to install it but you are not too sure how to? Well, this is a guide will help you through the steps needed to install SQL Server 2017. I will presume you have already downloaded SQL Server 2017 so the …