Mark Pelfmarkpelf.hashnode.dev·Dec 19, 2024SqlServer – Query performance – Database maintenance can helpSqlServer – Query performance – Database maintenance can help Some periodic SqlServer maintenance can improve query performance. Abstract: Periodic SqlServer database maintenance steps, like 1)updating statistics; and 2)defragment indexes can contrib...GeneralDatabases
Sean M. Drew Sr.blog.seandrew.info·Dec 17, 2024SQL Admin ScriptsEffective database management relies on having the right tools to streamline tasks and ensure optimal performance. Over time, I have created a set of SQL scripts designed to simplify routine administrative duties, enhance visibility into database env...SQL
Sean M. Drew Sr.blog.seandrew.info·Dec 16, 2024From Chaos to Clarity: A Journey Through Random SQL CodeIn SQL development, I often encounter recurring challenges that can be addressed with small, reusable pieces of code. Here, I've put together a few random yet handy SQL snippets that tackle common scenarios—from formatting output to managing permissi...SQL
Sean M. Drew Sr.blog.seandrew.info·Dec 16, 2024Boosting SQL Query Flexibility with CROSS APPLYCROSS APPLY is useful SQL operator that lets you look up related information for each row in a table. It is especially useful when you want to get extra details that depend on each specific row. It is especially handy when you need to perform row-by-...SQL
Sean M. Drew Sr.blog.seandrew.info·Dec 16, 2024Transforming Nested JSON into Usable Data with SQL CROSS APPLYJSON is a popular format for data interchange due to its flexibility and readability. One effective method for transforming nested JSON into a more accessible structure is by utilizing the CROSS APPLY operator. The SQL nested JSON arrayA SQL nested J...SQL
Sean M. Drew Sr.blog.seandrew.info·Dec 16, 2024Isolation Levels In SQL: A Brief OverviewIsolation is a key concept in SQL and database management systems, particularly in the context of transactions. It refers to the degree to which the operations in one transaction are isolated from those in other transactions. The isolation level dete...SQL
Gedion Danielblog.gediondaniel.dev·Dec 11, 2024Amazon Aurora Global DatabaseIntroduction Amazon Aurora Global Database is a powerful database solution that helps businesses run their applications worldwide. This guide will explain how to get started with Aurora in simple terms. What is Amazon Aurora? Amazon Aurora is a cloud...AWS
Vedant Sagolaledbforpuredevelopers.hashnode.dev·Dec 11, 2024DDL and DML commandsDDL (Data Definition Language) Commands DDL commands are used to define, modify, and manage the structure of a database and its objects (such as tables, schemas, etc.). CommandDescriptionExample CREATECreates a new database object (table, view...SQL
Samana Butool Mirzafrom-procrastination-to-progress.hashnode.dev·Dec 11, 2024Navigating Databases: From SQL to NoSQLHey Folks! In the world of development, understanding which database system to use for a project can make a huge difference in performance, scalability, and flexibility. As a developer who’s worked extensively with both SQL Server and MongoDB, I’ve e...SQL
Ngozika Nwaneriamiriltd.hashnode.dev·Dec 10, 2024Finally! A Shared-Cache Solution Based on SQL Server Cache!source code: https://github.com/amiriltd/hybrid-output-cache Its no secret that Output caching can significantly improve the performance and scalability of an app by reducing the work required to generate responses from the server. Theoretically, Mic...58 readsCost Effective Efficiencyhybridcache
