LAST_VALUE–The Basics of Framing
I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built...
2016-06-20
782 reads
Columnstore Indexes – part 84 (“Practical Dictionary Cases”)
Continuation from the previous 83 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this blog post I wanted to...
2016-06-20
622 reads
Monday Morning SQL Break – June 20, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-06-20
882 reads
Minimizing Cloud cost
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working...
2016-06-27 (first published: 2016-06-20)
1,477 reads
The PASS Speaker Agreement
I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not...
2016-06-24 (first published: 2016-06-20)
1,218 reads
Using Power BI with Enterprise, On-premises Data
I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for...
2016-06-19
702 reads
Power BI Architecture Diagram v2 is Now Available
I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram...
2016-06-18
982 reads
The RGE
I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores,...
2016-06-24 (first published: 2016-06-17)
1,811 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-17
790 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This course targets IT professionals that design and maintain Linux...
2016-06-17
14 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers