What's Downtime?
Steve asks the question today of how you might measure downtime and the scope you are concerned about.
Mount SQL Server DMVs and Custom Queries Using DBFS on Linux
With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.
How to execute a Powershell script via SSIS
Learn how you can execute a PowerShell script via the SSIS execute process task.
One Size Does Not Fit All
Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.
Data Retention: An Inexact Art
A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.
Analyze entity data flow in Power BI Desktop using Sankey charts
Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.
Whitepaper: Database deployments: Choosing a state-based or migrations-based approach
This whitepaper explores the differences between the approaches, state based or migrations based, and how Redgate tools can help.
Is the DBA Title Dying?
Titles are very important to many people. Steve wonders if the main title many of us use will go away.
Controlling Access to Azure Cosmos DB
Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Alamat kantor BCA KCU DAAN MOGOT Telp:082144477715
Wa:0821-4447-7715 Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers