COFFEE SQL AND TECH

Drink a coffee while you are reading about SQL, troubleshooting, tech and more.

Home: Welcome

Search

Some queries to use less the SQL Server Management Studio

Here I bring you some queries that will help you in the daily tasks that a database administrator does. See what query is blocking other...

Maria Elena Morillo Tejada

Jul 8, 20222 min read

75 views

0 comments

What's new in SQL Server 2022 (16.x) Preview

SQL server in this release made and improved features that are extremely important to continue having a better experience, security and...

Maria Elena Morillo Tejada

Jun 29, 20221 min read

25 views

0 comments

SQL Server Execution Plan

SQL server execution plan is a tool that offer SQL management studio that give to the user the explanation of each part of a query while...

Maria Elena Morillo Tejada

Jun 17, 20224 min read

199 views

0 comments

Indexes

An index serves as a navigational marker, analogous to an index in a book, facilitating the swift and efficient retrieval of data from a...

Maria Elena Morillo Tejada

Jun 9, 20223 min read

17 views

0 comments

Database Normalization

Is the process of the structuring a relational database to eliminate or reduce data redundancy and improve data integrity. These rules...

Maria Elena Morillo Tejada

May 24, 20223 min read

28 views

0 comments

SQL for Beginners : Operators

An SQL operator is a special word or character used to perform tasks like complex comparisons, to basic arithmetic operations. SQL...

Maria Elena Morillo Tejada

May 17, 20224 min read

22 views

0 comments

SQL For Beginners : SQL Clauses

SQL is a standard used to query, update, delete and insert data into a table. Clauses: Select – is a clause used to show the data storage...

Maria Elena Morillo Tejada

May 16, 20223 min read

12 views

0 comments

SQL for Beginners : Keys and Constraints

Keys and Constraints are rules that define what data values are allowed in certain data columns. They are an important database concept...

Maria Elena Morillo Tejada

May 13, 20223 min read

14 views

0 comments

HELLO

I started Coffee SQL and Tech with the goal of offering readers a glimpse into my thoughts and experiences. What started out as weekly posts has evolved into a dynamic site packed with information about various topics that are near and dear to me. Take some time to explore the blog and see for yourself what makes you curious and eager. Read on and enjoy!

Get in Touch

LET’S CONNECT

mmorillotejada@gmail.com

Amazon Support Links

UK

US

DE