In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.
In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.
The GitLab crisis has Steve Jones thinking about two things: competence and care.
From a well-built cockney who knew how to avoid wheel clamps, to an ex-member of an elite anti-riot unit, some of the best DBAs have a surprising diversity of skills and experiences, according to Phil Factor.
If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.
An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.
In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Raya Tajur No.143, RT.02/RW.06, Tajur, Kec. Bogor Tim., Kabupaten Bogor, DKI Jakarta 16141
Jl. Siliwangi No.101, RT.07/RW.02, Sukasari, Kec. Bogor Tim., Kota Bogor, DKI Jakarta 16142
Jl. Merdeka No.50, RT.04/RW.01, Ciwaringin, Kecamatan Bogor Tengah, Kota Bogor, DKI Jakarta 16133
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers