Daily Coping 16 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-16
38 reads
Blog Posts
ETL Antipattern: No Error Handling Logic
I usually avoid talking about technology in absolutes, but here’s one that I can share without reservation: On a long enough timeline, every single ETL process will eventually fail....
2020-12-16
15 reads
Migrating from SQL Server to Amazon AWS Aurora
Is Microsoft’s licensing scheme getting you down? It’s 2020 and there are now plenty of data platforms that are good for running your enterprise data workloads. Amazon’s Aurora PaaS...
2020-12-16 (first published: 2020-12-07)
641 reads
Provisioning storage for Azure SQL Edge running on a Raspberry Pi Kubernetes cluster
In a previous post we went through how to setup a Kubernetes cluster on Raspberry Pis and then deploy Azure SQL Edge to it. In this post I want...
2020-12-16 (first published: 2020-12-07)
165 reads
SQL Server Meets AWS Systems Manager
Excited. Have a new solution in the works to deploy Ola Hallengren via SSM Automation runbook across all SQL Server instances with full scheduling and synchronization to S3. Hoping...
2020-12-16
35 reads
SQL Server Meets AWS Systems Manager
Excited. Have a new solution in the works to deploy Ola Hallengren via SSM Automation runbook across all SQL Server instances with full scheduling and synchronization to S3. Hoping...
2020-12-16
16 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2020
At the end of 2019, Mala (b|t) invited us to write about the gifts we’ve gotten during the year. I’ve decided to try to make this yearly habit. This year...
2020-12-16
4 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2020
At the end of 2019, Mala (b|t) invited us to write about the gifts we’ve gotten during the year. I’ve decided to try to make this yearly habit. This year...
2020-12-16
9 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2020
At the end of 2019, Mala (b|t) invited us to write about the gifts we’ve gotten during the year. I’ve decided to try to make this yearly habit. This year...
2020-12-16
12 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2020
At the end of 2019, Mala (b|t) invited us to write about the gifts we’ve gotten during the year. I’ve decided to try to make this yearly habit. This year...
2020-12-16
7 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
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