The SQL Server DBA Bootcamp: Beginner To Expert (Part 2) is finally here. You will now be able to get training on becoming a SQL Server DBA within Azure and AWS Join the course now by clicking the following link The SQL Server DBA Bootcamp: Beginner To Expert (Part 2) You will learn How to create …
The SQL Server DBA Bootcamp: Beginner To Expert (Part 2) Read More »
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 …
Join our Affiliate Program and earn 35% commission SQL Server 2019 Developer Edition is free!Yes that is right, you can download SQL Server 2019 for free. You can download SQL Server 2019 from here :- Download SQL Server 2019 The Developer Edition is the same as the Enterprise Edition, but the only difference is that …
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.
Find out which SQL Agent Jobs that are currently running If you ever want to find out which SQL Server Agent jobs that are currently running on your server without using Management Studio, just run the code below. SELECT ja.job_id, j.name AS job_name, ja.start_execution_date, ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id, Js.step_name FROM msdb.dbo.sysjobactivity ja LEFT JOIN msdb.dbo.sysjobhistory jh …
Find out which SQL Agent Jobs that are currently running Read More »
Has it finished? is a question you will ask yourself many times when you are running something within SQL Server. If you are backing up a database, restoring a database or you just want to find out how long a task on your server will take to complete, then just run the code below to …
Configuring SQL Server 2017 How that you have installed SQL Server 2017, it is time to get your hands dirty and start to create databases. But before we do that, it is a good idea to configure your SQL Server 2017 environment correctly. To do this, just Right Click the server and click properties. …
Constraints in SQL Server play a big role in keeping data accurate in a database. Within SQL Server there are several methods of doing this and one way is using constraints • NOT NULL – Indicates that a column cannot store a NULL value • UNIQUE – Ensures that each row for a column must …
CROSS APPLY vs INNER JOIN vs LEFT JOIN vs OUTER APPLY So you want to improve your SQL skills and have come across some new operators like JOIN and APPLY and are wondering when you should use them. In this blog, I will focus on the following operators in the simplest terms and show you …
SQL Server Functions Sometimes you read books on subjects about SQL Server and you just want to learn the basics, well here are the basics of SQL Server Functions Functions can be Scalar or Table-valued Scalar returns one value and Table-valued functions (TVF) returns…well a table of results and this are usually found in the …