Ben Johnston in Blogs

Friendly Deletes in SQL Server

One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that...

01 March 2024 24 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

Find and Replace Text in Strings in T-SQL

String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases,...

29 February 2024 17 min read

Blogs

Dennes Torres in Blogs

Customizing Kusto (Data Explorer) Connections in Deployment pipeline

When organizing our SDLC (Software Development Lifecycle) in Power BI/Fabric, we use Deployment Pipelines and create rules to change connection...

28 February 2024 2 min read

Dennes Torres

Model Optimization: Available In MDX Property

Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and...

28 February 2024 3 min read

Database Administration

Aaron Bertrand in Database Administration

Upgrade SQL Server on your workstation

Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source...

26 February 2024 6 min read

Web

Benedict Ampea-Badu in Web

Making Accessibility Part of the Design Process – Part 3

Naviagation, flow, and testing it all In this last segment of the series, we’ll delve into the crucial elements of...

22 February 2024 14 min read

Blogs

Dennes Torres in Blogs

Eventstream and the new KQL Processing

Eventstream has many differences in relation to the technologies it proposes to replace. Event Hub, Stream Analytics, Streaming Dataflows and...

21 February 2024 2 min read

Software Delivery

Phil Factor in Software Delivery

Database Feature Toggles

In software development the concept of feature toggles are used to selectively turn on and off features. They are, for...

19 February 2024 15 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Functions and Procedures: Learning PostgreSQL with Grant

One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do...

15 February 2024 9 min read

Blogs

Dennes Torres in Blogs

4 Rules to follow on Microsoft Fabric Source Control

Power BI and Fabric are implementing source control support. It’s a long-awaited feature for Power BI. However, it’s important to...

14 February 2024 4 min read

Database Administration

Aaron Bertrand in Database Administration

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....

12 February 2024 8 min read

Blogs

Louis Davidson in Blogs

Planning, the First Step To Failure

You probably have heard the saying “if you fail to plan, you plan to fail”. I get the sentiment here,...

09 February 2024 4 min read

PowerShell

Laerte Junior in PowerShell

Automating BCP with PowerShell

I was talking with a good friend that has an environment with terabytes of information and to create a homolog...

09 February 2024 8 min read

Opinion Pieces

Dennes Torres in Opinion Pieces

The Fashionable Truth About AI

Over the past year, the topic of AI has really blown up in the general public. However, AI was already...

06 February 2024 14 min read

Testing

Alex Bunardzic in Testing

Why Test-Driven Development? (Part 2)

As discussed in Part 1, by segregating our focus on developing code that behaves as expected from the focus on...

01 February 2024 11 min read

Ben Johnston in Blogs

Feature Flags in Data Projects

My motivation for writing this summary was an interaction with a project owner that didn’t understand why we couldn’t use...

01 February 2024 23 min read

Camilo Reyes

C# Cancellation Tokens in AWS

A colleague of mine once asked about cancellation tokens in AWS. This question got me thinking about this problem and...

29 January 2024 11 min read

Blogs

Simple Talk Editor in Blogs

Adding a new AI usage policy to Simple-Talk

I used to think plagiarism was my worst thing to deal with as an editor. That is only sort of...

26 January 2024 5 min read

BI

Dennes Torres in BI

Top-Down and Bottom-Up Approaches in Microsoft Fabric

Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data...

25 January 2024 9 min read

Blogs

Dennes Torres in Blogs

Power BI and Resource Graph: Why you should care

Recently Azure Resource Graph was announced as a new connector in Power BI. Azure Resource Graph provides access to almost...

23 January 2024 1 min read

Register for Simple Talk

Articles

Friendly Deletes in SQL Server

Find and Replace Text in Strings in T-SQL

Customizing Kusto (Data Explorer) Connections in Deployment pipeline

Model Optimization: Available In MDX Property

Upgrade SQL Server on your workstation

Making Accessibility Part of the Design Process – Part 3

Eventstream and the new KQL Processing

Database Feature Toggles

Functions and Procedures: Learning PostgreSQL with Grant

4 Rules to follow on Microsoft Fabric Source Control

Leave it better than you found it

Planning, the First Step To Failure

Automating BCP with PowerShell

The Fashionable Truth About AI

Why Test-Driven Development? (Part 2)

Feature Flags in Data Projects

C# Cancellation Tokens in AWS

Adding a new AI usage policy to Simple-Talk

Top-Down and Bottom-Up Approaches in Microsoft Fabric

Power BI and Resource Graph: Why you should care