Setting Up a Drillthrough Action in your Power BI Report
At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service....
2017-09-03
1,719 reads
New Baby Musings (AKA Things I’ve Thought Upon On Sleepless Nights)
Hello!
One month ago I became a dad for the 3rd time. And so my spare time, which has always been...
2017-09-02
139 reads
Thank you for Microsoft MVP
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....
2017-09-02
375 reads
Livestreaming the Redgate Hub for the US
The Livestream launch for the Redgate Community Hub is next Wednesday, Sept 6, 2017. To ensure that our customers and...
2017-09-01
410 reads
Macros in ER/Studio Data Architect is your data modeling lifebelt
[2017-Sep-01] There is a well-known phrase, "the rescue of a drowning man is the drowning man's own job" from one of the...
2017-09-01
1,891 reads
Sample Databases For SQL Server
As a blogger, one thing that I appreciate greatly is examples of technical features. This is mainly because
technical features can...
2017-09-01
195 reads
SSIS ForEach Enumerator File Order
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files....
2017-09-01
588 reads
Knowing Your Data
Is it possible to be an effective data professional without knowing anything about the domain of data you support? I...
2017-09-01
317 reads
Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
421 reads
Friday Reading 2017-09-01
Going to be a busy few weeks as conference season gets into full swing. Really looking forward to the next...
2017-09-01
335 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers