Power BI Custom Visuals Class (Module 32 – Percentile Chart)
In this module you will learn how to use the Percentile Chart Power BI Custom Visual. The Percentile Chart is...
2017-01-05 (first published: 2016-12-29)
2,070 reads
Blog Posts
Query tuning 101: Non-trusted Foreign Keys
Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating...
2017-01-05 (first published: 2016-12-30)
3,542 reads
Sequence – Long awaited feature
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...
2017-01-05
481 reads
Announcing SQL Saturday Chicago Precon Training Session
Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago....
2017-01-04
355 reads
Comparing plan consistency and query performance using the Query Store Replay script
The 1.2 version of the Query Store Replay script a number of new features are added that return information of...
2017-01-04 (first published: 2016-12-30)
2,014 reads
Create quick queries quickly with SSAS in Azure
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or...
2017-01-04
269 reads
Finding Automatic Soft-NUMA
If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...
2017-01-04 (first published: 2016-12-30)
2,232 reads
Quick Prompt Tips–Custom Procedure Templates
One of the things that I often do is create stored procedures. The syntax for doing so is simple, but...
2017-01-04
509 reads
When was SQL Server installed?
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
13,526 reads
Be Careful of Your Create Stored Procedure Batch
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:
CREATE PROCEDURE...
2017-01-03
3,725 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers