• Mon. Jan 18th, 2021

Gary Cowan

I have been working with SQL Server for 20 years and have administrated and developed software solutions with SQL Server from SQL Server 6.5 through to SQ Server 2019. I have MCTS, MCP, MCDBA and MCITP Qualifications in SQL Server.
  • Home
  • Securing AWS – IAM (Identity Access Management)

Securing AWS – IAM (Identity Access Management)

To secure AWS properly, you need to do some initial steps within IAM (Identity Access Management).¬† These steps are used…

Has it finished?

Has it finished? is a question you will ask yourself many times when you are running something within SQL Server.…

Finding the status of your SQL Server Database with a script

Finding the status of your SQL Server Database with a script I have been in a position where I wanted…

What is a database?

What is a database? I thought I would write this article for people who have no experience in SQL Server…

Query Store in SQL Server 2017

Performance Tuning with Query Store in SQL Server 2017 If you want to monitor the performance of your queries within…

SQL Server Information from a script

SQL Server Information¬†from a script. SQL Server has a lot of useful information that you need to administrate or develop…

Configuring SQL Server 2017

Configuring SQL Server 2017 How that you have installed SQL Server 2017, it is time to get your hands dirty…

SQL Server Management Studio

After you have downloaded the Microsoft SQL Server Management Studio, you will find it is easy to install. Just double…

Install SQL Server 2017:Installation

SQL Server 2017 Installation Guide If you have downloaded SQL Server 2017 and you want to install it but you…

Constraints in SQL Server

Constraints in SQL Server play a big role in keeping data accurate in a database. Within SQL Server there are…