Bezyl Mophat Otienomophat.hashnode.dev·Mar 24, 2024The Role of Normalization in Ensuring Database Security.In the ever-evolving realm of cybersecurity, flashier solutions often steal the spotlight. Yet, a fundamental principle like normalization remains surprisingly underutilized, despite its significant security benefits. Shrinking the Attack Surface:R...DiscussSecury
Jamey Bartondbajamey.hashnode.dev·Mar 22, 2024PostgreSQL vs SQL Server: What Are the Differences?In today’s business landscape, effective management and storage of data are more crucial than ever. As a result, selecting the appropriate database management system for each particular project can be complicated. There is no universal solution for a...DiscussDatabases
Muhammad HassanforDevOps Journey with M Hassanhassandevops.online·Mar 21, 2024Setting Up MS SQL Server 2019 on Ubuntu 20.04: A Step-by-Step GuideAre you looking to set up Microsoft SQL Server 2019 on your Ubuntu 20.04 system? SQL Server is a powerful relational database management system that is widely used in various industries for managing and analyzing data. While traditionally associated ...DiscussMSSQL
DbVisualizerforThe Tablethetable.hashnode.dev·Mar 21, 2024Understanding Date and Time Extraction in MS SQL ServerMS SQL Server, a powerful RDBMS, facilitates complex data management and analysis. This guide highlights key methods for extracting date and time from datetime values, employing the CONVERT and CAST functions for efficient data manipulation. Key Meth...DiscussMSSQL
Bezyl Mophat Otienomophat.hashnode.dev·Feb 25, 2024Rethinking Database Security: The Forgotten Power of NormalizationIn the ever-evolving realm of cybersecurity, securing our data remains paramount. While firewalls, encryption, and AI-powered threat detection grab most attention, a fundamental principle often gets relegated to the backburner: normalization. This bl...DiscussDatabases
Victor Ndutidatacurious.hashnode.dev·Feb 18, 2024Seamless Data Transfer: Importing and Exporting Excel Data with SSMS 2019 and SQL Server 2022If you've ever faced challenges importing data into a MSSQL database, fret not. Here's a step-by-step tutorial with key learnings for achieving a seamless data transfer. This guide is tailored for SQL Server Management Studio 2019 (SSMS) and SQL Serv...DiscussMSSQL
Indu Chundiinduchundi.hashnode.dev·Feb 17, 2024CTE in SQLCTE(Common Table Expressions) especially useful when working with complex queries or when you need to reuse a subquery multiple times within a query. It provides provide a way to define temporary result sets that can be referenced within a single SQL...Discuss·49 readsSQL
Ayomide Gbadegesinayo-g.hashnode.dev·Jan 9, 2024Complete Guide: Setting Up an Offline SQL Workspace with Azure Data StudioIf you're like me and have been looking for ways to practice SQL queries or work on personal projects on your computer without having to be connected to the internet all the time, look no further because I might have just the solution for you.With Mi...Discuss·1 likeazuredatastudio
mortylenmortylen.hashnode.dev·Dec 18, 2023Importing Data From Multiple MS Access Files To SQL ServerIn this brief article, I aim to share my approach to importing data from MS Access files into SQL Server. With the task of importing data from hundreds of files with identical structures into SQL Server tables, I've distilled this guide to focus on a...Discussms-access
Jaimin Pateljaimin047.hashnode.dev·Dec 5, 2023SQL Commands that every Developer should knowSQL (Structured Query Language) is a powerful language used for managing and manipulating relational databases. Here are some essential SQL commands that every developer should be familiar with: SELECT: Retrieves data from one or more tables. SELEC...Discuss·1 likeSQL