Log Shipping By Abi Chapagai (Revised)
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,385 reads
Justin H-Davies
SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,484 reads
SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,939 reads
“One of the Pack to Top Dog”
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
579 reads
Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
683 reads
Enabling Memory Support for over 4GB of Physical Memory
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
943 reads
Mix & Match – Day 4
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-12
381 reads
Mix & Match – Day 3
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-08
384 reads
Mix & Match – Day 2
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-06
438 reads
Bin the unwanted to reap the rewards !
Looking through some of my databases this past week, theres a lot of data there which over time has become...
2010-07-04
435 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers