The Second Career
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.
How to Build Your First SQL Server Virtual Lab in Windows Azure
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.
Moving Through Five Years
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.
Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
Reconciling Data Across Systems Using a Reconciliation Hub
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.
Fix Commvault Backup Failures After an Upgrade
In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool
Why Devops? For Better Security
DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.
How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query Execution
Ben Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.
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
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...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers