Adding a dynamic ColumnId to a DAX Calculated Table
Learn how a calculated value can be added to a table with the missing key values filled in.
2019-10-01
1,909 reads
Articles
How to Create a Pareto Chart in Power BI Desktop
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
2019-10-01
PowerShell Alert API and Server-level Permissions Overview in SQL Monitor
SQL Monitor 9.1 offers a new PowerShell Alert API to control and fine tune your alert configuration, across a group of servers, and a new Server Permissions Overview table, which summarizes who has access to a server via a “super-privileged” server-level role. Here Redgate's Rebecca Woof dleves into the details.
2019-10-01
SQL Change Automation 4 now available with SSMS extension
The Development component of SQL Change Automation now integrates directly into SQL Server Management Studio as well as Visual Studio. This allows teams to collaborate seamlessly during development, regardless of their preferred IDE. Other new features include new data compare options for PowerShell and static code analysis.
2019-10-01
Transparent Data Encryption and Extensible Key Management – Better Together
Learn how you can secure your TDE environment by separating your key from the server using Extensible Key Management.
2019-09-30
9,472 reads
A fresh new look for Redgate University
Last September Redgate University opened its doors online, since then, with their selection of getting started courses they have been helping customers get up and running with their tools. Now, along with a brand-new look, new courses have been added to help you advance your skills past the basic usage of the tools. Come and check it out and leave your suggestions for future courses.
2019-09-30 (first published: 2019-09-16)
Introduction to DevOps: Security, Privacy, and Compliance
Robert Sheldon continues his DevOps series with a look at security, privacy, and compliance. He recommends that these critical areas are tackled early in the DevOps pipeline.
2019-09-30
WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits
An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.
2019-09-27 (first published: 2017-10-10)
5,931 reads
Brent Ozar's DBA Training Plan no.15: What’s Your SQL Server Waiting On?
Brent continues his DBA Training Plan: Whenever your queries need to wait on something – storage, locks, memory, whatever – SQL Server tracks what it’s waiting on, and for how long. It’s like you’re seeing INSIDE the server, with all kinds of possible debug points being tracked. All you have to do is ask SQL Server, “What have you been waiting on?”. Here Brent shows you how.
2019-09-27
Take the 2019 State of Test Data Management survey – you could win a $250 Amazon voucher
We want to hear from you on the approaches you take and the challenges you face when delivering test data to development and testing environments. Take part now for an advance copy of the research and a chance to win a $250 Amazon voucher.
2019-09-27
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers