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 …
Getting Started in SQL Server If you want to become an expert in SQL Server, then you will need knowledge of the following things Know how to secure a database system How to interact with SQL Server to retrieve, insert, delete and update information How to backup and restore a database within SQL Server There …
Can we send you a check every month? Earn ongoing monthly income by joining the free affiliate program We payout 35% commissions with a 90-day cookie for selling our courses. You could earn hundreds off a single email. email: training@cloudwer.co.uk and ask to join our affiliate program
You can now download SQL Server Management Studio (SSMS) 18.0 Just follow the link below SQL Server Management Studio (SSMS) 18.0 – Download
Here is a quick video on creating a SQL Server RDS Instance on AWS. You will need an AWS account to do this quick tutorial.
Finding the status of your SQL Server Database with a script I have been in a position where I wanted to know the status of my databases at regular intervals and I would want this information in a script. Well here is a script that I have used in the past that once placed in …
Finding the status of your SQL Server Database with a script Read More »
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’) …
After you have downloaded the Microsoft SQL Server Management Studio, you will find it is easy to install. Just double click the setup file and you should see something like this. Just click the ‘Install’ button. After you have installed the software, you can find the SQL Server Management Studio in Windows menu. When you …