In part 2 of this series, I showed an example implementation of distributing a long-running workload in parallel, in order to finish faster. In reality, though, this involves more than just restoring databases. And I have significant skew to deal with: one database that is many times larger than all the rest and has a higher growth rate.
2024-06-07
Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.
2024-06-05
15,431 reads
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator.
2024-06-05
797 reads
A new cohort of WITspiration is strating, the women in technology mentoring circle.
2024-06-05
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,700 reads
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.
2024-06-03
Another article on how the SQL language works in PostgreSQL. This time we examine the UNION, INTERSECT, and EXCEPT operators.
2024-05-31
1,511 reads
Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.
2024-05-31
In the contemporary digital landscape, web applications play a pivotal role in delivering services and facilitating interactions between users and businesses. However, the performance of these applications heavily relies on the efficiency of underlying databases. This comprehensive study aims to explore the intricate relationship between database optimization techniques and web application performance enhancement. The study begins by delineating the significance of web application performance and its correlation with database operations. It examines various factors affecting performance, including data retrieval, storage, and processing. Furthermore, it identifies common challenges such as latency, scalability issues, and inefficient query execution. Through an extensive review of the literature, this study evaluates state-of-the-art database optimization methodologies and their applicability to web applications. Techniques such as indexing, query optimization, denormalization, caching mechanisms, and data partitioning are scrutinized, highlighting their potential to mitigate performance bottlenecks. Moreover, the study investigates emerging trends and technologies in database management systems (DBMS), such as NoSQL databases, in-memory databases, and cloud-based solutions. It assesses their suitability for enhancing web application performance, considering factors like data volume, query complexity, and real-time processing requirements.
2024-05-29
2,210 reads
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha.
2024-05-29
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0818-751-777 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers