PowerBi and API – Visualising my Checkins
For my own amusement and also to show my wife where I have been I use the Swarm check-in app...
2016-11-03 (first published: 2016-10-29)
2,181 reads
PASS Summit 2016 Recap
It has been a fantastic week here in Seattle at the annual PASS Summit. I’ve spent the last five days...
2016-10-28
783 reads
Selfies at Summit
Not all selfies, and not enough, but lots of changes to meet people at the Summit this week.
The other Steve...
2016-10-28
876 reads
PASS Summit Announcements: DMA/DEA
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. My next few blogs...
2016-10-28
919 reads
PASS Summit 2016 – Announcements
There have been different announcements for new and upcoming features in the Microsoft Data Technology ecosystem. The one today I...
2016-11-03 (first published: 2016-10-28)
1,511 reads
Data Compare on Temporal Tables
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-10-28
553 reads
PASS Summit 2016-Thursday Part II
The second half of the day was spent talking with various speakers and attendees. I got into a great conversation...
2016-10-28
809 reads
Data Compare on Temporal Tables
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-11-02 (first published: 2016-10-28)
3,135 reads
This Week In Data – Episode 10 (Getting Started with Azure)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-28
845 reads
SQL Server Compression 101
The data compression feature in SQL Server can help reduce the size of the database as well as improve the performance of intensive I/O intensive workloads, especially on data...
2016-10-28
11 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
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