The Profiler Extension in Azure Data Studio (ADS)
This article covers the basics of the Profiler extension in Azure Data Studio, a handy way to trace your application calls.
Tinkering with Fabric Data Factory Framework Functionality
I recently asked myself, “Self, is it possible to apply framework functionality to Fabric Data Factory?” I decided to investigate.
Auto Renew Subscriptions
Reserved resources in Azure can auto renew now, but Steve isn't sure if that makes our jobs easier.
An Experimental Mindset
Steve wonders how many of you have an experimental mindset. He finds those that embrace this do better in their careers.
How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer
Learn how to optimize the size of your Power BI semantic models with the free Vertipaq Analyzer tool. Extra tips & tricks included.
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code.
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Learn how to get started with Microsoft Fabric along with the differences between managed and unmanaged tables.
Re-platforming
Sometimes you need to completely change your software, perhaps on a new platform. Steve has a few thoughts on this drastic action.
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually on the box. Yes, we still exist, and we will for as long as we’re still using physical servers in data centers and even IaaS. Not everyone has transitioned to server core and full-on PowerShell remoting for everything
Find Unused or Backup Tables
If you rename old or backup tables, learn how to find easily find and drop them.
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers