Friend of RedGate 2021
This past month RedGate graciously allowed me to be a part of their Friend of RedGate program. It’s been a great seven year run with this program and I...
2021-02-11
18 reads
Blog Posts
Set up connection from Azure Data Factory to Databricks
Both, Azure Data Factory and Azure Databricks offer transformations at scale when it comes to ELT processing. On top of that, ADF allows you to orchestrate the whole solution...
2021-02-11 (first published: 2021-02-04)
229 reads
Azure SQL DB – Troubleshooting CPU issues
When you have the need to find out real time what is causing high CPU issues within your Azure SQL Database, there is nothing better than using TSQL and...
2021-02-10
226 reads
Daily Coping 10 Feb 2021
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...
2021-02-10
20 reads
Fixing Python on Windows 10 – #SQLNewBlogger
The other day I picked up a laptop, opened a command prompt and typed “python” to check something. I got this: I did have Python 3.8 installed, so upgrading...
2021-02-10
21 reads
Grant or Revoke Permission on Power BI Report Server
I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last...
2021-02-10
17 reads
Identifying SQL Server Performance Problems Part 2
Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to gather for baselining your...
2021-02-10
38 reads
Launching On-Demand Training Platform SQLibrium
I am thrilled to announce the launch of a new education initiative called SQLibrium. For years, I’ve traveled the world educating technical audiences on deep-dive topics around how data and...
2021-02-10 (first published: 2021-02-02)
263 reads
Power of Unlearning
(2021-Jan-31) Working on DIY home projects is always fun, choosing the right tools: whether I handle paperhanging scissors to cut my wallpapers, or create an opening and trim my drywall...
2021-02-10 (first published: 2021-02-01)
259 reads
Professionalism in the age of COVID-19
Some years ago, I wrote about what it means to be “professional” (and that it doesn’t mean having to wear a suit and tie). Recently a conversation broke out...
2021-02-10
171 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCU KALIMALANG Tlp/Wa:0817839777
Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...
Alamat Kantor BCA KCU SITUBONDO Telp:0817839777
WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311
Alamat Kantor BCA KCU TUBAN Telp:0817839777
WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers