Power BI Dashboard vs Report vs Workbook
There are many different ways to present data using Power BI and this tip looks at these different methods such as Power BI Dashboards, Power BI Workbooks and Power BI Reports.
SQL ConstantCare® Population Report: Winter 2020
Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out.
What’s New in SQL Monitor 10?
New release: SQL Monitor 10
SQL Monitor 10 has landed! You can now integrate SQL Monitor alerts with your ticket management system, so chosen alerts are automatically raised as tickets. New suppression options give you granular control over what alerts are raised during specific times, such as maintenance windows. And, you can now annotate the server activity graph with specific events, so you can measure their impact on your servers.
Discover the new features
Azure Data Studio and Deployment Notebooks
Azure Data Studio (ADS) is a cross-platform tool that you can use to run T-SQL queries much as you have done using SQL Server Management Studio. No, the databases do not need to be hosted in Azure; the tool works fine for on-premises SQL Servers as well. I’ve started using ADS more as I teach […]
Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2
In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.
What's the Cost of an Hour?
Outages can be expensive, and today Steve asks if you know just how expensive they are for your organization.
Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins
Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.
What’s New in SQL Monitor 10?
SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.
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
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers