Why Not Use AI?
Steve re-posts a question from someone else, asking why you wouldn't want to use an AI.
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
Engineering a Lakehouse with Azure Databricks with Spark Dataframes
How can we get familiar with Azure Databricks with Spark Dataframes?
How to use the Azure Emulator to create blob containers, queues and tables
Learn how to emulate Azure storage for files, blogs, and queues.
What If You Need to Index a Lot of Duplicate Data?
Let’s get a little nerdy and look at database internals.
Triggers
Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold. But alas, I’m not here to talk about database triggers. Sorry, we’ll have to […]
Configuring Maintenance Plans in SQL Server
See a walkthrough of setting up a maintenance plan in SQL Server.
Moving On After a Technology Fail
After his watch broke, Steve had to get a new tool and isn't sure it was a good move.
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server
There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
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