Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,624 reads
SQL
Database Deployment with Terraform - The Basics
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
14,442 reads
INSERT EXEC statement cannot be nested, the Simple Solution
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
2022-08-19
39,469 reads
The Azure SQL portfolio
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.
2021-09-20
Text Mining and Sentiment Analysis: Oracle Text
Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.
2021-09-15
Improving performance with instant file initialization
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
How to query private blob storage with SQL and Azure Synapse
Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.
2021-08-13
SQL Features Explorer
Working as a DBA or developer, one needs to check from time to time about the availability of a particular feature on different SQL Server versions and editions. Hence to avoid the complexity of the search process we have developed a tool that helps DBAs and developers to verify the selected features' availability on all […]
2021-08-06
5,735 reads
How to Compare Two SQL Prompt Styles
A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.
2021-07-26
Introduction to generic Power BI themes
Formatting Power BI visuals can be tedious. In this article, Adam Aspin explains custom Power BI themes that will save you time when creating reports.
2021-07-02
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers