Blog Posts

Announcing a New Book on SQL from 3Cloud Authors

• by DataOnWheels

• DataOnWheels

I am proud to announce the launch of a new book, centered around the importance of SQL, authored by six consultants from 3Cloud. Our new book is called “SQL...

2023-06-07

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

• by Matthew McGiffen

• Matthew McGiffen DBA

Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...

2023-06-07

Setting Up Always Encrypted

• by Matthew McGiffen

• Matthew McGiffen DBA

In this post we're going to go through the steps to set up Always Encrypted and create an encrypted column. As with my last post we're looking at the...

2023-06-06

Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks

• by Tracy Boggiano

• Database Superhero’s Blog

I’ve been using Azure SQL Database for quite some while and have set up it in many various ways to run Ola’s Index Optimize and
The post Using Azure Automation...

2023-06-06

Analyzing Azure Cosmos DB Data with Azure Synapse Link – YouTube Live Stream

• by Koen Verbeeck

• Koen Verbeeck

At Tuesday 6th of June 2023, I’m giving an online version of my session “Analyzing Azure Cosmos DB Data with Azure Synapse Link” (which I presented at Techorama). It’s...

2023-06-05

Create and Verify Microsoft Fabric Capacity

• by Dharmendra Keshari

• SQL Geek

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal. Now, we can provision Microsoft fabric easily using Microsoft PowerBI premium per capacity or using...

2023-06-05

Power BI – Empowering Users to Disable Tooltips

• by DataOnWheels

• DataOnWheels

Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your stakeholders with a variety of tooltips that offer deeper insights. They love the tooltips, and...

2023-06-05

What is Always Encrypted and how does it work?

• by Matthew McGiffen

• Matthew McGiffen DBA

Always Encrypted was a new encryption feature added to SQL Server with the 2016 version of the product. Initially it was just available in enterprise edition, but from SQL...

2023-06-05

Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

• by Meagan Longoria

• Data Savvy

One of the nice things about the Microsoft Connector for Oracle is that it doesn’t require installation of an Oracle client. But because of this, you may not have...

2023-06-03

A New Word: Jouska

• by Steve Jones

• The Voice of the DBA

jouska – a hypothetical conversation that you compulsively play out in your head – a crisp analysis, a devastating comeback, a cathartic heart-to-heart – which serves as a kind...

2023-06-02