SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.
2008-06-27 (first published: 2004-06-17)
66,440 reads
See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.
2008-06-27
2,788 reads
SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.
2008-06-27
4,307 reads
2008-06-26
798 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
23,056 reads
Training in the UK this fall from a variety of SQL Server experts. If you are in the area, I'd recommend one of these classes.
2008-06-26 (first published: 2008-06-19)
2,639 reads
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
2008-06-26
4,215 reads
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
44 reads
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
42 reads
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
50 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers