Are My Problems Caused By Replication?
We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.
Pier to Pier Replication on Frozen Lake Erie
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
Checking the Plan Cache Warnings for a SQL Server Database
How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.
The Express Choice
This week Steve Jones wonders if you'd be willing to use Express edition in production situations.
Cloud Storage Replication Is Not Backup
The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.
SQL Saturday #381 - Richmond, VA
SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.
Building Small Habits
Today Steve Jones talks about development, and finding ways to make small changes that improve your code.
The Potential of Joins
An article about how we underestimate the power of joins and degrade our query performance by not using proper joins
Another Look at Tuning Big Data Queries
Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Kemang Pratama CSTelpon : 0853-73737551
Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blok AN, RT.004/RW.001, Bojong Rawalumbu,...
BCA KCP Kedoya Baru TLP/WA 08218573837
Ruko Tomang Tol, Blk. A1 No.21-22 Raya Blok, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Ruko Jababeka CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Ruko Permata Junction, Jl. Jababeka Raya Blok A2-3, Cikarang, Cikarang Sel.,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers