Jamey Bartondbajamey.hashnode.dev·Sep 9, 2024Level Up SQL Server Efficiency With the Newest Version of dbForge EdgeDevart has released a major update for dbForge Edge (v3.0), a comprehensive multidatabase solution designed to simplify and streamline database management, development, and administration across multiple platforms. The update introduces the following...DiscussDatabase Tool
Yuval Aloniyuval.hashnode.dev·Jul 20, 2024Databases: The Battle for ACIDIntroduction If you've ever dealt with ANY database system you probably encountered the ACID acronym. Let's briefly go over each of the principles it describes: A for Atomicity The concept of treating something (a block of data operations in our cont...Discuss·3 likes·98 readsDatabases
DbVisualizerforThe Tablethetable.hashnode.dev·Jul 4, 2024Optimize SQL Server with These Top Query Tuning TechniquesEfficient query tuning is vital for maintaining SQL Server performance. This article presents the top five techniques for optimizing queries. Identify Slow Queries Use the following query to find slow-running queries: SELECT req.session_id, r...DiscussMSSQL
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.site·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 ...Discuss·29 readsMSSQL
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·51 readsSQL
