Ewan MakforTenten - AI / ML Developmentdeveloper.tenten.co·Dec 12, 2024Building a Custom Dashboard UI for MS SQL: A Comprehensive GuideLearn how to design and develop a custom dashboard UI to effectively manage your SQL database. Explore popular technologies and frameworks for creating intuitive and functional dashboards. The most effective way to create a Dashboard UI for SQL data...MSSQL
louis chianglouischiang.hashnode.dev·Nov 24, 2024How to Move MSSQL to a New ServerOne way to manually move an entire MSSQL database to a new server is to copy the database files: the .mdf (Main Data File) and the .ldf (Transaction Log File). What are .mdf and .ldf files? The .mdf file contains all the data and structure of the dat...Databases
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...Database 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...3 likes·112 readsDatabases
DbVisualizerthetable.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...MSSQL
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...Secury
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...Databases
Muhammad 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 ...29 readsMSSQL
DbVisualizerthetable.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...MSSQL
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...Databases
